Unanswered

Condition if string (name) contains a certain letters

(0) Share

Report

Posted on by acolyter

Hi,

How do I create a condition that allows me to check if a string contains a specific 'name'? What I want is to have a condition that checks if there's a certain 3 letter identifier included in a string that's in a sharepoint list column.

Thanks!

Categories:

Using flows

I have the same question (0)

All responses (2)

Answers (0)

Barret 652 Most Valuable Professional on at

Like (1)

Report

You'll want to use an expression that uses the indexOf string function. Something like:

indexOf(stringToSearch, stringYouAreSearchingFor)

And you'll want to check if the result is >= 0. If it is, the string contains the search text. If the result is -1, it doesn't contain the text you are searching for.

Was this reply helpful? Yes No
ScottShearer 25,270 Most Valuable Professional on at

Like (0)

Report

@acolyter

I agree with the solution provided by @barret but would like to add that you need to put single quotes around the string for which you are searching.

Was this reply helpful? Yes No