web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
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
    69,397 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
    69,397 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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the April Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Vish WR Profile Picture

Vish WR 957

#2
Valantis Profile Picture

Valantis 847

#3
Haque Profile Picture

Haque 609

Last 30 days Overall leaderboard