How to Add a Row Filter for Lookup Columns in Power Automate

 When adding a row filter to a Power Automate flow for lookup columns, you need to adjust the column name slightly by adding both a prefix and suffix. Here's how to do it step by step:

Steps:

1. Identify the Lookup Column:
   Find the logical (schema) name of the lookup column. For example, if the column is called tri_form, that's the name you'll modify.

2. Modify the Column Name:
   Add an underscore _ at the beginning and _value at the end of the column name.
   Example: tri_form becomes _tri_form_value.

3. Write the Filter Expression:
   To filter rows where the lookup column is non-empty, use the following expression:

_tri_form_value ne null

This filter ensures the flow only triggers when tri_form has a value.

That's it! You now know how to add a row filter for lookup columns in Power Automate.