Hi,
That's a great use case. I will use the following SP List as sample data for this solution;
To start, you can add a Recurrence trigger (highlighted in orange) and set up the frequency to 1 day (highlighted blue). You can also set a time for the flow to run (highlighted in red). After that, add a Get items action (highlighted in green) and populate it with the respective List (highlighted in yellow). It will access all records from your List:
Now you can add an Apply to each loop (highlighted in red) and pass the dynamic content from the body/value property of your Get items (highlighted in blue). This action will iterate all records from you SharePoint List and perform some steps to each one of them. I'm also including a Compose to simply print the values from each iterated record when the flow runs, but this is not a required step:
Inside the loop, add a Condition and in the left-side input, add the dynamic content of your days count column (days_late in my case). Set the center dropdown to is equal to (highlighted in green) and type your respective notification days qty in the right-side input (highlighted in orange). Add two more statements by clicking in New item (highlighted in red) and repeat the same process, just changing the quantity of days in the right-side input to match your 3 scenarios. Before moving forward, change the operator on the top-right corner to OR (highlighted in blue):
In this Condition step, you will test if the quantity of days without action for each of the List records, and execute some task if the quantity of days is equal to 7, 30 or 60 (or, in my case, 2, 5 or 12).
Now you can add your Send email action to the True block of the Condition (highlighted in blue), since it will be executed only if the quantity of days match the values specified in the previous step. In my case, I'm instead simply adding a Compose action to print the actual Days late for each iteration (highlighted in red). You can leave the False block empty:
After running the flow, you can see that the condition returns false when the qty of days is 22:
But it returns true when the qty of days is equal to 12 (and for 2 and 5 as well):
Additional resources
I'm also sharing a few resources related to the topics discussed in this solution, which can be helpful for you or any users that find this thread in the future.
Let me know if it works for you or if you need any additional help!
-------------------------------------------------------------------------
If this is the answer for your question, please mark the post as Accepted Answer.
If this answer helps you in any way, please give it a like.
http://digitalmill.net/
https://www.linkedin.com/in/raphael-haus-zaneti/