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…
More About This Author
SharePoint and Office 365 Consultant/Developer always trying to get the best from Microsoft stack (Microsoft 365/Azure/Power Platform and related stuff).
Living in Ireland since 2018, I had previously worked in Brazil as a consultant/developer for Office 365, SharePoint and related technologies for almost 10 years.
- ModernWorkplace2022.06.08Updating list views JSON formatters for a SharePoint list using Power Automate
- ModernWorkplace2022.05.19SharePoint lists custom View and Edit Buttons using JSON Formatting
- ModernWorkplace2022.05.14Power Apps: Patch data from the Office 365 Users connector to a SharePoint multi-user field without using collect
- ModernWorkplace2022.04.30Glossary View formatting: JSON Template including Related Link