Share
Report
50I have a flow that looks like this:
What it does is:
Every Monday morning it checks a Power Bi Dataset that's been published online and runs a paginated report based on that data. It creates an excel file, saves that into sharepoint, and then sends a link to that excel file to people in Teams.
Well, what the excel file actually contains is a list of patients that will be visiting our hospital for clinical trials this week. Looks like this:
What I'd love to do is create a flow on Friday of every week that's pretty much just "hey did those people from that excel show up?"
Solutions I thought of that don't work great:
-Just sending a list of everyone who visited this week. Probably too many people, not the people from the list, might have been visits that were planned and occurred after this Monday list was sent.
-Reading back in this excel and checking it vs subject visits. Not great because this excel will be getting modified all week. Maybe if it was a different copy?
-Also, as a new file with new file name is saved every monday, I dont know how to tell an automated flow to "grab the most recent one".
Any thoughts? I know i'll have to figure out the coding to compare vs visits, but does anyone have a solution for how I can use monday flow results in a friday flow?
All responses (
Answers (
