Power Platform Community Forum Thread Details

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.

Categories:

Using Apps Using Formulas

Hi @IntraAdmin

At first I though the issue might be the order of the commands in the OnSuccess property where you might need to re-order the statements because "ResetForm" might be clearing the form:

Patch(

    'CAB Request',

    SharePointForm1.LastSubmit,

    {'Request ID': Concatenate("CAB ID " & CABIDDataCardValue.Text & " - " & "CR")}

);

ResetForm(Self); RequestHide();

To possibly track down where the issue is coming from, try adding this code to the "OnError" property of the App:

Notify(
    Concatenate(
        FirstError.Message,
        ", Observed: ",
        FirstError.Observed,
        ", Source: ",
        FirstError.Source
    ),
    NotificationType.Error
);
Trace(
    "Unhandled Error",
    TraceSeverity.Error,
    {
        Kind: FirstError.Kind,
        Message: FirstError.Message,
        Observed: FirstError.Observed,
        Screen: App.ActiveScreen.Name,
        Source: FirstError.Source,
        User: User().Email
    }
)
 

I added the Trace function since you said you were using Monitor.

Mathew Devaney has a great blog post regarding this: https://www.matthewdevaney.com/power-apps-onerror-property-capture-log-unexpected-errors/

This might help you track down where the error is coming from.

If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a Like.

Thanks
-Mark