Answered

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

All responses (7)

Answers (2)

Community Power Pla... on at

Like (0)

Report

Re: Validate the updated field in sharepoint

Thank you for the support @Expiscornovus
Verified answer

Expiscornovus 31,641 Most Valuable Professional on at

Like (0)

Report

Re: Validate the updated field in sharepoint

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.
Community Power Pla... on at

Like (0)

Report

Re: Validate the updated field in sharepoint

@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
Community Power Pla... on at

Like (0)

Report

Re: Validate the updated field in sharepoint

Thank you all for helping me out, I will definitely try this. thank you again
Expiscornovus 31,641 Most Valuable Professional on at

Like (0)

Report

Re: Validate the updated field in sharepoint

Thanks @ScottShearer. That is definitely a prerequisite. Forgot to mention that 🙂
ScottShearer 25,208 Most Valuable Professional on at

Like (1)

Report

Re: Validate the updated field in sharepoint

@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.
Verified answer

Expiscornovus 31,641 Most Valuable Professional on at

Like (2)

Report

Re: Validate the updated field in sharepoint

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