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

Notifications

Announcements

Community site session details

Community site session details

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

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 774 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 335 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 248

Last 30 days Overall leaderboard