web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Handling empty values ...
Power Automate
Unanswered

Handling empty values in PAD - Variable 'X' doesn't have a property 'Y'.

(0) ShareShare
ReportReport
Posted on by 8

Hi Everyone,

 

I'm trying to develop a flow to execute a scripting action using data from the Graph API. I've successfully done this using a Cloud flow which called the Desktop Flow, but it's very slow. So now I'm evaluating using a PAD flow to get the data from Graph and process the 'for each' loop directly.

 

What's thrown me is the PAD flow erroring out on: Variable 'CurrentItem' doesn't have a property 'jobTitle'.

Screenshot 2022-06-24 091524.png

Note: For the purposes of testing the flow. I'm calling excel and writing each of the values into a cell.

 

The first thing I tried was setting the Error Handling to All errors - Continue run flow.

The second this I tried is an If Empty condition:

Screenshot 2022-06-24 092438.png

 

The same logic worked fine in the Cloud flow. I think because if the "?" which specifies an optional value? 

 

outputs('CurrentItem')?['jobTitle']

 

 

Basically I'm looking for the default handling in Cloud flow which skips over the empty/blank value.

 

Any help would be greatly appreciated.

 

Cheers.

Categories:
I have the same question (0)
  • VictorIvanidze Profile Picture
    13,060 on at
    Re: Handling empty values in PAD - Variable 'X' doesn't have a property 'Y'.

    Do not use the flow environment at all. Create a  VB/C# app the will execute the GRAPH requests and populate your Excel file.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 462 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 456 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard