cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
lisha
Helper II
Helper II

Save more than one selected items in datasource by power apps

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

1 ACCEPTED SOLUTION

Accepted Solutions

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,",")

 

Best Regards,
Qi

View solution in original post

4 REPLIES 4
CharlesGN
Regular Visitor

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 ! 

lisha
Helper II
Helper II

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. 

uwenagel
Resolver II
Resolver II

Look to this thread:

https://powerusers.microsoft.com/t5/Building-Power-Apps/Patch-a-multiple-value-choice-column-with-mu... 

 

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.

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,",")

 

Best Regards,
Qi

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Carousel_PP_768x460_Wave2 (1).png

2022 Release Wave 2 Plan

Power Platform release plan for the 2022 release wave 2 describes all new features releasing from October 2022 through March 2023.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Top Solution Authors
Users online (3,308)