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
October Events

Mark Your Calendars

So many events that are happening this month - don't miss out!

Ignite 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Users online (4,281)