Answered

Send a single email to requestor with multiple items

(0) Share

Report

Posted on by tagustin2020

Hello,

I am trying to send a .csv report to whoever pushes the download button in a Power App. During testing, I'm receiving an email for each and every item in the report. I've tried a variety of Select and Compose Join Statement approaches, but nothing seems to work. Everything else in the app works fine. For example, the .csv report is generating just fine. I'm supposed to demo this app on March 20 at 1pm PST so if anyone could help me figure out what I am doing wrong I would be very grateful. Thanks! Teresa

Here are the basic flow steps:

Flow Steps 1-3.png

Flow Step 4.png

Flow Step 5-6.png

The body here is coming from the Parse JSON step. There are currently 2 items in the report so I am receiving 2 separate emails.

Flow Step 7.png

Here are some of the approaches I have tried.

GET USER PROFILE > SET EMAIL IN VARIABLE > COMPOSE UNION

Compose Email Union Steps.png

User Profile Results:

Compose Email Union Results.png

Here I tried adding a Select step for the "Report Email" dynamic content coming from the Parse JSON step.

Select and Compose Steps.png

Here are the flow run results.

Select Results.png

The Join function reduces it to a single email, but not in a form I can use in the To line of the email step.

Union Results.png

Categories:

General topics

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Mira Ghaly 11,415 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@tagustin2020

So the issue is mainly is caused by the highlighted field in the send email step below:

Is this field Unique across the whole list you are sending in the email or it is different.

If possible please paste a sample from your Json object and I will work out how it should be, I will need the below possible from the flow run history

Was this reply helpful? Yes No
tagustin2020 on at

Like
a
(0)

Report
Copy link

Link copied!
@Mira_Ghaly

Hello Mira,

The report email will be unique (just the email of the person who pressed the button). Here is the Collection from the Power App button.

Here are the Outputs of the Compose action test entries. Scroll down to see the text version.
[{"Barcode Value":"4732425107","Calibration Date":"2023-03-31","Calibration Due Date":"2024-03-31","Location":"Cleanroom 2","Report Email":"teresa.agustin@tektronix.com","Tek Trace Bench ID":"TT0011234","Tool Asset Number":"A12345","Tool Description":"Swingline Stapler"},{"Barcode Value":"8295871158","Calibration Date":"2023-02-01","Calibration Due Date":"2024-02-01","Location":"Cleanroom 1","Report Email":"teresa.agustin@tektronix.com","Tek Trace Bench ID":"TT32423432","Tool Asset Number":"987456","Tool Description":"Hole Punch"}]
Thank you for taking a look at this for me!

Sincerely,
Teresa

Was this reply helpful? Yes No
tagustin2020 on at

Like
a
(0)

Report
Copy link

Link copied!

@Mira_Ghaly

Hello Mira,

Just checking in. I hard-coded the email address to myself for the sake of the demo I presented yesterday, but I still haven't figured out a solution. I'm sure you are quite busy, but if you could take a look at the info I passed on to you in response to your latest post I would greatly appreciate it. Thanks!

Teresa

Was this reply helpful? Yes No
Verified answer

Mira Ghaly 11,415 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
@tagustin2020

Sorry for not getting back to you earlier so you will need to take the email out of the Apply to each and use the below expression on the To:

first(body('Parse_JSON'))['Report Email']

Was this reply helpful? Yes No
tagustin2020 on at

Like
a
(0)

Report
Copy link

Link copied!

@Mira_Ghaly

Hello Mira,

I'm sorry it took me a while to respond. Saturday was the first day I could get back to this flow. I made the change and tested it and only received one email. Thank you so much for your help!

Teresa

Was this reply helpful? Yes No