Hello everyone — I’m looking for guidance to automate expiry notifications for a large batch of Word documents in SharePoint. Details below:
Scenario
• ~1,000 existing Word files (.doc / .docx) will be uploaded into a SharePoint document library.
• Each file contains a Review Date inside the document (this is the expiry date). Date may vary.
• I cannot manually set or update a SharePoint date column for every file.
Requirement
-
Automatically scan each uploaded document, extract the Review Date from its content, and store it as a document property or use it directly.
-
Determine the document owner as the person who uploaded the file.
-
Send an email notification to the owner one day before the Review Date (for example, if Review Date is 07/11/2025, send notification on 06/11/2025)
What I have / prefer
• Basic familiarity with Power Automate and willingness to use Graph API, Azure Functions, or SharePoint automation if required.
Request
• A step-by-step solution or sample Power Automate flow (or hybrid approach) that:
– Extracts dates from the Word document content (robust handling of multiple formats),
– Writes the date to a SharePoint column or schedules a notification directly, and
– Sends an email to the uploader one day before expiry.
• Any recommended patterns for performance/scalability (processing 1,000+ files), error handling, and date parsing.
