Unanswered

Patch multi select combobox items in different rows in SP

(0) Share

Report

Posted on by IL_for

Hi all,
I have a simple case where I would like to save each selection made in a dropdown combobox to a different row in SP.

The SP column is a single line text and combobox Item property is "Table({Item:"Op1"},{Item:"Op2"}) ". No fruitful results so far and I ve tried all combinations found online.
E.g. I want to select Op1 and Op2 and save the records in two subsequent rows. With the script below I ve managed the same entry two times.

Op App.PNG

Any help will be appreciated.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

Anonymous_Hippo 1,247 Super User 2024 Season 1 on at

Like (1)

Report
Hello @IL_for ,

You are in the right direction ! we just need to make few tweaks in the code. While iterating we need to use the current record and not Combobox1.Selected.Item (because this will have all the selected value)

We have two options

//Option 1 works for collection/recor with only one column ForAll(ComboBox1.SelectedItems,Patch(Notifications,Defaults(Notifications),{Operator:Item})); //Option 2 Normally useful when you are trying to do a forall loop on a collection or dataset with multiple columns ForAll(ComboBox1.SelectedItems As TestCollection,Patch(Notifications,Defaults(Notifications),{Operator:TestCollection.Item}));

Hope this helps !

Cheers

Was this reply helpful? Yes No
IL_for 7 on at

Like (1)

Report

Hi @Anonymous_Hippo,
Thank you for taking the time to read and reply to my query! Option 2 is what I needed.
I cant describe how thankful I am!
Keep up the good work.

Was this reply helpful? Yes No
Anonymous_Hippo 1,247 Super User 2024 Season 1 on at

Like (0)

Report

Cheers !

Was this reply helpful? Yes No