Answered

Combining Outputs from Parallel Branches into One Email Action

(0) Share

Report

Posted on by bchager6

132

I'm hoping for some general guidance here. As you can see, I have two parallel branches where I'm running queries against 2 different Power BI datasets. I parse JSONs, get distinct emails, and create HTML tables that I'd like to insert into one email action.

I'm trying to understand if it's possible to combine the distinct emails and tables from both branches to be used in one email action.

Thanks in advance to anyone who can guide here!

p.s. Those are 2 separate pictures from the same flow. The Apply to each and Get distinct email actions are connected.

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Building with Why 351 Moderator on at

Like (1)

Report
Copy link

Link copied!

you want to combine the steps at the end to send a single email? yes. Turn off the "new" editor and the merge paths will become obvious.

Was this reply helpful? Yes No
Suggested answer

Vejai SH 560 on at

Like (1)

Report
Copy link

Link copied!

Hi @bchager6,

Initialize an array variable before your BI report query. In both branches, append values to this array. Then, merge the branches and use the array variable to send an email.

Thanks,

Vejai SH

Please mark as answer if my suggestion helps you.

Was this reply helpful? Yes No
Verified answer

bchager6 132 on at

Like (0)

Report
Copy link

Link copied!

The solution that worked for me was to deduplicate the emails from both branches with a union, merge the branches used to create the HTML tables after the union, use the Current item from the Apply to each action in the "To" section of the email, and the HTML style and Clean HTML actions in the body of the email. Close to what @Vejai SH recommended.

Was this reply helpful? Yes No