Skip to main content

Notifications

Power Apps - Power Apps Pro Dev & ISV
Unanswered

Filter for lookup fields, which are not set

Posted on 28 Nov 2024 12:28:31 by 13
I am using Dataverse, main table and other tables for lookup.
Different users add different data
 
I want a filter, which will give me rows, where a certain lookup is not set yet
 
As of now I use:
 
Filter(table, IsBlank(lookup_field.value_in_there))
 
I want to do something like in SQL:
 
Select * from table where lookup_id is null
 
How can I do that in PowerApps?
 
  • AmDev Profile Picture
    AmDev 3,002 on 28 Nov 2024 at 12:54:12
    Filter for lookup fields, which are not set
    You could create a Dataverse view with the filter set to show those records where that column 'Does not contain data'.
     
    Then display that view in the canvas app. You can select the view in the gallery/table properties or you can manually add the following into the Items property:
     
    Filter(YourTable,'YourTable (Views)'.'Your New View' )
     

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

November 2024 Newsletter…

November 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #7 Community Profile Tips…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,151

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,845

Leaderboard