Get Values Based on Multiple Item Selection from Combobox

[AkshayManke]

Hi,

I have an Canvas Application in which the user will submit a form by filling the information. In that form i have added a Combobox which is configured with a collection containing below table information. 

Product	Owner	Email
Product A	James	james@abc.com
Product B	Mahesh	mahesh@abc.com
Product C	Abhishek	abhishek@abc.com

Collection Name: ProdTable

Combobox Name: cb_Product

In the combobox i am showing Product and Owner.

What i want is: when user selects a specific product name and owner then the respective users email should get appear in a different datacard or label or taxtbox. 

Multiselect to be enabled in the combobox, hence for example if a user is selecting 'Product A' and 'Product B' then i need 'james@abc.com' and 'mahesh@abc.com' these two email addresses to be added in to the datacard or label or textbox, separated by a comma or semicolon.

Can anyone please help on how to achieve this?

Warm Regards,

Akshay

[WarrenBelz · Accepted solution]

Hi @AkshayManke .

The Default of a Text box or Text of a Label would be

Concat(
   cb_Product.SelectedItems,
   Email & ";"
)

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.

Visit my blog Practical Power Apps

[AkshayManke]

Hello @WarrenBelz, 

It is working exactly as expected. Thanks a ton for your great help... 😊

Warm Regards,

Akshay