Skip to main content

Notifications

Power Apps - Building Power Apps
Suggested answer

Unable to Filter Dataverse Table for Blank Lookup Column in PowerApps

Posted on by 2

Hi everyone,

I’m working on a PowerApps application where I need to filter a Dataverse table called Reviews. This table has a lookup column named Reviewer, which references the Reviewers Dataverse table.

I’m trying to filter records where the Reviewer column is blank, but I haven’t had any success. Here’s what I’ve tried so far:

  • Attempt 1:

    Filter(Reviews, Reviewer.Name = Blank())

    This didn’t return the expected results.

  • Attempt 2:

    Filter(Reviews, IsBlank(Reviewer.Name))
     
     
    This didn’t work either. Any guidance would be greatly appreciated!
Categories:
  • ronaldwalcott Profile Picture
    ronaldwalcott 1,167 on at
    Unable to Filter Dataverse Table for Blank Lookup Column in PowerApps
    Or use IsEmpty as it should check to see if the table is empty.
     
    Filter(Reviews, IsEmpty(Reviewer))
  • Suggested answer
    SebS Profile Picture
    SebS 4,149 on at
    Unable to Filter Dataverse Table for Blank Lookup Column in PowerApps
    Hi,
     
    I would try just Filter(Reviews, IsBlank(Reviewer)) do not include .Name and see if this will resolve the issue.

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,591

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 64,090

Leaderboard