cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
simms7400
Post Prodigy
Post Prodigy

Multi Select Field & populating another field

Hi Folks,

 

I have a multi-select field in my PowerApps application (SP is the source). The ComboBox displays a list of Descriptions for a collection of data elements. In the past, this field was just a single select so then I had another field I dynamically populated using a LookUp to return the unique ID based on the description selected.

 

However,  this get a tricky with the multi-select.  For instance, if a user select "Desc1" and "Desc2" I want me other field to populate with "123" and "456".

 

Here is the table layout.

 

snag.PNG

 

Is that possible? Both fields should be comma delimited (if more than 1 is selected).


Thank you!

1 ACCEPTED SOLUTION

Accepted Solutions

Hi @simms7400 

 

Can you please confirm if you are passing the values using the canvas app or if this is a calculated field, which automatically calculates the data based on input in first field.
 
If this is done through the powerapps, you can update the config as:
 
Edit Form -> Update property of second datacard: Concat(Filter(SPListName, Desc in Combobox1.SelectedItems.Desc),ID,",")
 
Individual Controls -> Patch formula -> Patch(SPListName,Defaults(SPListName),{Title:"ABCD",FieldName: Concat(Filter(SPListName, Desc in Combobox1.SelectedItems.Desc),ID,",")})
 
Hope this Helps!
 
If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

View solution in original post

2 REPLIES 2

Hi @simms7400 

 

Can you please confirm if you are passing the values using the canvas app or if this is a calculated field, which automatically calculates the data based on input in first field.
 
If this is done through the powerapps, you can update the config as:
 
Edit Form -> Update property of second datacard: Concat(Filter(SPListName, Desc in Combobox1.SelectedItems.Desc),ID,",")
 
Individual Controls -> Patch formula -> Patch(SPListName,Defaults(SPListName),{Title:"ABCD",FieldName: Concat(Filter(SPListName, Desc in Combobox1.SelectedItems.Desc),ID,",")})
 
Hope this Helps!
 
If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Hi There -

 

@yashag2255   worked like a charm...Thank you!

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