Power Platform Community Forum Thread Details

Hello

I am trying to get all the rows from an Excel file in my Power Automate Desktop flow, but I don't know how I can specify to the last row from that Excel file.

Example: The Excel file that I want to import the data from has 4,866 rows so I want my flow to write that same amount of rows in a new file.

In my current flow, the program keeps writing to all rows unlimitedly, so I'd like it to write exactly how many rows there are in the source Excel file (in this case 4,866).

I want the data obtained from the form to be repeated up to a certain number of times (the number of rows in the source file, in this case 4,866). There should be 4,866 rows in total, what it does now is to do it unlimitedly.

This is my current flow:

- Main flow