Unanswered

How to handle seemingly nonexistent properties in Power Automate Desktop?

(0) Share

Report

Posted on by yann1104

Hello everyone,

I'm trying to fetch data from a Jira API and then populate it into an Excel spreadsheet using Power Automate Desktop. Here's the challenge I'm facing:

When I attempt to retrieve the value of a specific property to copy it into Excel, Power Automate Desktop tells me that the main object doesn't have that property. However, visually inspecting the data, I can confirm the property does exist, leading me to suspect that its value might be empty or undefined. Does anyone know why Power Automate Desktop might report a property as nonexistent even though it's there?

Any insights or workarounds would be greatly appreciated. Thank you!

Categories:

Power Automate Desktop

I have the same question (0)

All responses (7)

Answers (0)

Sort by

Srini007 3,490 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @yann1104

It's better if you can share some screenshots of your flow, the property which you asking and the error you are getting

This will help in understanding the issue

If you find this reply helpful, please consider giving it a LIKE AND

If this reply answers your question or solves your issue, please ACCEPT AS SOLUTION

Thanks,

Srini

Was this reply helpful? Yes No
yann1104 4 on at

Like
a
(0)

Report
Copy link

Link copied!

Reply to Srini

Was this reply helpful? Yes No
yann1104 4 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks Srini
Here's a screenshot illustrating the error message:

Additionally, here's a template showcasing the property in question. While JavaScript recognizes the property customfield_13645 and its value as NULL, Power Automate Desktop seems not to recognize this value at all:

{
'customfield_XXXX1': 'MASKED_VALUE',
'customfield_XXXX2': ['MASKED_VALUE'],
'customfield_XXXX3': 'MASKED_VALUE',
'timetracking': {
'remainingEstimate': 'MASKED_VALUE',
'timeSpent': 'MASKED_VALUE',
'remainingEstimateSeconds': MASKED_VALUE,
'timeSpentSeconds': MASKED_VALUE
},
'customfield_XXXX4': 'MASKED_VALUE',
'attachment': ['MASKED_VALUE'],
'summary': 'MASKED_VALUE',
'customfield_XXXX5': 'MASKED_VALUE',
'customfield_13645': ,
'customfield_XXXX6': {
'self': 'MASKED_URL',
'value': 'MASKED_VALUE',
'id': MASKED_VALUE,
'disabled': MASKED_VALUE
},
// ... and so on for other fields ...
}

Was this reply helpful? Yes No
Srini007 3,490 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @yann1104

As you are getting this response from Jira API, can you write the response to a text file and check once? Because when you get response it will be a valid Json and the value if there is null means it will not be as missing value maybe it will be null / 0 something

Regards,

Srini

Was this reply helpful? Yes No
Agnius Bartninkas Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

PAD cannot handle null values properly at the moment. It will fail if you try accessing them. The right way to fix this is by using Replace text on the JSON (before converting it to custom object) and replacing null with "" (which will result in empty stings in JSON). When you convert that to a custom object afterwards, it will contain the properties properly, but the values will be empty strings, instead of null.

-------------------------------------------------------------------------
If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.

I also provide paid consultancy and development services using Power Automate. If you're interested, DM me and we can discuss it.

Was this reply helpful? Yes No
Steve48 431 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Agnius what is the correct syntax for replacing null with ””

Was this reply helpful? Yes No
Agnius Bartninkas Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

It's this:

As simple as that. You actually need to pass the literal double quotes into the JSON, so that you end up with empty strings when you convert the JSON into a custom object.

-------------------------------------------------------------------------
If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.

I also provide paid consultancy and development services using Power Automate. If you're interested, DM me and we can discuss it.

Was this reply helpful? Yes No