cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Ben_Love
Level: Powered On

Allowing NULL in JSON Schema removes item from Dynamic Content list

I have a Request trigger which in turn passes through a Parse JSON action. JSON schema was originally created using the 'Use sample payload to generate schema button. All worked well until I discovered that due to the payload being delivered to this trigger I needed to allow NULLs for some values within my JSON schema. Once this change was made to my schema, a number of items from the available Dynamic Content list from my Parse JSON action disappeared. Removing the 'allow NULL' config from the JSON schema and the Dynamic Content values return to the available list. 

 

Specifically I have verified this on JSON type 'Array' and 'String'. I haven't bothered testing other types at this stage. I have attached two screenshots showing with and without the NULL allowed in the schema. 

 

I believe this to be a bug, as we still need to work with the defined values, irrespective of whether the JSON schema allows NULL values. 1.jpg2.jpg

4 REPLIES 4
Community Support Team
Community Support Team

Re: Allowing NULL in JSON Schema removes item from Dynamic Content list

Hi Ben_Love,

 

I am afraid JSON schema would not allow Null value.


Please consider to replace the Null value with some string.

 

I have seen a similar one on Flow Ideas Forum, please consider to vote and comment the idea at here. I will also collect and report it on my side.

https://powerusers.microsoft.com/t5/Flow-Ideas/Support-null-in-Parse-JSON/idi-p/41182

Best regards,
Mabel Mao

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Ben_Love
Level: Powered On

Re: Allowing NULL in JSON Schema removes item from Dynamic Content list

Hi Mabel,

 

Thanks for your reply. The JSON Schema definition obviously allows for NULL values to be passed, so I assume that you are saying that specifically the Parse JSON Action in Flow does not support NULL values? Is that correct? 

 

This seems like a significant oversight. 

 

Given that we have no control over the system generating the JSON payload, and must simply work with what we're given, how do you suggest I convert the NULL values to something else? 

 

Ben

 

 

DanITman
Level: Power Up

Re: Allowing NULL in JSON Schema removes item from Dynamic Content list

I can confirm that this bug exists.  MS should fix this.

 

I had to remove the null type and then insert the field into my condition.  I then went back in and changed the schema to allow for null and all was good. 

Vinicius
Level: Powered On

Re: Allowing NULL in JSON Schema removes item from Dynamic Content list

Hello guys,

 

When i add property "null" into my json schema, i can't use the converted fields in a next step of my flow. Anyone can help me?

 

Thx!!

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors (Last 30 Days)
Users online (5,995)