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

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps - Microsoft Dataverse / Filtering 2 Dataverse ...
Power Apps - Microsoft Dataverse
Suggested answer

Filtering 2 Dataverse in Gallery

(0) ShareShare
ReportReport
Posted on by Melxy06
I have 2 Dataverse of slightly different information but the constant between both dataverse is Name.
 
How do i filter the name, in the gallery by incoporating 2 dataverse and extracting the information?  
Sadly, my powerapp doesnt support the function "union". 
Categories:
Microsoft Dataverse
I have the same question (0)
  • Suggested answer
    Inogic Profile Picture
    Inogic 1,063 Super User 2025 Season 2 on at
    Filtering 2 Dataverse in Gallery
    Hi,
     
    • Use Filter and Concat or Collect separately, then combine in a collection :
    • Since you can’t do Union, you can pull filtered data separately, then combine them in a collection, and finally set the gallery’s Items to that collection.
     
      • // Step 1: Create a collection combining filtered data from both tables on App start or on a button
      • ClearCollect(
      • CombinedCollection,
      • Filter(Table1, StartsWith(Name, TextInputSearch.Text)),
      • Filter(Table2, StartsWith(Name, TextInputSearch.Text))
      • );
     
      • // Step 2: Set Gallery Items to
      • Gallery.Items = CombinedCollection
     
    • ClearCollect takes multiple tables and appends the records in order, so this works as a manual union.
    • Replace StartsWith with whatever filter you want on Name.
    • TextInputSearch.Text is your search box input.
    Hope this helps.
     
    Thanks!
    Inogic
  • Suggested answer
    developerAJ Profile Picture
    developerAJ 3,386 on at
    Filtering 2 Dataverse in Gallery

    • Collections (ClearCollect + Collect) – the standard way to combine multiple Dataverse tables:

    ClearCollect(
    colMerged,
    Filter(DataverseTable1, Name = TextInput1.Text)
    );
    Collect(
    colMerged,
    Filter(DataverseTable2, Name = TextInput1.Text)
    )
     

    • This effectively merges the two tables into one local collection that you can use in your gallery.

     
     

    • Side-by-side galleries – if the tables are too large, or you want live data without snapshotting:

      • Gallery1 → Items = Filter(DataverseTable1, Name = TextInput1.Text)

      • Gallery2 → Items = Filter(DataverseTable2, Name = TextInput1.Text)

     

       

    If this solution helped you resolve your issue, kindly mark it as accepted — it makes it easier for others to find and also closes the discussion. If you found it useful, a Like ❤️ would be greatly appreciated!

    🤝 Let’s connect on LinkedIn || 📘 Explore more on my articles

     

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
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Tom Macfarlan – Community Spotlight

We are honored to recognize Tom Macfarlan as our Community Spotlight for October…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 1,019 Most Valuable Professional

#2
developerAJ Profile Picture

developerAJ 436

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 281 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Microsoft Power Platform Community release plans