Unanswered

Patch function - patch people selected in a combo box to multi-person SharePoint column

(0) Share

Report

Posted on by AntDim

I've got a combo box in my app with Items property:

Office365Users.SearchUser({searchTerm:'Expense Approvers ComboBox'.SearchText}).DisplayName

I'm using a Patch function in the OnSelect of a button to patch into a SharePoint List. My function is like that:

Patch('Travel Expenses',Defaults('Travel Expenses'),
{Title: 'Expense Title Input'.Text,
'Travel Date': 'Expense Date Picker'.SelectedDate,
Cost: Value('Expense Cost Input'.Text),
Approvers: 'Expense Approvers ComboBox'.SelectedItems
}
)

I've tested the formula and it all works fine if I leave the last line (Approvers: xxx) outside. 'Approvers' is a multi-person SharePoint Column in my dataset

Looking at this article:

https://www.matthewdevaney.com/power-apps-patch-function-examples-for-every-sharepoint-column-type/patch-a-sharepoint-person-column-with-multiple-people-in-power-apps/

and watching this Shane Young video:

https://www.youtube.com/watch?v=b4Fb57UsJLI

I was under the impression my function would work ok, but it is producing an error.

Any thoughts what's the fix?

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Mitchelvdh 6 on at

Like (0)

Report
According to your first article, it must be something like this (change the static values, ofcourse):

Patch('Travel Expenses',Defaults('Travel Expenses'), {Title: 'Expense Title Input'.Text, 'Travel Date': 'Expense Date Picker'.SelectedDate, Cost: Value('Expense Cost Input'.Text), Approvers: { '@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser", Claims: "i:0#.f|membership|djohnson@companyname.com", Department: "Technology", DisplayName: "David Johnson", Email: "djohnson@companyname", JobTitle: "", Picture: "" } } )

Was this reply helpful? Yes No
AntDim 70 on at

Like (0)

Report

Hi Mitchelvdh, thanks for your comment.

Hm, I don't think so because if you scroll down the article in the section with the combobox, you'll see this formula being used (screenshot attached). I was trying to make this formula work as it's simpler, plus your suggested formula above includes static values for email etc. which I do not know how to make dynamic in my case (which is what I need)

Was this reply helpful? Yes No