Wednesday, May 13, 2026

How to make a view show all records where two fields are the same

I have a client that has some user-created flows are populating two lookup fields. They want a view of all rows where the two lookup fields are the same, but you cannot compare two fields using advanced find. The solution is to create a new field in your table using a PowerFx formula. 

In this example, I created an 'Error condition' column on a custom table that compares the two contact lookups, and if they are the same, then this column will show Yes (true). 

In this variation, I use the IF() function to return a "Yes" string if the fields are the same. I would argue that this is more flexible than the above because I can update this in the future to return different strings for different error conditions. 


Now I can make a view that filters where those fields are the same value





No comments: