Hello,
For background: I have a Sharepoint library with a number of files (processes). Each file needs to be approved from time to time, which is triggered by a change of 'Status' value in a custom column to 'Pending'. That kicks off a separate Approval Flow (not pictured), which should result in one of two statuses: 'Approved' or 'Rejected'.
I now want to make a separate Flow, which will chase each Process Owner who doesn't react to approval request. In each instance an email and flow bot message will be sent. Specifically:
My Sharepoint library is here and my workflow so far is here.
I have taken the approach of creating a flow triggered by reccurence, daily, Mon-Fri. It should then filter the files down to only those in 'Pending' status and then for each of those files calculate the date 7 days ago, compare to 'Pending Status Date' column and if the date is the same, send a a separate reminder to each process owner for each file.
I have problems with:
Any help would be greatly appreciated!
They are separate entities.
So I basically did what you are referring to. I have multiple columns with different dates representing Quarters. My issue is that when the flow kicks off, it sends the approvals out 1 at a time. THere could be 10 approvals that need to go out, because 10 line items in my list have dates that match but they go out 1 by 1 based off of the previous getting a response. My issue is what if a person who owns their line item misses their notification? I need for all approvals to go out at the same time.
Hi @Agnes1
Hope you are well,
I recommend instead of doing multiple reccurence flows , you can create only one and create 3 extra columns in the SP list (i.e. 7Days Reminder , 14Days Reminder , etc ... )
When the flow runs and calculates the time , it will update the field after sending the notification
for example ,
Flow starts , calculates the time
If time is equal or greater than 7 days and less than 14
Send notification and update the field 7Days Reminder to true
and so on .....
Please let me know if this helps your implementation
Best Regards
Michael E. Gernaey
497
Super User 2025 Season 1
David_MA
436
Super User 2025 Season 1
Riyaz_riz11
244
Super User 2025 Season 1