PowerAutomate - Get Column before & After value changes
Вставка
- Опубліковано 14 жов 2024
- This video explains how to get previous value of field changes in SharePoint item using Power Automate.
Watch full video to understand how you can fetch previous version of SharePoint Item using a MS flow (Power Automate)
Thank you man you made it so easy, because of you i kept my job
Glad to know that 😊
it's very helpful and easy to understand even for beginners
Glad to hear that
Great video. Thank you. What about if I want to add the before and after value changes to a second sharepoint list instead of sending it on an email. Is this possible? I’m trying to create a list where I can track all the changes users do to the main sharepoint list. Thank you.
Very Nice and Informative Video Sir..
Thanks 🙏
Thank you so much, this is exactly what I was looking for.
Glad it was helpful!
Great Video. THANK YOU. I want to use the same flow using a Recurrence trigger. When I do so, the flow give following error message. I am using {item()?['{TriggerWindowStartToken}']} as my since parameter. Error: Action 'Get_changes_for_an_item_or_a_file_(properties_only)_1' failed
Never mind, I used an static time (from 1 hr ago)
Awesome solution. Thank you so much!
You're welcome!
Hi dear can i get the full command which you showed in notepad Please
This was very helpful. Thank you. Is there a way to have a ".d."status" where status is a two word column name? I'd like to see a change to a column which is two words instead of 1, if possible.
Thanks for your comment !
You can use the field internal name if your column has spaces for ex- Project_x0020_Name
You can see the internal as output at video 9:11 timestamp
Hi, its interesting
Kindly advise, Consolidate multiple SharePoint lists (diff. columns) into one using Power Automate
Thank you for your video! It helped me a lot :)
Glad it helped !
Thanks. Very helpful. Great work.
Thank you! I got it working!
Glad it helped
Great solution. Thanks for sharing your knowledge!
You're welcome!
Hi this is really helpful
but after running the flow in the body of "send http req to sharepoint" i am getting all previous values of all the time from the beginning, can you plz help me how to get only last previous values before modification
Great help....Thank You
You're welcome!
Hi, thank you this was very clear. I managed to follow the instruction and got my ''previous due date'' value in the workflow.
But the date formatting I got was ''YYYY-MM-DD time '', I would like to remove the time, may I know how to make the value in the ''YYYY-MM-DD'' format? thanks a lot! :)
(I already unselected the ''include time'' option in the SharePoint list via column setting, therefore I believe the change should be made in the power automate)
use the utcNow() expression. for example you can change the format to utcNow('dd-MMM-yyyy')
Thank you so much, do you have a tipping website, id like to buy you a coffee
Thanks so much !
Really glad that it helped you,
Your comments & likes are enough for me to keep me motivated 😊
Thank you
hello, can u help me please? I need to find out which item has changed and store it in a variable, and then write information about this item, such as the previous and its current value, to a text file on a new line.
Do you know how to get old value and new value of the Name column? Can't find "Has Column Changed: Name"
Use action "Get changes for an item or a file (properties only)".
Run a flow once - In success instance when you click on above action , you will see Has Column Changed : Column Name
@@m365techhelp I did use it, but the Name colum is not in there, like it is a special column.
10:44 - does anyone know why when I type "true" the resolved value that appears in the right hand side is [fx] undefined(...)? It still works, BTW - just weird that it shows the label undefined.
So, I followed the instructions but when I try to put in the expression for my column name Complete, it says invalid expression. the expression I am using is body('Send_an_HTTP_request_to_Sharepoint')d.Complete . Any advice?
I could see you missed a dot , it should be : body('Send_an_HTTP_request_to_Sharepoint').d.Complete
Thank you for your reply. What if you have a column with multiple works like "complete status"? I tried to use a space but it errors out on the flow.
Thank you.
I am stuck at the last step where are you doing .d.status. It throws an error. Says status doesn't exist, where I can see it with previous data in the raw output. If I see the raw output - body, d, results then each version with attributes. One thing though, for URI, I don't see versions(number). Like yours mine is not pointing to any number, URI just like versions(). I see all 5 histories with current version data, wonder if it is related to the version uri. Any idea where I am doing wrong.
never mind, a typo error broke it. All good
Good one!
Can you add code snippets to the description text above?
I hope you are looking for below api call code, but I would suggest to create it dynamically as your step name could be different.
I explained it at the 7:45 mark, how to build the string.
_api/web/lists/getByTitle('Project List')/items(@{triggerOutputs()?['body/ID']})/versions(@{outputs('Get_changes_for_an_item_or_a_file_(properties_only)')?['body/SinceVersionId']})
@@m365techhelp Your video helped me greatly. Thank you.
That's pretty cool. HOWEVER, I'm looking for changes in "Content Type" and there is no "Has Column Changed: Content Type" :(
You miss the most important step how did you get the API code and where
The api is of sharepoint rest end point.
If you are working in SharePoint is nothing new