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 tableand 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.
Go to Solution.
Hi @Mr0bb0 ,
Please modify formula as below:
Filter(colDistinctMembers, "Username" in displayName.displayName )
View solution in original post
Keep your eyes open for our upcoming T-shirt design contest!
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020