Unanswered

Validate the updated field in sharepoint

(0) Share

Report

Posted on by Community Power Pla...

Hi All,

I have a share point list I have created for team use, and this list can be updated by any team member,

What I wanted to do is, I need to trigger an automation when an existing SharePoint list item is modified and if the modified field is the "Name" then to Do something and if it's not the name, then to something else

How can I Archive this

Categories:

Using flows

I have the same question (0)

All responses (7)

Answers (2)

Verified answer

Expiscornovus 33,189 Most Valuable Professional on at

Like (2)

Report

Hi @Anonymous,

This would be possible via the Get changes for an item or file (properties only) action. Pieter Veenstra has written a nice blog about this:

https://sharepains.com/2020/09/24/changes-sharepoint-items-power-automate/

Update after Scott his comment.

Below is an example, which requires versioning to be enabled on the list.

1. Add a when an item or file is modified trigger action

2. Add a Get changes for an item or file (properties only) action. Configure it to use the ID and Modified field from the trigger action

3. Add a Condition action and check if the Name column has changed by using the Has Column Changed: Name field is equal to true

Was this reply helpful? Yes No
ScottShearer 25,270 Most Valuable Professional on at

Like (1)

Report

@Anonymous

I agree with the solution provided by @Expiscornovus but would like to add that you must enable versioning on your list for the to run without error.

Was this reply helpful? Yes No
Expiscornovus 33,189 Most Valuable Professional on at

Like (0)

Report

Thanks @ScottShearer. That is definitely a prerequisite. Forgot to mention that 🙂

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Thank you all for helping me out, I will definitely try this. thank you again

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

@Expiscornovus

Hi, Once again thank you for helping me out on this but A small clarification

I tried the above method and its worked, but when I go back and change another field, it still runs the above condition since the "Add a Get changes for an item or file (properties only) action" method returns the changed value as "True" for the current changed field as well as the previous changed field

Any workaround to this

thanks in advance

Was this reply helpful? Yes No
Verified answer

Expiscornovus 33,189 Most Valuable Professional on at

Like (0)

Report

Hi @Anonymous,

Yes, you can specify the Until field in the action and compare it with the previous version of an item or file.

When you do that it should only show you the changed fields between your latest and the previous version.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Thank you for the support @Expiscornovus

Was this reply helpful? Yes No