How to add single quote in an expression

Like (0) Share

Report

Posted on 18 Aug 2022 16:50:33 by Community Power Pla...

Hi all,

I am building an expression. So that when triggerBody()['text_1'] is null, it should return null (no quote). If it has value (e.g. value), it should return 'value' (with single quote). How can I do it? The Power Automate builder keep prompting for "The express is invalid".

if(empty(triggerBody()['text_1']),'null',''triggerBody()['text_1']'')

All responses (1)

Answers (1)

Verified answer

MF-12051538-0 398 on 18 Aug 2022 at 17:22:02

Like (3)

Report

Re: How to add single quote in an expression

Hi @Anonymous ,

To get single quotes to appear you'll have to use four quote marks in a row (i.e. ''''). Additionally, you'll need to concatenate them together instead of just placing them before and after the triggerBody()['text_1'].

Try this code:
if(empty(triggerBody()['text_1']), 'null', concat(concat('''',triggerBody()['text_1']),''''))

If you found this post helpful, please consider Accepting it as the solution.