Forum Discussion
Sharepoint Library Created and Modified Dates
claire2020 Try using convertToUtc or convertTimeZone function instead of "formatDateTime" function in body.
Please consider giving a Like if my post helped you in any way.
ganeshsanap thank you, I have used that and it works, so thank you for all your help, very much appreciated
claire2020
The Power Automate approach is one that works for you. Good to hear.Another approach is to extract the create and modify dates from the files itself (not the OS). Most common file formats such as docx, xlsx, pptx, doc, xls, ppt, pdf, jpg, png, msg, eml, ... contain the create and modify date within the files.
For example,
Example of metadata in PDF file
If these values are extracted during uploading into a SharePoint column then this offers a better approach for applying retention labels based on the actual create/modify dates and not the OS dates.Note: there are file formats such as zip, txt that do not have the capability.
claire2020 You're welcome, very glad it worked for you!
Please consider giving a Like if my post helped you in any way.
