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

8 REPLIES 8
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
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (4,193)