Filter a gallery by a nested gallery

[Jose_LuisA]

Hi yall

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!

[StalinPonnusamy]

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]

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