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" ?
Solved! Go to Solution.
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.
Check out our new profile badges recognizing authored solutions!
We are excited to announce the Power Apps Super Users!
Did you miss the call? Check out the Power Apps Community Call here.
Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!