Answered

Patching combobox multi select values to SharePoint

(0) Share

Report

Posted on by PowerApps880

Hello,

I have two multiselect combobox, first one select user (combobox1) and other select approver (combobox2). I want to patch that to sharepoint list but I am unable to do so, please guide as I am new to powerapps.

Suppose in combobox1 selected users are User1 and User2 and in approver combobox is approver1 and approver2, it should create 4 entries in Sharepoint like User1 and Approver1, User1 and Approver2, User2 and Approver1 and User2 and Approver2. I think it can be achieved by nested forall but I am not able to figure it out. Please help

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @PowerApps880 ,

Could you please share more details about your scenario? Would you like to add multiple entries into four SharePoint Text columns?

Best regards,

Was this reply helpful? Yes No
PowerApps880 10 on at

Like
a
(0)

Report
Copy link

Link copied!

SharePoint has only two columns User and Approver that should be patched based on selection on Comboxes, if the Comboxes has selection as Comobox 1 : User 1, User 2 and Combobox 2 : Approver 1 and Approver 2. This should create four entries in SharePoint as User1 and Approver 1, User1 and Approver2, User2 and Approver 1, User2 and Approver2.

Was this reply helpful? Yes No
FazalUrrehman 131 on at

Like
a
(0)

Report
Copy link

Link copied!

What's Exactly not working ??

Was this reply helpful? Yes No
Verified answer

v-jefferni Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @FazalUrrehman ,

If the two columns are both of type Text, then the formula to a button in your app should be:

Patch(YourList, UnGroup(ForAll(UserComboBox.SelectedItems As UU, ForAll(ApproverComboBox.SelectedItems As AA, {User: UU.DisplayName, Approver: AA.DisplayName})),"Value"))

Items properties of both Combo box are as below, so I use DisplayName field values in the formula:

Office365Users.SearchUserV2({searchTerm:Self.SearchText}).value

Best regards,

Was this reply helpful? Yes No
PowerApps880 10 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks, I was stuck in the second forall. This works

Was this reply helpful? Yes No