SKIP EMPTY CELL IN EXCEL FILES

[hashimieasri]

Hi Great People,

I'm currently designing a process where i will grabbing a certain data from excel file and I was doing it inside the power automate desktop. While doing so, I have stumble upon an issue in regards to the process I was trying to do.

The issue are, how do I skip an empty cell in specific row and proceed with the next data. Below are an example of data i was trying to do and i have come up with looping condition as solution but apparently the datatype i was using like "isEmpty" and "null" are not working and give me an error of wrong usage of datatype whereas the data retrieve from excel are in a datarow.

I do explore any solution that might help me but most of them are using web version where implementation of expression are possible and inside of the desktop version it seems like I cant find any that match. Could you guys help me out with this any information or suggestion will be valuable to me and thank you in advance for helping out.

*The row i try to skip are on the third row where invoice number and amount are not available. Hence i want to move forward with the available data like credit note and amount that is in the same row as well. Thank you in advance guys!

A/C CODE	LOCATION	PRINCIPAL	INVOICE	INV SET OFF AMOUNT	CREDIT NOTE	CREDIT NOTE AMT
ABC234	PARIS	VANS	JHIN76464	969.68	AJCN60395	-                                         710.68
ABC234	PARIS	VANS			DFCN60512	-                                         259.00
GHY098	LONDON	ETNIES	TSL2FJF	203.76	FFCN90087	-                                         203.76

[PetrosF-MSFT]

Hi @hashimieasri 

Please note that the "isEmpty" operator will be available on GA (Dec 2020).

In the meantime, you could try the solution as described here: https://support.softomotive.com/support/solutions/articles/35000112272-check-if-a-variable-is-null-

I hope it helps!

[hairilasri]

Hi @PetrosF-MSFT ,

It seems like the suggestion is not working for me. As for what you mention on the isempty part may I know when will this option can be used inside power automate desktop specifically and in the meantime is there any suggestion on how can i achieve this process of checking empty cell in a row?

[Anonymous]

@hashimieasri , @hairilasri  

isEmpty condition is available now. Download the latest version of PAD

[Canjun]

Hi, did you solve it? I'm having a similar problem with my flow too. I'm trying to skip the blank/0 value in my excel sheet but the if condition + for each loop wouldn't give me the correct result

[fraenK]

Did you also try comparing to the empty string variable %""% ?

[hairilasri]

Hi Canjun, 

I have already resolve the problem. There is new feature in Power Automate Desktop of which checking for an empty row is possible now. The next action on how you want to handle is follow with what you required in the process. Have you find a solution? There is many experinced guys in here and previously there is some guy who taught me to used json as custom object checking for null and empty values. It work fine until there is new feature present in PAD and i use that instead.