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 22 Nov 2024 20:30:32 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 734 on 22 Nov 2024 at 21:11:08
    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,147 on 22 Nov 2024 at 20:35:19
    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

October 2024 Newsletter…

October 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #4 How to Conntact Support…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,111

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,795

Leaderboard