Flow error because null. But the value exists

(0) Share

Report

Posted on by ABureaux

I can't figure out why Power Automate thinks this is null...

I am getting an error at my Compose (below), which is this:

split(body('Parse_JSON')?['feature']?['attributes']?['prime_pin_email'],',')

My Compose is referencing the Parse JSON above, which clearly indicates that the value is present when the flow runs:

Parse JSON step is receiving json from a string variable that is set in an Apply to Each just above (because I don't want my entire flow to be in an Apply to Each). Th source database has a value. When I set a variable within the apply to Each, I see the expected value. Outside the Apply to Each, it's somehow null.

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (0)

Sort by

v-yetonggu-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @ABureaux ,

Please try this expression:

split(body('Parse_JSON')?['data']?['attributes']?['prime_pin_email'],',')

Best Regards,

Sunshine Gu

Was this reply helpful? Yes No
ABureaux on at

Like
a
(0)

Report
Copy link

Link copied!

Same issue.

When I copy-paste the variable directly from Dynamic Content, it comes as body('Parse_JSON')?['feature']?['attributes']?['prime_pin_email'], so I should be referencing the proper variable.

I have a similar workflow that dumps json from SharePoint into the Parse JSON step and that works. It seems very strange to me that this isn't working.

Was this reply helpful? Yes No
v-yetonggu-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @ABureaux ,

Could you copy the value of the 'json' array variable to me? (Just delete your email address)

Best Regards,

Sunshine Gu

Was this reply helpful? Yes No
ABureaux on at

Like
a
(0)

Report
Copy link

Link copied!
Here you go:
{ "data": [ { "attributes": { "em8test_emp_email_h": "email@place.com", "header_mode": "new", "prime_pin_email": "email@place.com", "em8test_emp": "3503", "peri_bearing": null, "header_os": "Windows 10 Version 2009", "dt1": null, "time_calc": null, "dt2": null, "date2ca": null, "created_user": "username", "per_test": null, "header_timezone": "Mountain Standard Time", "prime_process": "FALSE", "header_devicemodel": "Precision Tower", "header_surveyname": "Template (No Geopoint)", "header_uuid": "34e77dbe-c9cc-4ECA-81eb-908f01caf4d8", "t1": null, "t2": null, "prime_user": "email@place.com", "header_hidden_date": 1709585880000, "globalid": "{9V8E5C86-EEC5-4C8F-B47D-7989430B51F6}", "header_status": null, "header_device_id": "dd1fbd7eeb454cbba203c26e8e2e5e61", "header_start": 1709585921527, "header_end": 1709586530005, "header_online": "true", "header_utc_date": "04-Mar-2024 06:58", "header_version": "2", "header_app_version": "3.19.120", "header_utc_offset": "-7", "header_uct_offset_pa": "-07:00", "uniquerowid": "{11D938A7-B47D-42e2-81B2-584A41FCFA43}", "last_edited_date": 1709586531362, "header_email": "email@place.com", "texterw": null, "header_username": "username", "date1ca": null, "date2": null, "date1": null, "grp_select": "grp1", "header_end_t": "Mar 04, 2024 14:08", "peri_wm_bl": null, "last_edited_user": "username", "em8test_emp_name_h": "F Name", "peri_wm_br": null, "created_date": 1709586531362, "header_start_t": "Mar 04, 2024 13:58", "objectid": 9 } } ] }

Was this reply helpful? Yes No
v-yetonggu-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @ABureaux ,

I did a test for your reference.

Please use 'Select' control.

My Flow:

item()?['data']?[0]?['attributes']?['prime_pin_email']

Best Regards,

Sunshine Gu

Was this reply helpful? Yes No