Filter list by PowerApps multi select listbox and concatenate all values of a selected row for email distribution

(0) Share

Report

Posted on by DaveWZ

HI,

New to powerapps and this forum so apologies if this has been answered or my post etiquette is not right.

I have an app designed for mailing selected customers to a major incident of our product.

This has a data source of a list called 'Major Incident Comms Matrix' that has a concatenated formula for column "emaildistrib" on all emails.

On the app there is a listbox called customerBox(heighted in red) that filters the 'Major Incident Comms Matrix' list based on the product dropdown = 1.

What i am trying to achieve is an email distribution list based on the 'Major Incident Comms Matrix'.emaildistrib column for all values selected from the customerbox listbox. This needs to be concatenated into one email BCC distribution and will be sent using powerapps/powerautomate.

could anyone give me some pointers?

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

WiZey 3,023 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Hello @DaveWZ ,

"Filter()" can help you retrieve the value of "EmailDistrib" based on the ID (or the name) of the items you have selected from the ListBox. The function will return a table, from which you can concatenate the rows with "Concat()".

Concat(Filter(ListSharePoint;ID in ListBox.SelectedItems.ID), EmailDistrib, ';')

With this, you will have a string with the concatenated values of all "EmailDistrib" from the multiple customers you have selected in your ListBox.

You can then send an email with "Office365Outlook" using "SendEmailV2()" with the previously built string. The message you send via mail can be formatted with HTML code.

Hope this helps.

Was this reply helpful? Yes No
DaveWZ 4 on at

Like
a
(0)

Report
Copy link

Link copied!

Thankyou sir

Was this reply helpful? Yes No