Hello,
I am trying to build a flow which does the followings:
- 1st of the month the flow gets triggered.
- Initialize variable to store a date information that is 31 days in the past from today.
- Compare the date from step 2 to a date in the date column in the folder that is in the specific document library.
- If files in that document library include the date greater than 31 days in the past from today, get those files. (Example: If the flow was triggered on November 1st, it looks for files that were added between October 1st and 31st.)
- After getting those files, names and links of the file will be added to an email (HTML table) and send the email to a group of people.
The 'image 001' is my attempt.
The 'image 002' is a test result. I got an error message below.
Error message: String was not recognized as a valid DateTime. Creating query failed.
clientRequestId: 2cff8e02-037a-4ae7-a483-435eec7e2be8
serviceRequestId: e5db5ca1-1028-6000-c07d-06d7da2a2a7c
I am not familiar with complicated flows and having a problem moving forward with this one... Any suggestions will be appreciated. Thank you so much for your help in advance!!
