Answered

Weird Daily Failure, 5 days out of 7 and not sure why.

(0) Share

Report

Posted on by jamescosten

643

I have a flow that runs each day at 5am. This works absolutely fine and has been for months but It has started to fail on 5 of the 7 days.

Works on Sunday and Monday, and its re-occuring each week.

And this is the error.

Any thoughts?

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

Daniel Bocklandt 5,099 Super User 2025 Season 2 on at

Like (0)

Report

Hey James,

You shared the Get Items input with us (By the way I made sure to sensore youre SharePoint URL for safety reasons), could you please also share the output with us?

Most of the time that will tell us more about the actual problem then the default error mesages from Power Automate.

Could you also run a few test runs today and tomorrow to see if they run sucessfully?

Was this reply helpful? Yes No
jamescosten 643 on at

Like (0)

Report

Thank you.

The Output of a succesfull flow is:

Which populates the table and results in this.

Just checked, and although it was reported this morning it has been down since July.

Was this reply helpful? Yes No
Daniel Bocklandt 5,099 Super User 2025 Season 2 on at

Like (0)

Report

Could you also share one that was not sucessfull and check if the body of all sucessfull runs where empty like shown in the picture:

Otherwise the only reason it works is because there is no item catched at all.

Was this reply helpful? Yes No
Verified answer

jamescosten 643 on at

Like (1)

Report

I have just solved it. For sanity reasons I started to check the column names to determine if something had changed and for some reason the "Job Type " column and field was not showing correctly. I remapped it and the failed flow ran perfectly.

Not sure why all of a sudden this would have stopped, there must have been a change on Sharepoint by a user that casued it.

Sorry for wasting your time and thank you.

Was this reply helpful? Yes No