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

How to check if a column was edited using power automate ?

Hi everyone,

 

I would like some assistance with Power automate.

Essentially, I'm trying to make a flow that would detect a change of a title of an item and change the folder name to that new name.

 

I was able to do all of that except detecting if the title column was modified or not.

 

Githendra23_0-1657033804860.png

 

 

Can anyone help me ?

 

Thanks in advance,

1 ACCEPTED SOLUTION

Accepted Solutions
vivekpande18
Super User
Super User

Hi @Githendra23 ,

 

You can achieve this by getting the previous version column values.

 

1- Trigger :  you can use any SP trigger

vivekpande18_0-1657038654792.png

 

2 - Http trigger : to get the previous version column value.

vivekpande18_1-1657038731401.png

 

Uri : _api/web/Lists/getbytitle('List - Name')/items(@{triggerOutputs()?['body/ID']})/versions

 

Note : This will give all the column values related to all the versions. like below.

VersionLabel is the version number

{
    "value": [
        {
            "Title":"Web Developer",
            "VersionLabel":"2.0"
        },
        {
            "Title":"Application Developer",
            "VersionLabel":"1.0"
        }
    ]
}

 

3- Get the previous title value

vivekpande18_2-1657038988045.png

Inputs :  body('Send_an_HTTP_request_to_SharePoint')?['d']['results']?[1]?['Title']

 

You can compare above value with current title value.

 

You can use this solution if you need previous column value, else you can follow @Shuvam-rpa  post to just detect the change.

 

 

Thanks

Vivek Pande

View solution in original post

5 REPLIES 5
David-
Solution Supplier
Solution Supplier

I don't know of a way for Power Automate to view the history of an item, so I think you will need to add another field to your list where the workflow sets the value of the title (Submitted Title). You can probably do the next part a couple of ways, but I think I would do this:

 

  1. Workflow 1 runs when the item is created. It sets the Submitted Title to the value of the Title field.
  2. Workflow 2 only runs when an item is modified. 
    1. I have not used trigger conditions a lot, so you may be able to configure it to only run when Title ne Submitted Title. Otherwise you can add a condition action to check this.
    2. If it does not match, then you do the steps you outlined, and then also update the Submitted Title field to the new updated Title to reset it for the next time the item is updated.
Shuvam-rpa
Solution Supplier
Solution Supplier

@Githendra23 you need to use Get changes for an item or a file (properties only)  action and then in next action you can use dynamic content to check if column modified or not. please check below screenshot for reference

 

Shuvamrpa_0-1657037320544.png

 

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

vivekpande18
Super User
Super User

Hi @Githendra23 ,

 

You can achieve this by getting the previous version column values.

 

1- Trigger :  you can use any SP trigger

vivekpande18_0-1657038654792.png

 

2 - Http trigger : to get the previous version column value.

vivekpande18_1-1657038731401.png

 

Uri : _api/web/Lists/getbytitle('List - Name')/items(@{triggerOutputs()?['body/ID']})/versions

 

Note : This will give all the column values related to all the versions. like below.

VersionLabel is the version number

{
    "value": [
        {
            "Title":"Web Developer",
            "VersionLabel":"2.0"
        },
        {
            "Title":"Application Developer",
            "VersionLabel":"1.0"
        }
    ]
}

 

3- Get the previous title value

vivekpande18_2-1657038988045.png

Inputs :  body('Send_an_HTTP_request_to_SharePoint')?['d']['results']?[1]?['Title']

 

You can compare above value with current title value.

 

You can use this solution if you need previous column value, else you can follow @Shuvam-rpa  post to just detect the change.

 

 

Thanks

Vivek Pande

Your solution worked !! Thank you

Thanks for your solution, I didn't use your solution but I appreciate it. 🙂

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Super User 2 - 2022 Congratulations 768x460.png

Welcome Super Users

The Super User program for 2022- Season 2 has kicked off!

Users online (3,046)