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
Solved! Go to Solution.
@Sandie Try using these:
Filter( Requests, Assigned = "" )
Filter( Requests, Assigned = Blank() )
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 👍
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.
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.
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