Send email with data from both outcomes of the Condition, Yes and No.

(0) Share

Report

Posted on by Dlehman3750

Creating a flow for when a user drops 2 files in a folder:

One is a .pptx file that needs a digital signature
Second file is supporting data file for the .pptx that could be .xlsx or .pdf

Using Condition to determine if it is a .pptx or not and then gathering data from both sides of Condition (Yes and No) and then inputting data in one email to send to personnel.

Problem is that I get two email, one has all the data for the .pptx file the other has the data for the other support file.

How do I create one email with both sides of Condition data?

FLOW:

Pic 1.png

Pic 2.png

EMAIL SENT:

Pic 3.png

Pic 4.png

Thanks in advance for any support.

Categories:

Building flows

I have the same question (0)

All responses (7)

Answers (0)

Afurness23 31 on at

Like (0)

Report

I wonder if something like this would work for what you need?

Was this reply helpful? Yes No
Dlehman3750 8 on at

Like (0)

Report

Afurness23 -
Are you running that after the Send Email? I cannot see top but it looks like it starts from my final Send Email.
Wouldn't that still send out the original two email?
I will test and let you know results.

Was this reply helpful? Yes No
Afurness23 31 on at

Like (0)

Report

No--I added some quick placeholder steps for testing, but basically get the file data, use filter array instead of a condition to split on .pptx or another file extension, then initialize a variable for each outcome that can then be referenced in your e-mail.

Was this reply helpful? Yes No
Dlehman3750 8 on at

Like (0)

Report

So it did work, it sent one email with both of the files data, but it sent ALL the data collected.

How can I just pull the link to open the file and use file name as the name for the link in the email?

Was this reply helpful? Yes No
Afurness23 31 on at

Like (0)

Report

When you tested, did you copy the formula from your original flow in compose/compose 2 to recreate the hyperlinks in the initialize variables steps?

Was this reply helpful? Yes No
Dlehman3750 8 on at

Like (0)

Report

What would I use in the formula to select the proper data?

Was this reply helpful? Yes No
Afurness23 31 on at

Like (1)

Report

Hi! I did some more thinking on this, and am wondering if this needs another trigger since it should be multiple files being uploaded and not just one. I had success with this:

PPTX Email Flow.docx

Was this reply helpful? Yes No