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:

Business Process Flows

All responses (7)

Answers (0)

Afurness23 31 on at

Like (1)

Report

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

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
Dlehman3750 8 on at

Like (0)

Report

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

What would I use in the formula to select the proper data?
Afurness23 31 on at

Like (0)

Report

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

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?
Dlehman3750 8 on at

Like (0)

Report

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

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?
Afurness23 31 on at

Like (0)

Report

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

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

Like (0)

Report

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

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.
Afurness23 31 on at

Like (0)

Report

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

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