Send Emails Based on a 📆 Date Column in SharePoint with Microsoft Power Automate

Поділитися
Вставка
  • Опубліковано 25 сер 2024

КОМЕНТАРІ • 68

  • @acreativeopinion
    @acreativeopinion  11 місяців тому +3

    How have you used this concept in your flows? What type of email reminders/notifications are you sending with Power Automate? Let me know down below! 👇👇👇

    • @maryjanederoxas1159
      @maryjanederoxas1159 Місяць тому

      Hi, I noticed that when I used the same condition which is the output is not equal to 0, it sends an email to all email address on the SP List since they all have a Birthdate. May I know what can I encode in Condition so that it will only become truth when the birthdate(MM-d) coincides on today's date?

  • @dsiuniversity5806
    @dsiuniversity5806 6 місяців тому +1

    Finally, someone who explains each step of the flow process in a manner that makes sense. Thank you for a great video!

    • @acreativeopinion
      @acreativeopinion  5 місяців тому

      Thanks so much for watching! Appreciate the feedback.

  • @MichaelDeBlasis1369
    @MichaelDeBlasis1369 4 місяці тому +1

    This video is a true gem. I come back to it any yime I need to make a flow based on any date column. There are not many other videos covering this. And none do as good a job.

  • @Kimwenman
    @Kimwenman 11 місяців тому +3

    Thank you!!! I did it!!!! Thanks for talking a little slower than the first videos, and for explaining why you put in some of the steps you do. Mine worked through all the tests. This is great. Will also use this for Employee Anniversary dates with the company. We have an HR system that posts these dates, but we get no notifications and rarely would be in the system where it is shown, so I like this idea for the team to do it this way. You are so smart!!!!

    • @acreativeopinion
      @acreativeopinion  11 місяців тому +1

      Amazing! Thx for giving it a try! Working on the pacing. Appreciate the feedback.

    • @Kimwenman
      @Kimwenman 9 місяців тому

      @@acreativeopinion hi there - I have a problem with my flow and not sure where - I went over the entire thing again. The flow went through and sent all managers the notifications that their staffs bdays are in 3 days. I did all the tests on ONE entry and they seemed to all work. As soon as I removed the FILTER QUERY of the one test item, well, that is when everyone got an email from me! LOL.... I was fast enough to at least recall most of the messages. Where should I look first? I looked in my Filter and have this text @and(not(equals(item()?['field_2'], null)),
      OR(contains(item()?['field_2'], outputs('Compose_-_Todays_Month_and_Day')),
      contains(item()?['field_2'], outputs('Compose_-_Dynamic_Date')))) I did have an error but fixed it and then tried it with a Bday within 3 days, it worked. I changed the Get Items to one that is further out and it worked as nothing was sent. I am afraid now to remove that Get Items if it goes to everyone again! So I tested with a few people that report to just me and edited my Filter query to ID eq 7 or ID eq 9 or ID eq 27. I got emails for all three when I should have only received for #27. HELP....please. :)
      Thanks for all this great content!!!!

  • @onat7140
    @onat7140 4 місяці тому

    The tips you gave to accommodate for the testing phase is so helpful

    • @acreativeopinion
      @acreativeopinion  2 місяці тому +1

      Thanks for watching and I'm glad you think so! It's much easier to troubleshoot as you are building instead of trying to do it once you've "finished" building the flow. This way you can adjust as you build.

  • @beastb5064
    @beastb5064 Місяць тому

    Legendary, thankyou for this video. I needed it to automate monthly reminders for inspections and I wasn't able to do it on my own. This video got me 99% of the way there and I could figure out the 1% with a little bit of tweaking and thought. Thanks so much!

    • @acreativeopinion
      @acreativeopinion  Місяць тому

      Amazing! Thanks for watching and I'm glad you were able to adjust the flow to work with your requirements!

    • @AmyM-r5b
      @AmyM-r5b Місяць тому

      Hi - how did you get your information to filter by items due in the current month? I would like to send a department email with all of the birthdays for that month: Happy Birthday to all... HTML table with Name MMM-dd to send on the first of each month and only pull in the BDays for that month.

  • @dannyparkins
    @dannyparkins 3 місяці тому

    🤗I'm in accord with all the accolades! I'm a big fan. Finally someone who gets to the point without wasting my time with preambles. I especially appreciate your agile development methodology of developing and testing incrementally. Much much appreciated.

  • @user-xs8dk9ve8e
    @user-xs8dk9ve8e Місяць тому

    Great tutorial. Thank you for your work! I have a question: how to insert a picture in the body of the email?

  • @nemanjap7244
    @nemanjap7244 11 місяців тому

    Hey, just found this channel via TikTok, very amazing work, thank you for what you do! So helpful

    • @acreativeopinion
      @acreativeopinion  11 місяців тому

      Thanks for watching! 🤗 Glad you find it helpful!

  • @cadenc.5979
    @cadenc.5979 Місяць тому

    Fantastic video, super helpful and organized

  • @11zou11
    @11zou11 5 місяців тому +1

    Great video and clear explanations. Just one question; I get bodu/value instead of value. I can’t figure out why? Can you help?

    • @sherlynescota1636
      @sherlynescota1636 5 місяців тому

      I think it's the same. When I switched back to the old design it shows as value. When I'm using new design of power automate it shows body/value

  • @jray1429
    @jray1429 6 місяців тому

    Thanks for taking the time to make this video! It’s great!

  • @SabrinaJacques-d1d
    @SabrinaJacques-d1d 12 днів тому

    Thanks a lot for these videos!! My flow is working fine except when I remove the Filter Query on the Get items. I want the flow to scan the whole list for the real task. Then my item count fall to "0" like there is no "today date" item.. but my test item is still on the list, the same list. If I put back the filter to only my test item , then the flow work, the item count show an "1" and an email is sent. any ideas?

  • @imran002ali
    @imran002ali 6 місяців тому

    Hi, this video is very helpful and very well explained, thank you for sharing your knowledge! 👍

  • @karnerlogical443
    @karnerlogical443 3 місяці тому

    Hello - this is super helpful, thank you so much! For some reason my Recurrence doesn't seem to work (the flow works entirely, just that I have to manually trigger) - do you have any tips for this?

  • @Serentine
    @Serentine 5 місяців тому

    This is a great video! It works for me, the only thing I'm struggling with is that I want to add another qualifier - based on date AND a choice selection. Every time I try to add the filter, it fails. Do you have any resources or guidance for that? It always gives me a null value of []. The filter array I'm using is checking against the dynamic "status" column, but I'm not sure what to enter for to properly grab the status choice.

  • @Vyperium
    @Vyperium 5 місяців тому

    Hello!
    Thanks for the tutorial really well explained as always :)
    One question for you, why only trigger the flow on the weekdays ?
    If someone's birthday appears on Saturday or Sunday, the manager will be notificied 3 days before but not the employee on the birthday's date.
    Or I'm mistaken something ?

  • @noodlebrains
    @noodlebrains 3 місяці тому

    I’m looking to use it to create alerts related to contract end dates

  • @elavarashidanaraja6741
    @elavarashidanaraja6741 12 днів тому

    Hi, how to automatically add email ID in SP list

  • @benmchutchison2006
    @benmchutchison2006 7 місяців тому +1

    Fantastic tutorial. I'm hoping to apply it but having an issues following along at 5:32 where you run a test after the filter array. My "Compose - Item count" test Output "0" on the count and the Output of the filter array above showed only "Body [ ] " as the output? Odd? My tests alongside yours are fine until that point. I've checked everything but stuck here. Any ideas by any chance? Muchly appreciated.

    • @acreativeopinion
      @acreativeopinion  7 місяців тому +1

      Thanks for watching! The reason for the Item Count (Compose action) is to confirm the number of items returned from the Filter Array action. If it's returning zero and you are expecting it to return items, your Filter Array action is set up incorrectly.

  • @rebeccamayer3602
    @rebeccamayer3602 4 місяці тому

    Great video! I need my power automate to count the number of rows that have a specific date inputted and then email the count of those daily… however when I try and use ‘length()’ function to count my power automate automatically says “length(outputs(‘filter_array’)[‘body/value’]) then when I run this I get the error saying ‘[‘body/value’] doesn’t exist?! Please can someone help me?

  • @QUETUMAQUE
    @QUETUMAQUE 7 місяців тому

    I truly appreciate this insightful tutorial! I've been trying to implement it to automate report reminders based on specific due dates, like the 1st or 5th of each month. However, I encountered an unexpected notification. Currently, reminders should only be sent on the 2nd of the month, but I received on the 18th, 25th, 26th, and 28th as well. Could I have made a mistake in my setup? Any suggestions on how to troubleshoot this?

  • @theblackice300
    @theblackice300 3 місяці тому

    Great video! Should I remove the ID eq 17 at the end when I want to stop testing and actually implement? If so what would I change to? Thank you.

  • @user-kj5el1ck2j
    @user-kj5el1ck2j 8 місяців тому +1

    Is there a way to use this method to trigger from a library instead of a list? I've tried but it doesn't seem to correlate.

    • @acreativeopinion
      @acreativeopinion  8 місяців тому

      Thanks for watching! You'll need to use the Get Files (properties only) action instead of the Get Items action.
      Fun fact. The Get Files (properties only) returns folders as well. You need to use a Filter Query to return Files only. Refer to this YT Short: ua-cam.com/users/shortsIHQIq6E7TbI
      Hope this helps!

  • @sohadaneen7639
    @sohadaneen7639 6 місяців тому

    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.

  • @user-wu8fo8or5m
    @user-wu8fo8or5m 5 місяців тому

    Great Video! At the 1:45 mark, you hard code the Filter Query for the ID of the Test item, but you never go back to make this more dynamic. Do you have a recommendation on how to make this more dynamic to scan all of the items in the SharePoint list?

    • @acreativeopinion
      @acreativeopinion  5 місяців тому

      Thanks for watching!
      Sorry I must have missed adding that part into the video. To scan all items in your SP List-remove the filter query. The point of specifying the test items was to return a single item while building and testing the flow. You can also use the Top Count field to limit the number of items returned instead to a smaller number. Customize the flow to suit your needs.

  • @aubreyweber4367
    @aubreyweber4367 Місяць тому

    Hello! It's me again!
    I am having a weird issue that started today where I am getting the emails sent for today and 3-day reminders, however, they are being send 3 times for each SharePoint list item. Do you know where I should look to see what is causing this or even why this is happening? Thank you!

    • @acreativeopinion
      @acreativeopinion  Місяць тому

      Sounds like the logic of your flow needs to be adjusted. You have your Send an Email column nested in an Apply to Each action. This means it'll send an email each time the Apply to Each action loops through. If you want to send a single email with multiple SharePoint items-refer to this YT Tutorial on how to do that: ua-cam.com/video/mmvJWKK690Y/v-deo.html
      Hope this helps! Thanks for watching!

  • @FRANKWHITE1996
    @FRANKWHITE1996 4 місяці тому

    great content ❤

  • @youtubenamebad4259
    @youtubenamebad4259 5 місяців тому

    How would I have the day added so it is added to the UK format? I can have the output of today’s month and time display correctly for the date I want. But adding a day will then make the dynamic date revert back and add the amount to what would be the month.

    • @acreativeopinion
      @acreativeopinion  5 місяців тому

      Sorry I'm not sure I follow your comment. The Convert Time Zone action used at 2:44 of this tutorial takes the current date/time and returns it in the local time zone. However, for this flow-I'm not using the time, only the date.
      At 12:52 of this tutorial I'm using the addDays() function to get the date 3 days from today's date. The dynamic content used in this expression is the date that has already been converted to the local time zone.
      Hope this helps!

  • @IgoCaNo831
    @IgoCaNo831 10 місяців тому +2

    item()?['Profile/Email'] does not pull out the email for me

    • @nickdilucia9617
      @nickdilucia9617 5 місяців тому

      I am having the same issue I believe the person above had. I can pull the whole top level profile in with the compose, but once I try to access only them email address within the profile, the inputs go to blank. @@christineho7656

    • @rhiangriggs1910
      @rhiangriggs1910 4 місяці тому

      @@christineho7656 I am also having this problem... the column that has the Manager Microsoft profile in is called 'Lead' and when I checked my outputs, 'Lead' appears where 'Profile' does in the video. I assumed that I would then enter item()?['Lead/Email'] but this returns in the email as blank. I have not been able to find a solution anywhere.

    • @acreativeopinion
      @acreativeopinion  4 місяці тому

      Thanks for watching! If you are using the New Designer, I would recommend switching to the Classic Designer. The New Designer is still very buggy. You can try: item()?['YourInternalColumnNameHere']['Email'], however this should also work: item()?['YourInternalColumnNameHere/Email']. You need to ensure that your Compose action is inside the Apply to Each action looping through your items.

    • @DarkWolfProwler20
      @DarkWolfProwler20 4 місяці тому

      Hmm so “Lead” is the internal column name but I will definitely try the first example you gave!
      I definitely agree that the new designer is a bit buggy and I find it a bit too clunky compared to the classic designer!

  • @aubreyweber4367
    @aubreyweber4367 Місяць тому

    I am receiving an error only when I have line items that have an empty date. Not every line item will contain a date... is there a way to filter out and not apply the flow to items that do not contain a date?

    • @acreativeopinion
      @acreativeopinion  Місяць тому

      Filter out the items without a date. It's always best practice to filter your SP items using the Filter Query in the Get Items action before looping through them. Hope this helps!

    • @aubreyweber4367
      @aubreyweber4367 Місяць тому

      @@acreativeopinion That worked! Thank you very much!

  • @MichaelDeBlasis1369
    @MichaelDeBlasis1369 4 місяці тому

    I'm setting a payment due date reminder using this video. However, I must have missed something because I seem to get an email for every record regardless of if the date matches today. How can I solve this behavior?

    • @namysparkle
      @namysparkle 4 місяці тому

      Filter the array

    • @MichaelDeBlasis1369
      @MichaelDeBlasis1369 4 місяці тому

      @@namysparkle TY! I missed that step somehow. I got it working. I just wish that Flow ran a little less like a public bus in Florida. Sometimes they seem to run and sometimes they take a while or fail for no good reason it seems. But mostly running well. Especially this flow. Thanks again

  • @bradhoyer8691
    @bradhoyer8691 6 місяців тому

    @acreativeopinion This is an interesting solution. How do you get the O365 Profile into the Profile column? Thanks.

    • @acreativeopinion
      @acreativeopinion  6 місяців тому

      Thanks for watching. You need to add a Person column in your SharePoint list. Hope this helps!

    • @bradhoyer8691
      @bradhoyer8691 6 місяців тому

      @@acreativeopinion Thanks. Not sure why I never used the Person column before.

  • @jomarrosales3251
    @jomarrosales3251 9 місяців тому

    What about to get items in filter query?

    • @acreativeopinion
      @acreativeopinion  9 місяців тому +1

      Thanks for watching! Can you be more specific? What part of the tutorial are you referring to?

    • @PaulCeman
      @PaulCeman 4 місяці тому

      @@acreativeopinion I agree, did you every circle back to show how to set up the filter query after you set it to the test ID? How do you get it to search all on the list?

  • @murodbekvohidov
    @murodbekvohidov 7 місяців тому

    Hello, Can I reach you please by email to simplify this solution. I am new to this :)

  • @redasvilimas
    @redasvilimas 11 місяців тому +3

    You make it way too complicated

    • @user-rv6mu4xu6p
      @user-rv6mu4xu6p 10 місяців тому +2

      agree

    • @cvkealey
      @cvkealey 10 місяців тому +5

      "too complicated" how? While this might sound like something that should be really easy, it's not. I've built many flows like this and most of them are more complicated than what's shown here.