web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Get unrelated records ...
Power Apps
Answered

Get unrelated records without delegation warking

(0) ShareShare
ReportReport
Posted on by 18

Hi all,

 

There are two tables:
TableA (ID_A,Name_A)
TableB (ID_B,Name_B,TableA_B(optional, Lookup to TableA))

I need to get rows from TableB which are not related to TableA. 

ClearCollect(colUnrelatedToTableA(Filter(TableA,IsBlank(TableA_B.ID_A)))

It works fine but with delegation warning. Is there an option to get it without delegation warning?
There was an assumption to use  "=Blank() " instead of "IsBlank()" but I haven't got it worked.

I have the same question (0)
  • Nikolay_ps Profile Picture
    18 on at

    Found a solution - to use Views. But wanted to know if there is an option to use it inside the Apps

  • Verified answer
    Nikolay_ps Profile Picture
    18 on at

    Got it!

    ClearCollect(colUnrelatedToTableA,Filter(TableA,TableA_B.ID_A= GUID(Blank()) )

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 93 Most Valuable Professional

#2
Haque Profile Picture

Haque 81

#3
Valantis Profile Picture

Valantis 49

Last 30 days Overall leaderboard