cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Filter Table where Look Up Column Blank

Table "Requests" and a Lookup Column "Assigned" (looks up users).  Unassigned = no user selected in lookup column

I can accurately count how many unassigned requests I have using:

CountIf(
    Requests,
    IsBlank(Assigned)
)

  
However, if I try to filter a Data Tables "Items" field I don't get any items in my table:

Filter(
    Requests,
    IsBlank(Assigned)
)

 

What am I overlooking?

 

Environment: Teams: Power Apps & Dataverse

1 ACCEPTED SOLUTION

Accepted Solutions
Drrickryp
Super User
Super User

@Anonymous 

Trying again

Filter(
        AddColumns(
                    Requests,"assgnd",Assigned.XXXS //use intellisense to identify value
         ),IsBlank(
                    assgnd
           )
 )

View solution in original post

7 REPLIES 7
ganeshsanap
Memorable Member
Memorable Member

@Anonymous Try using these:

 

Filter(
    Requests,
    Assigned = ""
)

 

OR

 

Filter(
    Requests,
    Assigned = Blank()
)

 

 References:

  1. Filtered Lookup Column - filtered value will not be saved 
  2. LookUp Field Blank Check 

Please click Accept as solution & 👍 if my answer helped you to solve your issue. This will help others to find the correct solution easily. If the answer was useful in other ways, please consider giving it ‌‌👍

Anonymous
Not applicable

Thanks for your reply @ganeshsanap, unfortunately neither works

 

Assigned = "" gives an error indicator under the equals sign (Invalid argument type)
Assigned = Blank() does not error but does not return any items.

EDIT: Both actually give the same error!

I'll keep reading through the other posts you linked to see if I can find something more.

Drrickryp
Super User
Super User

@Anonymous 

Try

CountIf(
    Requests,
    IsBlank(Assigned.Value)
)
Anonymous
Not applicable

Thanks @Drrickryp unfortunately that doesn't work either.  "Assigned" does not have a "Value" property.

One of the confusing things about my situation is that the CountIf function I provided works as expected, but the same expression in the Filter function does not.

Anonymous
Not applicable

Bump

BlessedCobba
Responsive Resident
Responsive Resident

Hi Sandie,

have you tried pulling the data into a collection and running the same filters over the collection to populate the table?
i know its a workaround but my help with troubleshooting the issue directly for the source

Drrickryp
Super User
Super User

@Anonymous 

Trying again

Filter(
        AddColumns(
                    Requests,"assgnd",Assigned.XXXS //use intellisense to identify value
         ),IsBlank(
                    assgnd
           )
 )

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Power Apps Ideas

Changes to Ideas Coming

We are excited to announce a new way to share your ideas for Power Apps!

Top Solution Authors
Top Kudoed Authors
Users online (1,835)