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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Compare two SQL server...
Power Apps
Unanswered

Compare two SQL server tables, and highlight missing data

(0) ShareShare
ReportReport
Posted on by 28

I have the following two columns in the SQL Server tables "name" (orange) and "name2" (yellow):

msuser48_0-1662220927037.png

 

I want to "compare these two tables", such that I get the following display in a drop down as shown above:

- Names that are in name2 table AND in name table will be highlighted green.

- Names that are NOT in name2 table, but exist in name table, will be highlighted red.

- (there are duplicate names in name2, but there should not be duplicates in the drop down list)

 

How to achieve this?

 

Categories:
I have the same question (0)
  • Drrickryp Profile Picture
    Super User 2024 Season 1 on at

    @msuser48 

    In the Invisible property of the screen,

    Sort(District(ClearCollect(coltable, nametable nametable2),namecolumn),Result)

    coltable as the items of the dropdown.

    You cannot highlite the individual items in a dropdown like in a gallery.

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

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 765 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 343 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 272

Last 30 days Overall leaderboard