Unanswered

IF statement with four conditions

(0) Share

Report

Posted on by MBlaired79

I am wanting to score information entered on a form. The data is stored in SPO. I have created and successfully tested for two conditions but I to use this for 4 conditions.

Working 2 conditions:

if(or(equals(outputs('Create_item')?['body/field_6'], '1000'),equals(outputs('Create_item')?['body/field_6'], '25000')),'2','3')

Invalid Statement:

if(or(equals(outputs('Create_item')?['body/field_6'], '0 - 999'),(equals(outputs('Create_item')?['body/field_6'], '1000'),(equals(outputs('Create_item')?['body/field_6'], '25000'),equals(outputs('Create_item')?['body/field_6'], '25000 +')),'0','1','2','3')))

Can I only use 2 conditions, i.e. true or false?

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (1)

Ellis Karim 11,681 Super User 2025 Season 2 on at

Like (0)

Report

Hi @MBlaired79 ,

One option is to use the Switch option:

Ellis
____________________________________
If I have answered your question, please mark the post as ☑️ Solved.
If you like my response, please give it a Thumbs Up.
My Blog Site

Was this reply helpful? Yes No
MBlaired79 15 on at

Like (0)

Report

Thanks for this. I did consider this as an option but I have 25 questions to score and I wanted a quick solution 🙂

Was this reply helpful? Yes No
Ellis Karim 11,681 Super User 2025 Season 2 on at

Like (0)

Report
Hi @MBlaired79 ,

Another option is to use a JSON object to store your "key" and their associated values:

{ "1000": "1", "25000": "2", "0 - 999": "0", "25000 +": "3" }

Then using an expression, you could "lookup" the key value and return its associated value

variables('varRange')?[outputs('Create_item')?['body/field_6']]

So, if field_6' contained "25000", the expression should return the value "2".

Ellis
____________________________________
If I have answered your question, please mark the post as ☑️ Solved.
If you like my response, please give it a Thumbs Up.
My Blog Site

Was this reply helpful? Yes No
MBlaired79 15 on at

Like (0)

Report

I love this but I've hit an error

Unable to process template language expressions in action 'Compose' inputs at line '0' and column '0': 'The template language expression 'variables('VarRange_UsersImpacted')?[outputs('Create_item')?['body/field_6']]' cannot be evaluated because property '25000' cannot be selected. Please see https://aka.ms/logicexpressions for usage details.'.

Config below

Screenshot 2024-0...

Was this reply helpful? Yes No
Verified answer

Ellis Karim 11,681 Super User 2025 Season 2 on at

Like (1)

Report

Hi @MBlaired79

The error is due to the second part of your expression referencing a SharePoint column (field_6) that does not exist?

Can you use the source column/value from the form. In my demo flow I'm using the following:

Field_6 may not be the correct name of the SharePoint column. Please see : 🔍How to Find the Internal Name of a SharePoint Column – Ellis Karim's Blog

Ellis
____________________________________
If I have answered your question, please mark the post as ☑️ Solved.
If you like my response, please give it a Thumbs Up.
My Blog Site

Was this reply helpful? Yes No
MBlaired79 15 on at

Like (0)

Report

Perfect, thank you. All working!

Was this reply helpful? Yes No