cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Kudo Kingpin
Kudo Kingpin

Bypass null

Hi there,

 

New in flow, new in PowerApps and a silly question here?

 

I have a JSON schema form my powerapps. It is lots and lots of fields, so I mean the schema is huge. For many reason some fields could be empty. I have been trying to add If(Blank(myfield)," ", myfield), but this is a tedious process.

 

Anyway to bypass or simplify this process?

 

Thanks in advance for any response.

 

Regards  

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User II
Super User II

Re: Bypass null

Hello @sajarac 

 

Try to stringify your JSON object, then do a replace of the null with "", and finally turn it back into a JSON object. Like this:

Replace null in JSON object.jpgReplace null in JSON object.Result.jpg

The expression is in the comment 🙂

Kind regards, John

View solution in original post

1 REPLY 1
Highlighted
Super User II
Super User II

Re: Bypass null

Hello @sajarac 

 

Try to stringify your JSON object, then do a replace of the null with "", and finally turn it back into a JSON object. Like this:

Replace null in JSON object.jpgReplace null in JSON object.Result.jpg

The expression is in the comment 🙂

Kind regards, John

View solution in original post

Helpful resources

Announcements
FirstImage

Microsoft Ignite 2020

Check out the announcement of Power Platform content at Microsoft Ignite!

thirdImage

Experience what's new for Power Automate

Join us for an in-depth look at the new Power Automate features and capabilities at the free Microsoft Business Applications Launch Event.

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Users online (7,253)