Hi everyone
I'm looking for some help or advice on a recurring flow I have created to update file properties for particulars that are identified using an ODATA filter. The flow is running successfully (i.e. it's not failing), but I am not getting the same result when it runs on its own compared to when I run a test.
Here are the Action details:
1. Details of recurrence action:
2. Get files (properties only) action - this action gets files from the relevant library using the following Filter Query to identify files with a 'Due for Review' date 90 days from now:
DueforReview eq 'formatDateTime(addDays(utcNow(), 90), 'yyyy-MM-dd')'
For each value:
3. Get file properties retrieves details from the files identified in the Get files (properties only) action.
4. Update file properties updates the 'Status' field to 'Due for Review'
END FLOW
The problem:
When I test the flow, it works perfectly and only updates the status of files with a Due for Review date 90 days from today. However, when I allow the flow to run as per its recurring schedule, it updates the 'Status' of ALL files with any date in the Due for Review column to 'Due for Review', regardless of when that date might be.
How can I make sure my recurring flow behaves the same way it does during my test runs and only updates the relevant files?
I have tried changing the date format in the fx expression above, adding timezone conversion to the fx expression above, neither make a difference. Looking at the run history, the recurring flow appears to identify the appropriate files, runs the for each the appropriate number of times (for the identified files only), but still updates the status of all files in the library that have any date in the 'Due for Review column' instead of just those identified files.
Any advice would be amazing, this has been doing my head in for a week.
Thanks in advance!
