cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
pcaracc
Level 8

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

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!

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

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

My syntax was indeed off. It should have been:

 

Title = MyCollection[@Title]

 

 

View solution in original post

3 REPLIES 3
Super User
Super User

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

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.

pcaracc
Level 8

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

Doesn't seem to be working for me with that syntax Smiley Sad 

 

I tried this 

Title = MyCollection.Title

with no success

 

Super User
Super User

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

My syntax was indeed off. It should have been:

 

Title = MyCollection[@Title]

 

 

View solution in original post

Helpful resources

Announcements
thirdimage

Power Apps Super User Class of 2020

Check it out!

thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

SecondImage

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (5,027)