Can't make IF work

(0) Share

Report

Posted on by DanielPineault

113

What am I doing wrong?

if(length(outputs('Execute_stored_procedure_(V2)_-_Create_projects_in_database')?['body/outputparameters/outputContactFirstName'])=0, triggerBody()?['contactFirstname'], outputs('Execute_stored_procedure_(V2)_-_Create_projects_in_database')?['body/outputparameters/outputContactFirstName'])

I keep getting an 'The expression is invalid' error.

All responses (4)

Answers (1)

DanielPineault 113 on at

Like (0)

Report

Re: Can't make IF work

length() returns explicit numerical values, does it not?
Community Power Pla... on at

Like (0)

Report

Re: Can't make IF work

I think generally speaking the '=' sign assigns values to a variable, it does not compare them. When you need to start compare values, the 'equals' function is more appropriate.
DanielPineault 113 on at

Like (0)

Report

Re: Can't make IF work

No Words, the language doesn't handle simple equalities?! You need to use a function. OMG.

At least I learnt something new today.
Verified answer

fchopo 7,968 Super User 2025 Season 1 on at

Like (0)

Report
Re: Can't make IF work

You should replace "=" by using "equals" function:

if(equals(length(outputs('Execute_stored_procedure_(V2)_-_Create_projects_in_database')?['body/outputparameters/outputContactFirstName']),0), triggerBody()?['contactFirstname'], outputs('Execute_stored_procedure_(V2)_-_Create_projects_in_database')?['body/outputparameters/outputContactFirstName'])

Hope it helps!

Ferran