Power Platform Community Forum Thread Details

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

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:

Compare two SQL server tables, and highlight missing data