cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Mike44
Helper I
Helper I

Excel to Google Sheets

I've built a flow to move rows of data in an Excel spreadsheet to a Google sheet.  For the most part it is working, however, it is not moving all 373 rows from my Excel sheet to my Google sheet.  It only moves 313 rows.  I'm not sure why this is happening.  Below is a copy of my flow.  I'm hoping someone might be able to explain why this might happen or point out something wrong with my flow.

gov.flow.microsoft.us_manage_environments_Default-b9b2d16d-cf20-4fc5-9105-8dee90652eda_flows_958f6aa1-94bb-4ac1-be67-6e31623d4c8a.pnggov.flow.microsoft.us_manage_environments_Default-b9b2d16d-cf20-4fc5-9105-8dee90652eda_flows_958f6aa1-94bb-4ac1-be67-6e31623d4c8a (2).png

1 ACCEPTED SOLUTION

Accepted Solutions
BradWest
Frequent Visitor

Two things:

  1. Do you have any filters set in the "List Rows" step?
  2. In the 'List Rows' step click the 3 dots in the upper right, select "Settings", turn on "Pagination", type in the number of rows in the field below the toggle, click save.  

1 List Rows.png2 List Rows.png

View solution in original post

3 REPLIES 3
BradWest
Frequent Visitor

Try removing the first "Apply To Each".  It shouldn't be necessary to have as a step. 

Removed the first "Apply to Each" and now it's returning even fewer row, only 257.  Any other thoughts?

BradWest
Frequent Visitor

Two things:

  1. Do you have any filters set in the "List Rows" step?
  2. In the 'List Rows' step click the 3 dots in the upper right, select "Settings", turn on "Pagination", type in the number of rows in the field below the toggle, click save.  

1 List Rows.png2 List Rows.png

View solution in original post

Helpful resources

Announcements
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Top Solution Authors
Top Kudoed Authors
Users online (2,746)