Unanswered

Send a unique table to Teams user

(0) Share

Report

Posted on by AnitaE61

Wanting to send HTML table from Excel document to multiple users using Power Automate. I want each user, which are identified by email address column, to receive HTML table with only those rows that contain that individual's unique email address (one Teams message per person). I was able to loop through and get the unique email addresses, but now need to send Teams message with unique HTML table. However, when I trigger the flow each person gets the whole table & not just their own data. How do I send each person just their unique table? I can do it with emails but cannot do it with Teams. This is my flow

Grateful for your help

Categories:

Building flows

I have the same question (1)

All responses (4)

Answers (0)

Sort by

efialttes 14,756 on at

Like (1)

Report
Copy link

Link copied!

Hi @AnitaE61 !
I believe with both "Select PM Email" and "Compose - Group Emails" action blocks you are building an array with all the email addresses, and then you assign this array as the input for the 'Apply to each' action block, right?
Next, I assume in your test execution you are obtaining two email addresses so that's the reason 'Apply to each' is executed twice (i.e. two iterations), right?
I also assume when you inspect 'Filter array' execution in the first and second iteration, you verify the desired rows are filtered by means of the email selected in that iteration, right?
Finally, which input did you assign to 'Create HTML table'? If you assigned 'Filter array' output as its input the flow should work as you expect, but if you assigned 'List rows present in a table' output instead, than the same whole table will be sent to both email addresses without filtering
Hope this helps!
============

Was this reply helpful? Yes No
AnitaE61 10 on at

Like (0)

Report
Copy link

Link copied!

Hi @efialttes , thank you so much for your response.

I can confirm your comments listed below are correct
I believe with both "Select PM Email" and "Compose - Group Emails" action blocks you are building an array with all the email addresses, and then you assign this array as the input for the 'Apply to each' action block, right?
Next, I assume in your test execution you are obtaining two email addresses so that's the reason 'Apply to each' is executed twice (i.e. two iterations), right?
I also assume when you inspect 'Filter array' execution in the first and second iteration, you verify the desired rows are filtered by means of the email selected in that iteration, right?

The input I assigned to the Create HTML table was the value from the List Rows Present in a Table as it was the only way I could pull the data for the columns I needed

However, if I assign the Filter Array as the input, it changes the fields and sends an empty table

This is the empty table it sends

When I change the column values to the items()?['column header'] this is what I get
and when running the flow I get this error message

I appreciate your help

Was this reply helpful? Yes No
AnitaE61 10 on at

Like (0)

Report
Copy link

Link copied!

Hi @efialttes

Figured it out, I rewrote the 'Apply to Each' using the output from the Compose Group - Emails, then adding the Filter Array from the value of the List rows present in a table, taking the PM column is equal to current item, I think this is where the original one went wrong, though the two test emails showed up on the outputs from the Filter Array, it was not grouping the rows. Then as you mention above the Create HTML Table was using the body from the Filter Array which then let me enter the values. In the Post Message in a chat or channel step I entered the current item in recipient field. Retested it and now each person gets only their rows.

Thanks so much for your help with this.

Was this reply helpful? Yes No
efialttes 14,756 on at

Like (0)

Report
Copy link

Link copied!
Hi again!
I believe the combination you shared that is currently providing as output empty HTML tables is the right approach. So what can be wrong?
My next suggestion is to please open your flow on Power Automate editor, expand the 'Filter array' action block and share a screenshot with its current design.
I would also recommend you to add a 'Compose' action block just after 'Filter array' with the following WDL expression for troubleshooting purposes, i.e. it will provide number of matching Excel rows obtained by 'Filter array'

length(body('Filter_array'))

Reexecute your flow and inspect output provided in this new 'Compose' action block on both iterations. If its value is 0, the HTML table will be empty, meaning you should redisign the 'condition rule' in your 'Filter array'

Hope this helps

Was this reply helpful? Yes No