Power Apps: Patch data from the Office 365 Users connector to a SharePoint multi-user field without using collect

michelcarloModern Workplace2 years ago3 Views



Sometimes when building a Power Apps Canvas app we want to use the Patch function instead of Forms to update items in SharePoint for several reasons, such as to have fewer controls in the screen, or to have more control over how the data is updated.

For some complex fields, it can be trickier, as there will be more data manipulation needed and the format varies per field type. Especially when you are updating data using a data source that is not using the Choices function for that field, for example when you use the Office 365 users connector to update a Person field, or when you use data from the source list to update a Lookup field.

Updating multi value fields

To update fields with multiple values we would need to use a table to be the field value instead of a record. For example, if you want to update a user multi field (Person field with Multiple Values enabled), you could use the following syntax (note that only the Claims field is required, this is what SharePoint…



Source link

Leave a reply

Join Us
  • X Network2.1K
  • LinkedIn3.8k
  • Bluesky0.5K
Support The Site
Events
February 2025
MTWTFSS
      1 2
3 4 5 6 7 8 9
10 11 12 13 14 15 16
17 18 19 20 21 22 23
24 25 26 27 28   
« Jan   Mar »
Follow
Sign In/Sign Up Sidebar Search
Popular Now
Loading

Signing-in 3 seconds...

Signing-up 3 seconds...