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 Automate / How lookup column trig...
Power Automate
Unanswered

How lookup column trigger a flow

(0) ShareShare
ReportReport
Posted on by 6

I have a flow based on a library.

  • The library has some columns. One column is lookup type. 
  • The Flow trigger is "file is modified".

I want the flow to run only when the lookup type column is modified. Is there any suggestion how to do?

 

I searched the blog: http://microsoftdynamics.in/2020/06/09/trigger-condition-expression-example-for-each-datatype-in-power-automate/ However I don't understand how to define the variable as shown below. Can anyone help? 

fishscience_0-1613140007549.png

 

Categories:
I have the same question (0)
  • Verified answer
    annajhaveri Profile Picture
    8,531 Most Valuable Professional on at

    @fishscience you can ptovide the trigger condition as follows, please replace Columnnamehere with the name of your lookup column. Please note that this should be internal name of the column.

    To get internal name of column go to your list/library settings, click on column and then see the browser URL and you will find column name after Field=, e.g. if it is Field=Title, then internal name of column is Title.

    @equals(triggerBody()?['ColumnNameHere']?['Value'], 'test')

     

    In addition to this i would suggest to use When item or file is modified trigger, configure trigger condition, then add Get Changes for an item or file action, configure it as shown in below screenshot. Then add condition action to check if lookup column column value has changed, so you can select Has Column Changed: <lookup column name> in condition in left side of condition and select true from dynamic content -> expression  on right side of condition, please take a look at screenshot below. Please note to use this approach you need to enable versioning on your library.

     

    annajhaveri_1-1612367696516.png

     

     

  • fishscience Profile Picture
    6 on at

    Thanks annajhaveri! your suggestion works for me.

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 Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 522 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 364 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard