Answered

Save more than one selected items in datasource by power apps

(0) Share

Report

Posted on by lisha

Hi Everyone,

I have one question, how can we save more than one item in the data source when we are selecting more than one or two items from the combo box? In my case, it is only saving one item that is selected in the last. How can I solve this?

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

CharlesGN 29 on at

Like (0)

Report
Copy link

Link copied!

Heij !

I think you can found your answer in this thread :
https://powerusers.microsoft.com/t5/Building-Power-Apps/Patch-ForAll-Combobox-Items/m-p/1502797

If you use SharePoint List, the Patch() and ForAll() functions can be your savior 😊.

Have a great day !

Was this reply helpful? Yes No
lisha 80 on at

Like (0)

Report
Copy link

Link copied!

Hi @CharlesGN ,

No, Actually I want to select the multiple values from combo box which is in the form. So if I am using patch function and for all in it then this will create multiple records with same value selected in the last in combo box.

Was this reply helpful? Yes No
uwenagel 382 on at

Like (0)

Report
Copy link

Link copied!

Look to this thread:
https://powerusers.microsoft.com/t5/Building-Power-Apps/Patch-a-multiple-value-choice-column-with-multiple-value-combo/td-p/871530

I think it will answer your question.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item.

If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @lisha,

Have you solved your problem?

Do you want to save multi selected items to data source?

Could you please tell me how you set the Items property of the Combo Box and what the column type of the column that you want to save the selected items to?

If the column you want to save the selected items to is a Choice type allowing multi select, you should set the Update property of the data card as below:

ComboBox.SelectedItems

However, if you want to save selected items to a Text column, and you set the Combo Box Items property as List.TextColumn(Here TextColumn is from another column), you should set the Update property of the data card as below:

Concat(ComboBox.SelectedItems,TextColumn,",")

Was this reply helpful? Yes No