Forum Discussion

RussB365's avatar
RussB365
Copper Contributor
Mar 02, 2022

Power Apps form(s) on SharePoint list build a collection of approvers and fails in certain instances

Error Message = The requested operation is invalid.  Server Response Change Form Failed.  The specified user i:0#.f|membership| could not be found.  ClientRequestId ServiceRequestId


ForAll(
Filter(
'SAP Change Approvers',
If(
//!IsBlank(DataCardValue9.Selected.Locations.Value),
//Locations.Value = DataCardValue9.Selected.Locations.Value,
!IsBlank(DataCardValue9.Selected.Record.Locations.Value),
Locations.Value = DataCardValue9.Selected.Record.Locations.Value,
false
) && If(
!IsBlank(DataCardValue3.Selected.Value),
Requestor_x0020_Department.Value = DataCardValue3.Selected.Value,
false
)
),
Collect(
ApproversCol,
{
DisplayName: ThisRecord.Primary_x0020_Approver.DisplayName,
Email: ThisRecord.Primary_x0020_Approver.Email
}
);
Collect(
ApproversCol, //SecondaryApproversCol,
{
DisplayName: ThisRecord.Secondary_x0020_Approvers.DisplayName,
Email: ThisRecord.Secondary_x0020_Approvers.Email
}
);
Collect(
SecondaryApproversCol, //SecondaryApproversCol,
{
DisplayName: ThisRecord.Secondary_x0020_Approvers.DisplayName,
Email: ThisRecord.Secondary_x0020_Approvers.Email
}
)
);

1 Reply

  • RussB365's avatar
    RussB365
    Copper Contributor
    Turns out this is related to the Secondary Approver field being blank. Its just trying to set the secondary approver but getting an empty value

Resources