Power Platform Community Forum Thread Details

Adding Value from previous step into Send an Email

Hello,

My flow build attempt should work as follows.

1. grab table from SP

2. List rows present in a table (filtered to a specific date)

3. Filter to rows that have a status of Incomplete.

4. Append to arrary (create a customer ID list from Account column found in table)

5. Union Self (CustId list to CustId list)

6 Filter array where current item is equal to CustId (Account).

7. Select Columns for table

8. Create table

9. Format table

10. Send email

The table should have all rows with the same CustId (Account) included in the body of the email. If the CustId appears 3 times on the excel file than all 3 rows would be included in the one table and only one email will be sent. What I am having issues with is getting the CustId (Account) added to the subject line of the email and having only one email sent. When I try to add the value from List Rows Present in a table it creates another Apply to each and I don't want that as it sends one email per row. So in the above example it sends 3 emails. I tried adding a compose step after the Filter array where current item is equal to CustId (Account) step but that didn't work. Any help is greatly appreciated!