web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Reducing processing ti...
Power Automate
Answered

Reducing processing time for large Lists.

(0) ShareShare
ReportReport
Posted on by 91

I've got a flow that reads a MS List, looks for records that are missing our file names, and creates an appropriate one. There are usually less than 100 of these processed and our list shouldn't exceed 5000 items.

 

My processing so far with only 300 items takes about 6 mins to run. That's pretty slow.

 

I'm wondering if I can just Get the last 100 items, look for the last one not to have a file name, then go through my file naming process to create and save the updated list item.

 

Screenshot 2023-11-14 155919.png

 

Screenshot 2023-11-14 155954.png

 

Screenshot 2023-11-14 160036.png

 

Best solution would be to just start the rename at whatever record number was "inLastGood"+1. (inCurrentRecord)

Categories:
I have the same question (0)
  • Verified answer
    michael0808 Profile Picture
    304 on at

    Hi!

     

    In the Filter Query of your Get Items action, place this to return only the results where your Record  (Or which ever column you are looking to check) is empty or null.

     

    Record eq null or Record eq ''

  • Chriddle Profile Picture
    8,686 Super User 2026 Season 1 on at

    Additionally, you could potentially write all the actions for creating and setting variables into fewer actions.

     

    If you're looking for a time-optimized process, you may want to rethink the entire approach.

    If you give us a quick example of your data and describe what you're trying to achieve, maybe someone will have a better solution.

  • clicker666 Profile Picture
    91 on at

    I tried using JSON for declaring the variables but had no success. 

     

    The variables aren't really the problem, it's enumerating all the records.

  • clicker666 Profile Picture
    91 on at

    I'll give that a shot, thanks!

  • clicker666 Profile Picture
    91 on at

    Thing of beauty. Took 10 secs to run, did exactly what it was supposed to do.

  • clicker666 Profile Picture
    91 on at

    Here's a screenshot of how I filled it in, in case someone comes across this post in the future.

     

    Screenshot 2023-11-16 114032.png

     

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the April Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Vish WR Profile Picture

Vish WR 780

#2
Valantis Profile Picture

Valantis 668

#3
Haque Profile Picture

Haque 601

Last 30 days Overall leaderboard