Bypass null

[sajarac]

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  

[JohnAageAnderse · Accepted solution]

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:

The expression is in the comment 🙂

Kind regards, John