Unanswered

Filter a gallery by a nested gallery

(0) Share

Report

Posted on by 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!

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

StalinPonnusamy Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Jose_LuisA 31 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No