Unanswered

Using "Is Empty" in Power Automate Desktop for Data-Driven files - Excel

(0) Share

Report

Posted on by AutomationGuy

I know that "Is Empty" Conditional action was recently introduced but not sure how I can use this feature as of today.

To keep it simple, I have an excel file with 70 columns and it has 1 row. Each row in the excel file represents 1 record which I am appending to a Web application using Power Automate Desktop.

I was able to read excel file using Sub flow and reading each record in Main flow using For Loop and that seems to be working.

There are some records which may or may not have data. How can I code or configure PAD to skip the empty record(s).

Feel free to throw in from simple to complex logic / Programming code or conditionals here.

Categories:

Power Automate Desktop

I have the same question (0)

All responses (6)

Answers (0)

Sort by

miketran13 720 on at

Like
a
(2)

Report
Copy link

Link copied!

Hi Guys,

From my last experiences, I just need to add a condition inside the loop and check if the current item value is empty, then I have an action that is Next Loop. So, it will skip all the item which is empty.
Please see the image below for my example.

Thanks and hope it can help you.
Mike
---------------------------------
Did I answer your question? Please consider to Mark my post as a solution! to guide others

Was this reply helpful? Yes No
AutomationGuy 16 on at

Like
a
(0)

Report
Copy link

Link copied!

@miketran13 Thanks but that didn't work for me. As I am using 'Populate text field on Web Page' for each (Excel field) field to populate on the web application I might have to write for each of the 70 fields or is there an efficient way?

Was this reply helpful? Yes No
miketran13 720 on at

Like
a
(0)

Report
Copy link

Link copied!

If you have a same number of fields on the web application that you have to populate the value to, then I don't think you can have any other efficient way to do that. You have to populate it field by field.

Thanks and hope it can help you.
Mike
---------------------------------
Did I answer your question? Please consider to Mark my post as a solution! to guide others

Was this reply helpful? Yes No
oscar_bolanos 13 on at

Like
a
(0)

Report
Copy link

Link copied!

Great answer!!

Was this reply helpful? Yes No
MichaelAnnis 5,727 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you, I was having a similar issue with Loop Condition While %Var% <> 0. The point was to keep running an Excel Macro until a specific cell came back empty, but zero is not empty and the Loop Condition didn't have an (Is Empty) option. So, using what you said above, I was able to build into the Loop Condition one that said If %Var% (is empty), then Set %Var% to 0.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

You can use get free rows first to get total no of Rows count
Then use LoopCondition. in Loop condition you can use input from Get free rows. From Loop condition you will get variable current item. While in Loop you can use current item is empty or not to skip the rows in excel data table.
Thanks
Harsh

Was this reply helpful? Yes No