Power Automate - Send Previous vs Current Version Values Over Email when Columns Changes in List

#powerautomate #versionhistory #trackcolumnchnages
In this detail video i have gone through the detail of getting previous values vs current values of a list item column when there is any column changes happen inside SharePoint List.
below are the refrence code -
split(replace(replace(string(outputs('Get_changes_for_an_item_or_a_file_(properties_only)')?['body/ColumnHasChanged']),'{',''),'}',''),',')
outputs('Send_an_HTTP_request_to_SharePoint_2')?['body']?[json(item())]
split(replace(replace(string(outputs('Send_an_HTTP_request_to_SharePoint')?['body']),'{',''),'}',''),',')
replace(split(item(),':')[0],'"','')
_api/lists/GetByTitle('Issue tracker')/items()/versions()

[@nimishanalinam]

Hi , Can we use the REST API filter (Top=2)_api/web/Lists/getbytitle('Test')/items(1)/versions?$top=2, to get last two versions ? with a combination of Has column changed equal to true ?

[@LernenTech]

i have not tetsed it properly so can't comment

[@nimishanalinam]

@@LernenTech I used this approach in my application and it works well.

[@LernenTech]

@@nimishanalinam great and thank you
:)

[@jmci24]

This was great: I'd like to build a summary table of daily changes, but send a consolidated list to the owner: Eg owner 1 3 items have changes, all include in same table

[@LernenTech]

use manual trigger for that

[@johanvandyk6532]

Great video👍, thanks a stack

[@kalieeaton]

I keep getting an error in the Select_3 step. And my outputs have not looked the same as yours after the filter array step. ChatGPT is saying that my outputs appear to be a mixture of JSON-like structures, HTML, and other text. How do I fix my flow?

[@vivienronai2194]

Hi!
Thank you for the video! :)
After selecting data, I have the URL format of the headers, like "Planned_x005f_x0020_x005f_date_x005f_x0020_x005f_to_x005f_x002". How can I fix it and have the normal Text?
Thank you!

[@LernenTech]

for that you will have to write few extra step

[@michelleroach8059]

Can you do another video on how to do the extra steps for this? Possible explain how to remove them. I'm experiencing the same issue.@@LernenTech

[@marcocruz5351]

how do we get the actual name of the column? In your SP list, 'Title' column is 'issue', i want to grab that 'issue' instead of 'title'. How can i do this without using apply to each?

[@LernenTech]

for that there is extra step you have to perform by creating a repalce set for each column

[@alondraespinal5115]

Hello, great video. What about if you want to add the changes to a 2nd sharepoint list and not via email. I’m trying to have a 2nd sharepoint list that logs all the changes/version history. Any suggestions on how to accomplish that instead of sending it through email. Thank you.

[@LernenTech]

If you want to just create new entry every time there is change then it’s simple create item in another list by mapping columns or if you want to update single record then create a unique id field. There is a video in channel already about update item in secondary list

[@alondraespinal5115]

Thank you for answering. I saw the tutorial on updating the second sharepoint list but it doesn’t apply to me because the fields on my second sharepoint list are not the same as in the primary list. I want to be able to store the changes the user makes to the field on the primary list on the secondary list. Kind of like a version record of previous and current changes. But after I get to the “select 3 step” I have not been able to figure out how to add the “previous changes “ and “current change” field to the second sharepoint list.

[@sohadaneen7639]

Hi Team, Nice Vedio, I have an requirement like , I have sent Initial mail and after needs to send update on top of it initial mail, how can we achieve this? My source data is Share point excel sheet where I have values like Initial ,Update, Skip, Resolution where ever I changed the status I need to send an email on top of it Initial mail only.

[@siboneyyy]

@12:00 sounds like birds in costa rica 🙂

[@user-uh2vc4zk5j]

Hey Lermen
When a file is created on a sharepoint folder, after 30 minutes I want to check who has edited the file, how to ?

[@LernenTech]

you want automate it or manually?

[@user-uh2vc4zk5j]

@@LernenTech No, I want to do it by automation. When a file is created, every 30 minutes, check to see who has edited the file. There is a group assigned to edit the file. If they don't edit, check every 30 minutes and send an email. Notify them in editing

[@LernenTech]

@@user-uh2vc4zk5j not sure what you are trying to achieve but based on your input you can create trigger when a file is modified and check for modified by column you will get the detail of last modifier. but to get all modifier you need to get the version history detail. i hope i am clear :)

[@Letty-25]

Hi! Still new to Power Automate. Will this flow be possible if the data is in an Excel file through OneDrive shared folder instead of a Sharepoint list?

[@deepakgocher4378]

Have you got the answer?

[@LernenTech]

I am not clear on excel how we can get version history and make api call?