Power Automate Send Task Due Reminder Emails

[@anilkumar-ml2sl]

Can't imagine the amount the effort you put in to create such nice videos... Thank you🙏

[@RezaDorrani]

Thank you so much! I was in some way hoping this video would be of a lot of interest for folks. Hence, I went all out at it. Sadly, the initial response in terms of viewership is very low.

[@anilkumar-ml2sl]

@RezaDorrani I'm sure this will pick up.. this has really useful and practical content..

[@RezaDorrani]

@@anilkumar-ml2sl I hope so.

[@mluthi69]

As always, packed with way more than what the topic title promises - thank you Reza.

[@RezaDorrani]

Most welcome and very happy to hear the feedback

[@ajit382]

Dear Reza Bro, you are the right guider for low code platform, 👏👏👏🙏

[@RezaDorrani]

Glad to hear that

[@chitrakshichitrakshi-cf1bg]

Your videos make the concepts so much easier to understand. They’re incredibly insightful! I’m currently working on an application, and each time I plan my next steps, one of your videos covers exactly what I need. It’s been immensely helpful in simplifying the process-thank you!😊

[@RezaDorrani]

Great to hear this! Thanks so much for watching and liking the videos.

[@tbone536]

I can see how this would tie in nicely with your next video on bulk table updates, with a deep link to a screen in your app that is prefiltered to the logged in user's items only (so they can take bulk actions on their items). Spectacular as usual Reza!!!

[@RezaDorrani]

Love the idea! It would be an awesome scenario.

[@imran002ali]

Hi Reza, I don't have words to express, how good your contents are, appreciate your knowledge sharing, thank you!😊

[@RezaDorrani]

Wow, thank you so so much!

[@imran002ali]

@@RezaDorrani , you are welcome! Every Monday, look forward to your new video 😁

[@johanvanbussel2073]

I'm a big fan of your videos Reza! You inspired me to try power automate and I love it eversince, so now I still watch your videos to keep getting inspired :)

[@RezaDorrani]

Awesome! Thanks so much

[@dougydoe]

Great video again, well paced and very systematic to follow the concepts and understand. Thank your for staying consistent.

[@RezaDorrani]

Much appreciated!

[@cedartree816]

wow wow wow. Are you eaves dropping on my teams calls Reza???? I was quite literally just asked to do exactly this, just last week.I got the basics working no problem, but your union/union formula is going to be a life saver. Hadn't gotten that far yet and it's going to save much a ton of time. Fantastic video! Thanks again for all the great videos you produce.

[@RezaDorrani]

You are most welcome! I am on Teams on all day 😉

[@kausarjahan1868]

Such a well-explained video, Reza!! Loved how you made everything so simple and clear... Thank you for sharing this!

[@RezaDorrani]

Glad it was helpful! Thanks for watching

[@Gadgetuniverse888]

😊

[@spen2431]

Perfect timing. Thanks for sharing 💥💥

[@RezaDorrani]

Any time!

[@raslaankhan5146]

Shoutout to you, well not regarding this video. I used Coalesce function in one of my apps and it worked like a charm what I wanted to achieve. I learned it from you. Thank you Reza ❤

[@RezaDorrani]

Thanks for sharing

[@Gilgameshx]

Awesome Reza, you always brings very useful material, thank you for that.

[@RezaDorrani]

Most welcome!

[@eyoborelvis8224]

I almost can’t do without power automate.. thanks Reza🤓

[@RezaDorrani]

Absolutely Not :)

[@niu745]

This is God sent! Truly helped with my organization❤

[@RezaDorrani]

Glad it helped and thanks so much

[@niu745]

@@RezaDorrani i have a similar scenario for taking lunch order for members(outside org), where i save record from a "public" MS Form submission using Power Automate into a Sharepoint List. Member Head can submit for their group members and they can do multiple submission before a cut off date. I would take the latest submission using Power automate to generate the list of members in html table (for each group) and total number to send to the event organizer email. I tried to create a variable (using compose) to get latest entry of Member Head using "max()" expression in power automate. it seems like "max()" cant read the the DateTime field format of "yyyy-mm-ddThh:mm:ssZ" How can i get the latest submission Date Time? Thank you!

[@RezaDorrani]

Simply sort the data based on date and use first function

[@niu745]

@@RezaDorrani Not sure why is my replies deleted... Thanks again for the prompt reply! I have figured out how to use max function. i would need to add calculated column in Sharepoint List to convert my SubmitDateTime to datenumber like in excel. Then, in power automate 1 Use Get to get sharepoint list 2 Select to build an array of datenumber column, make sure to convert to float type 3 Compose max function on Select output I have also tried your recommended first function method, below are my steps 1 Use Get to get sharepoint list with Orderby SubmitDateTime desc 2 Select to build an array of SubmitDateTime column 3 Compose first function on Select output Please do not remove my reply. Thank you!

[@RezaDorrani]

@@niu745 Note: I do not delete any reply. Replies that include links to certain words are auto blocked by channel policy. I get 100s of comments per day. I don't have the time to sit and delete replies.

[@fovalere]

Great job as usual!

[@RezaDorrani]

Thank you! Cheers!

[@TheKermit2110]

That was such a great vid, Reza, thanks so much

[@RezaDorrani]

Most welcome

[@denied501]

Awesome content as always, Reza. How to handle sending reminder to individual(s) in Assigned to column given it is a multiple allowed people column. Thanks

[@RezaDorrani]

Most welcome! I do not have a video reference on it and I would have to try out with multi select person column to know the steps. Il suggest checking on forums at powerusers.microsoft.com/

[@denied501]

Thanks for the response, Reza. I had many errors while trying and your video just happened to come out at the same time. Was worth asking. Hope you get time to make a video on it one day. You have been a great teacher. 🙏

[@RezaDorrani]

@denied501 thanks so much! Every 6 monts I ask subscribers for topic suggestions on community tab of my channel. Make sure to post this idea there. If it gets the max votes, I would definitely work on it.

[@silkygarg3086]

Thank you so much Reza. I have learnt a lot from your videos.

[@RezaDorrani]

Glad to hear that

[@jaybenson6589]

Good stuff, this has been very helpful. Any chance you could expand on how to apply basically the same process to tasks that are a multi-select owner? So if a single task could be assigned to two or more people, how would you change the process so that the select statements could loop through the multi select person field?

[@RezaDorrani]

Thanks! I would have to show that in a separate video. Would involve a different process. Currently, I have no plans for a part 2.

[@megabuilds3007]

I've the same requirement.

[@miguelalejandro3457]

Gracias por compartir sus conocimientos

[@RezaDorrani]

Bienvenidos

[@ShivaV-d6c]

That was superb loved it♥.

[@RezaDorrani]

Thank you so much

[@muffin17]

Super Thanks!!!

[@RezaDorrani]

Most Welcome!

[@rjaybanaglorioso9275]

Hi Reza this is exactly what I was looking for. A little help please, in addition to this data set, I have another people column that I wanted to CC on the emails, how do I do this?.

[@RezaDorrani]

I would have to try that to know the steps. I showed 2-3 scenarios in video and for each of them the technique would probably be different. I will recommend checking or posting your query on forums in case someone has done something similar community.powerplatform.com/

[@paolovr1970]

Thanks Renza 🙏🙏🙏

[@RezaDorrani]

Most welcome

[@JandeGroot-i2p]

thanks for your videos they are a huge help... but when i use the people column in the sharepoint the flow doesn't work for example create html table always goes into a for each loop... maybe you can help me :)

[@RezaDorrani]

I have not experienced the mentioned issue and hence not sure what is the cause for it. I will recommend posting your issue with screenshots on the forums at powerusers.microsoft.com in case someone has experienced something similar. Also, video description has link to download entire solution (members only)

[@shubhabratadey]

A great video as usual, full of information. Can you share the HTML Style code? We can use it then.

[@RezaDorrani]

I made the html style by asking chatgpt. Video description has entire solution shared for members (check description for details)

[@MollyCavallaro-v4s]

Do you have a video to do this except send the list as an excel attachment instead and then could they make updates to excel reply back and have it update the sharepoint list?

[@RezaDorrani]

I have ones to export to excel but to update or reply back.

[@gunasekar4098]

This is truly an excellent video with valuable content and great presentation! One thing I would like to request: the monthly Gold Club subscription fee seems a bit high for us in India, making it difficult to join. Is there any possibility of offering a discount or concession for members from India? I’d love to join and learn more about your interesting topics. Your assistance would be greatly appreciated.

[@RezaDorrani]

Most welcome! The membership price is set uniformly and applies equally to all members, regardless of their location. KZbin does not offer options for regional bassd pricing that would allow me to set different prices for different countries.

[@shineremanan5523]

I was looking for the same content..... thank you so much.... one thing, how will get style code... or can u share the code which u have used here

[@RezaDorrani]

Video description has link to download entire app which includes all the code (members only - check description for details) The style code I had built using chatgpt

[@shineremanan5523]

How to get an email I'd from dataverse table lookup of users(systemusers) in place of assigned to email

[@RezaDorrani]

@@shineremanan5523 I do not have a specific video ref on it. I suggest checking or posting your query on forums at powerusers.microsoft.com/

[@crispy3406]

Hello, How else can I get the rows name? Are you able to show how you created the sharepoint?

[@RezaDorrani]

Pick any sharepoint list of your choice and follow the steps. There is no way to show or share a sharepoint list here on comments. Entire solution is available for download to members (check video description for details)

[@mohamedmasoud8564]

Dear Reza, i need to make automation when SharePoint is created send automated email to direct supervisor and after 24 h if no action taken as per a specific condition send to the manager, do you have any flow or video help me in that

[@RezaDorrani]

I do not have a specific video reference for this scenario. I will recommend checking or posting your query on forums in case someone has done something similar community.powerplatform.com/

[@oluwatobiyusuf]

Thank you Reza

[@RezaDorrani]

Most welcome!

[@SamanBassam]

Hi reza - very good content I want to join but I have question before I join up - I don’t have ms work account - if I join will I be able to use any dev environment - specially for power apps - or if I join the club I only get access to the links and I will need to upload the solution into my own environment? Sorry for that

[@RezaDorrani]

It would be your own environment.

[@SamanBassam]

@@RezaDorrani ok , sorry is that mean i need to build the sharepoint library with all the columns on my own ? or there is way , is there any video how to use your projects?

[@RezaDorrani]

@@SamanBassam all links shared include a readme file which will walk you through the steps on how to create the lists or libraries

[@SamanBassam]

@@RezaDorranisure - sorry but can I take copy of the library template so I don’t create all the columns manually ?

[@RezaDorrani]

@SamanBassam it depends on the video scenario shared. It would max take 10 mins to setup what is shared.

[@DjOyda-i9u]

Does this work for DataVerse tables too?

[@RezaDorrani]

Video is specific to sharepoint but technique shown should work with any data source

[@DjOyda-i9u]

@@RezaDorrani Hi Reza, do you have any video controlling power automate to create records in power app data verse tables? I'm finding it hard to find here.

[@RezaDorrani]

@@DjOyda-i9u I don't have one

[@AhmadSaab-x7n]

Super Hero ❤

[@RezaDorrani]

Thanks

[@Jeremy-ow4op]

I set this up but I'm only getting 12 rows of data. What am I missing?

[@RezaDorrani]

I have not experienced the mentioned issue and hence not sure what is the cause for it. I will recommend posting your issue with screenshots on the forums at powerusers.microsoft.com in case someone has experienced something similar.

[@SibusisoMBATHA-i6i]

Hi Reza how do i get the style code for the HTML table can you copy and paste it on the comment please!

[@RezaDorrani]

I got that from chatgpt. Entire solution is available for download to silver and gold members.

[@AniketRaghav-s4m]

hey rezza I am getting error for the same i am getting the mail but it has no data to show'

[@RezaDorrani]

I have not faced any issues, hence not sure the reason for your error. Video description has link to download entire solution (members only - check description for details)

[@ABCD-ABCDEFGH]

Can we send reminders for before or after 60,200 days

[@RezaDorrani]

Check video again

[@ABCD-ABCDEFGH]

@ the video is great. It’s a scheduled workflow. In SharePoint designer we can create flows that can pause for a time no matter how long then execute the action. Poweautomate took that away by not letting the flow wait more than 29 days which is real sad. Now I might have to run schedule flow every day to check if it is 60 days to due date or not.

[@RezaDorrani]

@ABCD-ABCDEFGH power automate never took anything away. It was never an option in the first place. Power Automate it not a replacement for SharePoint workflows. It's a successor. What's the problem if flow runs every day? It would run, check for due items and then send the email.

[@ABCD-ABCDEFGH]

@@RezaDorrani it was an option in SharePoint Designer . I still have workflows that pause for like 200 days or more than send an email. I guess that’s the only option I have now. Run the workflow everyday check the date and send email. My point is something that we were able to achieve before we are no longer.

[@RezaDorrani]

@ABCD-ABCDEFGH My point is that power automate is NOT a replacement for SharePoint designer.

[@nelsonminoso8971]

🎉🎉

[@RezaDorrani]

Thanks

[@mrinalpain1540]

Can I get the css code please 🥺

[@RezaDorrani]

I had chatgpt build it for me. I have shared entire solution with channel members (details in description)

[@Gadgetuniverse888]

Sir plz can you create a video for how to create microsoft 365 developer account

[@RezaDorrani]

I make videos when I receive multiple requests on a topic. Every 6 months I ask subscribers for topic suggestions on Community Tab of my channel. Most voted idea gets added to my backlog. Make sure to post this idea whenever I post the next topic suggestion post.

[@FaizanKhan-tn5hv]

please can you make videos in urdu

[@RezaDorrani]

I cannot