cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Jose_LuisA
Helper I
Helper I

Filter a gallery by a nested gallery

Hi yall

 

Jose_LuisA_0-1650304334039.png

so this is my gallery as u can see, I have an employee number on the main gallery, then a gallery inside this gallery, that brings me the info from another table using the employee number of the main gallery and also another gallery that does the same ,yes I'm trying to see if its possible to work with 3 different SQL tables joined by an employee number
So my question is, I don't need all the employees on the main table, I just need those that doesn't have any register on the other SQL tables, is that possible?
For example filter the main gallery if the other galleries are empty if the two of them are full, then don't show that employee

Thanks in advance!

2 REPLIES 2
StalinPonnusamy
Super User
Super User

Hi @Jose_LuisA 

 

There is no way to filter main gallery based on child/nested gallery. You need to filter the main gallery based on all SQL tables.

 

Can you elaborate your use case? What data that child gallery/tables has it?

 


Thanks, Stalin (Microsoft MVP)
Blog - Learn To Illuminate Blog
YouTube - Learn To Illuminate Videos

Jose_LuisA
Helper I
Helper I

Hi @StalinPonnusamy 

Thanks for your answer!
Now I'm working on trying to add a column to my table, but it doesn't seems to work, and also takes a very very long time to upload the data to my gallery (like 20min), maybe you can help me with this

My formula is:

AddColumns(tblEmployees,
                      "Documents",
                        LookUp(tblDocuments, employeeNumber = tblEmployees[@employeeNumber]
)
)

so what im basically trying now is, do a look up on another table, create a column and then filter by that new column

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (4,448)