cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
simms7400
Level 8

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

Re: Multi Select Field & populating another field

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

Re: Multi Select Field & populating another field

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

simms7400
Level 8

Re: Multi Select Field & populating another field

Hi There -

 

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

Helpful resources

Announcements
thirdimage

Power Apps Super User Class of 2020

Check it out!

thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

SecondImage

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (4,424)