Wow! You posted this at literally the perfect time. I have been working on trying to figure out something like this all week and almost gave up today. Thank you!
Thanks April, this is exactly what I was looking for! Something I found. I copied your code for the HTTP expression for Send an HTTP Request to Sharepoint, but then I replaced the version with the SinceVersionID dynamic value. What I caught was that your code referenced SinceVersionID and the dynamic value referenced SinceVersionLabel. The Flow kept failing at that step, but once I pasted your code in everything worked. Thank you so much for this video!
@@AprilDunnam Thank you for the video April. This is super helpful. I too had the same issue but was able to resolve by copying your code from the description.
A year later this is super helpful! Standard notification rules don't apply to columns with multiple text, so this video is the life saver, thanks a million!
Excellent as always. Clear, well paced, instruction on using some of the intermediate functions of powerautomate. Even a beginner can follow April's logic and actions to find a solution for themselves.
Hi April, first of all also from me THANK YOU, as you are the only person I have found (and I have looked long and hard for this) who has put this in understandable terms. There are many comments here that reference errors that people ran into as well as mentions that people found was around this. Since it took me quite a while to figure this out I thought I'd post the solution (and maybe you could incorporate it into an updated version of your video?). The error is caused by the part of the URI after "versions". I tried following along your steps in the video and tried everything I could think of (even using it as an expression etc) - without success. I also tried copying your code and replacing the parts in the brackets with the items that you show in the video, again without success. Then I noticed that whenever I used the dynamic content buttons the result looked different from the results you show in your video. It didn't say "body/Since Version...", rather just "Since Version ...". So I decided to again copy your code, but this time I just altered the SharePoint list name and the ID (via Dynamic Content). I just left the rest of the code untouched. And voila, it showed up just as it does in the video and worked perfectly! Again, I don't understand why this is so, but thought I might save other users some hassle :-)
Hi There! Amazing Video!! I wanted to know if the Condition control can be modified to only send an email when a status change to a specific item for example when status change from Pending to process , but not send an email when is changed from processed to closed?
Oh my gosh you are heaven sent! I’ve watched too many videos attempting provide the results you just gave me, so THANK YOU 🙌. I do have a follow up question…If I wanted a different email with different recipients based on the status to get sent, how do you build that condition? Ex: If status=Recieved, email these people or if status=approved the email these people instead? Thank you for what you do!
This video really helps, although you might get an error. I solve it! Just like others mentioned, I get an error on step "Send an HTTP request to SharePoint". I notice that in video 9:02, the content of your URL ends with "versions(2048)", not versions(4.0). I check the raw outputs of step "Get changes for an item or a file" and found the number 2048 is more likely from "SinceVersionId". Then I check my dynamic content on step "Send an HTTP request to SharePoint", and it shows "body/SinceVersionLabel". I modify it to "body/SinceVersionID", then this step passed successfully. After this step passed, the "Compose" step failed, but now I know how to find the error, just go to check the raw output of your previous steps, you may find some column names different from what you think. e.g. ['d']['a_Status'] failed, but changed it to['d']['a_x005fStatus'] passed.
Thanks for the detailed explanation! Is there a way to check if a new version of a file within the document library has been uploaded and trigger an email based of that event?
Great video. Thank you Professor. Helped me solve a business problem. Wanted to share a tip, in my eagerness to avoid writing a formatdate expression. Used "convert time zone" tool for "Date Modified" and keep source and destination time zone the same, then I simply selected the way I wanted the date to look like in format string.
Thank you! this is what I want. But I met a problem with the error msg "Input string was not in a correct format. clientRequestId: 49da171a-570e-4684-899b-739762eaa773" , i type the code according on the viedo but cannot work...
This is really awesome. I was tasked with this and had no idea how to capture the changes. There were a few other articles out there but had SO many more steps- this is streamlined to do what it needs to without having the flow be too many steps. Brilliant ! Thank You for Sharing this
Thank you, April! This is awesome! I have a question, how do you get column changes to multiple columns and list those changes in the email? Thanks again!
April, many thanks for this extremely useful and brilliantly explained video. I have tried this and got it working so you have a new subscriber and I look forward to watching more of your videos...Ken
Great help thank you very much. BTW, is it possible if the status is "WIP" to send an email to one person but if the status is "Done" to someone else? I've tried but it hasn't worked for me. (Send email to different people according to the status) Thank you
Hi April! Thank you for this. How can I get the "Current Status" from the HTTP Request. I want to make a condition, that I only want to "send an e-mail" if the Current status = X
This video is so helpful. You showed adding previous output of one field. I want to add previous output of 4 fields. How do I do that? I am new to sharepoint, so its bit confusing what more steps to add
This was so clear and easy to follow. Any times on how I could call back in my new table what column was changed, I know you can call back if it’s true or false but I wanted to name the column that was modified
Amazing Info! I was trying to update a "Previous Owner" column with the "Current Owner" of the previous version. It finally worked by checking that the "Current Owner" on the previous version was not Empty (There is a custom check condition for that), and then using the data from Current Owner --> LookupValue like this: body('Send_an_HTTP_request_to_SharePoint')['d']['CurrentOwner']['LookupValue']
Great help thank you very much. BTW, is it possible if the status is "WIP" to send an email to one person but if the status is "Done" to someone else? I've tried but it hasn't worked for me. (Send email to different people according to the status) Thank you
Hey April, thanks for this super useful guide in the first place! Is there a way to achieve this with Dataverse since there is no "Get changes" action as in Sharepoint? I'm desperate to find a way because I want to notify some employees when a specific column gets modified (Choice column changes from "To Do" to "Done"). Thank you!
that is impressive, just quick question on the issue i am facing. i have different internal column name and display name in the share point list. when i use "Send an http request to sharepoint" it give me a different name than the internal name. did you face this issue before?
excellent explanation specially for a beginner as myself. i am building a complex flow with several status changes that trigger a certain action/teams approval flow depending on the status that the column status has. I have a question: instead of sending an email could i add another condition to compare if the output of the status is a certain status to trigger another action? Thank you.
Great video April...love you videos...they are very informative and I have learnt a lot!. Would it be also possible to attach the document associated with the library change to a list item in the same site?
This is amazing! I was wondering if it is possible to see the change history like we see in the SPO list History. I am not sure how to dynamically create an email that will show which columns has changed with old values and new values.
This is so good. I was able to get changes specific to one column. What if I want previous changes of 4 columns to be mentioned in the email? Am able to get current changes but I want previous changes of all the 4 fields. I don't know what other step to add. I am new to SharePoint.
Hi April - you are a great orator, and I appreciate your post. Question? I have followed the steps you've outlined in your video to retrieve the previous value, but I get an "Input string was not in a correct format" error in the Send an HTTP request to SharePoint section. I've reformatted and reran several time with no success. The output for this section defaults to "status code" 400? I put _api/web/lists/getByTitle('List Name')/items(ID - from the Get changes for an item or file (properties only)/versions(Since Version Number - from the Get changes for an item or a file (properties only). Not sure why it wont work?
I exactly got the same issue, instead inserting "Since Version Number" copy paste this outputs('Get_changes_for_an_item_or_a_file_(properties_only)')?['body/SinceVersionId']. it worked for me
@@sanghamithra5651 - Thanks, I was following your input after getting error at HTTp request step, I am still getting error - "The expression "web/lists/getByTitle('Test List')/items(20)/versions(body/SinceVersionID)" is not valid. clientRequestId: ff8f7ac8-cb14-42ef-a8f3-a1d3142ae68c serviceRequestId: 9efc87a0-d0e0-1000-f5e5-89b5f7ced28b" Any suggestion to fix this?
For anything else at 6:37, just paste this code which is in description. {outputs('Get_changes_for_an_item_or_a_file_(properties_only)')?['body/SinceVersionId']} She's not just pressing on since version, she using SinceVersionId which is not SinceVersionNumber.
Hi I want to ask you something about my sharepoint list. There is a calculated field (obtained by subtracting 2 other fields). I was wondering if it is possible to check the value of this calculated field with powerapps ? When this value differs from 0 another field (called status field) must change its value. Thx in advance and your posts are a very added value for me.
Hello April, video was so helpful, however, been trying to get the version history from my sharepoint list into a powerapp so that my users can view the version history without opening the list item. Is there anyway that I can get ALL changes in a particular version (my list item has at least 50 fields)
Hi April, love your Videos!! have you tried doing this for lookup columns like Person/or group column? as fetching the current status from the dynamic content tool bar is not possible. please let me know if you have a solution. kind regards
This vidéo is excellent. But How can we do when we don't know what column has changed. I would like to inform by email only columns wich has been modified.
Thank you for posting this, I was losing faith that this would work. I must say I appreciate your videos you not only show the functionality, but explain where things are coming from. Thanks! I have a slightly different case, I am looking for a date change in my list and I am getting an error saying "Input String was not in correct format" at the "Setting Up the HTTP Action" step. Does this only work with Strings? How can I pass a date to get this to work for me?
I got this to work by copying the api code directly from the description only changing my list name. I also ran into a snag on the body expression you need to copy the name of the column as it gets outputted by the http call I had Target Implementation Date and had to copy Target_x005f_x0020_x005f_Implementation_x005f_x002 in order for it to work.
You are so thorough with your tutorials, its so easy to not only follow along but understand whats being executed! Thank you! I thought this video might lead me on the right path, I'm building a flow that links 2 different sharepoint lists together, trigger is "When an item or a file is modified" trigger conditions set for when Progress column=Completed.. I want to get the item in list 2 that has the same unique identifier as list 1 and append list 1 fields to existing fields in list 2 without losing data already in those fields that I'm updating. Do you have a video on that? If not can you respond here or can you assist via email? Thank you April!!!
Thank you for this. I have run into an issue with the getByTitle it doesn't like the name i put in where do you find the correct name please for this part? Thank you
Two questions 1: If we want to send a true/false value back to power apps would use the “Respond in Power Apps” node instead of the “Send and Email” node. 2: for every SharePoint column I would want to return to power Apps would I need to create Condition node and a compose node. I have about 20 columns I need to check.
Thank you April. This is the only video i was abke to get on UA-cam on what i exactly needed. However I did everything you have mentioned. The URI string did not work. When I used ID and Since Version Number the flow was keep failing stating input is in incorrect format. I tried converting both ID & Since Veraion Number to integer using int and flow worked but it doesnt actually pulling the data. when you inspect HTTP, it says GetbyID: Null. I tried everything i could and it didnt work. Since this is not resolved the compose action keep failing. I used [`d`][`Notes`] and notes was my field i wanted. It says the property not found although i can see in the inspect window. Do you think you can help?
In fact thaks April. It worked. I read some other replies and saw Craig had similar issue. I also copied and pasted your code exactly and it work. Thats was awesome. Thank you.
Great tutorial, thanks! I'm trying to follow along but get a failed action Action 'Send_an_HTTP_request_to_SharePoint' failed -> Input string was not in a correct format. Microsoft.SharePoint.Client.InvalidClientQueryException. I do get the correct Uri: _api/web/lists/getByTitle('My sharepoint list')/items(140)/versions(3.0), but then in the Outputs it says Input string was not in a correct format. :( Hope you have a tip as to what I'm doing wrong. Thanks!
This is wonderful - unless your company has locked down the HTTP request because of DLP... then you are toast if you happen to need the previous value in your flow :(
Aren't they released what changed before and after or is it still in development? I saw user voice votes for this change just to make to see what changed much more easier.
Thanks April. I am trying to identify which columns have changed and send an email. I have 20 columns, and if one changes, the mail needs to show just that one with the prvios value. I have been able to do the flow that mails all the columns. any idea? or can you point me in the right direction. thanks a mil again
Hi April, Thanks for the video but when I tried to copy exact same steps as you, it threw me an error message at Send an HTTP request to SharePoint step "Input string was not in a correct format", even though I added the ID and Since version details in the correct order with correct list name in place. How ever, when I checked the failed flow, in that ouput, it says bad request but I can see the item id and version number is getting correct.
Hi April, excellent! However, since my column field is a lookup with multiple values, it is not working for me, error message says "Input string was not in a correct format" you have any workaround for this?
Hi , Your videos are amazing. I have learned a lot from your videos. Can you make a video where you can show like for example I have a list where there are different status of project . Now, when the first status selected when entering a new item in list the date column should show current date and now whenever that status is changed the date column should show the current date and unless the status is not changed it should keep showing the date when that status was created or selected . The date should only change when status is changed . How can we do this using power automate workflow . Please make a video of this step by step as I am new to Sharepoint.
This helped me out tremendously. The only issue i'm having is its working for all my fields except the name column(which is a people picker) when run it shows a whole bunch of meta data text and then the persons email address and any columns that allows multiple inputs. How can the workflow formula be adapted to capture the previous name in a people picker field?
April is it possible to get an example of how to use this in a canvas power app. I have a small task list which I need the people to enter the latest date and percent complete. I know I can use your power automate. It would be great if your can show how we can do this in power app. Then in the other screen show what items have changed since
In the Expression for SharePoint HTTP Action URI Property "Lists" doesn't work for a document library. I am working off a Teams channel, which is a document library - how and where would I change the code?
Is there a way to see what controls in power apps have changed values? I want to change a border/fill color if someone modify a question in an already submitted record.
Hi April, is it possible to update a Column Name when a new document (excel, word etc.) is added to a folder (not updating a SharePoint List item column), for e.g. when a new Excel file is added to a documents folder then the Column Name gets updated. Thank you!!
Hi so, I'm working with an on Premise SP and have no access When file or item is modified. But instead use When Existing Item is modified and have no access to TriggerWindow dynamic content. How would I find a way around this?
Hello! I am trying these steps to bring in the changes for a column and I am getting a format error when bringing in the dynamic value for "SinceVersionLabel" in the uri.., specifically I have... _api/web/lists/getbytitle('TEST Onboarding')/items(@{triggerOutputs()?['body/ID']})/versions(@{outputs('Get_changes_for_an_item_or_a_file_(properties_only)')?['body/SinceVersionLabel']}) and it is giving me an error: " Input string was not in a correct format." Do you know why it would be flagging for a format issue?
Great video, but I am looking for the reverse process.. If the manager approves in email, Status column in list should change from 'pending' to 'approved' (no changes in other columns). Please help!
Sounds like you need to make your share point list an approval list (in list settings) and run an approval flow. It will send run the approval through the power automate approval center and update the list item when it gets approved.
This is exactly what I need, however I get an error on Get Changes (abbreviated the error below): "error": "code": 502, "message": "BadGateway "innerError": "Index was out of range. Must be non-negative and less than the size of the collection". This particular list has versioning turned on - but also has Content Approval turned on. I suspect this is the cause of this error. Are you able to confirm? Is there a work around?
I've found that it is not only that Content Approval is turned on - but also Draft security was set to only allow the author and the approvers to see the item. The account that was running the flow needed to be added as an approver. Hopefully this helps someone else 🙂
Please help! I have watched all your videos and still can't get my flow to operate properly since I added the Send an HTTP request to SharePoint. I keep getting an error and can't figure out why it isn't working. 😰
When I get to the "If yes" part and instead of sending an email I tried to update another column, "Assigned Date" using a Sharepoint Update Item action I get an error saying Title is missing. I used Title from the item was modified... If I take that out and just send an email it works fine.. Any idea what i'm doing wrong?
Question: If I've never successfully configured and ran a flow with a "Get changes for an item or file" before, how am I supposed to review the run history to view the "since version number"?
So, I created a flow with the steps "when an item is created or modified" and "get changes for an item or file (properties only)", so that I could successfully run a test to get the "since version number". However, now that I've completed the rest of the steps you outlined, I get a failed test run with an error on "send an HTTP request to SharePoint". It indicates the version (5.0) is not valid. How can I fix this? Thanks.
Thanks April. I tested on a Document Sets library but I got this error message "The query cannot be completed because the number of lookup columns it contains exceeds the lookup column threshold". So I tried to use a view with less columns but I can't see changing status of loockup columns that are inside the view.
If someone is trying to convert ONE item or get ONE item changes do the following: After "When an item or a file is modified", "Get Changes", "Send an HTTP": Create initialize variable. Set type to Array and in Value just input body of Get items with []. For example.: [@{body('Send_an_HTTP_request_to_SharePoint')}] Now you have an array. Call Select action and From set to your variable. In MAP select for example "TEST" and in MAP value set item()['d']. Now you can map it, create html table, css, and sent it ;)
If you have having problems with this with the HTTP Request make sure you put in this code since the dynamic pulls the label instead of the ID @{body('Get_changes_for_an_item_or_a_file_(properties_only)')?['SinceVersionId']}
Hello all, I've been following the guide in the video step by step but im having a problem: The uri in the "Send an HTTP request to SharePoint" is not working in my case, although i've changed the version section in the uri to "int(outputs('Get_changes_for_an_item_or_a_file_(properties_only)')?['body/SinceVersionLabel'])" and it worked but the problem is im have an empty response as follow: { "d": { "GetById": null } }
I followed each steps which are showing in the video and all looks good. When i run the flow i get this error : Error Action 'Send_an_HTTP_request_to_SharePoint' failed / Error Details :Input string was not in a correct format. Can you please help ?
If anyone else is running in an "invalid client query exception -> Input string was not in a correct format". I could resolve the issue by passing in the value 'outputs('Änderungen_für_ein_Element_oder_eine_Datei_abrufen_(nur_Eigenschaften)_2')?['body/SinceVersionId']' as a function as parameter for the 'versions' input. Since Version Number uses the SinceVersionLabel property, which is then changed to SinceVersionId. So the whole uri looks like this: _api/web/lists/getByTitle('OM Ticket System Liste')/items(@{triggerOutputs()?['body/ID']})/versions(@{outputs('Änderungen_für_ein_Element_oder_eine_Datei_abrufen_(nur_Eigenschaften)_2')?['body/SinceVersionId']}) I hope this helps anyone with the same issue.
Or you can just use the "alert" feature built into SharePoint list and it will send you and email of all the things that changed. 1000x easier than doing all this
Not sure what i am doing incorrect. But i keep getting error eventhough i used same as you mentioned . _api/web/lists/getByTitle('TEST_03_09_2023')/items(ID)/versions(Since Version)
I am able to follow the steps and get http error, Action 'Send_an_HTTP_request_to_SharePoint' failed (Details :- The expression "web/lists/getByTitle('DC Resource Demand Management - T-Mobile')/items(20)/versions(outputs(6.0)" is not valid. clientRequestId: 834ae097-9adc-48a5-a8e3-efba80268fed serviceRequestId: 864d88a0-c0b9-1000-ee4f-40dffd0bd536) Any suggestion on how to fix this?
![[UA] NAVI vs MOUZ | BO5 | IEM Rio 2024](http://i.ytimg.com/vi/CMBYk0cbGoA/mqdefault.jpg)
Wow! You posted this at literally the perfect time. I have been working on trying to figure out something like this all week and almost gave up today. Thank you!
Sweet - glad I had good timing 😀
Thanks April, this is exactly what I was looking for!
Something I found. I copied your code for the HTTP expression for Send an HTTP Request to Sharepoint, but then I replaced the version with the SinceVersionID dynamic value. What I caught was that your code referenced SinceVersionID and the dynamic value referenced SinceVersionLabel. The Flow kept failing at that step, but once I pasted your code in everything worked.
Thank you so much for this video!
You're welcome Craig - glad it's what you were looking for!
@@AprilDunnam Thank you for the video April. This is super helpful. I too had the same issue but was able to resolve by copying your code from the description.
A year later this is super helpful! Standard notification rules don't apply to columns with multiple text, so this video is the life saver, thanks a million!
Seriously thank you so much for taking the time to publish something like this, it is greatly appreciated.
Unbelievably helpful. I'm in awe of the way you present these so clearly and succinctly. Thank you 🙏🏻
Excellent as always. Clear, well paced, instruction on using some of the intermediate functions of powerautomate. Even a beginner can follow April's logic and actions to find a solution for themselves.
Thank you! 🙂
Hi April, first of all also from me THANK YOU, as you are the only person I have found (and I have looked long and hard for this) who has put this in understandable terms. There are many comments here that reference errors that people ran into as well as mentions that people found was around this. Since it took me quite a while to figure this out I thought I'd post the solution (and maybe you could incorporate it into an updated version of your video?).
The error is caused by the part of the URI after "versions". I tried following along your steps in the video and tried everything I could think of (even using it as an expression etc) - without success. I also tried copying your code and replacing the parts in the brackets with the items that you show in the video, again without success. Then I noticed that whenever I used the dynamic content buttons the result looked different from the results you show in your video. It didn't say "body/Since Version...", rather just "Since Version ...". So I decided to again copy your code, but this time I just altered the SharePoint list name and the ID (via Dynamic Content). I just left the rest of the code untouched. And voila, it showed up just as it does in the video and worked perfectly!
Again, I don't understand why this is so, but thought I might save other users some hassle :-)
Thank you. This just saved me a bunch of troubleshooting
Omg!! You’re amazing! I have been looking for this tutorial how to get the previous values. Thank you so much!! This is a big help! Thank you again!
You're so welcome! Glad it was helpful!
Hi There! Amazing Video!! I wanted to know if the Condition control can be modified to only send an email when a status change to a specific item for example when status change from Pending to process , but not send an email when is changed from processed to closed?
Oh my gosh you are heaven sent! I’ve watched too many videos attempting provide the results you just gave me, so THANK YOU 🙌. I do have a follow up question…If I wanted a different email with different recipients based on the status to get sent, how do you build that condition? Ex: If status=Recieved, email these people or if status=approved the email these people instead? Thank you for what you do!
This video really helps, although you might get an error. I solve it! Just like others mentioned, I get an error on step "Send an HTTP request to SharePoint". I notice that in video 9:02, the content of your URL ends with "versions(2048)", not versions(4.0). I check the raw outputs of step "Get changes for an item or a file" and found the number 2048 is more likely from "SinceVersionId". Then I check my dynamic content on step "Send an HTTP request to SharePoint", and it shows "body/SinceVersionLabel". I modify it to "body/SinceVersionID", then this step passed successfully. After this step passed, the "Compose" step failed, but now I know how to find the error, just go to check the raw output of your previous steps, you may find some column names different from what you think. e.g. ['d']['a_Status'] failed, but changed it to['d']['a_x005fStatus'] passed.
You are amazing! Got same problems but with your explanation all fixed!!!
How did you modify it to be body/SinceVersionID?
Thanks for the detailed explanation! Is there a way to check if a new version of a file within the document library has been uploaded and trigger an email based of that event?
Great video. Thank you Professor. Helped me solve a business problem. Wanted to share a tip, in my eagerness to avoid writing a formatdate expression. Used "convert time zone" tool for "Date Modified" and keep source and destination time zone the same, then I simply selected the way I wanted the date to look like in format string.
Thank you! this is what I want. But I met a problem with the error msg "Input string was not in a correct format.
clientRequestId: 49da171a-570e-4684-899b-739762eaa773" , i type the code according on the viedo but cannot work...
This is really awesome. I was tasked with this and had no idea how to capture the changes. There were a few other articles out there but had SO many more steps- this is streamlined to do what it needs to without having the flow be too many steps. Brilliant ! Thank You for Sharing this
Much better/neater solution than having a 'Previous Status' field that was often suggested to compare to
For sure - very glad I don't have to do that work-around anymore!
Thank you, April! This is awesome! I have a question, how do you get column changes to multiple columns and list those changes in the email? Thanks again!
April, many thanks for this extremely useful and brilliantly explained video. I have tried this and got it working so you have a new subscriber and I look forward to watching more of your videos...Ken
Thank you for the sub!
Thanks a lot April for producing and posting this! Very helpful!!
Glad it was helpful!
Great help thank you very much. BTW, is it possible if the status is "WIP" to send an email to one person but if the status is "Done" to someone else? I've tried but it hasn't worked for me.
(Send email to different people according to the status)
Thank you
Hi April!
Thank you for this.
How can I get the "Current Status" from the HTTP Request.
I want to make a condition, that I only want to "send an e-mail" if the Current status = X
This video is so helpful. You showed adding previous output of one field. I want to add previous output of 4 fields. How do I do that? I am new to sharepoint, so its bit confusing what more steps to add
This was so clear and easy to follow. Any times on how I could call back in my new table what column was changed, I know you can call back if it’s true or false but I wanted to name the column that was modified
Hello April, Very fantastic video explaining complex concept in a simple way. You are Superwomen for PowerPlatform. Thanks a ton...!! 🙂🙂
Awe thanks so much!!
Amazing Info! I was trying to update a "Previous Owner" column with the "Current Owner" of the previous version. It finally worked by checking that the "Current Owner" on the previous version was not Empty (There is a custom check condition for that), and then using the data from Current Owner --> LookupValue like this: body('Send_an_HTTP_request_to_SharePoint')['d']['CurrentOwner']['LookupValue']
Thank you very much, I've been looking for this type of tutorial the whole day , this is exactly what I need . Thank you!! :)
Glad I could help!
Great help thank you very much. BTW, is it possible if the status is "WIP" to send an email to one person but if the status is "Done" to someone else? I've tried but it hasn't worked for me.
(Send email to different people according to the status)
Thank you
Hey April, thanks for this super useful guide in the first place!
Is there a way to achieve this with Dataverse since there is no "Get changes" action as in Sharepoint? I'm desperate to find a way because I want to notify some employees when a specific column gets modified (Choice column changes from "To Do" to "Done"). Thank you!
that is impressive, just quick question on the issue i am facing. i have different internal column name and display name in the share point list. when i use "Send an http request to sharepoint" it give me a different name than the internal name. did you face this issue before?
excellent explanation specially for a beginner as myself. i am building a complex flow with several status changes that trigger a certain action/teams approval flow depending on the status that the column status has. I have a question: instead of sending an email could i add another condition to compare if the output of the status is a certain status to trigger another action? Thank you.
Great video April...love you videos...they are very informative and I have learnt a lot!. Would it be also possible to attach the document associated with the library change to a list item in the same site?
This was wildly helpful. Thank you so much!
I'm so happy it's helpful!
Thanks so much for the clear instructions. This video helped me debug my workflow :)
I'm so glad this helped! :)
This is amazing! I was wondering if it is possible to see the change history like we see in the SPO list History. I am not sure how to dynamically create an email that will show which columns has changed with old values and new values.
This is so good. I was able to get changes specific to one column. What if I want previous changes of 4 columns to be mentioned in the email? Am able to get current changes but I want previous changes of all the 4 fields. I don't know what other step to add. I am new to SharePoint.
excellent video april. love your presentation. Any reason we need to hard code the List Name in 'Send Http' rather using the dynamic value?
Figured it out. Since the list title is not available for the context.
That's exactly it :)
Hi April - you are a great orator, and I appreciate your post. Question? I have followed the steps you've outlined in your video to retrieve the previous value, but I get an "Input string was not in a correct format" error in the Send an HTTP request to SharePoint section. I've reformatted and reran several time with no success. The output for this section defaults to "status code" 400? I put _api/web/lists/getByTitle('List Name')/items(ID - from the Get changes for an item or file (properties only)/versions(Since Version Number - from the Get changes for an item or a file (properties only). Not sure why it wont work?
I exactly got the same issue, instead inserting "Since Version Number" copy paste this outputs('Get_changes_for_an_item_or_a_file_(properties_only)')?['body/SinceVersionId']. it worked for me
@@sanghamithra5651 Thank you. This fixed it by pasting what you suggested as a function instead of picking it from dynamic content as April indicated.
@@sanghamithra5651 - Thanks, I was following your input after getting error at HTTp request step, I am still getting error - "The expression "web/lists/getByTitle('Test List')/items(20)/versions(body/SinceVersionID)" is not valid.
clientRequestId: ff8f7ac8-cb14-42ef-a8f3-a1d3142ae68c
serviceRequestId: 9efc87a0-d0e0-1000-f5e5-89b5f7ced28b"
Any suggestion to fix this?
For anything else at 6:37, just paste this code which is in description. {outputs('Get_changes_for_an_item_or_a_file_(properties_only)')?['body/SinceVersionId']}
She's not just pressing on since version, she using SinceVersionId which is not SinceVersionNumber.
thank you, it works now.
Hi I want to ask you something about my sharepoint list. There is a calculated field (obtained by subtracting 2 other fields).
I was wondering if it is possible to check the value of this calculated field with powerapps ?
When this value differs from 0 another field (called status field) must change its value.
Thx in advance and your posts are a very added value for me.
Hello April, video was so helpful, however, been trying to get the version history from my sharepoint list into a powerapp so that my users can view the version history without opening the list item. Is there anyway that I can get ALL changes in a particular version (my list item has at least 50 fields)
Hi April, love your Videos!! have you tried doing this for lookup columns like Person/or group column? as fetching the current status from the dynamic content tool bar is not possible. please let me know if you have a solution. kind regards
Hi Odoh, even I am struggling with this person/or group column lookup, did you find any solution, can you please share... thanx :)
This vidéo is excellent. But How can we do when we don't know what column has changed. I would like to inform by email only columns wich has been modified.
Thank you for posting this, I was losing faith that this would work. I must say I appreciate your videos you not only show the functionality, but explain where things are coming from. Thanks!
I have a slightly different case, I am looking for a date change in my list and I am getting an error saying "Input String was not in correct format" at the "Setting Up the HTTP Action" step. Does this only work with Strings? How can I pass a date to get this to work for me?
I got this to work by copying the api code directly from the description only changing my list name. I also ran into a snag on the body expression you need to copy the name of the column as it gets outputted by the http call I had Target Implementation Date and had to copy Target_x005f_x0020_x005f_Implementation_x005f_x002 in order for it to work.
I achieved this as followed your tutorial, a problem that the flow runs in loop without stopping even not new trigger happen. Appreciate your advice
I've been learning SO MUCH from your videos, April. You rock (and, as I can tell from your keyboard and guitars, both literally and figuratively)!
Wow, thank you! 🤘
Exactly what I needed, thank you so much.
Glad it helped!
Hi. Where did you get that Check Previous Status Json Block from???
You are so thorough with your tutorials, its so easy to not only follow along but understand whats being executed! Thank you! I thought this video might lead me on the right path, I'm building a flow that links 2 different sharepoint lists together, trigger is "When an item or a file is modified" trigger conditions set for when Progress column=Completed.. I want to get the item in list 2 that has the same unique identifier as list 1 and append list 1 fields to existing fields in list 2 without losing data already in those fields that I'm updating. Do you have a video on that? If not can you respond here or can you assist via email? Thank you April!!!
Thank you for this. I have run into an issue with the getByTitle it doesn't like the name i put in where do you find the correct name please for this part? Thank you
Two questions
1: If we want to send a true/false value back to power apps would use the “Respond in Power Apps” node instead of the “Send and Email” node.
2: for every SharePoint column I would want to return to power Apps would I need to create Condition node and a compose node. I have about 20 columns I need to check.
Thank you April. This is the only video i was abke to get on UA-cam on what i exactly needed. However I did everything you have mentioned. The URI string did not work. When I used ID and Since Version Number the flow was keep failing stating input is in incorrect format. I tried converting both ID & Since Veraion Number to integer using int and flow worked but it doesnt actually pulling the data. when you inspect HTTP, it says GetbyID: Null. I tried everything i could and it didnt work. Since this is not resolved the compose action keep failing. I used [`d`][`Notes`] and notes was my field i wanted. It says the property not found although i can see in the inspect window. Do you think you can help?
In fact thaks April. It worked. I read some other replies and saw Craig had similar issue. I also copied and pasted your code exactly and it work. Thats was awesome. Thank you.
Awesome - glad you got it working!
Great tutorial, thanks! I'm trying to follow along but get a failed action Action 'Send_an_HTTP_request_to_SharePoint' failed -> Input string was not in a correct format. Microsoft.SharePoint.Client.InvalidClientQueryException. I do get the correct Uri: _api/web/lists/getByTitle('My sharepoint list')/items(140)/versions(3.0), but then in the Outputs it says Input string was not in a correct format. :( Hope you have a tip as to what I'm doing wrong. Thanks!
did you get this working? i'm getting the same error
This is wonderful - unless your company has locked down the HTTP request because of DLP... then you are toast if you happen to need the previous value in your flow :(
Oh no, that's no fun :(
Aren't they released what changed before and after or is it still in development? I saw user voice votes for this change just to make to see what changed much more easier.
Thanks April. I am trying to identify which columns have changed and send an email. I have 20 columns, and if one changes, the mail needs to show just that one with the prvios value. I have been able to do the flow that mails all the columns. any idea? or can you point me in the right direction. thanks a mil again
Hi April,
Thanks for the video but when I tried to copy exact same steps as you, it threw me an error message at Send an HTTP request to SharePoint step "Input string was not in a correct format", even though I added the ID and Since version details in the correct order with correct list name in place.
How ever, when I checked the failed flow, in that ouput, it says bad request but I can see the item id and version number is getting correct.
Thank you, April. It's helpful.
Is any power automate AI builder video creation in pipeline. It would be great to have one.
Hi April, excellent! However, since my column field is a lookup with multiple values, it is not working for me, error message says "Input string was not in a correct format" you have any workaround for this?
Hi , Your videos are amazing. I have learned a lot from your videos. Can you make a video where you can show like for example I have a list where there are different status of project . Now, when the first status selected when entering a new item in list the date column should show current date and now whenever that status is changed the date column should show the current date and unless the status is not changed it should keep showing the date when that status was created or selected . The date should only change when status is changed . How can we do this using power automate workflow . Please make a video of this step by step as I am new to Sharepoint.
This helped me out tremendously. The only issue i'm having is its working for all my fields except the name column(which is a people picker) when run it shows a whole bunch of meta data text and then the persons email address and any columns that allows multiple inputs. How can the workflow formula be adapted to capture the previous name in a people picker field?
I was able to figure it out for the people picker field
Glad you were able to figure it out!
April is it possible to get an example of how to use this in a canvas power app. I have a small task list which I need the people to enter the latest date and percent complete. I know I can use your power automate. It would be great if your can show how we can do this in power app. Then in the other screen show what items have changed since
In the Expression for SharePoint HTTP Action URI Property "Lists" doesn't work for a document library. I am working off a Teams channel, which is a document library - how and where would I change the code?
This was excellent. Thank you so much.
You're very welcome!
Excellent Video, Thank you.
You are welcome!
Is there a way to see what controls in power apps have changed values? I want to change a border/fill color if someone modify a question in an already submitted record.
This is exactly what I want to know. Wonderful~!
Glad I could help!
Hi April, is it possible to update a Column Name when a new document (excel, word etc.) is added to a folder (not updating a SharePoint List item column), for e.g. when a new Excel file is added to a documents folder then the Column Name gets updated. Thank you!!
Hi so, I'm working with an on Premise SP and have no access When file or item is modified. But instead use When Existing Item is modified and have no access to TriggerWindow dynamic content. How would I find a way around this?
Hello! I am trying these steps to bring in the changes for a column and I am getting a format error when bringing in the dynamic value for "SinceVersionLabel" in the uri.., specifically I have... _api/web/lists/getbytitle('TEST Onboarding')/items(@{triggerOutputs()?['body/ID']})/versions(@{outputs('Get_changes_for_an_item_or_a_file_(properties_only)')?['body/SinceVersionLabel']}) and it is giving me an error: " Input string was not in a correct format." Do you know why it would be flagging for a format issue?
Really well presented, kudos!
Thank you kindly!
Great video, but I am looking for the reverse process..
If the manager approves in email, Status column in list should change from 'pending' to 'approved' (no changes in other columns). Please help!
Sounds like you need to make your share point list an approval list (in list settings) and run an approval flow. It will send run the approval through the power automate approval center and update the list item when it gets approved.
This is exactly what I need, however I get an error on Get Changes (abbreviated the error below):
"error": "code": 502,
"message": "BadGateway
"innerError": "Index was out of range. Must be non-negative and less than the size of the collection".
This particular list has versioning turned on - but also has Content Approval turned on. I suspect this is the cause of this error.
Are you able to confirm? Is there a work around?
I've found that it is not only that Content Approval is turned on - but also Draft security was set to only allow the author and the approvers to see the item. The account that was running the flow needed to be added as an approver.
Hopefully this helps someone else 🙂
Great Video! Need help.. I got error - Input string was not in a correct format'.
Please help! I have watched all your videos and still can't get my flow to operate properly since I added the Send an HTTP request to SharePoint. I keep getting an error and can't figure out why it isn't working. 😰
When I get to the "If yes" part and instead of sending an email I tried to update another column, "Assigned Date" using a Sharepoint Update Item action I get an error saying Title is missing. I used Title from the item was modified... If I take that out and just send an email it works fine.. Any idea what i'm doing wrong?
Very nice video 👍🏼
Thank you 👍
What about the other way, when received email with specific title, add item from email into SharePoint list?
Really good video
Thanks!
Question: If I've never successfully configured and ran a flow with a "Get changes for an item or file" before, how am I supposed to review the run history to view the "since version number"?
So, I created a flow with the steps "when an item is created or modified" and "get changes for an item or file (properties only)", so that I could successfully run a test to get the "since version number". However, now that I've completed the rest of the steps you outlined, I get a failed test run with an error on "send an HTTP request to SharePoint". It indicates the version (5.0) is not valid. How can I fix this? Thanks.
Great video! Saved my day!!
Glad it helped!
Hi April
In the compose action, I'm getting an error property doesn't exist
What if I what to use the "Has column changed" property to check if a content type changed? There is no option for it.
Thanks. Could you please help me with below error?
The expression "web/lists/getByTitle(‘Tech Portfolio’)/items(2)/versions(42.0)" is not valid.
The error isn't occurring if I exclude /versions() from URI
Thanks April
You're welcome!
Thanks April. I tested on a Document Sets library but I got this error message "The query cannot be completed because the number of lookup columns it contains exceeds the lookup column threshold". So I tried to use a view with less columns but I can't see changing status of loockup columns that are inside the view.
What does it do when you set it to the view? Does it throw an error?
thanks. huge help.
Glad it helped!
Awesome it is!
Thanks!
If someone is trying to convert ONE item or get ONE item changes do the following:
After "When an item or a file is modified", "Get Changes", "Send an HTTP":
Create initialize variable.
Set type to Array and in Value just input body of Get items with []. For example.:
[@{body('Send_an_HTTP_request_to_SharePoint')}]
Now you have an array.
Call Select action and From set to your variable.
In MAP select for example "TEST" and in MAP value set item()['d'].
Now you can map it, create html table, css, and sent it ;)
If you have having problems with this with the HTTP Request make sure you put in this code since the dynamic pulls the label instead of the ID @{body('Get_changes_for_an_item_or_a_file_(properties_only)')?['SinceVersionId']}
where exactly do i put this though 😅
Is there a way to do the same for a column in Dataverse?
Obrigado 👏👏👏👏👏👏
De nada!
Hello all,
I've been following the guide in the video step by step but im having a problem:
The uri in the "Send an HTTP request to SharePoint" is not working in my case, although i've changed the version section in the uri to "int(outputs('Get_changes_for_an_item_or_a_file_(properties_only)')?['body/SinceVersionLabel'])" and it worked but the problem is im have an empty response as follow:
{
"d": {
"GetById": null
}
}
actually it was a bug from the power automate :D
Glad you got it working!
I followed each steps which are showing in the video and all looks good. When i run the flow i get this error : Error
Action 'Send_an_HTTP_request_to_SharePoint' failed / Error Details :Input string was not in a correct format.
Can you please help ?
i got the flow run by using expression, thanks
Glad you got it working!
@@connect2faisal I'm having the same issue, what expression did you use please?
@@connect2faisal i'm getting the same issue... which expression are you using
Hi Faisal, can you help to share your expression ?
how do I update an already existing list item when a form is submitted?
Thank you
Welcome!
Thks 👍🌷🙋♂️
☺
Can someone please tell me how to show the result not in mail but in a column in the share point list as a column
If anyone else is running in an "invalid client query exception -> Input string was not in a correct format". I could resolve the issue by passing in the value 'outputs('Änderungen_für_ein_Element_oder_eine_Datei_abrufen_(nur_Eigenschaften)_2')?['body/SinceVersionId']' as a function as parameter for the 'versions' input. Since Version Number uses the SinceVersionLabel property, which is then changed to SinceVersionId.
So the whole uri looks like this: _api/web/lists/getByTitle('OM Ticket System Liste')/items(@{triggerOutputs()?['body/ID']})/versions(@{outputs('Änderungen_für_ein_Element_oder_eine_Datei_abrufen_(nur_Eigenschaften)_2')?['body/SinceVersionId']})
I hope this helps anyone with the same issue.
Or you can just use the "alert" feature built into SharePoint list and it will send you and email of all the things that changed. 1000x easier than doing all this
Well that alert feature is limited in scope so there is 100% still validity in this method depending on what you want to do with those alerts.
Not sure what i am doing incorrect. But i keep getting error eventhough i used same as you mentioned .
_api/web/lists/getByTitle('TEST_03_09_2023')/items(ID)/versions(Since Version)
I am able to follow the steps and get http error, Action 'Send_an_HTTP_request_to_SharePoint' failed (Details :- The expression "web/lists/getByTitle('DC Resource Demand Management - T-Mobile')/items(20)/versions(outputs(6.0)" is not valid.
clientRequestId: 834ae097-9adc-48a5-a8e3-efba80268fed
serviceRequestId: 864d88a0-c0b9-1000-ee4f-40dffd0bd536)
Any suggestion on how to fix this?