Filter Canvas App gallery - Only show items without related table rows

(0) Share

Report

Posted on by joakimgg

Hi Community,

I am trying to apply some filtering to my canvas app gallery which is using Dataverse as source.

Description

I have a parent table (Table 1) and a child table (table 2) with a 1:N relationship.

In my canvas app gallery I am currently displaying all Table 1 rows.

Challenge/requirement

I want to filter my gallery to only show Table 1 rows that does not contain any related table 2 rows, based on the current user.

Does anyone have some pointer on how this could be achieved?

Thanks in advance!

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Verified answer

mmbr1606 14,629 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
hey @joakimgg

you can try do it this way, here is an example:

Filter( Table1, IsEmpty( LookUp( Table2, Table2ForeignKey = Table1PrimaryKey && Table2UserField = User().Email ) ) )

Let me know if my answer helped solving your issue.

If it did please accept as solution and give it a thumbs up so we can help others in the community.

Greetings

Was this reply helpful? Yes No
joakimgg 31 on at

Like (0)

Report
Copy link

Link copied!

Hi @mmbr1606 ,

Thank you for a very quick response! I tried to implement your logic, but I am currently experiencing the below error:

"The specified column is not accessible in this context"

Do you by chance know what the root cause could be?

Was this reply helpful? Yes No
mmbr1606 14,629 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Can u copy paste the code u worked out please

Was this reply helpful? Yes No
joakimgg 31 on at

Like (0)

Report
Copy link

Link copied!

Please see the below code:

The error is thrown after the lookup step when I'm trying to retrieve table 2 (Notice Histories).

Was this reply helpful? Yes No
joakimgg 31 on at

Like (0)

Report
Copy link

Link copied!

Hi @mmbr1606 ,

I managed to resolve this, thanks! I needed to also update some of my general app settings.

In addition, I could also just create the same filter by creating a dataverse view.

Was this reply helpful? Yes No