Unanswered

How to separate the data by the users name and then email each of the users names separately with the accompanying data for each? see post for more info.

(0) Share

Report

Posted on by hiltgena

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!

Categories:

General topics

All responses (5)

Answers (0)

Sort by

Jcook 7,783 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @hiltgena

You will want to pass the outputs of the union expression into another apply to each loop. And put the send email action in there.
hiltgena 8 on at

Like
a
(0)

Report
Copy link

Link copied!

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....
hiltgena 8 on at

Like
a
(0)

Report
Copy link

Link copied!

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.
Jcook 7,783 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @hiltgena

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.
hiltgena 8 on at

Like
a
(0)

Report
Copy link

Link copied!

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