Announcements
12
Hey guys. I'm trying to list the files in a folder in Google Drive. This folder has at least 300 files and it keeps growing and I want to create a flow that can view the files but the connector only returns up to 100 items. How to read the rest?
Here you go. Hopefully, it is not too horribly cost prohibitive to run R code inside of power automate
@AlanCruz @Matthy79 that is 100 per 60 seconds but that is odd that you would see that throttling limit because that throttle on paper looks to be designed in the number of google drive connections (files) loaded NOT the limit for the google drive metadata connection.
There is a hard limit per day of the number of google sheets and other google objects you can load in. However, that limit is actually in the millions: https://developers.google.com/drive/api/guides/limits and per second its like 200 (20,000 per 100 seconds).
However, just listing information should take up only 1 query resource (while pulling X files takes up X number). So the fact that you are experiencing that query throttling make me think its a bug.
I suspect that limit is there because Microsoft is not using the latest version of the google API or has not updated the code for there connectors. So they are pulling metadata using what is supposed to be the data API. Instead of using the metadata API or pulling from the 100 of other google services.
As using the new API would be a dramatic change to the User Experience (as its a 2 stage process of select then download), I suspect that might another reason they have not made the switch.
I think have a solution in lieu of Microsoft fixing that issue with the connector.
Mr. Edmonson wrote a pretty good API library that uses R to query and "download" access google sheets.
Would you like the source code to use that library? I can write up the source code this weekend, but I will need to check to see how feasible it is to use they query operation. I just need to figure out if Power Automate can run an R script.
#1
Michael E. Gernaey
497
Super User 2025 Season 1
#2
David_MA
436
Super User 2025 Season 1
#3
Riyaz_riz11
244
Super User 2025 Season 1
Share
Report
All responses (
Answers (
