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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / List Rows Action Gatew...
Power Automate
Unanswered

List Rows Action Gateway Error 504

(0) ShareShare
ReportReport
Posted on by 34

Hello,


I am trying to use the 'List rows present in a table' action to retrieve data from a table with more than 5000 thousand rows.
I tried to add a Filter Query but I keep getting Gateway Error

Filter Query: PurchasingGroup eq 'FRD'

With the filter

jfcricardo_3-1716800239690.png

 



 "message": "BadGateway",
 "innerError": {
 "status": 504,
 "message": "Request to Graph API has timed out.



Without the filter

jfcricardo_2-1716800214100.png

Update 28/05/2024:

After removing lines in batches I eventually found the automation running properly but this is not a real solution for my problem.
Note: After removing the lines the file went from 36k lines to approximately 26k (4.5MB to 3.5MB)

Update 29/05/2024:


Forgot to mention this is inside a Do Until.

 

 

 

 

Categories:
I have the same question (0)
  • v-yueyun-msft Profile Picture
    on at

    Hi , @jfcricardo 

    Can you try to update your Timeout in the setting of your action to test if it can work?

    vyueyunmsft_0-1716802824322.png

     

     

     

    Best Regards,

    Yueyun Zhang

  • jfcricardo Profile Picture
    34 on at

    I did the alteration but the result was the same.

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
trice602 Profile Picture

trice602 248 Super User 2026 Season 1

#2
David_MA Profile Picture

David_MA 207 Super User 2026 Season 1

#3
Power Platform 1919 Profile Picture

Power Platform 1919 101 Super User 2026 Season 1

Last 30 days Overall leaderboard