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

All responses (4)

Answers (1)

Sort by

Verified answer

fchopo 8,003 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
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
DanielPineault 127 on at

Like
a
(0)

Report
Copy link

Link copied!

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

At least I learnt something new today.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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 127 on at

Like
a
(0)

Report
Copy link

Link copied!

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