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
yashag2255
Dual Super User II
Dual Super User II

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
yashag2255
Dual Super User II
Dual Super User II

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

Hi There -

 

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

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

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

Top Solution Authors
Top Kudoed Authors
Users online (1,138)