At first, I had issues with multiple emails for every row that included the emails I was calling out. I was able to fix this with the below flow.
However, now it is sending 1 "group" email with everyone on the email. I would like to separate the emails by the person.
I would appreciate any help!
Hi @Jcook ,
I tried this - but it sent 3 separate emails with all 3 people in it; instead of my earlier issue 1 email with 3 people. I very well could have done this incorrectly....
Getting a little bit closer (see snapshot of the change).... the emails appear to be separated with this - but the data is still for every persons name (not just for the person who's being emailed). How do I separate the date per user? Outputs equals the Union Compose action above as you suggested. I just replaced the To (person receiving email) with Current Item.
Could you give me a sample of your outputs that is coming from the Excel 'List rows present in table' this way I can mess around with the data to get this to work. I will be off for a couple hours.
My time zone is Mountain Daylight Time (UTC-6).
We can do a screen share tonight if you need.
I went ahead and threw together a sample file so you can see the main columns that it is looking to.
I am not sure how to share an excel file on here. I will include snapshots for now.
Essentially, there are about 8 people or so total.. (Owner column)
The IF_Emails column is a look up to the Owner Column that will populate their email address based on the Owner name.
The US _Lifecycle column shown in the below snapshot will either be 1 or 0 based on a formula I have on this column.
This is a huge workbook with this sheet containing multiple columns. I took a snapshot of the table columns I am extracting (which are not shown in my sample excel file here (except for the Owner column). See below snapshot for the table columns.
I also included a snapshot of my List Rows Present in a Table