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

(0) Share

Report

Posted on by MallonoX

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:

Building flows

All responses (1)

Answers (0)

VictorIvanidze 13,083 on at

Like
a
(0)

Report
Copy link

Link copied!

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