Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Using Flows
Answered

"Limit Columns by View"

(0) ShareShare
ReportReport
Posted on by 24
I have a flow with the "when an item or file is modified" trigger; this trigger also has a "limit columns by view" parameter.  However, the flow is triggered if I modify ANY column in the SP list-- even if that column is not included in the specified view.  Is there something I'm missing?
 
 
  • Verified answer
    Pstork1 Profile Picture
    66,758 Most Valuable Professional on at
    "Limit Columns by View"
    The trigger condition is always going to measure against some specific value.  There is no way I can think of to trigger based on some unknown change to a particular set of columns unless you are storing the previous values in a parallel field. In that case you could do a trigger condition that would only fire if that columns value doesn't equal the parallel current value.  You could then do the same for multiple columns. But each column would need a parallel column.  Then when the flow does run the last thing you do is store the current values for those columns in the parallel fields.

    ----------------------------------------------------------------------------------
    If this Post helped you, please click "Does this answer your question" and give it a like to help others in the community find the answer too!

    Paul Papanek Stork, MVP
    Blog: https://www.dontpapanic.com/blog
     
  • richzip Profile Picture
    24 on at
    "Limit Columns by View"
    @Pstork1  Thank you, and that make sense!   
    That makes sense!  Would you be able to help with the format of the trigger condition?  I found this expression, but it seems to apply if the specified column (Status) is changed to a specified value (Completed).  I want the flow to trigger if specified column(s) are changed to ANY value.
     
    @equals(triggerBody()?['Status'], 'Completed')
  • richzip Profile Picture
    24 on at
    "Limit Columns by View"
    That makes sense!  Would you be able to help with the format of how to set up a trigger condition?  I found this expression, but it seems to apply if the specified column (Status) is changed to a specified value (Completed).  I want the flow to trigger if specified column(s) are changed to ANY value.
     
    @equals(triggerBody()?['Status'], 'Completed')
  • Verified answer
    Pstork1 Profile Picture
    66,758 Most Valuable Professional on at
    "Limit Columns by View"
    The limit columns by view doesn't change what triggers the flow.  It modifies the columns included in the data returned by the trigger.  This is so you can decrease the size of the data packet being returned. If you want to limit what columns will actually trigger the flow you need to use a trigger condition.
     

    ----------------------------------------------------------------------------------
    If this Post helped you, please click "Does this answer your question" and give it a like to help others in the community find the answer too!

    Paul Papanek Stork, MVP
    Blog: https://www.dontpapanic.com/blog
     

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

Michael Gernaey – Community Spotlight

We are honored to recognize Michael Gernaey as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard >

Featured topics

Restore a deleted flow