Automate Emailing Excel Task Reminders with ZERO Coding!

แชร์
ฝัง
  • เผยแพร่เมื่อ 24 ธ.ค. 2024

ความคิดเห็น • 514

  • @yvonnewilliamson602
    @yvonnewilliamson602 11 หลายเดือนก่อน +2

    Thank you so much!! It has taken me a lot of attempts and a lot of different tutorials! This one was so easy to follow and I did it! We now have an automatic email reminder for our tech subscriptions at a school. Great life saver so we do not forget anything!!

    • @MyOnlineTrainingHub
      @MyOnlineTrainingHub  11 หลายเดือนก่อน

      Awesome to hear!

    • @jerryhamilton1150
      @jerryhamilton1150 8 หลายเดือนก่อน

      Great example. How do you format to look at tasks within a week range vs daily?

  • @tomfontanella6585
    @tomfontanella6585 2 หลายเดือนก่อน +5

    Wow. I hadn't expected that it would take so much to automate that operation. Your usual excellent clear explanation notwithstanding, it doesn't exactly motivate me to play with Power Automate - at least until I have a real use case for it.

    • @MyOnlineTrainingHub
      @MyOnlineTrainingHub  2 หลายเดือนก่อน

      I get it, it can be a lot to take in - hope you'll give it another try when you do have a real use case!

    • @renelove
      @renelove หลายเดือนก่อน

      @@MyOnlineTrainingHub Appreciate the video! Excited to test this out. While I understand the amount of work that goes into it, I also see the value it would deliver for my team. Excited to see more of your content!

  • @guillermorodriguezvera7886
    @guillermorodriguezvera7886 2 หลายเดือนก่อน +4

    I got congratulations from my manager for applying the e-mail reminder. I really want to thank you a lot. Greetings from Mexico!

    • @MyOnlineTrainingHub
      @MyOnlineTrainingHub  2 หลายเดือนก่อน +1

      Congratulations on your success! Glad I could help 😁

  • @Cagandenizd
    @Cagandenizd 7 หลายเดือนก่อน +3

    Hello thank you first of all. I want to change it so that it sends an e-mail if today's date is the same as or past the ReminderDate. What change needs to be made?

    • @MyOnlineTrainingHub
      @MyOnlineTrainingHub  7 หลายเดือนก่อน +2

      Great question. However, I'm not a Power Automate expert, sorry. You're best to post your question in the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity

  • @GurinderSingh-mh1ln
    @GurinderSingh-mh1ln ปีที่แล้ว +1

    Hi thanks for the video, do you have video for creating outlook calendar event from excel with capacity to auto update if there is any change in the excel thanks.

    • @MyOnlineTrainingHub
      @MyOnlineTrainingHub  ปีที่แล้ว

      No, I don't, sorry. You're best to post your question in the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity

  • @dmha1655
    @dmha1655 2 ปีที่แล้ว +1

    Thank you. I had to watch it twice to understand what was happening. Can't wait to try this out.

  • @ScionFruits
    @ScionFruits 2 หลายเดือนก่อน +1

    You are right, it is not coding but it is as complicated as coding. I hope Automate will develop a way to do automations bit easier for everyone

  • @Officeinstructor
    @Officeinstructor 2 ปีที่แล้ว

    Excellent tutorial Mynda, thanks for sharing. I couldn't add the filter for the second action as I failed to find the proper format for Canada EST. Otherwise, it worked fine.

    • @MyOnlineTrainingHub
      @MyOnlineTrainingHub  2 ปีที่แล้ว +2

      Thank you! I wonder if you can use the equivalent US time zone to convert your date/time.

    • @aviman2010
      @aviman2010 2 ปีที่แล้ว

      There isn't a standard time for Canada as it covers numerous time zones. For example, Calgary is Mountain Standard Time and Toronto is Eastern Standard time. Hope that helps.

  • @bryansmith3235
    @bryansmith3235 3 หลายเดือนก่อน +1

    This video is very on-point with a good example of how to use power automate in a useful way. Do you have a playlist for your power automate related videos?

    • @MyOnlineTrainingHub
      @MyOnlineTrainingHub  3 หลายเดือนก่อน +1

      Glad it was helpful. I'm not a Power Automate expert, so this was a one off for me, sorry.

  • @Spottheviral
    @Spottheviral 9 หลายเดือนก่อน +1

    Mam I complete my flow but after test the flow means its came on Bad Request Error in list rows present in a table session what im do ? 😢

    • @MyOnlineTrainingHub
      @MyOnlineTrainingHub  9 หลายเดือนก่อน

      Yikes! Not sure, sorry. I'm not a Power Automate expert. You're best to post your question in the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity

  • @nykiruarch
    @nykiruarch 2 ปีที่แล้ว +1

    Thank you for the video, are you able to upload the power automate flow file and excel file for us to make a copy and try it out

    • @MyOnlineTrainingHub
      @MyOnlineTrainingHub  2 ปีที่แล้ว

      I don't have the file to hand, sorry. It's only 5 columns and a few rows so should be quick to recreate. Then you can follow the steps in the written tutorial: www.myonlinetraininghub.com/automatically-email-reminders-from-excel-with-power-automate

  • @robwilliams937
    @robwilliams937 7 หลายเดือนก่อน +1

    The flow works well thanks. Just one quetion, if I have 10 rows of data with a common due date I get 10 emails each with the same information. Is there a way to group the rows of data so I ony get one email instead of 10?

    • @MyOnlineTrainingHub
      @MyOnlineTrainingHub  7 หลายเดือนก่อน

      I'm sure there will be however, I'm not a Power Automate expert, sorry. You're best to post your question in the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity

  • @gordoncprice
    @gordoncprice 2 ปีที่แล้ว +2

    Great tutorial Mynda. If I need to capture all rows/records that fall within say today and 60 days later, how would I best build in the filter?
    Tried to replace the "eq" with a "le" in the list filter query, but it didn't like it.

    • @MyOnlineTrainingHub
      @MyOnlineTrainingHub  2 ปีที่แล้ว +3

      Hi Gordon, in that case you're filtering for dates that are equal to today OR less than or equal to today +60 days. So it'll be something like:
      ReminderDate/all (r: r eq 'formatDateTime(utcNow(),'yyyy-MM-dd') or r le 'formatDateTime(addDays(utcNow(),60),'yyyy-MM-dd') )
      That might need some tweaking as I'm not expert on ODATA functions. You can find out more here: docs.microsoft.com/en-us/azure/search/search-query-odata-logical-operators

    • @gordoncprice
      @gordoncprice 2 ปีที่แล้ว

      @@MyOnlineTrainingHub Unfortunately OData doesn't support the "le" operator in the filter query. Will keep trying

    • @StevenLawrence-Eyre
      @StevenLawrence-Eyre ปีที่แล้ว

      @@gordoncprice Did you ever find a way round this? I am also trying to only get content from an excel table based on whether it is within a 30 day 'deadline date', as opposed to all content, all the time.

  • @Cagandenizd
    @Cagandenizd ปีที่แล้ว +1

    Hi Mynda, thank you for your tutorial. I have a question.
    I have a question, I want it to continue sending e-mails after the reminder date has passed too.
    When you delete the related row or update the date in Excel, it should stop send mail.
    for example:
    today: 13.07.2023
    reminder due date : 13.07.2023 (This system is sending mail ok)
    tomorrow : 14.07.2023
    reminder due date: 13.07.2023 (this system should send to continue mail during a mounth remaind up to change or update date)
    How can i do this, which parameters should i add?
    thank you.

    • @MyOnlineTrainingHub
      @MyOnlineTrainingHub  ปีที่แล้ว +1

      I'm not a Power Automate expert, sorry. You're best to post your question in the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity

  • @jackyo8547
    @jackyo8547 ปีที่แล้ว +1

    I really enjoy your crystal-clear training. I followed step you suggested but got stuck at apply to each step when it causes an error "The execution of template action 'Apply_to_each' failed: the result of the evaluation of 'foreach' expression '@outputs('Compose')' is of type 'String'. The result must be a valid array." what should I do in this one?

    • @MyOnlineTrainingHub
      @MyOnlineTrainingHub  ปีที่แล้ว

      Great to hear! Unfortunately, I'm not a Power Automate expert so I'm not sure what the issue is. You're best to post your question in the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity

  • @WilsonC15
    @WilsonC15 ปีที่แล้ว +2

    You alleviated my discomfort! I liked your video since it solved my problem, especially the part about sending a single unique email to a list of outstanding rows rather than sending many emails to a person for an overdue task! Brilliant! You're the greatest! 🤩😘🥰

    • @MyOnlineTrainingHub
      @MyOnlineTrainingHub  ปีที่แล้ว

      Thanks for your kind words!

    • @WilsonC15
      @WilsonC15 ปีที่แล้ว

      @@MyOnlineTrainingHub Please add another action that after Create HTML table to improve the style of the output table, which is currently just a plain text table with no formatting.

  • @westleyempeigne6541
    @westleyempeigne6541 2 ปีที่แล้ว +2

    Hi Mynda, the Time Zones names link doesn’t open, showing an error

    • @MyOnlineTrainingHub
      @MyOnlineTrainingHub  2 ปีที่แล้ว +1

      TH-cam is truncating it and omitting the end. I've shortened it and you can use this link: bit.ly/3HdmIgF

    • @westleyempeigne6541
      @westleyempeigne6541 2 ปีที่แล้ว

      Thanks Mynda, just want to say your lessons are really good

  • @ryankitchen3230
    @ryankitchen3230 2 ปีที่แล้ว

    Thank you so much for this! Is it possible for filter query eq the date and older? I want emails to continue to keep coming until the reminder date has been changed to a future.

    • @MyOnlineTrainingHub
      @MyOnlineTrainingHub  2 ปีที่แล้ว

      My pleasure. I'm sure you can modify the flow to dates less than or equal to.

  • @Arielle-Blaze-Midnight
    @Arielle-Blaze-Midnight หลายเดือนก่อน

    Very informative, can you also apply the same logic to to create a workflow for Contracts, to send 90days, 60 and 30 days expiration reminders

  • @parthivshah0857
    @parthivshah0857 10 หลายเดือนก่อน +1

    Hey, this is very useful for me as to remind me task on which id due on yearly basis.
    I have follow all the step mention in the video and run the test which is also success but I am not getting any Email and after "Apply to each" step all below step (i.e. filter array, create HTML table and Send and email (V2) ) are skipped by putting message like "ActionConditionFailed"
    Kindly let me know what to do to resolve this error

    • @MyOnlineTrainingHub
      @MyOnlineTrainingHub  10 หลายเดือนก่อน

      Glad you’ll be able to make use of it. If you’ve followed the steps exactly, then I’m not sure what’s causing the error. I'm not a Power Automate expert, sorry. You're best to post your question in the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity

  • @Moana173
    @Moana173 2 ปีที่แล้ว

    Excellent! I have one question if we have one task and multiple email ids in one cell then how to run the flow

    • @MyOnlineTrainingHub
      @MyOnlineTrainingHub  2 ปีที่แล้ว

      I don't have a tutorial on that. I recommend you post your question on the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity

  • @vccamino
    @vccamino ปีที่แล้ว +1

    Thank you for your video. I have a small employee chart and we are trying to generate email reminders, but I keep getting this error "There is an unterminated string literal at position 24 in 'REMINDER eq ' 2023-09-28'. inner exception: There is an unterminated string literal at position 24 in 'REMINDER eq ' 2023-09-28'. clientRequestId: cd39f8fb-9753-40a2-9b9e-7eeffc69f53a" It would be a wonderful thing if it works for me.

    • @MyOnlineTrainingHub
      @MyOnlineTrainingHub  ปีที่แล้ว

      This error usually means you haven't entered a closing parenthesis or curly brace etc. i.e. you haven't closed the expression.

  • @TheIKA710
    @TheIKA710 ปีที่แล้ว

    Thank you for the video! Can I have multiple email addresses in one excel cell and send to all those address one email asking for input "participant names" for a "meeting" ?
    In may case each meeting will be one row hence needing to have in the "email" cell multiple email addresses.

    • @MyOnlineTrainingHub
      @MyOnlineTrainingHub  ปีที่แล้ว

      It's not ideal to store multiple records in a single cell. Maybe if they're separated by a delimiter, you can use them, but you'd have to ask your question in the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity

  • @aliyaesubi6383
    @aliyaesubi6383 ปีที่แล้ว

    Thank you for the great video. I am beginner at Power Automate trying to setup automatic emails 90, 60 and 30 days in advance (of the due date) using my excel tracker.
    I have made my excel sheet and tables, but when I want to enter tables, it only shows table 1 to table 7 without my table headers (or names).
    How can I fix this?
    Thanks,
    Al.

    • @MyOnlineTrainingHub
      @MyOnlineTrainingHub  ปีที่แล้ว +1

      Glad you liked it 🙏 I'm not a Power Automate expert either, sorry. You're best to post your question in the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity

  • @susiethielbert
    @susiethielbert 2 ปีที่แล้ว

    Hi I need something far simpler, but can't figure it out. I have a large database where one column is a follow up date for that row. I would like to just send ONE email, to one person (CC'd to another) to follow up when the follow up date is today. I keep getting date format errors.

  • @k.p.4818
    @k.p.4818 8 หลายเดือนก่อน

    do you need premium version of power automate to access the scheduled cloud flow. I am not finding it in basic

    • @MyOnlineTrainingHub
      @MyOnlineTrainingHub  8 หลายเดือนก่อน

      Not sure of the current licensing requirements. Try asking your in the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity

  • @humnahaleem4322
    @humnahaleem4322 2 หลายเดือนก่อน

    If we want to send reminders daily until the reminder date is changed manually (by us), instead of just once prior to the expiration, how would that logic work in the filter query?
    Basically, let’s say I have a task due on 11/24. It alerts me for the first time on 11/14, 10 days before expiry. I’d want it to alert on 11/13, 11/12, 11/11, etc

    • @MyOnlineTrainingHub
      @MyOnlineTrainingHub  2 หลายเดือนก่อน

      I'm not a Power Automate expert, sorry. You're best to post your question in the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity

  • @tanxiaoyancarol1356
    @tanxiaoyancarol1356 ปีที่แล้ว

    Base on your video, i can see the column header called "Email". May i know if this is sender email address or recipient email address? If this is for recipient email address purpose, can i put more than 1 recipient address at the same time? if it's allowable, should i just use "Comma" as separator in the same excel row cell?

    • @MyOnlineTrainingHub
      @MyOnlineTrainingHub  ปีที่แล้ว

      It's the recipient. If you want multiple recipients, put them on separate rows.

  • @stanleywong2452
    @stanleywong2452 หลายเดือนก่อน

    Hi Mynada, Thank You for sharing just a great video. I didn't receive the HTML table detail when receiving the email. Do you have any idea?

    • @MyOnlineTrainingHub
      @MyOnlineTrainingHub  หลายเดือนก่อน

      Glad it was helpful. Regarding the HTML issues, I'm not a Power Automate expert, sorry. You're best to post your question in the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity

  • @hosseinbirjandinejad6731
    @hosseinbirjandinejad6731 ปีที่แล้ว

    Hi. Great video! How can I change this so it sends an email on both current date and past due reminder dates?

    • @MyOnlineTrainingHub
      @MyOnlineTrainingHub  ปีที่แล้ว

      Glad you liked it. Regarding modifying the flow, unfortunately I'm not a Power Automate expert. You're best to post your question in the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity

  • @momodoualieujallow7486
    @momodoualieujallow7486 9 หลายเดือนก่อน

    Amazing video! thanks for sharing. I got issues on the Date Format "formatDateTime(convertFromUtc(utcNow(),'E. Australia Standard Time'), 'MM-dd-yyyy')" how should I adjust for GMT 0 (West Africa)? Thank you!

    • @MyOnlineTrainingHub
      @MyOnlineTrainingHub  9 หลายเดือนก่อน +1

      You can find the name of your time zone here: bit.ly/3HdmIgF
      Looks like it might be: W. Central Africa Standard Time

  • @ArchitaSharma-qm2in
    @ArchitaSharma-qm2in ปีที่แล้ว

    I have been sending bulk emails and after sometime we have to do a follow up how can we use this function in that VBA sheet. Curious for the comment

    • @MyOnlineTrainingHub
      @MyOnlineTrainingHub  ปีที่แล้ว

      I'm not a Power Automate expert, sorry. You're best to post your question in the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity

  • @francisafrane3489
    @francisafrane3489 ปีที่แล้ว

    Thanks, I've been searching for this. One question, though, if all the reminders go to the same person, in which case I wouldn't need an email column. Which steps in the flow can be skipped?

    • @MyOnlineTrainingHub
      @MyOnlineTrainingHub  ปีที่แล้ว

      I'm sure you can modify it to handle this however, I'm not a Power Automate expert. You're best to post your question in the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity

  • @stanTrX
    @stanTrX 11 หลายเดือนก่อน

    Very good thanks. Can you do the reminding not with a new email but somehow following the latest correspondance (using entryid or conversationid or something else)

    • @MyOnlineTrainingHub
      @MyOnlineTrainingHub  11 หลายเดือนก่อน +1

      Probably however, I'm not a Power Automate expert, sorry. You're best to post your question in the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity

    • @stanTrX
      @stanTrX 11 หลายเดือนก่อน

      @@MyOnlineTrainingHub thanks

  • @ya007
    @ya007 ปีที่แล้ว

    Thank you for the video. Is this possible to send reminders on a specific time in a day using this method? As an example two reminders 9am and 1pm?

    • @MyOnlineTrainingHub
      @MyOnlineTrainingHub  ปีที่แล้ว +1

      I'm sure it is however, I'm not a Power Automate expert, sorry. You're best to post your question in the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity

  • @sarahsardella2927
    @sarahsardella2927 2 ปีที่แล้ว

    Great tutorial! How would I change the distinct list part? I need a unique email sent for each row!

    • @MyOnlineTrainingHub
      @MyOnlineTrainingHub  2 ปีที่แล้ว

      Thank, Sarah! I'm not a Power Automate expert, so you're best to post your question in the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity

  • @fay5306
    @fay5306 ปีที่แล้ว

    Thank you for your explanation! But i received an error says "only work accounts supported in excel online connector" so i couldn't upload the file I can't use my personal email?

  • @armravindra9350
    @armravindra9350 ปีที่แล้ว

    Hi Mynda, Thanks for the detailed and step by step explanation. I tried and created a similar flow, but I am not receiving email alerts. Can please help me to fix this issue?

    • @MyOnlineTrainingHub
      @MyOnlineTrainingHub  ปีที่แล้ว

      I'm not a Power Automate expert, sorry. You're best to post your question in the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity

  • @JovelynSlivka
    @JovelynSlivka 4 หลายเดือนก่อน

    Thank you Mynda for this video! M flow ran successfully as shown in PA, but I didn't get the email notification. What could be wrong? I'd be grateful for your input

    • @MyOnlineTrainingHub
      @MyOnlineTrainingHub  4 หลายเดือนก่อน

      Great to hear you were able to get it partially working. Unfortunately, I'm not a Power Automate expert, sorry. You're best to post your question in the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity

  • @chandratreseduhub
    @chandratreseduhub 7 หลายเดือนก่อน

    I am getting only 4 email out of 9 emails...please help me how I can complete unique emails

    • @MyOnlineTrainingHub
      @MyOnlineTrainingHub  7 หลายเดือนก่อน

      Hmm, that's odd. I'm not a Power Automate expert, sorry. You're best to post your question in the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity

  • @roshinisaac2643
    @roshinisaac2643 ปีที่แล้ว +1

    Myanda, thank you for sharing this video. However, it would be helpful if you can share a tips on how to create dynamic mail body, sender name and attachment

    • @MyOnlineTrainingHub
      @MyOnlineTrainingHub  ปีที่แล้ว

      I'd love to, but I'm not a Power Automate expert, sorry. If you're stuck, try posting your question in the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity

  • @luisrosario432
    @luisrosario432 11 หลายเดือนก่อน

    This is exactly what I was looking for. I tried to duplicate this since I have a similar task at my work, and I found that in the filter array control, when I add the parameters, I see you did from "Value" and the filter query "email is equal to current item". For me, the from is only showing body/value instead of just value and because of this, the flow is skipping every step because of this. Is there a way to fix it? Power automate doesnt seem to add a separate value expression, it just adds body/value together.

    • @MyOnlineTrainingHub
      @MyOnlineTrainingHub  11 หลายเดือนก่อน

      I'm not a Power Automate expert, sorry. You're best to post your question in the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity

    • @sabbirahmed2657
      @sabbirahmed2657 11 หลายเดือนก่อน

      I am having the same thing, did you find any solution?

    • @luisrosario432
      @luisrosario432 11 หลายเดือนก่อน

      @@sabbirahmed2657 Not yet, let me know if you find a solution.

  • @Fatima-bn9co
    @Fatima-bn9co ปีที่แล้ว

    Thank you for this. In filter array, the option to select current item doesnt come up. Ive followed all steps.

    • @MyOnlineTrainingHub
      @MyOnlineTrainingHub  ปีที่แล้ว

      Strange 🤔 I'm not a Power Automate expert, sorry. You're best to post your question in the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity

  • @KiranKumar-ec6qf
    @KiranKumar-ec6qf ปีที่แล้ว

    Hi, Thank you very mush for the explanation. I have been searching for this type of flow and could not fine one till now. It work on the file and Table I have now. But it is sending email of every status I have. Need your help and suggestion. How do I trigger email based on only two conditions using And Condition.

    • @MyOnlineTrainingHub
      @MyOnlineTrainingHub  ปีที่แล้ว

      Glad you found the video helpful. Regarding your question, I'm not a Power Automate expert, sorry. You're best to post your question in the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity

  • @6206Films
    @6206Films ปีที่แล้ว

    Is there a way of having the emails generate and pop up on our screen before sending? We often have attachments - that cant be autoattached or we have clients that need an email that covers multiple co-insurer invoices so being able to do a quick tinker to the email on those specific cases would be ideal. thoughts on this?

    • @MyOnlineTrainingHub
      @MyOnlineTrainingHub  ปีที่แล้ว

      Probably. However, I'm not a Power Automate expert, sorry. You're best to post your question in the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity

    • @6206Films
      @6206Films ปีที่แล้ว

      @@MyOnlineTrainingHub Hey again! So i am trying to replicate this minus the time schedule but when i get to the 2nd step with the Select field i do not have an option to say Value. Any ideas on this? Could it be how i have set up my excel document/table?
      Thank you so much in advance!

  • @hdp6612
    @hdp6612 ปีที่แล้ว

    Hello! Super basic question but when I select a table and try to select the row value it only says Table1 no matter what I do, the data of course is formatted as a table and everything but Power Automate wont recognize the header of any row

    • @MyOnlineTrainingHub
      @MyOnlineTrainingHub  ปีที่แล้ว

      I'm not a Power Automate expert, sorry. You're best to post your question in the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity

  • @prince9853057012
    @prince9853057012 ปีที่แล้ว

    Hii Madam,
    Thank for sharing such a great things .
    I am stuck of error.
    The execution of template action 'apply_to_each failed : the result of the evaluation of foreach expression 'ou@{output('compose') is of type string . The results must be valid array.

    • @prince9853057012
      @prince9853057012 ปีที่แล้ว

      Request you guidance

    • @MyOnlineTrainingHub
      @MyOnlineTrainingHub  ปีที่แล้ว

      I'm not a Power Automate expert, sorry. You're best to post your question in the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity

  • @square007tube
    @square007tube ปีที่แล้ว

    Hi, Thanks for the video, it is very helpful. I want to filter data from excel instead of equal to a specific date, I want to select a range of dates, please let me know if this applicable. thanks

    • @MyOnlineTrainingHub
      @MyOnlineTrainingHub  ปีที่แล้ว +1

      Possibly, but I'm not a Power Automate expert, sorry. You're best to post your question in the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity

  • @abidkhan-pm3gf
    @abidkhan-pm3gf หลายเดือนก่อน

    Hi, I have encountered an issue when I am trying to send an email via the send email v2 part. If i put the "To" part in the email to current item, I get an error OpenApiOperationParameterValidationFailed, it considers my email an object and not an string so it can't read it. I used the dynamic content and used the column that had emails in it and replaced the "Current items" function and it which works. However, it sends everyone all the rows I have and not the specific rows of data for each email. What would you recommend to solve this challenge I am facing

    • @MyOnlineTrainingHub
      @MyOnlineTrainingHub  หลายเดือนก่อน

      I'm not a Power Automate expert, sorry. You're best to post your question in the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity

  • @jameslanceley422
    @jameslanceley422 2 ปีที่แล้ว +1

    Very informative, thank you Mynda. As a school we use Gmail as our mail client, so i have replaced the Send Email v2 connector with a Gmail send Email (2) and works a treat. Thanks again

  • @abidkhan-pm3gf
    @abidkhan-pm3gf หลายเดือนก่อน

    Hi, I have half solved the previous issue with the following output --> outputs('Apply_to_each')['email]. But the issue is that it sends all excel lines to both emails in the list and not the specific email on each list. Is there a way to do that?

    • @MyOnlineTrainingHub
      @MyOnlineTrainingHub  หลายเดือนก่อน

      Glad you're making progress. I'm not a Power Automate expert, sorry. You're best to post your question in the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity

  • @np-il4ms
    @np-il4ms ปีที่แล้ว

    Hi,
    would this work for simple reminders for productivity rates for individual employees? If I have an excel spreadsheet for the productivity rates of employees ( 30days, 60days, 6month with the company ect.) Could I set up my excel to send email reminders to the office personnel regarding those milestone dates?

    • @MyOnlineTrainingHub
      @MyOnlineTrainingHub  ปีที่แล้ว

      I'm sure you can. If you get stuck, you're best to post your question in the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity

  • @khushbumali9099
    @khushbumali9099 8 หลายเดือนก่อน

    This is the output that is being generated by the UTCNOW function when the parameter is 'India Standard time'.
    And since the logic is not satisfied there is no list of values. can you please help me out on this?

  • @janelopez554
    @janelopez554 2 หลายเดือนก่อน

    Hello, I have a problem with running the flow. It was a successful for one time and the next recurrence it is all failed. In my dynamic content (perhaps in the new version), 'body' and 'value' are combined 'body/value" thus creating an issue in the creation of html. Please help.

    • @MyOnlineTrainingHub
      @MyOnlineTrainingHub  2 หลายเดือนก่อน

      I'm not a Power Automate expert, sorry. You're best to post your question in the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity

  • @grandittehadboutiquehotel4263
    @grandittehadboutiquehotel4263 2 ปีที่แล้ว

    How can I assign task to multiple users through list and make any type of FLow

  • @YT-cd2vi
    @YT-cd2vi ปีที่แล้ว +2

    Thanks, was searching for this. Got Office Prof but not business 365, so will need to wait for that I guess.

  • @prathmeshkulkarni6491
    @prathmeshkulkarni6491 9 หลายเดือนก่อน

    Thanks Mynda....
    I am getting error in Send an email (V2) option.
    Dynamic content option is missing in To....
    Please suggest

    • @MyOnlineTrainingHub
      @MyOnlineTrainingHub  9 หลายเดือนก่อน

      Hard to say. And I'm not a Power Automate expert, sorry. You're best to post your question in the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity

  • @balajimarley2875
    @balajimarley2875 ปีที่แล้ว

    Excellent Tutorial. I created a flow for due date. How about the due hours ??? Please help me out. I’m not expert either that much good in power automate

    • @MyOnlineTrainingHub
      @MyOnlineTrainingHub  ปีที่แล้ว

      Glad you found it helpful! I'm not a Power Automate expert, sorry. You're best to post your question in the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity

  • @rubin_ludi
    @rubin_ludi 11 หลายเดือนก่อน

    on 5:07 what is standard time Indonesia.?

    • @MyOnlineTrainingHub
      @MyOnlineTrainingHub  11 หลายเดือนก่อน

      The time zone names are listed here: docs.microsoft.com/en-us/previous-versions/windows/embedded/gg154758(v=winembedded.80)

  • @Kidandfamilyhappy
    @Kidandfamilyhappy 2 ปีที่แล้ว

    Thanks, Mynda, for the helpful flow. I am able to run the flow without errors and receive email, but the email content only shows the column headers mentioned in the HTML Table creation step ... there are no values showing up under the column headers. Please help.

    • @MyOnlineTrainingHub
      @MyOnlineTrainingHub  2 ปีที่แล้ว

      Glad you liked it. Please post your question in the Power Automate support forum where someone can help you troubleshoot: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity

  • @ekapz
    @ekapz หลายเดือนก่อน

    This is totally amazing but I just have one issue. I am using a dollar amount for an upcoming payment reminder, and the email wont recognize the number as a currency. I've spent days trying to alter the steps, but nothing seems to work. Any advice?

    • @MyOnlineTrainingHub
      @MyOnlineTrainingHub  หลายเดือนก่อน

      I'm not a Power Automate expert, sorry. You're best to post your question in the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity

  • @goldcarps
    @goldcarps 2 ปีที่แล้ว

    Hi Mynda,
    Can I includes other emails in the reminder?
    Thanks

    • @MyOnlineTrainingHub
      @MyOnlineTrainingHub  2 ปีที่แล้ว

      Not sure what you mean by 'other'.

    • @goldcarps
      @goldcarps 2 ปีที่แล้ว

      @@MyOnlineTrainingHub I mean can we sent the reminder besides ourselves to any others person.

  • @andradadumitru6821
    @andradadumitru6821 2 ปีที่แล้ว

    Thank you for this tutorial, it is very helpful. Could you please tell me if it's possible to send just one email for multiple entries from the table? Currently if there are multiple lines included in the table, it sends multiple email reminders. Thank you!

    • @MyOnlineTrainingHub
      @MyOnlineTrainingHub  2 ปีที่แล้ว

      🤔My table has multiple entries for the same person and it only sends one email.

  • @AlexChen-v9v
    @AlexChen-v9v 10 หลายเดือนก่อน

    Hi, thank you so much for this tutorial, it helped solved my problem. However, if i only want to send the email where those tasks that have 'Pending' status and ignore those that are 'Completed', how should i do?
    Thanks in advance

    • @MyOnlineTrainingHub
      @MyOnlineTrainingHub  10 หลายเดือนก่อน

      Great question, however I'm not a Power Automate expert, sorry. You're best to post your question in the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity

  • @briancashjr
    @briancashjr ปีที่แล้ว

    Hi Mynda, really great tutorial. Is it possible to break the items pulled from the excel into the body of the email? They load in fine but are all cramped together. Is there a way to add breaks between items in the filter array to better list out the headers and values?
    Also, is it possible to list multiple dates in the excel so that the emails could fire on certain assigned dates in the future?
    Kind regards from Dublin, Brian

    • @MyOnlineTrainingHub
      @MyOnlineTrainingHub  ปีที่แล้ว +1

      Glad it was helpful, Brian! I'm confident you can do the things you want, however I'm not a Power Automate expert, sorry. You're best to post your question in the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity

  • @Rafaqio0
    @Rafaqio0 ปีที่แล้ว

    Would it work with for example sending message on teams chat ?

    • @MyOnlineTrainingHub
      @MyOnlineTrainingHub  ปีที่แล้ว

      Probably. I'm not a Power Automate expert, sorry. You're best to post your question in the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity

  • @samaruti9446
    @samaruti9446 2 หลายเดือนก่อน

    I have a cloud flow that watches a mailbox for new emails. If I send an email to the mailbox it is processed per the rest of the flow, meaning the flow works. However, if I send a large number of emails to the mailbox the flow does not process all of them. In my example, the flow received about 400+ emails within minutes but only processed about 100+. Are you aware of any restrictions related to how fast the flow can process information? I have posted this question on the Power Automate Community website a two weeks ago and have not received any response. Do you know anyone that I can contact to discuss my issue?

    • @MyOnlineTrainingHub
      @MyOnlineTrainingHub  2 หลายเดือนก่อน +1

      I'm not aware of any restrictions, but it sounds like you must be hitting some limits. I'd reach out to your Microsoft support person for your account.

    • @samaruti9446
      @samaruti9446 หลายเดือนก่อน

      @@MyOnlineTrainingHub Thank you very much

  • @lindahenry8473
    @lindahenry8473 ปีที่แล้ว

    Excellent tutorial and loved how the step by step has been provided. Is there anyway possible if to run a script of the reminder due date has past? 1st attempt using power automate and am loving it.
    Is there a way to run a parallel script with a different reminder due date? Would be keen to view later videos of a similar nature. Thank you!

    • @MyOnlineTrainingHub
      @MyOnlineTrainingHub  ปีที่แล้ว

      Glad you liked it. I'm not a Power Automate expert, sorry. You're best to post your question in the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity

  • @joannablack
    @joannablack 2 ปีที่แล้ว +3

    I would love to be able to do this but with creating separate Excel workbooks for each. I tried using the OneDrive "Create File" function but couldn't get it to work. Love this tutorial! Thank you so much for all you put out there!

    • @MyOnlineTrainingHub
      @MyOnlineTrainingHub  2 ปีที่แล้ว +1

      Glad you liked it, JoAnna. There probably is a way with separate workbooks, but that's beyond my Power Automate skillset at this point 😁 Try the Power Automate community forum.

    • @danielleyumi7841
      @danielleyumi7841 3 หลายเดือนก่อน

      Hi Joanna, just wondering if you got any joy creating the workflow for different workbooks or spreadsheets

  • @chandanrebel350
    @chandanrebel350 ปีที่แล้ว

    Hi Myranda, can you please help with the flow to check an excel file, with a column called incident and trigger a message in teams when a new incident is added.

    • @MyOnlineTrainingHub
      @MyOnlineTrainingHub  ปีที่แล้ว

      I'm not a Power Automate expert, sorry. You're best to post your question in the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity

  • @javasathar
    @javasathar 5 หลายเดือนก่อน

    test was succeeded but i didn't receive any email
    how to solve
    ActionConditionFailed
    The execution of template action 'Filter_array' is skipped: there are no items to repeat.

  • @arunmoorthy2780
    @arunmoorthy2780 14 วันที่ผ่านมา

    Hi, under "Select," it's not getting the values of each row from the Excel sheet. Could you please explain the reason for the error.

    • @MyOnlineTrainingHub
      @MyOnlineTrainingHub  14 วันที่ผ่านมา

      I'm not a Power Automate expert, sorry. You're best to post your question in the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity

  • @fabiovitale1779
    @fabiovitale1779 2 ปีที่แล้ว

    Hi! how can i see the preview of the email?
    thanks

  • @anilkumar-pi6ep
    @anilkumar-pi6ep 7 หลายเดือนก่อน

    Excellent video. However, I am unable to see "value" in the list of items. Hence flow after "Apply to each" is getting skipped. Please let me know how i can correct here. Really appreciate your response.

    • @MyOnlineTrainingHub
      @MyOnlineTrainingHub  7 หลายเดือนก่อน

      Not sure what's gone wrong for you there. I'm not a Power Automate expert, sorry. You're best to post your question in the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity

  • @todimapreetam
    @todimapreetam 2 ปีที่แล้ว

    Hi Mynda,
    We have a SharePoint document library where we store all the excel spreadsheets. Our aim is to get a notification when someone completes an entire column in the spreadsheet. How can we acheive this?

    • @MyOnlineTrainingHub
      @MyOnlineTrainingHub  2 ปีที่แล้ว

      I'm not a Power Automate expert, so you'd be best to ask this question in the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity

  • @aquabestindian
    @aquabestindian 2 ปีที่แล้ว

    Thanks, this is great!
    Could you please help me with a problem,
    Whenever a new Excel file is placed in a SharePoint folder, I want to read its contents and send emails accordingly.
    Each Excel file will have a different name, but the table design in it will be the same.

    • @MyOnlineTrainingHub
      @MyOnlineTrainingHub  2 ปีที่แล้ว

      I'm not an expert in Power Automate. Best to seek help in the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity

  • @sabbirahmed2657
    @sabbirahmed2657 11 หลายเดือนก่อน

    I tried but got the following error in filter array section, would you please help?
    ActionConditionFailed
    The execution of template action 'Filter_array' is skipped: there are no items to repeat.

    • @MyOnlineTrainingHub
      @MyOnlineTrainingHub  11 หลายเดือนก่อน

      I'm not a Power Automate expert, sorry. You're best to post your question in the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity

  • @CherieChan-wr5hd
    @CherieChan-wr5hd 11 หลายเดือนก่อน

    when I add create html table, it will sepreate to apply to each 2 and equired me to select an output from previvous steps. also, when I choose send an email body, could not find create html table-output, could you help on it?

    • @MyOnlineTrainingHub
      @MyOnlineTrainingHub  11 หลายเดือนก่อน

      I'm not a Power Automate expert, sorry. You're best to post your question in the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity

  • @lelialina
    @lelialina ปีที่แล้ว

    Hello, it is great video! however I would love to find how to add CC email from the table

    • @MyOnlineTrainingHub
      @MyOnlineTrainingHub  ปีที่แล้ว

      Glad you liked it 🙏 In regards to adding a CC address, you’re best to post your question in the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity

  • @remuslupinhp
    @remuslupinhp 2 หลายเดือนก่อน

    This is an awesome tutorial! I tried it out and it worked like a charm...Thanks a ton!

  • @runfortress
    @runfortress 8 หลายเดือนก่อน

    Hi, I am a complete begginer here, I am trying to generate emails from expiry dates in an excel workbook. I have arrived at the filter query and am unsue what to put in here. I have a column titled reminder date. Can you help?

    • @MyOnlineTrainingHub
      @MyOnlineTrainingHub  8 หลายเดือนก่อน

      I'm not a Power Automate expert, sorry. You're best to post your question in the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity

  • @b-maxtv
    @b-maxtv 3 หลายเดือนก่อน

    how can we setup a RAG using this format?

  • @JayArulnathan
    @JayArulnathan 9 หลายเดือนก่อน

    Great tutorial. But for some reason I was not successful, even though the flow ran successfully. I get "ActionConditionFailed. The execution of template action 'Filter_array' is skipped: there are no items to repeat." at "Filter array" process step. Can you please help what is going wrong here.

    • @MyOnlineTrainingHub
      @MyOnlineTrainingHub  9 หลายเดือนก่อน

      I'm not a Power Automate expert, sorry. You're best to post your question in the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity

  • @DavidMaharjan-k1h
    @DavidMaharjan-k1h 2 หลายเดือนก่อน

    Best video ever after looking into many video tutorials and succeeded to sent email on reminder date looking into your video. But want to send it until the due date comes (recurring everyday until the due date). Can you help me on that ?

    • @MyOnlineTrainingHub
      @MyOnlineTrainingHub  2 หลายเดือนก่อน

      So pleased it was helpful. Regarding sending it every day until the due date, unfortunately, I'm not a Power Automate expert, so I'm not sure myself. You're best to post your question in the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity

  • @deanm2980
    @deanm2980 ปีที่แล้ว

    Is there a way to use lessOrEquals to create a List rows so that an email will be sent every day until the "due date" in the spreadsheet is changed?

    • @MyOnlineTrainingHub
      @MyOnlineTrainingHub  ปีที่แล้ว

      Probably, but I'm not a Power Automate expert, sorry. You're best to post your question in the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity

  • @winstonchay
    @winstonchay 2 ปีที่แล้ว

    Great video, would you happen to know rather than using eq, can I also get overdue items? (I.e. the ones that have passed the current date)

    • @MyOnlineTrainingHub
      @MyOnlineTrainingHub  2 ปีที่แล้ว

      Thank you! Yes, from memory you can use gt and lt for greater than and less than.

  • @MuhammadRizal-ii8tx
    @MuhammadRizal-ii8tx ปีที่แล้ว

    Hai nice work by the way, i have a question about filter query. Can i make query that RemainderDate equivalent to today date also after date. Because i wanna keep emailing the remainder task everyday even the date is due. Thanks

    • @MyOnlineTrainingHub
      @MyOnlineTrainingHub  ปีที่แล้ว

      Yes you can. If you get stuck, you're best to post your question in the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity

    • @MuhammadRizal-ii8tx
      @MuhammadRizal-ii8tx ปีที่แล้ว

      @@MyOnlineTrainingHub can you help me with the queries? or method that i can use?

  • @vinodvinu9605
    @vinodvinu9605 2 ปีที่แล้ว

    Can we use same in lower version of Excel example office 2013

    • @MyOnlineTrainingHub
      @MyOnlineTrainingHub  2 ปีที่แล้ว

      It shouldn't matter what version of Office you have AFAIK.

  • @th3n0rthsid3
    @th3n0rthsid3 2 หลายเดือนก่อน

    Awesome use case, thanks for the clear steps and links!

  • @hopeledet3047
    @hopeledet3047 2 ปีที่แล้ว

    Could you post correct formula for Central standard time below? I have tried over and over to no avail. Any help would be appreciated. Thank you!

    • @MyOnlineTrainingHub
      @MyOnlineTrainingHub  2 ปีที่แล้ว

      formatDateTime(convertFromUTC(utcNow(), 'Central Standard Time'), 'yyyy-MM-dd')

    • @hopeledet3047
      @hopeledet3047 2 ปีที่แล้ว

      @@MyOnlineTrainingHub Thank you so much!

  • @darlenestephaniesalazar5816
    @darlenestephaniesalazar5816 9 หลายเดือนก่อน

    Hi. This video is very helpful! I followed these steps last october 2023, all were working. But I think there was an update with Power Automate (obviously the look of it is now different). Not sure if this has an effect on the previous flow I made copying from your video. Would it be possible if you recreate an updated video, using the examples you have here, but in the new platform of power automate? Really hope you can help out. Thank you so much 😊

    • @MyOnlineTrainingHub
      @MyOnlineTrainingHub  9 หลายเดือนก่อน

      That's a shame. I'll add it to the list of video topics, but I'm not sure when I'll get to it. In the meantime, you're best to post your question in the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity

    • @darlenestephaniesalazar5816
      @darlenestephaniesalazar5816 9 หลายเดือนก่อน

      @@MyOnlineTrainingHub thank you so much!

  • @sukirtmohansrivastava9342
    @sukirtmohansrivastava9342 ปีที่แล้ว

    Nice explanation but i have one query though, As you have applied filter for date, I have multiple conditions to follow through. Example I want only those data sent through mail that does match with the requirement date, also whether any column contains 'not implemented' text etc. So how can I use multiple conditions in there cause by using 'and' it is throwing error saying only one condition is allowed.

    • @MyOnlineTrainingHub
      @MyOnlineTrainingHub  ปีที่แล้ว

      I'm not a Power Automate expert, sorry. You're best to post your question in the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity

    • @sukirtmohansrivastava9342
      @sukirtmohansrivastava9342 ปีที่แล้ว

      @@MyOnlineTrainingHub Thank you

  • @Nomad_Pirate
    @Nomad_Pirate ปีที่แล้ว

    I tried doing it 2-3 times my program is showing successful after that when i check the program like you showed at 12:07 my data is empty. Please advise how to resolve this problem

    • @MyOnlineTrainingHub
      @MyOnlineTrainingHub  ปีที่แล้ว +1

      If you've done everything as I've done it and it's not working, then I'm not sure. I'm not a Power Automate expert, sorry. You're best to post your question in the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity

  • @victormoran9330
    @victormoran9330 ปีที่แล้ว

    somehow im not getting the "current item" option at the "filter array" step, what could be the reason?, thanks.

    • @MyOnlineTrainingHub
      @MyOnlineTrainingHub  ปีที่แล้ว

      That seems odd. I'm not a Power Automate expert, sorry. You're best to post your question in the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity

    • @maxencemarchalot6446
      @maxencemarchalot6446 ปีที่แล้ว

      Hi victor, I got exactly the same problem. Did you find the solution?

  • @humamalsebai
    @humamalsebai 2 ปีที่แล้ว

    Thank you for this tutorial. I would be happy if you could assist me in a simple task. I would like to send an Email to myself several times every day to remind me of several task I must do on a daily basis is this possible. The tasks are listed in the excel sheet along with their times and I would like to get an email at the beginning of every task
    Thx

    • @MyOnlineTrainingHub
      @MyOnlineTrainingHub  2 ปีที่แล้ว

      Glad you found Power Automate helpful. I'm not a Power Automate expert, so you're best to post your question on the Power Automate community forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity

  • @kumarirakhi75
    @kumarirakhi75 6 หลายเดือนก่อน +1

    Amazing video. I was stuck on formatdate. Didn’t find any video that used the dynamic content in html… finally!!!! Pls pls pls create a power automate list. It is not there when i looked in the playlists.. waiting for more power automate videos!!! ❤❤❤

    • @MyOnlineTrainingHub
      @MyOnlineTrainingHub  6 หลายเดือนก่อน

      Glad it was helpful! I'm not a Power Automate expert, so probably won't be publishing a playlist on this topic 🫤

    • @kumarirakhi75
      @kumarirakhi75 6 หลายเดือนก่อน

      @@MyOnlineTrainingHub I understand!! Will keep looking for more on this to be made by you 😉 this was pretty simple, clear and instantly useful. Loved it!!! More success and power to you..

  • @T33mohi
    @T33mohi ปีที่แล้ว

    Thanks for this video, so easy to follow! I have one issue that I’m struggling to resolve: I’ve set up the flow and tested it on a sample group (10 people) which all works as planned, however when I use the flow for the full list (approx. 900) the flow seems to max out at around 32 emails. Any help would be appreciated! Thanks

    • @MyOnlineTrainingHub
      @MyOnlineTrainingHub  ปีที่แล้ว

      So pleased it was helpful! Not sure about the limits. I wonder if it's your subscription with Microsoft that's limiting it. You might need to check your account settings.

    • @Caba-Rojo
      @Caba-Rojo ปีที่แล้ว

      Would a Delay help?

  • @kristin149
    @kristin149 11 หลายเดือนก่อน

    Can I include a link in the generated email to a Microsoft form or other file like Excel that could allow me to prompt staff for further questions or information? Thank you for the helpful video, and whatever guidance you can provide 😊😊

  • @wayneedmondson1065
    @wayneedmondson1065 2 ปีที่แล้ว +1

    Thanks Mynda. Useful lesson! Thumbs up!!

  • @dogukanozen3510
    @dogukanozen3510 ปีที่แล้ว

    Can we email the table with a frame so that the items in the email we send look more organized?

    • @MyOnlineTrainingHub
      @MyOnlineTrainingHub  ปีที่แล้ว

      Probably, but I'm not a Power Automate expert, sorry. You're best to post your question in the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity

    • @dogukanozen3510
      @dogukanozen3510 ปีที่แล้ว

      @@MyOnlineTrainingHub thanks for support, have a nice day.