Differences in the behavior of the Power Automate Desktop and WinAutomation [Substract lists] action]

[ZS440]

In an Excel data table like the following
Get first free column/row from Excel Worksheet] will not count well if there is a blank string.

So I used [Substract lists] in Winautomation to count the number of lines, excluding the blank strings.
This will give me the correct number of rows.

If I do the same thing with PAD, [Substract lists] will do Distinct processing at the same time.
I can't get the correct row count anymore.

I don't want it to work differently from WinAutomation.
Please fix this.

[miketran13]

Hi,

You are right, it does not work as expected with Get first free column/row from Excel. So, I have used Read from CSV file to solve this problem for my flow instead of waiting for MS to fix it.

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

[ZS440]

Thanks for the reply.
I tried saving the Excel file as csv.
But the solution seems to be difficult.
I have converted the RPA Challenge Excel file to csv.
The ghost cells remain.
http://www.rpachallenge.com/

It is also possible to count with regularized expressions and looping.
But it is slow.

I am now trying a python script action.