cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Advocate I
Advocate I

Power Automate Desktop - Is Empty or Is Not Empty conditions

Hello,

 

I have to process Excel data in Power Automate flow, since I can not ask end users to format Excel data into table before sending it to email mailbox for processing I am using Power Automate Desktop.

  1. Flow is triggered when new email arrives
  2. Moving email from Inbox to For Processing folder
  3. Filtering only Excel structured data
  4. Starting Power Automate Desktop
  5. Moving email from For Processing to Processed folder or Failed folder depending on action

filipovicdino_0-1608542544942.png

Problem is in Power Automate Desktop application that I don't have all features that I had on Softomotive desktop application and that are Is Empty or Is Not Empty to check fields in Excel datatable and I can not check with condition If that cell is empty or not.

Do you have some WA or I need to wait for release of new version of Power Automate Desktop?

https://docs.winautomation.com/en/if-else-endif.html#if-else-endif

 

Best regards,

Dino

1 ACCEPTED SOLUTION

Accepted Solutions
Advocate I
Advocate I

I have solved this problem by building JSON object in List then I have sent it to Power Automate as output then I have done Parse JSON action and checked empty values there. 

View solution in original post

1 REPLY 1
Advocate I
Advocate I

I have solved this problem by building JSON object in List then I have sent it to Power Automate as output then I have done Parse JSON action and checked empty values there. 

View solution in original post

Helpful resources

Announcements
Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Users online (89,746)