Answered

variable Expression help please

(0) Share

Report

Posted on by Portland

167

Using a SharePoint list with a multichoice field, a user can select 1-11 teams. In my flow, I added an initialize variable (varAssignedTo) and set it to a string. Next, I added an Apply to each containing an Append to String Variable. This is working great.

Now I want to add an UPDATE ITEM action to update additional text fields used to indicate which teams have been assigned.

TeamA

TeamB

TeamC

TeamD

Using an UPDATE ITEM action, I want to select my TEAMB field, add an expression to look at my "varAssignedTo" and if it finds TEAMB in the string, set this field to YES.

I see in the expression builder there is an "if(expression, valueIfTrue, valueIfFalse)" however, being a rookie not sure how to write it out. something like, If(contains(variables('varAssignedTo'),'TeamB',YES,'')))

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

Diksha 301 on at

Like (0)

Report
Copy link

Link copied!

Hello @Portland ,

Can you please share the screenshot of the flow you have developed ?
I want to see the value of variable varAssignedTo .

Thanks,
Diksha

Was this reply helpful? Yes No
Portland 167 on at

Like (0)

Report
Copy link

Link copied!

This is the field to place the expression. If contains BUS set BUS EXP to YES

Was this reply helpful? Yes No
Verified answer

Portland 167 on at

Like (0)

Report
Copy link

Link copied!

I got it.
This expression works nicely. :
if(contains(variables ('varAssignedTo'), 'Bus'), 'Yes','')

Was this reply helpful? Yes No
Diksha 301 on at

Like (0)

Report
Copy link

Link copied!
Hi @Portland ,

Thanks for sharing the flow details.

In an Update Item action , use below expression for BUS Exp field -
if(contains(variables('varAssignedTo'),'BUS'),'Yes','No')
It will check if the variable varAssignedTo value contains a word 'BUS' and then set the value to Yes/No accordingly.

Output (List item)-

If this answered your question, please mark this question as answered and if you liked my response, please consider giving it a thumbs up .
Thank You !!!

Was this reply helpful? Yes No