Unanswered

Help with comparing strings with array e.g string a contains in array [a;b;c]

(1) Share

Report

Posted on by naijacoder

172

Hi All
I have field in sharepoint list that i store these values its not a multi choice field but a single line of text
The values look like this a;b;c;d

I have split the values below

split(variables('var_splitCatEquip'),';')

and the output is this

["a","b","c","d","]

and also adding it to an array

For now i would like to compare using a condition

The top string gets the first index of the array (Also how can i dynamically loop through each values here like a for each in JavaScript?)

The above is just the values of all the arrays e.g [a;b;c;d]
But when i test the flow it is always returning false...

Not sure why?I'm probably missing something

Thanks in advance

Categories:

General topics

I have the same question (0)

All responses (5)

Answers (0)

DamoBird365 8,942 Microsoft Employee on at

Like (1)

Report

Hi @naijacoder

You would want to drop your array into an apply to each action and then you can use each value in your condition.

When I am debugging, I often rely on the compose action. It is easily added/removed and will quickly identify the data I am playing with. So in your case, I think you have your condition the wrong way around. You've got "a contains abcd" whereas you want "abcd contains a".

I've also done a blog post on comparing arrays which you might find useful.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Cheers,
Damien

P.S. take a look at my new blog here

Was this reply helpful? Yes No
naijacoder 172 on at

Like (0)

Report
Thanks DamoBird365.
You are absolutely correct i have had used it the opposite way.
One other question is instead of getting each values using an index e.g like below

string(variables('var_catEquipArray')?[0])

Can i do something like this below in power automate

string(variables('var_catEquipArray')?[i]))

Loop through the array and passing the values to filter

Thanks

Was this reply helpful? Yes No
DamoBird365 8,942 Microsoft Employee on at

Like (1)

Report

Hi @naijacoder

You can indeed. You could define a variable at the beginning of your flow and increment the variable in a do until (variable is less than a number or for example length of array)

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Cheers,
Damien

P.S. take a look at my new blog here

Was this reply helpful? Yes No
naijacoder 172 on at

Like (0)

Report

Thanks. Will give it a shot

Was this reply helpful? Yes No
DamoBird365 8,942 Microsoft Employee on at

Like (0)

Report

Hi @naijacoder

How are you getting on?

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Cheers,
Damien

P.S. take a look at my new blog here

Was this reply helpful? Yes No