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.
Trying again
Filter(
AddColumns(
Requests,"assgnd",Assigned.XXXS //use intellisense to identify value
),IsBlank(
assgnd
)
)
@Sandie 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.
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
Trying again
Filter(
AddColumns(
Requests,"assgnd",Assigned.XXXS //use intellisense to identify value
),IsBlank(
assgnd
)
)
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
User | Count |
---|---|
198 | |
100 | |
59 | |
59 | |
55 |
User | Count |
---|---|
258 | |
161 | |
90 | |
79 | |
70 |