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

Подписаться 18 тыс.

Просмотров 7 тыс.

50% 1

#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()

Опубликовано:

5 окт 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 44

@nimishanalinam 11 месяцев назад

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 8 месяцев назад

i have not tetsed it properly so can't comment

@nimishanalinam 8 месяцев назад

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

@LernenTech 8 месяцев назад

@@nimishanalinam great and thank you :)

@jennyhoang7906 3 месяца назад

Hi Lernen, could you please make another video to show the the detail of getting previous values vs current values of a list item column for email/ multi-select field? These codes run well but when it encountered the person column which is an array, it threw errors.

@Kris-qx5fw 27 дней назад

Hi Jenny, I'm experiencing the same issue, did you find a way to overcome it? The issue happens because the http requests results split based on commas but multi select fields have commas within them.

@jennyhoang7906 27 дней назад

No I did not. I switched to work on something else, and didn't get a chance to go back and deal with this issue. It seemed like you found a solution right? Could you share with us in details please? Thanks.

@Kris-qx5fw 27 дней назад

@@jennyhoang7906 Hi, I also haven't found a solution to it. I just know what the issue is. It wasn't a required feature for what I was working on so I left it out.

@jennyhoang7906 26 дней назад

Oh OK, if you happened to find a solution to this issue, please share with us. Much appreciate it.

@jmci24 11 месяцев назад

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 8 месяцев назад

use manual trigger for that

@mairatchaprapa1650 3 месяца назад

@@LernenTech Can you please teach and make a video for this topic?

@WilsonC15 3 месяца назад

Thank you very much. This video is definitely helpful. Is that possible to to retrieve specify columns and trigger just specific date column only?

@shathike4079 10 дней назад

Thank you for the excellent demonstration. I have a question: I tested it, and it works, but I need to change the internal name to the display name because the email notification output shows only the internal name. Could you please assist with this?

@michaelrsnow 4 месяца назад

Hi all, got this to work as instructed in this video, anyone know how/where in the flow you could remove fields that have changed but you don't want to see in the table? like 'modified' and 'modified by' as these are showing as changes in the table between the last person/date it was modified to the current person and date who modified it?

@Talesoffabiya 2 месяца назад

Thank you for the education. i'm trying to get a deadline date into previous and current value. it is not catching the date and showing modified date only, whereas deadline date is user selectable. but when i'm changing any other column, it is taking it into account and showing previous/current values. any solution?

@MrRagerrrr7777 9 месяцев назад

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 8 месяцев назад

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

@shubhabratadey 3 месяца назад

Very helpful video

@wmgeter 2 месяца назад

The step for select 3 gives an "invalid expression". Any idea of why this would be?

@sohadaneen7639 7 месяцев назад

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.

@alondraespinal5115 5 месяцев назад

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 5 месяцев назад

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 5 месяцев назад

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.

@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 11 месяцев назад

for that you will have to write few extra step

@michelleroach8059 10 месяцев назад

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

@SoftwareSollugaallu 4 месяца назад

I am getting error in select 3 step the error is unable to process template language expressions in action 'Select3' inputs at line '0' and Column'0' : String can't be of Zero length . Can you please help me on this how to resolve this

@kalieeaton 6 месяцев назад

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?

@sandeepsingh-me4om 4 дня назад

Hi all-I am getting the error in send http request (first one ) -when we try to use 'join' with - $select=join('Body(select_2)', ',') --it says invalid expression -but in this video it worked correctly ..And i am not able to get the current values though Versioning is on for list --Can someone please guide me .Thanks

@beabondoc8567 3 месяца назад

Hello. is it possible to share the table formatting code?

@johanvandyk6532 8 месяцев назад

Great video👍, thanks a stack

@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 9 месяцев назад

Have you got the answer?

@LernenTech 8 месяцев назад

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

@giathịnhphan-d4w 9 месяцев назад

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 8 месяцев назад

you want automate it or manually?

@giathịnhphan-d4w 8 месяцев назад

@@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 8 месяцев назад

@@giathịnhphan-d4w 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 :)