Hi from Seattle Rich! This was exactly what I needed - thank you! Super helpful step by step and appreciate all the detail on filtering out unnecessary items. You are a gem!
This is SUPER helpful for a project I'm working on. Quick question - there's a username and time stamp at the beginning of each comment. Is there any way to capture this information, as well?
Hiya - maybe you already fixed this? If not you could just expand the select action to pull in the columns you want - this would be created and created by. Let me know if this helps or if you need more help. Thanks!
Hi Rich, thanks for the video, its really helpful. Can you tell me why the comments I get when I run my flow have a lot of formatting code around it rather than just the comment? Test Comment 2 Test Comment 1
You need to clean the result from the previous step, add a compose with the following and add the new output to the email: Compose: replace(replace(replace(replace(replace(body('Create_HTML_table'),'<',''),'&','&'),''','"'),'"','"')
Would there be a way to send a single email with all of the comments included? My use case is emailing an update log which would contain the appended fields for all items that have been modified. This video was awesome! But now I have one email to read for each updated item. Much appreciated!
Hi - yes you can do this - you would just need to maybe put into an array or append to text and then put this into your email - let me know if you need more guidance?
Hi - yep this is possible - probably the best approach would be to get the version history of that item then for each version append each comment - using the http request to sharepoint that has the url of _api/web/Lists/getbytitle('yourlist')/items(yourID )/versions - this clip might help you? ruclips.net/video/hPoDDx1GknA/видео.html Hope thats what you are looking for - but if not - please let me know!
Hi - sure - I can extend this tutorial to show you the options here. Off the top of my head you may have to remove that version of the list item vs just the text in that value - but I'll check what options we have here and come back with a clip to assist
@@newabyuser - as close as I can get is to be able to remove a version - but this is still the full version of that item - so if any changes to that item occurred along with the multi line text column these would be removed. The only solution here i can think of would be to get the full version into an array / compose action in power automate. Delete that version then add a new version with all the other values except the data from the mutli line text column - version history would show the item history so it might be out of sync in terms of data needed to show for that item..
Hi from Seattle Rich! This was exactly what I needed - thank you! Super helpful step by step and appreciate all the detail on filtering out unnecessary items. You are a gem!
This is SUPER helpful for a project I'm working on. Quick question - there's a username and time stamp at the beginning of each comment. Is there any way to capture this information, as well?
Hiya - maybe you already fixed this? If not you could just expand the select action to pull in the columns you want - this would be created and created by.
Let me know if this helps or if you need more help. Thanks!
Hi Rich, thanks for the video, its really helpful. Can you tell me why the comments I get when I run my flow have a lot of formatting code around it rather than just the comment?
Test Comment 2
Test Comment 1
I found it. The multiple lines of text column needs to be in plain text rather than rich text.
You need to clean the result from the previous step, add a compose with the following and add the new output to the email: Compose: replace(replace(replace(replace(replace(body('Create_HTML_table'),'<',''),'&','&'),''','"'),'"','"')
Would there be a way to send a single email with all of the comments included? My use case is emailing an update log which would contain the appended fields for all items that have been modified. This video was awesome! But now I have one email to read for each updated item. Much appreciated!
Hi - yes you can do this - you would just need to maybe put into an array or append to text and then put this into your email - let me know if you need more guidance?
What if we want to get all the comments on a specific item, and not just comments related to a specific user?
Hi - yep this is possible - probably the best approach would be to get the version history of that item then for each version append each comment - using the http request to sharepoint that has the url of _api/web/Lists/getbytitle('yourlist')/items(yourID )/versions - this clip might help you?
ruclips.net/video/hPoDDx1GknA/видео.html
Hope thats what you are looking for - but if not - please let me know!
@Richie1902 Thankyou. I'll take a look at it later. 🙂
thanks for video but my question is how to delete the oldest comment appended with Power automate
Hi - sure - I can extend this tutorial to show you the options here. Off the top of my head you may have to remove that version of the list item vs just the text in that value - but I'll check what options we have here and come back with a clip to assist
It will delete the whole version, rather I want just to delete the older appended comment.
@Richie1902 any luck with delete?
@@newabyuser - as close as I can get is to be able to remove a version - but this is still the full version of that item - so if any changes to that item occurred along with the multi line text column these would be removed.
The only solution here i can think of would be to get the full version into an array / compose action in power automate. Delete that version then add a new version with all the other values except the data from the mutli line text column - version history would show the item history so it might be out of sync in terms of data needed to show for that item..