Say I have the following incomplete code snippet
ForAll(MyCollection,Filter(AnotherCollection, Title = Title))
"MyCollection" and "AnotherCollection" both have a column named "Title". How do I compare them using "=" in the filter so that PowerApps knows that one "Title" is from "MyCollection" and the other is from "AnotherCollection" ?
Thank you!
Solved! Go to Solution.
My syntax was indeed off. It should have been:
Title = MyCollection[@Title]
I believe the best solution is using the disambiguation symbol "@" and defining your column from the other list. I am doing this from memory, so it may be a bit different but I believe it is:
ForAll( MyCollection, Filter( AnotherCollection, Title = MyCollection.[@Title] ) )
That should at least be headed in the right direction if I messed up the syntax.
Doesn't seem to be working for me with that syntax
I tried this
Title = MyCollection.Title
with no success
My syntax was indeed off. It should have been:
Title = MyCollection[@Title]
User | Count |
---|---|
179 | |
113 | |
88 | |
44 | |
42 |
User | Count |
---|---|
225 | |
113 | |
112 | |
70 | |
67 |