Automatic reminders from Excel data - Power Automate - Step by Step

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

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

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

    Download sample file and follow along
    efficiency365.com/wp-content/uploads/2023/11/PO-Reminders.xlsx
    Learn how to generate reminders from Excel data using Power Automate.
    Step by step process with detailed explanation.
    Understand triggers, actions, conditions, variables and loops.

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

    Nice video, I’ll have to come up with scenarios to use something like this.
    I assume the spreadsheet needs to be saved online somewhere for power automate to “find” it.

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

      Thanks @RonDavidowicz
      Yes. The spreadsheet needs to be on OneDrive. Or any other SharePoint location.
      Check out my other best practices videos as well.
      Efficient Tasks Management - th-cam.com/video/vLFpWVfUfQ8/w-d-xo.html
      Task Apps Comparison: th-cam.com/video/ViWJIzMPQZg/w-d-xo.html
      Teams Meeting - Agenda, Action Points, Notes - th-cam.com/video/k0t8_mNkMDw/w-d-xo.html
      Microsoft Teams - 15 Best Practices - th-cam.com/video/W8Ufx_znKxI/w-d-xo.html
      OneDrive Best Practices Part 1 - th-cam.com/video/D7ZrfphW4vo/w-d-xo.html Part 2 - th-cam.com/video/nFx6YQxc-b4/w-d-xo.html
      Smart and Effective Email - 5 powerful ways - th-cam.com/video/6NEFSMqHgQE/w-d-xo.html
      Outlook Calendar Best Practices : Part 1 - th-cam.com/video/GzsQnecjAQo/w-d-xo.html and Part 2 - th-cam.com/video/padKH8ys5Cs/w-d-xo.html
      OneNote - Best Practices - th-cam.com/video/m-4AY1cMi8s/w-d-xo.html
      Microsoft 365 Best Practices - th-cam.com/video/kVC_YcL5ObU/w-d-xo.html
      Cheers. Doc.

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

    This is a great video... thanks a lot.

    • @efficiency365
      @efficiency365  26 วันที่ผ่านมา

      Thanks @mazenbits4173
      Check out my other best practices videos as well.
      Task Management Best Practices - th-cam.com/video/DJcxPtu-rcg/w-d-xo.html
      Efficient Tasks Management using the New Planner 2024 - th-cam.com/video/kgxqzDirw1o/w-d-xo.html
      Microsoft Teams Meetings - 16 Best Practices - th-cam.com/video/l3Bvq-I0hy4/w-d-xo.html
      Microsoft Teams - 15 Best Practices - th-cam.com/video/W8Ufx_znKxI/w-d-xo.html
      OneDrive Best Practices Part 1 - th-cam.com/video/D7ZrfphW4vo/w-d-xo.html Part 2 - th-cam.com/video/nFx6YQxc-b4/w-d-xo.html
      Smart and Effective Email - 5 powerful ways - th-cam.com/video/6NEFSMqHgQE/w-d-xo.html
      Outlook Calendar Best Practices : Part 1 - th-cam.com/video/GzsQnecjAQo/w-d-xo.html and Part 2 - th-cam.com/video/padKH8ys5Cs/w-d-xo.html
      OneNote - Best Practices - th-cam.com/video/m-4AY1cMi8s/w-d-xo.html
      Microsoft 365 Best Practices - th-cam.com/video/kVC_YcL5ObU/w-d-xo.html
      Cheers. Doc.

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

    My case is little more complicated, but your video has given me some ideas to try through it.. i was thinking its easy but i am getting few setbacks when creating my flow :-(... any how big thumps up for making world more efficient.

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

      Thanks @user-km4gt9iz2u
      Best is NOT to use Excel for tasks. Watch this video.
      Task Management Best Practices - th-cam.com/video/DJcxPtu-rcg/w-d-xo.html
      Check out my other best practices videos as well.
      Efficient Tasks Management using the New Planner 2024 - th-cam.com/video/kgxqzDirw1o/w-d-xo.html
      Microsoft Teams Meetings - 16 Best Practices - th-cam.com/video/l3Bvq-I0hy4/w-d-xo.html
      Microsoft Teams - 15 Best Practices - th-cam.com/video/W8Ufx_znKxI/w-d-xo.html
      OneDrive Best Practices Part 1 - th-cam.com/video/D7ZrfphW4vo/w-d-xo.html Part 2 - th-cam.com/video/nFx6YQxc-b4/w-d-xo.html
      Smart and Effective Email - 5 powerful ways - th-cam.com/video/6NEFSMqHgQE/w-d-xo.html
      Outlook Calendar Best Practices : Part 1 - th-cam.com/video/GzsQnecjAQo/w-d-xo.html and Part 2 - th-cam.com/video/padKH8ys5Cs/w-d-xo.html
      OneNote - Best Practices - th-cam.com/video/m-4AY1cMi8s/w-d-xo.html
      Microsoft 365 Best Practices - th-cam.com/video/kVC_YcL5ObU/w-d-xo.html
      Cheers. Doc.

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

    Great explaining video

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

      Thanks @ConTecHub
      Check out my other best practices videos as well.
      Efficient Tasks Management - th-cam.com/video/vLFpWVfUfQ8/w-d-xo.html
      Task Apps Comparison: th-cam.com/video/ViWJIzMPQZg/w-d-xo.html
      Teams Meeting - Agenda, Action Points, Notes - th-cam.com/video/k0t8_mNkMDw/w-d-xo.html
      Microsoft Teams - 15 Best Practices - th-cam.com/video/W8Ufx_znKxI/w-d-xo.html
      OneDrive Best Practices Part 1 - th-cam.com/video/D7ZrfphW4vo/w-d-xo.html Part 2 - th-cam.com/video/nFx6YQxc-b4/w-d-xo.html
      Smart and Effective Email - 5 powerful ways - th-cam.com/video/6NEFSMqHgQE/w-d-xo.html
      Outlook Calendar Best Practices : Part 1 - th-cam.com/video/GzsQnecjAQo/w-d-xo.html and Part 2 - th-cam.com/video/padKH8ys5Cs/w-d-xo.html
      OneNote - Best Practices - th-cam.com/video/m-4AY1cMi8s/w-d-xo.html
      Microsoft 365 Best Practices - th-cam.com/video/kVC_YcL5ObU/w-d-xo.html
      Cheers. Doc.

  • @akhilvashu480
    @akhilvashu480 8 หลายเดือนก่อน +1

    Sir, please create more videos on Powerautomate and Powerapps
    Thank you, sir, creating this video 🙏

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

      Thanks @akhilvashu480
      Check out my other best practices videos as well.
      Efficient Tasks Management 2024 - th-cam.com/video/DJcxPtu-rcg/w-d-xo.html
      Microsoft Teams Meetings - 16 Best Practices - th-cam.com/video/l3Bvq-I0hy4/w-d-xo.html
      Microsoft Teams - 15 Best Practices - th-cam.com/video/W8Ufx_znKxI/w-d-xo.html
      OneDrive Best Practices Part 1 - th-cam.com/video/D7ZrfphW4vo/w-d-xo.html Part 2 - th-cam.com/video/nFx6YQxc-b4/w-d-xo.html
      Smart and Effective Email - 5 powerful ways - th-cam.com/video/6NEFSMqHgQE/w-d-xo.html
      Outlook Calendar Best Practices : Part 1 - th-cam.com/video/GzsQnecjAQo/w-d-xo.html and Part 2 - th-cam.com/video/padKH8ys5Cs/w-d-xo.html
      OneNote - Best Practices - th-cam.com/video/m-4AY1cMi8s/w-d-xo.html
      Microsoft 365 Best Practices - th-cam.com/video/kVC_YcL5ObU/w-d-xo.html
      Cheers. Doc.

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

    Everyone showing with one plus business or sharepoint. Is it possible to do the same task with normal one drive or other location

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

      Yes Power Automate works on regular (personal) OneDrive as well. Local drive? No.

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

    I am not getting the excel columns under dynamic content after writing a function, eg: once add formatdatetime() and move to dynamic content, there are no columns listed for selection, but it exists before writing the function. Could you pls help on this.

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

      Add one extra step above this one and check.
      Most probably, some syntax issue.

  • @gajendrapalbaghel1730
    @gajendrapalbaghel1730 26 วันที่ผ่านมา

    Flow has saved successfully without error an after testing the flow getting , (Action 'Condition' failed: Unable to process template language expressions for action 'Condition' at line '0' and column '0': 'In function 'parseDateTime', the value provided for date time string '' was not valid. The datetime string must match ISO 8601 format.'.
    1) how to resolve the error.

    • @efficiency365
      @efficiency365  25 วันที่ผ่านมา

      what is the input date?

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

    Great video, thanks a lot😀
    Just one query, I am not able to click on the TEST option even when there are no mistakes. Tried it with repeating this same problem but again test option is not getting activated

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

      It test is not enabled, it means some error.
      Just recreate the flow from scratch and follow the steps. It will work.

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

    How to Get or Activate the Copilot. Pls do one Video on the same

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

      Thanks @vmmohan08
      As suggested by you - I created a video about Copilot activation and usage.
      Have a look th-cam.com/video/Sjszdd5io8I/w-d-xo.html
      Check out my other best practices videos as well.
      Efficient Tasks Management - th-cam.com/video/vLFpWVfUfQ8/w-d-xo.html
      Task Apps Comparison: th-cam.com/video/ViWJIzMPQZg/w-d-xo.html
      Teams Meeting - Agenda, Action Points, Notes - th-cam.com/video/k0t8_mNkMDw/w-d-xo.html
      Microsoft Teams - 15 Best Practices - th-cam.com/video/W8Ufx_znKxI/w-d-xo.html
      OneDrive Best Practices Part 1 - th-cam.com/video/D7ZrfphW4vo/w-d-xo.html Part 2 - th-cam.com/video/nFx6YQxc-b4/w-d-xo.html
      Smart and Effective Email - 5 powerful ways - th-cam.com/video/6NEFSMqHgQE/w-d-xo.html
      Outlook Calendar Best Practices : Part 1 - th-cam.com/video/GzsQnecjAQo/w-d-xo.html and Part 2 - th-cam.com/video/padKH8ys5Cs/w-d-xo.html
      OneNote - Best Practices - th-cam.com/video/m-4AY1cMi8s/w-d-xo.html
      Microsoft 365 Best Practices - th-cam.com/video/kVC_YcL5ObU/w-d-xo.html
      Cheers. Doc.

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

      @@efficiency365 Thanks a lot

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

    I am getting this error still after entering 0, The input parameter(s) of operation 'Apply_to_each' contains invalid expression(s). Fix invalid expression(s) for the input parameter(s) of operation 'Apply_to_each'.

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

      I cannot help you without seeing the entire flow.
      Just start from scratch and go step by step. It will work.

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

      I get the same error

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

    Very useful

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

      Thanks @danielperkins8656
      Check out my other best practices videos as well.
      Efficient Tasks Management 2024 - th-cam.com/video/DJcxPtu-rcg/w-d-xo.html
      Microsoft Teams Meetings - 16 Best Practices - th-cam.com/video/l3Bvq-I0hy4/w-d-xo.html
      Microsoft Teams - 15 Best Practices - th-cam.com/video/W8Ufx_znKxI/w-d-xo.html
      OneDrive Best Practices Part 1 - th-cam.com/video/D7ZrfphW4vo/w-d-xo.html Part 2 - th-cam.com/video/nFx6YQxc-b4/w-d-xo.html
      Smart and Effective Email - 5 powerful ways - th-cam.com/video/6NEFSMqHgQE/w-d-xo.html
      Outlook Calendar Best Practices : Part 1 - th-cam.com/video/GzsQnecjAQo/w-d-xo.html and Part 2 - th-cam.com/video/padKH8ys5Cs/w-d-xo.html
      OneNote - Best Practices - th-cam.com/video/m-4AY1cMi8s/w-d-xo.html
      Microsoft 365 Best Practices - th-cam.com/video/kVC_YcL5ObU/w-d-xo.html
      Cheers. Doc.

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

    I am getting error in Apply to each option. Although it seems correct. Please help

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

      It is difficult to troubleshoot remotely. Check the previous step.
      Better still, create a new flow from scratch and follow instructions.

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

    Good

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

      Thanks @alexmamode2691
      Check out my other best practices videos as well.
      Efficient Tasks Management using the New Planner 2024 - th-cam.com/video/kgxqzDirw1o/w-d-xo.html
      Microsoft Teams Meetings - 16 Best Practices - th-cam.com/video/l3Bvq-I0hy4/w-d-xo.html
      Microsoft Teams - 15 Best Practices - th-cam.com/video/W8Ufx_znKxI/w-d-xo.html
      OneDrive Best Practices Part 1 - th-cam.com/video/D7ZrfphW4vo/w-d-xo.html Part 2 - th-cam.com/video/nFx6YQxc-b4/w-d-xo.html
      Smart and Effective Email - 5 powerful ways - th-cam.com/video/6NEFSMqHgQE/w-d-xo.html
      Outlook Calendar Best Practices : Part 1 - th-cam.com/video/GzsQnecjAQo/w-d-xo.html and Part 2 - th-cam.com/video/padKH8ys5Cs/w-d-xo.html
      OneNote - Best Practices - th-cam.com/video/m-4AY1cMi8s/w-d-xo.html
      Microsoft 365 Best Practices - th-cam.com/video/kVC_YcL5ObU/w-d-xo.html
      Cheers. Doc.