Answered

Filtering gallery based on function FIltr and Lookup

(0) Share

Report

Posted on by Nowak

Hi,

I have a problem. How do I use lookup or some other function to return all the rows in my list? I want to use this function to filter the gallery but when I use the function below it only contains the first row for me. The first column is person and the second one is choice.

Filter( 'Stan GMP', LookUp( Places, PersonPlace.Email = User().Email ).MiejscePlace.Value = Miejsce.Value )

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (1)

Sort by

Verified answer

CNT 10,921 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@Nowak

Please try the following,

Filter( 'Stan GMP', Miejsce.Value=LookUp(Places, PersonPlace.Email = User().Email ).MiejscePlace.Value)

Please remember to give a 👍 and accept my solution as it will help others in the future.

Was this reply helpful? Yes No
WarrenBelz 156,299 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Nowak ,

Will this do what you need ?

With( { wPlace: LookUp( Places, PersonPlace.Email = User().Email ).MiejscePlace.Value }, Filter( 'Stan GMP', Miejsce.Value = wPlace ) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Nowak 51 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @CNT @WarrenBelz ,
Thanks for the answers, but I need such a function that will match me all the values from "PlacePlace.Value" to the user, while the user can repeat with the assigned Values.

Best regards
Nowak

Was this reply helpful? Yes No
WarrenBelz 156,299 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@Nowak ,

@CNT responded just before me, so I will exit here (getting late here and also a bit unclear what you actually want different from the post)

Was this reply helpful? Yes No
CNT 10,921 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Nowak Could you show clearly the fields in both the lists, their datatypes and explain a bit more clearly what you are trying to achieve. Tnkx.

Please remember to give a 👍 and accept my solution as it will help others in the future.

Was this reply helpful? Yes No
Nowak 51 on at

Like
a
(0)

Report
Copy link

Link copied!

@CNT
I have applications added to the main list, there are choice columns in the application. Like just "Miejsce". I need to filter the gallery from this main database based on the logged in user who will have places assigned in this second list. And for this I need this function to filter the gallery based on the user who is responsible for some place, e.g. Place1, Place2, Place3 etc. and just one user can have several "places".

In the main database I don't have people columns, I only use choice columns.

Best Regards,
Damian

Was this reply helpful? Yes No
CNT 10,921 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Nowak

What does LookUp( Places, PersonPlace.Email = User().Email ).MiejscePlace return?

What is the datatype of Miejsce in 'Stan GMP'?

Was this reply helpful? Yes No
Nowak 51 on at

Like
a
(0)

Report
Copy link

Link copied!

@CNT
Thats, works.
I had to fiddle around a bit and it worked.

Best regards
Nowak

Was this reply helpful? Yes No
CNT 10,921 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

@Nowak Glad you got it working!

Please remember to give a 👍 and accept my solution as it will help others in the future.

Was this reply helpful? Yes No