cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
hiroki
Regular Visitor

Flow with a trigger "when an item is created or modified " from share point list. "Limit Columns by View" dosen't work.

I create Flow with a trigger "when an item is created or modified " from share point list.

I input "Limit Columns by View". But the trigger also works when a column other than set columns is modified. 

I consider this is Bug. Please correct it or teach me solution.

Thank you.

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support
Community Support

Re: Flow with a trigger "when an item is created or modified " from share point list. "Limit Columns by View" dosen't work.

Hi @hiroki,

Has your problem been solved?
If your problem has been solved, You could go ahead and mark the post as solved by clicking “Accept as Solution” so that this thread will be marked for other users to easily identify!

Best Regards,
Community Support Team _ Lin Tu

View solution in original post

6 REPLIES 6
Community Support
Community Support

Re: Flow with a trigger "when an item is created or modified " from share point list. "Limit Columns by View" dosen't work.

Hi @hiroki,

 

You can use the "Select action" instead of "Limit Columns by View" to achieve your purpose.
Capture4.PNG

 

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

hiroki
Regular Visitor

Re: Flow with a trigger "when an item is created or modified " from share point list. "Limit Columns by View" dosen't work.

Hi @Lin,

 

Thank you for your reply.

I can't understand how to use the "Select action" instead of "Limit Columns by View".

My purpose is the trigger works only when limited column is modified.

I may achieve my purpose, if I could know which column is modified. 

 

I'm looking forward to your reply. Thank you.

 

Hiroki,

Community Support
Community Support

Re: Flow with a trigger "when an item is created or modified " from share point list. "Limit Columns by View" dosen't work.

Hi @hiroki,

 

Sorry for misunderstood your issue.

The Limit Columns by View is a feature that limits the output of the item, it is not the feature that limits trigger works only when the limited column is modified. And the trigger is monitoring all columns of the SharePoint, it could not be only triggered when some special columns are modified.

Annotation 2019-09-10 170659.png

However, there is a complex way to get the previous version of the modified item.

Currently, there is no action can get the previous version of the item before modified.  So we need to use the Send an Http request to SharePoint. The following are the steps that get previous version of item which has not been modified. Then parse it, and comparing it with the modified version. It can know which column is modified and the special columns whether they are modified. Annotation 2019-09-10 175002.pngAnnotation 2019-09-10 175048.png

 

 

Cause this method is complex, if you are interested in it, I will reply to you with more details about it. You can refer to this post firstly:

https://powerusers.microsoft.com/t5/General-Flow-Discussion/How-to-get-previous-versions-of-a-list-i...

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

hiroki
Regular Visitor

Re: Flow with a trigger "when an item is created or modified " from share point list. "Limit Columns by View" dosen't work.

@v-litu-msft 

 

I'm interested in the complex way to know which column is modified.

Plase give me more detail information.

 

Thank you.

Community Support
Community Support

Re: Flow with a trigger "when an item is created or modified " from share point list. "Limit Columns by View" dosen't work.

Hi @hiroki,

 

I found this method has been published as a Blog by @He USES the same method as mine, and it is more detailed.

Microsoft-Flow-Community-Blog: Check-for-a-Change-in-a-SharePoint-List-Column-Value

You can refer to his Blog, if you have any question during structure, please contact us.

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Community Support
Community Support

Re: Flow with a trigger "when an item is created or modified " from share point list. "Limit Columns by View" dosen't work.

Hi @hiroki,

Has your problem been solved?
If your problem has been solved, You could go ahead and mark the post as solved by clicking “Accept as Solution” so that this thread will be marked for other users to easily identify!

Best Regards,
Community Support Team _ Lin Tu

View solution in original post

Helpful resources

Announcements
firstImage

New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Automate Community!

firstImage

Now Live: Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Community Summit North America

The top training and networking event across the globe for Microsoft Business Applications

Users online (7,535)