check for null or blank values in json values

(1) Share

Report

Posted on by Veblitz

2,249

How to check for null and blank values in the below json expression?

json(concat('{ "', replace(replace(triggerOutputs()?['body/subject'],':','" : "'),'\','", "'),'" }'))

When new email arrives with subject customer name:John\Customer no:12345 im using above expression and store in list item and what i ask is that if my subject has null or blank or unnecessary blank spaces it should remove for example

customer name: \ Customer no:12345 //name is empty and some spaces between name \ customer no values

Categories:

Building flows

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

Dieter Gobeyn 29 on at

Like (1)

Report
I can't see your total solution here, but based on the info you've provided you might want to look in the below functions:

To remove leading & trailing whitespace from a string:
trim('customer name: ')
See: https://learn.microsoft.com/en-us/azure/logic-apps/workflow-definition-language-functions-reference#trim

To check if a value is empty, this will return true if the value is empty. I suggest to do a trim() first.
empty(variables('myvar'))
see: https://learn.microsoft.com/en-us/azure/logic-apps/workflow-definition-language-functions-reference#empty

If I've been helpful, please mark my answer as Resolved/Answered and give it a thumbs up. This will help others too.

Was this reply helpful? Yes No