Excel In the Power Automate Desktop flow Read data with empty or without empty

(0) Share

Report

Posted on by Ahmedmuz

203

Hi Everyone,

In the Power Automate Desktop flow, after launching Excel, the automation needs to read data from columns A2 to H2. If data is found in these cells, the flow should proceed with the next steps. However, if any blank cells are encountered, the flow should move to the next loop. Could you please assist with this.

Best Regards

Muzamil Ahmed

Categories:

Power Automate Desktop

I have the same question (0)

All responses (18)

Answers (10)

Verified answer

Agnius Bartninkas Most Valuable Professional on at

Like (1)

Report

Well, once you have read your data from Excel, use a loop to iterate through each cell and check if the value of that cell is empty. If it is, use Next loop to skip the rest of the actions inside the loop.
-------------------------------------------------------------------------
If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.
I also provide paid consultancy and development services using Power Automate. If you're interested, DM me and we can discuss it.

Was this reply helpful? Yes No
Verified answer

Ahmedmuz 203 on at

Like (0)

Report

HI Agnius,

Thanks a lot - If you could show a sample with snap how to use the loop iterate through each cell with one example it will very helpful, as i am a very new to all this ,, Appreciate your help 🙂

Thanks a million times:)

Was this reply helpful? Yes No
Verified answer

Agnius Bartninkas Most Valuable Professional on at

Like (1)

Report

The following steps will do it, but depending on what you want to do with the values, you might want to use a different loop (if you need a loop index to write back to Excel):
Also, this assumes that you are only reading a single row (A2 through H2). That's why it's iterating through a single row, too (using %ExcelData[0]%). If you read more than that, you would need an extra loop and the flow would look like this:
-------------------------------------------------------------------------
If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.
I also provide paid consultancy and development services using Power Automate. If you're interested, DM me and we can discuss it.

Was this reply helpful? Yes No
Ahmedmuz 203 on at

Like (0)

Report

Hi Agnius,
Thanks for the above snap shots, I tried but its not working the the close excel & its not going to next loop can you please check once and help where im doing error - attached is the snap shot for you,,

456Capture.PNG

Was this reply helpful? Yes No
Agnius Bartninkas Most Valuable Professional on at

Like (0)

Report

Why are you closing Excel in the loop? You should only close it after you're completely done with what you want to do. And you only need to close it once - not within the loop.

Was this reply helpful? Yes No
Verified answer

Ahmedmuz 203 on at

Like (0)

Report

Ok Sure, I want the open excel file should close if that is empty once it read then go to next loop or else it will be kept open so,, Can you help me how to do that ?
Have attached snap shot's for your reference.

Was this reply helpful? Yes No
Verified answer

Agnius Bartninkas Most Valuable Professional on at

Like (1)

Report
I do not fully understand your use case, but regardless of what you are trying to do, there are at least 2 things wrong with your flow:

You use %CurrentItem% in both of your loops. You should change the name of the variable either in the parent loop for files or the nested loop for Excel rows.

You have Close Excel in row 6 and 12. The action in row 6 will close the file before it stops using it. You are either missing some actions there, to skip to the next file after closing, or should not have the Close Excel action there.

-------------------------------------------------------------------------

If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.

I also provide paid consultancy and development services using Power Automate. If you're interested, DM me and we can discuss it.

Was this reply helpful? Yes No
Ahmedmuz 203 on at

Like (0)

Report

If you don't mind can you give a proper step snap shots as new it will help a lot for me please...?

Was this reply helpful? Yes No
Agnius Bartninkas Most Valuable Professional on at

Like (0)

Report

No, I cannot, because I don't understand what you are trying to do. Please provide a clear step-by-step instruction of what you want to achieve and then maybe I can come up with a suggestion for the flow.

Was this reply helpful? Yes No
Ahmedmuz 203 on at

Like (0)

Report

1.Opening the excel Files one by one using the for each loop after Get files in folders step.
2.If the file name contains 12345 it should not open the file and go to next Loop.
3.Other than 12345 file name contains it should open - which is No 6 Launch Excel.
4.No 7th Step is reading the excel file from A2 to H2 row.
5.Created one more For each loop steps 8 within in For each loop - to perform- If the current excel file cells from A2 to H2 is empty then current excel file should close and go to next loop - to open next excel file.

Hope it helps you..

Was this reply helpful? Yes No