cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Maria_DK
Frequent Visitor

Filter items from value in Lookup column

EDITED - The column in question is a lookup column

Hi, 

 

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.

1 ACCEPTED SOLUTION

Accepted Solutions

Hi @Maria_DK 

 

I have another video tutorial for this.

 

https://www.youtube.com/watch?v=Lxuv_vEvFbM&t=21s

 



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blogPower Automate Video Tutorials

View solution in original post

6 REPLIES 6
abm
Super User
Super User

Hi @Maria_DK 

 

Please have a look 

 

https://www.youtube.com/watch?v=N20Y-ZNRKhk

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blogPower Automate Video Tutorials
Maria_DK
Frequent Visitor

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?

Hi @Maria_DK 

 

I have another video tutorial for this.

 

https://www.youtube.com/watch?v=Lxuv_vEvFbM&t=21s

 



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blogPower Automate Video Tutorials

View solution in original post

Maria_DK
Frequent Visitor

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."

 

Any suggestions?

Hi @Maria_DK 

 

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.

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blogPower Automate Video Tutorials
Maria_DK
Frequent Visitor

Thank you again.

 

It was the field name after / that was the problem. 
It works now 🙂

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Users online (1,768)