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? kzbin.info/www/bejne/noHSdXeuZqyepKM Hope thats what you are looking for - but if not - please let me know!

@Richie1902 Thankyou. I'll take a look at it later. 🙂

Hi Kristen, yes this would be possible - you would need to grab data from both columns and get it into a format that you can add to an array, then filter that array to just have the unique people per record. Would be a little complicated but yes it is possible to do - I'll aim to create something to show you how to achieve this - but it will take me a day or two to get the time for the tutorial - hope this helps!

@@Richie1902 thank you for replying! i am looking forward to your tutorial. :)

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'),'&lt;','<'),'&gt;','>'),'&amp;','&'),'&#39;','"'),'&quot;','"')

hi - with SharePoint as my data source if I have contribute access to a record I can edit all the columns for that record. There is no granular locking down of specific columns. You could however block quick edit and force the sharepoint form to be a powerapp, then in your power app show hide fields, adjust display mode properties based on the user or item status to achieve what you are looking for. Another option would be to break your lists down so there is a parent item and child items - then allow people to edit the items they have access to.. like a relational database. Hope this helps.

Awesome! Thanks for the feedback - glad it helped you!

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?

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 there - in your odata filter for Get Items you will want to add in something like myemailcolumnname ne Null so you only pull items where there is a value for email OR you could return all items and then use a condition so that if myemailcolumnname is Null send the task reminder to someone else like an admin, but if there is value in this field to send to that person instead. I'll try to put a clip up to show how to do this.

Hi - you can use the excel connector for sure - but it does require more effort and in my personal experience just isnt as good to create files quickly. documentation - learn.microsoft.com/en-us/connectors/excelonlinebusiness/ You can create a table or worksheet - but need a file to call to work within.. creating a csv that you can then open in excel / save as excel is (to me) a super pragmatic and easier path for many makers. Hope this helps!

Hi Ruby - so you need to filter your list data and use ge for greater than or equal to and le for less than or equal to filters. in Power Automate I would set up a scheduled workflow to run daily and then use the action get future time and configure that for 7 days, then I would use an expression or substring to set that value to a utc format just on date eg 2024-12-25 then repeat and do the future date for 14 days. So then you would have 2 dates 7 days and 14 days from now. called 'My7Days' and 'My14Days' Then in your datasource if we had a column called duedate. You could then run a parallel branch one to find the 7 days items and one to find the 14 days items. the filter would like like duedate le 'My7Days' I'll see if I can get time to show this in a tutorial to show how to do this for you. Hope this helps!

@@Richie1902wow i will be waiting for that tutorial. I tried days ago to make my flow but i received infinite loops of email after testing.

Hi Feng - if you expand the send an email v2 action to see the advanced settings - you can see the CC part of the email you can populate. In terms of selecting who to cc - you can hard code that, select emails from other people columns in the list item or look up people to email and place them into a string variable separated with a ';' to allow the emails to work. I'll extend this current tutorial to show how you could approach all 3 of those scenarios

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..

Hi Rasaq - sure thing - I can put out a clip for this to help you - but my approach would be to create a string variable, then use the action 'append to string variable' and look up anyone who needs to be notified into this message adding their email followed by a ; I'll aim for a clip on this in the next day or so.

Hi @StephanieSeattle - are you wanting to show that fields history in your email correspondence? Im going to assume yes! Will work on that for you - cheers for the request!

Hi @StephanieSeattle - here is the tutorial - kzbin.info/www/bejne/pJjbYZ-ubsqUjJY took me a bit to clear my schedule to create it - but I hope it helps!

Hi Rebecca - for a canvas app I still use alot of bespoke onStart actions to set my branding variables. I'm watching the modern themes development closely - but its not quite there yet in terms of being customizable enough that I can match any clients primary/secondary etc colors - modern theming will take the primary color and present a theme back that works for accessibility vs what a client always wants.. To get around that - I'm still using custom themes via onStart. Hoping it will change this year.. will see.

@@Richie1902 I see option to create modern theme. Haven't tried it yet

@@rebeccaj138 - nice - I've found if I create a light colored theme light a lime green. it all looks good, but then if I add a modern button to this app - the button is a much darker green - keeps it accessible.. but doesnt 'look' the way I want it to in a canvas app.. so im hoping for some future override options so I can keep clients happy vs pushing them to a 'this is the only option when using a modern canvas app' approach.. Best of luck with your app building!

hi there - you'll want to still create a scheduled daily workflow and use the action get past date and use 7 days as the date you want. Then ensure that this date value has a structure of 2024-05-21 for example - you can use UTC then the text action to substring the utc to just the date, then use get items and apply a filter where datedue eq 'your date value' Then apply to each and send your email. I hope that makes sense - if you want me to spin up an example of how to do that I can - just let me know!

Hi - please can you let me know if you are seeing any errors in the workflow runs? or if the workflow just isnt finding the correct items? or something else? If you let me know as much as you can - I'll be able to give you some help. Thanks!

@@Richie1902 I have found no errors.

Hi Taylor - yep - when you use the get Items action in Power Automate - you can toggle the odata filter to pull back whatever data you need - so if you have specific values you need to pull back thats where you would do it. So due date eq today and status eq open type thing - then you only get the data you need. If you need to pull different status types back - you but only run the notification on a particular status you could either use the data operation of Filter to reduce the items down to just what you want OR you could use Apply to Each and have a condition within the apply to each step - so if a value eq the value you want then do something. Filter is a bit easier/efficient Let me know if this helps!

Hi Kirsten - in the o365 get users action in Power automate there is 'Given Name' which is generally your first name.. but depends if your IT have populated it. On a sharepoint person column you really only have display name which is your first and last name. So you could use an apply to each email found and get user profile from the o365 users action to achieve this.. Hope this helps - just let me know if you'd like a walk through clip on doing this.

Thanks Richard. I’m actually using a SQL table to get my data. I’ve used your flow and it works, but as soon as I use the ‘Forename’ from my SQL table in my email, it’s adds another ‘Apply to each’ step in 😕

@@KirstenChinnock - is the Forename column in the same row/table as the item you are running the check on to get the items? So you will have a list items, then an an apply to each item. Can you put a compose into the apply to each action where you are getting the record and use an expression maybe to show the forename? If you wanted to send a screen shot of how you have the actions configured I might be able to help more [email protected] Cheers

@@Richie1902 thank you so much for the reply, I will take a look and see if I can work it out. I'll drop you an email if not, thanks again! :)

@@KirstenChinnock - new tutorial to show how I tackled this is here - kzbin.info/www/bejne/eJywpq1prrSBo6c enjoy!

Hi Rebecca - can you look at the flow run with the error and see the format that the date has come through as? Also - can you let me know if the sharepoint column you are using is a date only or a date + time type? Happy for you to send screen shots of what you are seeing / your workflow to [email protected]

@@Richie1902 thanks Richard, I ended up figuring it out by watching a different tutorial. One detail which I don’t believe you mention is if the column name has spaces on your SP site, you have to remove these as SP does not read spaces. That was my issue! So simple! But thank you as your video helped enormously 👍🏻😊

sure is - just change the filter to get anything that is overdue - so duedate lt today.. lt less than gt greater than - wanna go with due date less than today I think. Good luck!

Hi Christian - I did this demo quite a while back and for a consultancy where I'm no longer based.. so I cant get you the original :) but I could whack together a replica with a similar structure - pretty sure the top section is just a table with the active content controls in place, then a 2 column table with the relevant controls in that - if thats ok with you - send me you email to [email protected]

Thanks Richard I sent you message

Hi Remy - ooh wow I put this out 4 years ago, when I was at a different consultancy - so I'll have to rewatch it again and replicate. Are you trying to do the same as you see in the clip? or something different? If different let me know your goal and I'll try to help as best I can! Cheers

Hi there - if the workflow isnt returning any values - I would take a look at workflow run and expand the get items action and check the date that is being looked for and any other values in the odata query - then check your data source and do a comparison. If you think something should be getting returned we can look at your odata query and validate it then adjust as needed.. Let me know how you are getting on?

@@Richie1902 Thank you so much for the guidance. I realized the flow was not returning values because I set it up on the Document library. I created a new library and applied the flow there, and it ran fine. Thanks for sharing valuable content that broadens our knowledge about workflows and power automation.

@@anamahmed2765 - awesome!