I keep getting an error where my multiselect dropdown does not work on adding the data to my sharepoint list.
The sharepoint column's properties are: People field, does not allow selection of groups, and allows multiple selections.
My dropdown control in PowerApps has the Items field as Choices('My Sharepoint List'.mypeoplecolumn).
My Patch function is
ForAll(
MyPowerAppsGallery.AllItems,
(Patch(
'My Sharepoint List',
Defaults('My Sharepoint List'),
{
mypeoplecolumn: mypeopledropdown.SelectedItems
What's the workaround in patching the data? The errors I get is something related to IOConvertible. Many thanks!
Hi @migiiyaa ,
Do you want to update a multiple people column?
Firstly, since it is a multiple people column, you should use combo box instead of drop down.
Drop down control is used for single choice.
Inset a combo box, and set its Items: Choices(listname.columnname)
Secondly, according to your formula, I'm a little confused.
Here are a few of my assumptions:
1)create a new record
Patch(listname,Defaults(listname),{columnname:ComboBox1.SelectedItems})
2)modify multiple records
ForAll(MyPowerAppsGallery.AllItems,
Patch('My Sharepoint List',LookUp('My Sharepoint List',ID=MyPowerAppsGallery[@ID]), {mypeoplecolumn: ComboBox1.SelectedItems}
)
)
3)create multiple records
ForAll( MyPowerAppsGallery.AllItems, Patch( 'My Sharepoint List', Defaults('My Sharepoint List'), { mypeoplecolumn:ComboBox1.SelectedItems}
)
)
Best regards,
Community Support Team _ Phoebe Liu
Sorry for my terminology! But I was indeed using a combo box, the correct assumption is the 3rd. Although we have the same formula, it just doesn't seem to work on my end. Thanks for the response!
User | Count |
---|---|
140 | |
138 | |
78 | |
77 | |
70 |
User | Count |
---|---|
223 | |
180 | |
69 | |
64 | |
58 |