You’re offline. This is a read only version of the page.
Maybe there is a different solution for this.... Basically I have an excel file that lists documents and includes various data points. These include a UID, Expiration Date, Document Name, Doc Owner (email address), Business Owner (email address)...
Is there a way to create a flow (or other solution) that runs ever 24hrs, where it checks the list and if and row has an Expiration Date that - today's date, Teams will send an approval request to the Business Owner, requesting whether or not they want the agreement to be renewed, and sends the response to the Doc Owner?
Or am I just hoping for something too complicated?
Yes, better you use a SharePoint list as your data store with a column name called Status (with a default value of New).
Next, build a scheduled flow that runs daily and looks for items with Status = New, performs team tasks, etc.
Finally, it updates the column to "Processed" so that it is not picked up in the next run.
Share
Report
All responses (
Answers (
14,396
