
Announcements
Hi I have an issue where my filter doesn't seem to be able to identify the correct value to filter on:
Filter(colDistinctMembers,displayName.displayName in "Username")
Obviously username is a proper username.
The colDistinctMembers collection has 2 levels.
displayName which is a table
and userPrincipleName which is a column.
The table underneath displayName also has a displayName column which is the column I want to filter on.
I'm not sure why my filter query above is giving me a table value error.
Any ideas?
Hi @Mr0bb0 ,
Please modify formula as below:
Filter(colDistinctMembers, "Username" in displayName.displayName )
Best regards,
Sik