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
"message": "BadGateway",
"innerError": {
"status": 504,
"message": "Request to Graph API has timed out.
Without the filter
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.
