Filter items from value in Lookup column

(0) Share

Report

Posted on by Community Power Pla...

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.

Categories:

Building flows

I have the same question (0)

All responses (8)

Answers (1)

abm abm 32,856 Most Valuable Professional on at

Like (0)

Report

Re: Filter items from value in multiple choice column

Hi @Anonymous

Please have a look

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

Thanks

Was this reply helpful? Yes No
Community Power Pla... on at

Like (1)

Report

Re: Filter items from value in multiple choice column

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?

Was this reply helpful? Yes No
Verified answer

abm abm 32,856 Most Valuable Professional on at

Like (2)

Report

Re: Filter items from value in multiple choice column

Hi @Anonymous

I have another video tutorial for this.

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

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Re: Filter items from value in multiple choice 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."

Any suggestions?

Was this reply helpful? Yes No
abm abm 32,856 Most Valuable Professional on at

Like (1)

Report

Re: Filter items from value in multiple choice column

Hi @Anonymous

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

Was this reply helpful? Yes No
Community Power Pla... on at

Like (2)

Report

Re: Filter items from value in multiple choice column

Thank you again.

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

Was this reply helpful? Yes No
AlexN 269 on at

Like (3)

Report

Re: Filter items from value in Lookup column

For everyone maybe also stumbeling over this thread with the same problem I had, when you get the lookup values in your list you want to query, you see "Id" and "Value" as fields.
But the filter is not "OrderHeader/Value eq '...'" but "OrderHeader/Title eq '...'"
Seems very obvious, but still gave me 10 minutes of extra work 😂

Was this reply helpful? Yes No
Time4Nine 8 on at

Like (1)

Report
Re: Filter items from value in Lookup column

Alexn, I want to clarify one thing further on this item that really had me scratching my head. The part that is after the slash (e.g. /Title), may not always be "Title". What needs to be after the slash is the internal field name of the _source_ column which may not be "Title". Let me explain this further.

I have a Parent list called "States" and in that list I have the "State Name" using the internal "Title" column and then a second column called "State Code" using an internal name of "StateCode".
I have a secondary list called "Invoices" and in that, I have a column with an internal name of "AssociatedStateCode" which is a lookup column to the States/State Code column.
In my flow, I want to do a "Get Items" on the "Invoices" list and I want a filter query based on the "AssociatedStateCode" equal to some value, my filter query would be as follows:
AssociatedStateCode/StateCode eq 'Some Value'

Hopefully this will help other people as this had me stumped for while.

Was this reply helpful? Yes No