Combobox multiple selection patch to SharePoint

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi Power Apps community,

I have a problem about Power Apps and have no idea to solve after searching and testing.

Here is the background:

I have a combo box 'ComboBox3' which for select Team Member at Power Apps which allows multiple selection.

And there is a Share Point list 'Shift Turn Registration' to collect records.

There is a columns at Share Point list 'Shift Turn Registration':

Column Name: TeamMember; Column Type: Single Line of Text.

When i select 2 items at Combo Box and click button 'Apply' at Power Apps, there will be 2 records created at SharePoint list.

Below is my formula:

And here is my apps:

When i am trying to patch the values back to my database table, apps pop up an alert like this:

If anyone knows what's the problem and how to improve.

Thanks in advance !

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

DanishIslam 108 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi JOEANLI,

Considering your combobox is a simple choice column, modify your formula as below-

ClearCollect(ShiftTurnSelectedUser,ComboBox3.SelectedItems);ForAll(ShiftTurnSelectedUser,Patch('Shift Turn Registration',Defaults('Shift Turn Registration'),{Title:1, TeamMember:Value}))

Hope this helps.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@DanishIslam
Hi dear,
I tried with your method, but there was still an alert.
Could u please help to review.
Thank u soooooo much!

Was this reply helpful? Yes No
Verified answer

v-xida-msft Microsoft Employee on at

Like
a
(2)

Report
Copy link

Link copied!
Hi @Anonymous ,

Could you please share a bit more about your scenario?

Do you want to patch multiple selections from your ComboBox back to your SP list as separated rows?

Further, could you please share a bit more about the formula you typed within the Items property of the ComboBox? Is it set to a Distinct formula? Or is it bind to a Person type column from a SP List?

Actually, it is not necessary to collect the multiple selections from the ComboBox into a collection firstly. I have made a test on my side, please consider take a try with the following workaround:

Set the OnSelect property of the "Submit" button to following:

ForAll( ComboBox3.SelectedItems, Patch( 'Shift Turn Registration', Defaults('Shift Turn Registration'), { Title: 1, TeamMember: ColumnNameFromComboBox3 } ) )

Note: The ColumnNameFromComboBox3 represents the column from the ComboBox3.SelectedItems formula, which you used as display column value within the ComboBox3.

In addition, if the Items property of the ComboBox3 is set to a Distinct formula, please modify above formula as below:

ForAll( ComboBox3.SelectedItems, Patch( 'Shift Turn Registration', Defaults('Shift Turn Registration'), { Title: 1, TeamMember: Result } ) )

If the ComboBox3 is bind to a Person type column in a SP List, please modify above formula as below:

ForAll( ComboBox3.SelectedItems, Patch( 'Shift Turn Registration', Defaults('Shift Turn Registration'), { Title: 1, TeamMember: DisplayName } ) )

Please consider take a try with above solution, then check if the issue is solved.

Best regards,

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi@v-xida-msft
I want to patch multiple selections from ComboBox back to SP list as separated rows.
And i tried with your formula as:
ForAll( ComboBox3.SelectedItems, Patch( 'Shift Turn Registration', Defaults('Shift Turn Registration'), { Title: 1, TeamMember: DisplayName } ) )

It worked!!!! OMG!!!!
This problem has stalled my development. Now it solved!
I don't know what else can say to you except to be grateful!💓

Was this reply helpful? Yes No
Harris021 181 on at

Like
a
(0)

Report
Copy link

Link copied!
@v-xida-msft Hi, I have very similar issue, because of 5000 records lookup limitation, I have customize my SP library with PowerApps. Below code is my item property for my combo box.
If(IsBlank(DataCardValue4.SearchText), Filter('FileService_neats.Alf', StartsWith(FileName, "1")),Filter('FileService_neats.Alf', StartsWith(FileName, DataCardValue4.SearchText)))
Multi selection is enabled in both SharePoint and PowerApps.
I have created a Save button and I added your code under OnSelect attributes.
ForAll( DataCardValue4.SelectedItems, Patch( 'Harris Document Testing 5000 records', Defaults('Harris Document Testing 5000 records'), { '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference", Title: 1, FileNmae:FileNmae_DataCard1DataCardKey1 } ) )
However, I am still having issue. can you please help.

Was this reply helpful? Yes No