Answered

Using if(contains) statement in update item.

(0) Share

Report

Posted on by ML147243

Hello,

I am still learning this correct formatting and syntax for this system. I have a list with multiple columns and shown. I would like to add a Role column that updates based on the class that was selected. My current flow works for the function in the Totals for class, so it is likely how the If statement is written. I get an error message about the number of characters.

Any help is appreciated. Thank you.

flow update.jpg edited to add a better picture of If statement.

if statement.jpg

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

tom_riha 10,185 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hello @ML147243 ,

the if(...) should be entered as an expression, not as a string.

Was this reply helpful? Yes No
ML147243 80 on at

Like (0)

Report
Copy link

Link copied!

@tom_riha Hi Thanks,
Yes, I have tried to enter it as an expression and I get that the expression is invalid.

Was this reply helpful? Yes No
Verified answer

tom_riha 10,185 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

My guess would be that you're missing one or more closing brackets. Try to put the whole expression in some code editor, e.g. 'Visual Studio Code' to check if every opening bracket has also a closing bracket.

Was this reply helpful? Yes No
ML147243 80 on at

Like (0)

Report
Copy link

Link copied!

So it was that I was using " instead of ' . The flow isn't working though, I tried changing class to class value but it still is not working.

Was this reply helpful? Yes No
ML147243 80 on at

Like (1)

Report
Copy link

Link copied!

after some tweaking, this was what worked,

if(contains(triggerBody()?['Class/Value'],'EDM RN'),'RN',
if(contains(triggerBody()?['Class/Value'],'Tech'),'CNA',
if(contains(triggerBody()?['Class/Value'],'CNA'),'CNA',
if(contains(triggerBody()?['Class/Value'],'HUC'),'HUC',
if(contains(triggerBody()?['Class/Value'],'SIS RN'),'RN',
if(contains(triggerBody()?['Class/Value'],'RN'),'RN',
if(contains(triggerBody()?['Class/Value'],'HF'),'RN',
if(contains(triggerBody()?['Class/Value'],'student'),'SN',
if(contains(triggerBody()?['Class/Value'],'SCM RN'),'RN',
If(contains(triggerBody()?['Class/Value'],'Athena'),'HFMG','other'))))))))))

Was this reply helpful? Yes No