Google sheets to one drive file creation

Like (2) Share

Report

Posted on 13 Aug 2024 02:21:03 by PS-25070741-0

Hi All,

I trying to get the data from google sheets by using get rows step in power automate and converting output of get rows in to csv a table and creating a csv file one drive.

The above process is working fine there is no error in my flow. But, the data in the output of one drive csv file is only 257 rows and the google sheet has data rows more than 700.

Can anyone please tell me the reason why this is happening and how to get the all rows from google sheet?

Thanks in advance!

Categories:

Business Processes

All responses (2)

Answers (1)

Suggested answer

PS-25070741-0 8 on 13 Aug 2024 at 05:55:24

Like (0)

Report

Google sheets to one drive file creation

Hi @FLMike,

Thanks for your response.

I understood that there is default of 256 rows. But, I Manually updating TOP count as 700. still getting the same default 256 rows. is there any limitation for this google sheets api calls? also, I'm using power automate per user license.
Verified answer

Michael E. Gernaey 42,027 Super User 2025 Season 1 on 13 Aug 2024 at 04:27:49

Like (0)

Report

Google sheets to one drive file creation

Hi,

The answer comes from their connector page (you should review it)
https://learn.microsoft.com/en-us/connectors/googlesheet

It says the default number of rows returned for Get Rows is 256.

So that is the answer. See the Top Count Parameters below.