Get Items action has started being skipped at end of flow with no error message

(2) Share

Report

Posted on by AVFC

147

Hello wondering if you can help!

I have a flow that extracts data from PDFs sent in via email which is then stored onto a SP list and that list has a status column which the flow sets a value of 'Pending Export'. This works fine. It's the latter part of the flow that has stopped working. The last get items action as shown below should filter only records with that status:

The final part of the flow has now started to be skipped. This should use the update item action to change the column status from 'Pending Export' to 'Ready for Export' but as you can see below it's not working anymore. Has there been a change on the Power Automate platform? I can't see why it's stopped working as the flow says it has run successfully with no errors. Is this anything to do with exceeding the amount of records in a SP list perhaps? I've got around 4500 records at present. Any help would be most appreciated. Many thanks, Rob.

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Suggested answer

trice602 16,544 Super User 2026 Season 2 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi,

Based on what I see here this tells me that the Get Items doesn't have any items to process. Please check your output of Get Items (above this loop) and verify there are items returned in the output.

That's the root cause of the update item (loop action) being skipped, there are no items to update in Get Items.

------------------------------------------------

⭐ If this was helpful, please like and/or mark as a verified answer to help others find this too!

Always glad to help! 💯💯💯💯💯

Tom

Follow me on LinkedIn - Thomas Rice, PMP | LinkedIn

Was this reply helpful? Yes No
AVFC 147 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @trice602

Thanks for your response. I've just tested the flow again and the first part works fine by setting the status column to 'Pending Export' as below for the newly added records but then the last part of the flow has skipped when it should get items that have status 'Pending Export' and change them to 'Ready for Export'. This used to work absolutely fine until it stopped around Tuesday this week. I need this urgently resolved and not sure what to do. I'm having to manually change the status of the column which obviously isn't efficient. Any suggestions?

Just to add, the below is the last time it worked normally and i haven't changed any part of how the flow works:

Was this reply helpful? Yes No
Suggested answer

AVFC 147 on at

Like
a
(1)

Report
Copy link

Link copied!

So i've managed to resolve the issue as someone advised me to turn on the Pagination setting on the Get Items action as below as it was turned off so wasn't pulling all my items in one run. I've set it to the maximum threshold now. With pagination turned on the flow retrieves data in manageable chunks to prevent performance issues on cloud side.

Was this reply helpful? Yes No