EDITED - The column in question is a lookup column
In my flow, I want to get items from a list, filtered by the value of a multiple choice column.
I want to get items where the multiple choice column "Group Membership" contains at least one of the values "Group 1", "Group 2", "Group 3".
I wanted to use the odata filter query, but I can't quite figure out how to do this with a multiple choice column.
I also looked at the possibility of using Filter array, but I do not know how to work with the data afterwards.
The filtered items should be put into a new list.
I hope you can help, thanks in advance.
Solved! Go to Solution.
Hi @abm ,
Thanks for your reply, that was a good video.
I now discovered that my column is actually not a choice, but a lookup column, and I get this error, when I try using the method in the video with GroupMembership eq 'Group1':
Exception from HRESULT: 0x80131904
So I should change my question to How do I filter multiple values from a lookup column?
Thanks again, @abm .
When I try it out, I get this error:
"One or more field types are not installed properly. Go to the list settings page to delete these fields."
That means you are not using the exact internal name. Some one might have renamed the columns. Go to list settings. Click on the column and check the url. End of the url it shows the actual internal name. Use this name in your filter.
Check out the News & Announcements to learn more.
Check out the new Power Platform Community Connections gallery!
Congratulations, the new Super User Season 2 for 2021 has started!
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.