web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / fitler of two tables i...
Power Apps
Unanswered

fitler of two tables in two different collections

(0) ShareShare
ReportReport
Posted on by GreenFrog 53

Hi,

 

I have two collections in PoweApps, colOne where there are two columns, id and a table relating to multi select choices.  The other collection has just one table of the same options of multi select choices as the first table.

 

How do I fitler to compare the two collections so I just have a column of id’s where there is a match of the two tables. 

thank you for your help in advance.  

Categories:
Building Power Apps
I have the same question (0)
  • Meekou Profile Picture
    Meekou on at

    For this specific issue related with data source and query logic, I would recommend you share a demo which including the mock two collections and expected result, also share the logic how to query to get expected result.

  • GreenFrog Profile Picture
    GreenFrog 53 on at

    Hi,

     

    Thanks for your message.  


    I have two collections: colSelected which has just one column called Pas2 with a table which comes from dataverse multi select columns. The other collections has two columns, id which is  autonumbered and Pas1 which is a column of tables which comes from a dataverse table of multi select choices.  Pas1 and Pas2 could the same choices available and I am trying to fitler these two tables to get a list of numbered id where any of these options match. E.g. if Pas1 has apple, banana, and grape and Pas2 has just apple and banana there should be a match and number id is filtered and stored in a collection.

    My code I used is

     

    ClearCollect(

                      colSelected,

                      ForAll(

                            colRelevantPandas,

                            If(

                               Pas1 = colSelected.Pas2,

                               ThisRecord

                               )

            )

    )

     
    powerapps does not like a table to be compared against another table so I am really stuck on how to proceed.

     

    Any help would be really appreciated.  Thanks for looking at this.               

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 345 Most Valuable Professional

#2
11manish Profile Picture

11manish 207 Super User 2026 Season 2

#3
Mohsin Ali Profile Picture

Mohsin Ali 177

Last 30 days Overall leaderboard

Featured topics

Auto-Populate field Power Pages
Gallery Tabs - Show or Hide Tabs based on Field Value
How to patch multiple records at once
Enable Copilot for end users in model-driven apps
Question for everyone : How are you using Create Text GPT in AI Builder?
Community content - sample components, blogs etc. - Link to this page (http://aka.ms/PCFdemos)
Welcome to the Power Apps forum!

Product updates

Microsoft Power Platform Community release plans