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|
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?
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
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.
Check out the News & Announcements to learn more.
Participate in the Power Virtual Agents Community Challenge
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.
DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.