Hello, and thank you kindly if you can help. โฎ๐โ
I have a Power Automate process that is working well. The process queries a tabular model, retrieves a date from a date table, and stores it in a SharePoint list. Then, a second flow checks if this date is one day behind the current date. Since the data model is always a day behind, this indicates that the system is up to date.
Hereโs how it works:
This process works as intended. However, Iโve been asked to address an additional scenario, and Iโm unsure how to implement the logic.
The new requirement is:
If the system is initially marked as โnot up to dateโ but later updates within the same day (e.g., the tabular model data refreshes), Iโd like to send an email indicating the system is now up to date.
Key conditions:
Is it possible to build this kind of logic in the Power Automate flow that i already have, or too complex? If so, how would you recommend structuring it?
My 2 flows that I have currently that work well are below:
FLOW 1:
FLOW 2