Can't make IF work

(0) Share

Report

Posted on by DanielPineault

127

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.

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

fchopo 8,003 Moderator on at

Like (0)

Report
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

Was this reply helpful? Yes No
DanielPineault 127 on at

Like (0)

Report

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

At least I learnt something new today.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

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.

Was this reply helpful? Yes No
DanielPineault 127 on at

Like (0)

Report

length() returns explicit numerical values, does it not?

Was this reply helpful? Yes No