I need to dynamically pass Starting and Ending Row number dynamically instead of passing hardcoded Row ending number highlighted below (in my input excel file last row number is 7874, which will change every week). So, need to pass dynamically which will be help full to use in multiple actions.
Can someone explain how to capture that will be a great help.
Power Automate Desktop- From Excel file, how to pass total number of rows count to a variable
Use "Get first free row on column from Excel worksheet" -action. Then it produces you the first free row so if you have 10 rows filled it gives you the row number 11.
Like so:
If you want to only autofill 10 then minus 1:
Was this reply helpful?YesNo
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
56
Share
Report
All responses (
Answers (
