I have two SQL queries that are running against two separate SQL instances (servers). I need to take the values returned, find the difference in them, and depending on that result send an email. My plan is to have these queries scheduled and sent to my inbox (SSRS). I can create a flow for each query to look in my inbox and create a OneDrive excel file. I would need an additional flow to take these results when their files are created and compare them, like below. Last, on one of the email conditions I would need to attach a pdf report. That report is sent automatically as well, so I think I would need an additional flow to upload that to OneDrive. Is there a more efficient way to approach this problem? I know multiple triggers aren't supported in single flows, but having to create this many flows seems a little difficult to manage.
note: The data is on premises and I do not have a data gateway installed.

Report
All responses (
Answers (