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 / "Limit Columns by View"
Power Automate
Answered

"Limit Columns by View"

(1) ShareShare
ReportReport
Posted on by 30
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?
 
 
Categories:
I have the same question (0)
  • Verified answer
    Pstork1 Profile Picture
    68,898 Most Valuable Professional on at
    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
     
  • richzip Profile Picture
    30 on at
    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')
  • richzip Profile Picture
    30 on at
    @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')
  • Verified answer
    Pstork1 Profile Picture
    68,898 Most Valuable Professional on at
    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
     

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…

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
trice602 Profile Picture

trice602 378 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 305 Super User 2025 Season 2

#3
Expiscornovus Profile Picture

Expiscornovus 135 Most Valuable Professional

Last 30 days Overall leaderboard