Power Platform Community Forum Thread Details

Hi all, I am hoping someone out there can help me with an issue I am having with a combobox (Select Multiple- False) which uses the NHS tenant directory. I am attempting to code an 'update' button, that updates a list item based on the selection of gallery items via checkbox and the combobox and date picker. I had this working using a choice column for AssignedUser, but I cant for the life of me use the combobox with NHS Directory.

User selects gallery items, these are stored in a collection colSelectedItems
User selects a date from a datepicker, and the user. (These are set to default today() date and user()
User updates items, so they have the BookingDate and AssignedUser populated on the SharePoint List.

Please note, this is code that worked on the principle of the drop down, with persons as choices rather than combobox of NHS users. The Function UpdateIf has some invalid arguments and invalid argument type. Expectign a Record value, but of a different schema. The AssignedUser Combobox is connected to Office655 users

Office365Users.SearchUser({searchTerm: Self.SearchText})

ClearCollect(
    colIDs,
    ForAll(
        colSelectedItems,
        {ID: Value(ID)}
    )
);
UpdateIf(
    'LDLL V2',
    ID in colIDs.ID,
    {
        AssignedUser: CmbAssignedUser.Selected,
        BookingDate: DatePicker.SelectedDate
    }
);
Notify(
    "Updated selected items",
    NotificationType.Success,2000)

Categories:

Building Power Apps

Hi,

The error is because CmbAssignedUser.Selected is an Office365Users record, but a SharePoint Person column expects a SharePoint person record with fields like Claims, Email, DisplayName, Department, JobTitle, and Picture.

UpdateIf/Patch can update records, but the replacement value must match the column schema. Microsoft’s UpdateIf docs describe it as modifying values in matching records, while the Office 365 Users connector returns user profile data, not SharePoint person-column records.

AssignedUser would look like:

AssignedUser: {
                    '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
                    Claims: "i:0#.f|membership|" & Lower(varUserEmail),
                    DisplayName: CmbAssignedUser.Selected.DisplayName,
                    Email: varUserEmail,
                    Department: Coalesce(CmbAssignedUser.Selected.Department, ""),
                    JobTitle: Coalesce(CmbAssignedUser.Selected.JobTitle, ""),
                    Picture: ""
                }

If you have any questions or feedback, please let me know. Have a great day! 😊

-----------------------
SpongYe Power Platform Enthusiast [LinkedIn] | [Youtube| [My blog]

I love to share my knowledge and learn from others. If you find my posts helpful, please give them a thumbs up 👍 or mark them as a solution ✔️. You can also check out my blog [@S pongYe] for some cool solutions and insights. Feel free to connect with me on any of the platforms above. Cheers! 🍻