Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Suggested answer

Delete File No Longer Working in Workflow

(0) ShareShare
ReportReport
Posted on by 12
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
 
 
  • Suggested answer
    Michael E. Gernaey Profile Picture
    43,258 Super User 2025 Season 1 on at
    Delete File No Longer Working in Workflow
    The only thing I can think of is that the time zone somehow changed and so its either the format of the DataTime etc has changed.
     
    Do this
     
    1. Do a list files (dont filter)
    2. After it runs, look at a time and grab the JSON
    3. put it in notepad or notepad++ or whatever
    Look for the DateTime format in the Created column
    See if its changed and doesn't match what you have anymore.
     
    that's my guess
    that or you are actually looking in the wrong place because you didn't remember changing where the files go.. I got nothing else ;-) its usually the first one.
     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Michael Gernaey – Community Spotlight

We are honored to recognize Michael Gernaey as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 566 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 516 Super User 2025 Season 1

#3
stampcoin Profile Picture

stampcoin 492