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 ?
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 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.
Hey @Lernen Tech, I love this video. If I credited you with the original flow, would you mind if I made a medium article about a flow that I built from this? I converted your flow into a flow that follows the principle of single responsibility instead of the nested functions. Its about 3x longer, but easier to follow and more modular.
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?
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. 😃
For the 2. task can be done by setting a Trigger Condition for your flow. For example, a flow only runs if the status is pending: @equals(triggerOutputs()?['body/{ModerationStatus}'],'Pending') The 1. task need a manual flow or a scheduled low with some logic.
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?
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 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?
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! 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.
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! 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?
@@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 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.
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
:)
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 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.
Hey @Lernen Tech, I love this video. If I credited you with the original flow, would you mind if I made a medium article about a flow that I built from this? I converted your flow into a flow that follows the principle of single responsibility instead of the nested functions. Its about 3x longer, but easier to follow and more modular.
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?
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. 😃
For the 2. task can be done by setting a Trigger Condition for your flow. For example, a flow only runs if the status is pending: @equals(triggerOutputs()?['body/{ModerationStatus}'],'Pending')
The 1. task need a manual flow or a scheduled low with some logic.
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?
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 very much. This video is definitely helpful. Is that possible to to retrieve specify columns and trigger just specific date column only?
Great video👍, thanks a stack
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?
The step for select 3 gives an "invalid expression". Any idea of why this would be?
Very helpful video
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!
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
_ in list name gets converted into _x005f_ and space in list name gets converted into _x0020_
-> replace(replace(item(),'_','_x005f_'),' ','_x0020_')
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.
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! 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.
Hello. is it possible to share the table formatting code?
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 :)
@12:00 sounds like birds in costa rica 🙂
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.