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
User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Power Apps Community Call Jan. 2022 768x460.png

Power Apps Community Call

Please join us on Wednesday, January 19th, at 8a PDT. Come and learn from our amazing speakers!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (2,446)