Answered

Comparing two SharePoint lists with the same column names using a filter

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

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!

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

wyotim 2,545 on at

Like
a
(0)

Report
Copy link

Link copied!
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.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Doesn't seem to be working for me with that syntax

I tried this
Title = MyCollection.Title
with no success

Was this reply helpful? Yes No
Verified answer

wyotim 2,545 on at

Like
a
(2)

Report
Copy link

Link copied!
My syntax was indeed off. It should have been:

Title = MyCollection[@Title]

Was this reply helpful? Yes No