Hi @Jonas9 the issue you are facing in you are trying to compare multiple choices in a for each item which is one of these choices values.
To fix this its a bit of a data manipulation but ill walk you through how I achieved this:
So firstly the Choice column in SP when returned to PA will return as an array :
So we want to initialise 2 variables at the top of your flow:
One Array and one String
So what we need to do is in side your for each Value we want to append to the array variable:
The outputs of this are:
Then we want to convert this to a string that we can compare so we use:
Outputs:
Then we need to remove the ["Value1","Value2"] in to Value1, Value2:
To do this we use compose and then this expression:
replace(replace(replace(variables('StringVar'),'["',''),'","',','),'"]','')
This will then give us this output:
The we change the condition to be the following: this does not need to be in a for each loop:
Hope this helps you 🙂
Please click Accept as solution if my post helped you solve your issue. ✔️ This will help others find the solution to this problem. It also closes the item. Remember, you can accept more than one post as a solution.
If the content was useful in other ways, please consider giving it Thumbs Up. 👍
Thanks
Andrew
