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.
No comments:
Post a Comment