cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper III
Helper III

Trigger a flow when particular field Updates in SP List

 I want to trigger flow only when Comments field updated in My SP List.
I have tried versioning but issue is initially my Comments field is null hence unable to parse that.

and in select control when i try to assign values From field not accepting Bode from HTTP response

7 REPLIES 7
Super User
Super User

Hi @fd00094 

The flow can be triggered based on the trigger actions available for SharePoint. For the list, you can use the trigger actions like when an item is created or modified or deleted, once the flow is triggered, you can check the Comments field and based on the value whether it is null or valid data, you can start doing your functionality.

 

Hope it helps, please like it or mark it as a solution if it resolves ur clarification or issue
-Sudharsan K...

Hope it helps, please like it or mark it as a solution if it resolves your clarification or issue
-Sudharsan K...

Hi @sudharsan1985 

 

I want to compare last 2 versions of comments fields,

Checking comments blank or not will help in initial triggering but if there are multiple modifications events then how to manage this.

 

I want to send an email every time when comments are added/updated.

 

 

Super User
Super User

Hi @fd00094 

Whenever the item is added or updated, the trigger actions will provide you with all the values that are updated, you can use the results from the trigger actions and then based on that you can send an email. If you want to check the versions of the comments then you have to use SharePoint REST API to fetch the versions of the items and then compare the field with the versions.

 

Below is a link to the REST API for list in SharePoint

https://docs.microsoft.com/en-us/sharepoint/dev/sp-add-ins/working-with-lists-and-list-items-with-re...

 

To access the item version use the below endpoint

/_api/web/lists/GetByTitle('Test')/items/getById(1)/versions

 

Hope it helps, please like it or mark it as a solution if it resolves ur clarification or issue
-Sudharsan K...

Hope it helps, please like it or mark it as a solution if it resolves your clarification or issue
-Sudharsan K...
Super User III
Super User III

@fd00094 

Is your comments field a simple text column or is it a multiline text column with append text set to true?

You might try using the append text feature.  Anytime the column is not null it has been updated,  All content is saved with a specific version.

 

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott

Hi @ScottShearer 

 

Its Multi line and append to field
Lets take scenario :

1. Item Created  - Comments null

2. Item Modified - Comments Added

3. Item Modified - Title Changes, Comments Unchanged

4. Item Modified - Comments Updated

 

Want to trigger flow in 2nd and 4th case only.

 

Any Help

 

Thanks

 

@fd00094 

In my example, I have an append text multi-line column called MultiText.  I am using a SharePoint when an item changes or is modified trigger.

Adding the following as a trigger filter will allow for the Flow to run only when the MultiText column changes:

@not(equals(triggerBody()?['MultiText'],null))

TriggerFilter.jpg

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott

Hi @ScottShearer 

 

This will solve 2nd scenario but what about 4th Scenario

 

I want to compare last 2 version comments but how to get that using HTTP and Parse JSON,

 

HTTP will give versions but how to get Comments field for compare, If i use parse JSON it gives Null value issue
and if  i added string and Null in Schema then Unable to get Comments field in dynamic content

Helpful resources

Announcements
Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

Microsoft Ignite

Microsoft Power Platform: 2021 Release Wave 1 Plan

Power Platform release plan for the 2021 release wave 1 describes all new features releasing from April through September 2021.

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Users online (69,238)