2024-08-02 - Update:
I removed the filtering from the workflow, and it returned no documents from the folder. I changed the workflow to a different folder in the same document library, and it returned a list of files in that folder. Same workflow, same document library, different folder yields different results.
It's as if the workflow no longer sees the content of the folder.
Any suggestions?
Original Post:
I created a simple automatic workflow (scheduled to run daily at 6:00AM) to delete files in a specific folder of a document library that were created more than 4 days ago. It worked fine for over three months. To my knowledge, nothing was changed. On June 4, 2024, the flow stopped working.
Running the file in test mode, I get the following error: ActionConditionFailed The execution of template action 'Delete_File' is skipped: there are no items to repeat.
Looking at the "Get files (properties only) action, in the Outputs section under body, I can clearly see the filter parameter is correct - getfileitems?$filter=Created+lt+%272024-07-27 but for some reason, it's no longer seeing files that match the filter.
I've attempted to re-create the workflow, but the results are the same.
Any help would be appreciated!
Flow:
Get files (properties only)
File Query
For Each
Delete File