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 ?
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.
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.
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.
@@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.
GREAT VIDEO!!! I have a question for you. How can do what you do in your video BUT I have two stipulations. 1 - I want to send a CONSOLIDATED email. In your video, anytime a single item is changed at any time, an email would be sent. Example, if I made a mistake and changed something in error and went back to correct it, that is 2 emails. That gets a little cumbersome. 2. How can I do all of this but only when a certain column in not null. Example, things can happen prior to this person being assigned a project, but once a designer is assigned, now the emails can commence to be sent to the people it needs to be sent to? Thank you. Looking forward to seeing the update or knowing what to do. I even reached out to Reza and he suggested reaching out to forums. So I reached out to you. Maybe you can figure it out. You'll be the hero. 😃
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
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?
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?
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?
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?
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?
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!
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.
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
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.
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
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
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.
@@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
@@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 :)
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?
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 ?
i have not tetsed it properly so can't comment
@@LernenTech I used this approach in my application and it works well.
@@nimishanalinam great and thank you
:)
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.
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.
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.
@@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.
Oh OK, if you happened to find a solution to this issue, please share with us. Much appreciate it.
GREAT VIDEO!!! I have a question for you. How can do what you do in your video BUT I have two stipulations. 1 - I want to send a CONSOLIDATED email. In your video, anytime a single item is changed at any time, an email would be sent. Example, if I made a mistake and changed something in error and went back to correct it, that is 2 emails. That gets a little cumbersome. 2. How can I do all of this but only when a certain column in not null. Example, things can happen prior to this person being assigned a project, but once a designer is assigned, now the emails can commence to be sent to the people it needs to be sent to?
Thank you. Looking forward to seeing the update or knowing what to do. I even reached out to Reza and he suggested reaching out to forums. So I reached out to you. Maybe you can figure it out. You'll be the hero. 😃
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
use manual trigger for that
@@LernenTech Can you please teach and make a video for this topic?
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?
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?
for that there is extra step you have to perform by creating a repalce set for each column
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?
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?
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?
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!
for that you will have to write few extra step
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
The step for select 3 gives an "invalid expression". Any idea of why this would be?
Thank you very much. This video is definitely helpful. Is that possible to to retrieve specify columns and trigger just specific date column only?
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.
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
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.
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
Great video👍, thanks a stack
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
Very helpful video
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.
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 ?
you want automate it or manually?
@@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
@@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 :)
Hello. is it possible to share the table formatting code?
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?
Have you got the answer?
I am not clear on excel how we can get version history and make api call?
I really need this, please help me out.
@12:00 sounds like birds in costa rica 🙂