Hello Team,
I have an idea here that might help you out.
First up you need to create a Custom Date type column in SharePoint Library called Due Date as shown below-
Manual Trigger and Get Files (properties only) -
With the Manual trigger you can run this flow every morning and the second action (Get files) will get all the files in your SharePoint Library.
Then we will loop each of these files and using a condition we will check if the due date is equal to the today's date.
So add an Apply to each and then inside the Apply to each add a Condition.
The expression will be as follows (Due date is available as a dynamic content) -
Due Date is equal to formatDateTime(utcNow(),'yyyy-MM-dd')
If the condition satisfies for a file it will go to the Yes part of the condition as send an email to Outlook as a reminder. This is shown below -
This should definitely sort your requirement out, I mean this is a complete solution as per your needs.
Try it out...
If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!
