Filter a Gallery

(0) Share

Report

Posted on by absolutbeginner

Hello everybody,

I got a problem filtering a gallery with two arguments:

Filter('LM Themen';Lieferantennummer=GalleryMALiefauswahl.Selected.Lieferant;Status.Value in colStatusauswahl)

The first selection is done by the selected item of another gallery. The second one by comparing with a collection.

If I use only one of this argument, they work with out problem. If I use both I get no results.

Database is a Sharepointlist and there are datasets fiting the and-connection of the arguments.

Thanks for answers

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (2)

Sort by

v-mengmli-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @absolutbeginner ,

Is there any red error with your current formula?

If colStatusauswahl is a collection, please add '.ColumnName' after it. The column stores status in the collection.

Filter('LM Themen';Lieferantennummer=GalleryMALiefauswahl.Selected.Lieferant;Status.Value in colStatusauswahl.ColumnName)

Best regards,

Rimmon

Was this reply helpful? Yes No
Verified answer

timl 37,212 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi @absolutbeginner

Can you clarify how many items you have in your list? The 'in' operator is not delegable so that might be a cause of the problem.

Also, can you confirm what you're expecting to match with those 2 expressions? If you want to match those records where Lieferantennummer=GalleryMALiefauswahl.Selected.Lieferant OR Status.Value in colStatusauswahl, the syntax would look like this:

Filter('LM Themen'; Lieferantennummer=GalleryMALiefauswahl.Selected.Lieferant || Status.Value in colStatusauswahl )

Was this reply helpful? Yes No
absolutbeginner 21 on at

Like (0)

Report
Copy link

Link copied!

Hi @Rimmon,

there is a waved underline in red below the equal sign. But it is working, when its the only argument.

Best regards
Kai

Was this reply helpful? Yes No
absolutbeginner 21 on at

Like (0)

Report
Copy link

Link copied!

Hi, @timl,

thanks for your reply.

there are maximum 4 items in the list, out of a combobox.

I expect an Lieferantennummer=GalleryMALiefauswahl.Selected.Lieferant AND Status.Value in colStatusauswahl, so to see record where both is true.

The OR syntax you have posted is working, as soon as I put in the ; to get an AND I don't get any records.

Was this reply helpful? Yes No
timl 37,212 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @absolutbeginner

If you hover the mouse over the waved red error message, what's the error message that appears?

Was this reply helpful? Yes No
absolutbeginner 21 on at

Like (0)

Report
Copy link

Link copied!

Hi timl,

it says that the datatyp are not the same number, text.

I noticed that, but when I put in only this condition it is working in pite of the error.

Was this reply helpful? Yes No
absolutbeginner 21 on at

Like (0)

Report
Copy link

Link copied!

Hi timl,

I changed the Datatyp and the error dissapears.
But I still do not get the result expected.

Was this reply helpful? Yes No
Verified answer

absolutbeginner 21 on at

Like (0)

Report
Copy link

Link copied!

HI timl,
after trying several times changing the arguments, it's working now.

Thanks for the help!

Was this reply helpful? Yes No