Dear Experts,
I have a power automate flow that has a Union function which is working perfectly.
I need to make the below adjustment to the flow, and I am having trouble to adjust this one input.
As per the below data in the spread sheet (attachment V2-1), the flow should send 1 email containing the first two rows in the spreadsheet (because it is being sent to one user) and then 1 email to the 3rd row.
CC email in column (L) is different – L2 is different than L3 – and therefore the fist email that should be sent tot he first user is being sent twice, which is not what is intended from this flow.
I want the flow to send one email to first user (1111111 – Mona Hotmail) , this email should contain the first two rows, and in the send an email V2 variable, I want to add a dynamic variable for the CC email so I can CC it in the email. ( check attachment V2-2)
The CC Email showing in the attachment , should be CC email in Column L2 and CC email in Column L3.
Sorry if this sound too confusing, I tried to explain it as much as possible. Thank you for any help 😊
32
Share
Report
All responses (
Answers (
