How to filter gallery based on lookup in lookup columns?

(0) Share

Report

Posted on by Oskarkuus

1,097

How do i filter my gallery

I have one table with the main info.

Then i have two other tables with logs and status of the main table.

I made this picture

I cant figure out how to only filter the gallery on the Third table when the gallery´s datasource is the First table.

I really dont want to change the relationships even tho i realize it would be much easier to have the Third (TASK STATUS) connected to the First (TASKS) table.

So i hope i can figure out someway to filter the gallery

Filter(TASKS;
TaskProgress.TaskStatus.StatusName = "STATUS ONE")

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (0)

Ethan_009 4,838 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Oskarkuus ,

I really doubt you can achieve this using a single Gallery avoiding delegation warnings.

You can try hidden galleries to filter out data from 1 Table and then filtering that gallery using another gallery.

As Gallery items are usually focused on that specific Table to which it is assigned, jumping to 3rd table will require Hidden gallery control involvement.

Use Pagination method to solve delegation as well as accessing multi-level table traversing.

Hope this helps

Was this reply helpful? Yes No