cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
hashimieasri
Regular Visitor

SKIP EMPTY CELL IN EXCEL FILES

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 CODELOCATIONPRINCIPALINVOICEINV SET OFF AMOUNTCREDIT NOTE  CREDIT NOTE AMT 
ABC234PARISVANSJHIN76464                               969.68AJCN60395-                                         710.68
ABC234PARISVANS  DFCN60512-                                         259.00
GHY098LONDONETNIES TSL2FJF                                203.76FFCN90087-                                         203.76
6 REPLIES 6
PetrosF-MSFT
Microsoft
Microsoft

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!

 

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?

sakula1996
Responsive Resident
Responsive Resident

@hashimieasri , @hairilasri  

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

Canjun
Frequent Visitor

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
Memorable Member
Memorable Member

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

 

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.

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Users online (1,537)