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.
@Anonymous
Trying again
Filter(
AddColumns(
Requests,"assgnd",Assigned.XXXS //use intellisense to identify value
),IsBlank(
assgnd
)
)
@Anonymous Try using these:
Filter(
Requests,
Assigned = ""
)
OR
Filter(
Requests,
Assigned = Blank()
)
References:
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.
@Anonymous
Try
CountIf(
Requests,
IsBlank(Assigned.Value)
)
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.
Bump
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
@Anonymous
Trying again
Filter(
AddColumns(
Requests,"assgnd",Assigned.XXXS //use intellisense to identify value
),IsBlank(
assgnd
)
)