Hi all.
I have seen multiple posts regarding this, but cannot get my Update property to not throw the error Expected Record Value. I have a SharePoint Integrated list. My SharePoint column is named ChangeRequestAssessmentTeam and allows multiple users. The cbCRAssessmentTeam is the data card value for the combo box where I have the Items property set to the following:
Filter(
Sort(
RenameColumns(
AddColumns(
MicrosoftEntraID.GetGroupMembers("xxxxxx-xxxx-xxxx-af62-d643f97e66d3").value,
Claims,
"i:0#.f|membership|" & ThisRecord.mail
),
mail,
Email,
displayName,
DisplayName
),
DisplayName
),
!("admin" in DisplayName) && !("Test" in DisplayName) && !("Admin" in DisplayName)
)
This is my Update property formula:
ForAll(
cbCRAssessmentTeam.SelectedItems As _AssessmentTeam,
{
'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
Claims:
"i:0#.f|membership|" & Lower(_AssessmentTeam.Email),
Department: "",
DisplayName: _AssessmentTeam.DisplayName,
Email: _AssessmentTeam.Email,
JobTitle: "",
Picture: ""
}
)
The Patch function was being used in the ShaerPoint Integration property OnSave but now I just have SubmitForm(SharePointForm1). In the OnSuccess property of SharePointForm 1, I have a Patch function to Patch a Request ID to the SharePoint list based upon Last Submit. This is throwing an error, as well. Her is the OnSuccess property:
ResetForm(Self); RequestHide();Patch(
'CAB Request',
SharePointForm1.LastSubmit,
{'Request ID': Concatenate("CAB ID " & CABIDDataCardValue.Text & " - " & "CR")}
)
I have spent days trying to get this to work and do not understand why it is not. Even when I remove the For All from the Update propertyI am getting "An unexpected error occurred". There is nothing jumping out at me with the Monitoring tool. I will try a trace but not sure that will answer anything.
Thank you in advance for your help.