You’re offline. This is a read only version of the page.
Announcements
I have the flow working for a single query. When the scheduled recurrence happens, it goes to ADO and gets query results for "Missing Target Date", counts the total items, then select the "ID"s and creates a table of the items, I fix/format some string values to get a clean list of "Assigned To" then I remove the duplicates so it's a single list of names/emails.
From the output of my "RemovedDupes" email variable, I run an Apply to Each loop, then filter the array through each item, I then build another table of the items that are specific to each person, I run a few other string formatting steps to clean up the email address/assigned to field, and the final step of the loop is to send an email to the individual.
This works perfect for 1 query, each person receives an email with all of the items that are "Missing Target Date".
For the next version of this flow, I'm trying to add a few more queries: "High Risk Items" and "Past Due Items" etc, so the individual receives a single email with 1-5 tables "if" their names are included in the list/queries "Assigned to".
I built an additional 4 branches with the same logic, but I don't quite understand how to combine the branches into a single loop
Has anyone done this before? Have any advice?
this is the loop that sends the email
email sent:
work in progress with 5 queries on branches, and 5 apply to each steps (I need 1 apply to each, but confused on how to set up)
Hi, Are you able to provide a screenshot of your original flow for emailing the results to the assigned to for 1 query. I am doing something similar and want to see how you built yours. Sorry, that I am not able to provide insights on your original question but I thought I'd reach out.
Specifically this part of your flow
Share
Report
All responses (
Answers (
9
