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

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Fetching 400k rows fro...
Power Apps
Suggested Answer

Fetching 400k rows from PostgreSQL

(1) ShareShare
ReportReport
Posted on by CU30082123-0 12

Hello! I'm trying to speed up the process of fetching more than 400,000 rows from a PostgreSQL table. Currently, I'm using the collections method, which takes around 10 minutes to load, and sometimes it just breaks. I also tried using Power Automate, but it has a limitation of 100,000 rows and takes about 8 minutes to fetch those.

Is there any way to speed up this process?

Categories:
Building Power Apps
  • Suggested answer
    Michael E. Gernaey Profile Picture
    Michael E. Gernaey 53,970 Super User 2026 Season 2 on at
    Hi
     
    Technically, you absolutely can make Power Automate work for your 400K, but speeding it up, that takes a lot more thought than we can give just off this little information.
     
    But can you give more details on why you want to load 400K rows into a Canvas or Model Driven App?
     
    It is possible to load them all, but its going to cause the users PC and or Phone to explode as its way too memory intensive,. Also collections can only hold ( by default 2k) so I am not sure how you are using Collections to pull 400K, no way,.
     
     
  • CU30082123-0 Profile Picture
    CU30082123-0 12 on at
    Hi FLMike,
     
    I have Collections code that fetches batches of 2,000 records using the index column until all records are retrieved. The goal is to use these rows as a template for users to write into another table.

    For example, imagine we have 20 types of shoes, where the only difference between them is color. We want to use these rows as a template to bulk update the price across all 20 shoes. This process will be done on a monthly basis.

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

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the August Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 382 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 329

#3
WarrenBelz Profile Picture

WarrenBelz 187 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

Auto-Populate field Power Pages
Gallery Tabs - Show or Hide Tabs based on Field Value
How to patch multiple records at once
Enable Copilot for end users in model-driven apps
Question for everyone : How are you using Create Text GPT in AI Builder?
Community content - sample components, blogs etc. - Link to this page (http://aka.ms/PCFdemos)
Welcome to the Power Apps forum!

Product updates

Microsoft Power Platform Community release plans