PowerAutomate - Website Population from Excel - Stop at Blank cell

[TomHalbert]

Hi All,

I am new to PowerAutomate so excuse my lack of knowledge in this write up.  

I have successfully created a PowerAutomate flow to open up an excel document, takes the specific data, open a browser, navigates to a website and populates fields.  I have it repeating the process as there is many rows to complete.  This works well.  

My Issue:

When I fully automate this process I will not know how many rows my excel dataset will have.  I would like it to be able to identify when a row or column is empty and then stop the process.  Currently it continues the repeat process and enters blank values on the UI Elements that are selected.  

Appreciate any assistance that can be offered. 

Thanks

Tom

[Nived_Nambiar · Accepted solution]

Hi @TomHalbert 

For that you have to read  the excel within range having values like below 

First Launch the excel using Launch Instance.

Find the first free row and column in the excel instance (of active sheet)  using find first free row/column

This will produce two values as output: FirstFreeColumn, FirstFreeRow

Both will represent the first free column and first free row position as in excel.

Now you know start and end positions of range in excel, use read from worksheet like below

You can change the start row and start column depending upon your requirement.

Also enable the above option in Advanced sections.

Thanks & Regards,

Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌

[TomHalbert]

Thanks @Nived_Nambiar, 

This worked excellently.  I appreciate your assistance.  

For those who may be trying to get this working as well - I was able to follow the instructions but I had to manually add in the '-1' for the end column and row information  -----  '%FirstFreeRow - 1%'

That took me a small while to understand it was not just a drop-down selection from {x} but manually enter just as what was instructed in the images.  

Excellent instructions and thanks again.  I'll mark it as a solution.