Power Automate Tutorial - Create Planner Tasks from Excel

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

КОМЕНТАРІ • 31

  • @ChristianAbata
    @ChristianAbata 3 роки тому +12

    Thank you Jon for the chance and sorry friends for my english I'm doing my best to improve it day by day. ;)

    • @LT-lp7pm
      @LT-lp7pm 3 роки тому

      Your english is just fine! Thanks a lot for the excellent tutorial!

  • @rustyjim
    @rustyjim 3 роки тому +7

    Great video guys! Any chance of automating the checklist in a task? Would love to know how to do that 😀

  • @didierclveh7109
    @didierclveh7109 3 роки тому +2

    Thank you Jon and Christian, muchas gracias a vos.

  • @fritznie4456
    @fritznie4456 3 роки тому +2

    Great one, thanx.
    I can read in the documentation, that its possible to manipulate a checklist item. Any tipp, how to create checklist items for a task from an excelsheet?

  • @mohammedyunus7043
    @mohammedyunus7043 2 роки тому +1

    Please explain how do you generate dynamic bucket ids

  • @ramjamram
    @ramjamram Рік тому +1

    s there a way to make the Bucket more dynamic? As it is, it will only update one Bucket at a time.

  • @andreassiebert7251
    @andreassiebert7251 2 роки тому

    Great video! You can make an video using multple tables in de excel file

  • @hirokohodge1186
    @hirokohodge1186 3 роки тому +1

    Thank you, this is very useful! Is there any way of creating a flow from Planner to excel and/or linked each other so both are updated simultaneously?

  • @ipablome
    @ipablome 3 роки тому +2

    Hello Jon, how can we update or create labels in tasks vis flow?

  • @stugryffin3619
    @stugryffin3619 2 роки тому +2

    Interesting that trainer elected to delete the original task. Would have been better to demonstrate ability for the flow to determine that task already existed and update existing task without duplication. Really common demonstration that doesn't fully cover the most often encountered gap in this approach.

  • @mohammedyunus7043
    @mohammedyunus7043 2 роки тому +1

    Ok how do you get the dynamic buckets from your excel spreadsheet nobody seems to know

  • @camilamantilla3748
    @camilamantilla3748 3 роки тому

    Is it possible to build a flow for existing tasks created from excel and update the tasks from Excel too?

  • @krittamukkanchanabut7742
    @krittamukkanchanabut7742 Рік тому

    If there is one more row of data, will the program automatically create a task?

  • @CrazyOneCanuck
    @CrazyOneCanuck Рік тому

    What happens if you have more than one bucket?
    And various states (Progression) in which the projects are?

  • @rebekahblake7507
    @rebekahblake7507 3 роки тому

    thank you!

    • @rebekahblake7507
      @rebekahblake7507 3 роки тому

      let's say I would like these tasks to be created yearly and the due dates are of that year. is there a way to make this happen?

  • @sprasannaatsjec
    @sprasannaatsjec 3 роки тому +1

    How to make new bucket from excel ?

  • @KalemBilal
    @KalemBilal 3 роки тому

    could you please tell us if we can update task "checklist" ?

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

    What is a simple process to use Power Automate to create the buckets and then put the tasks under the correct bucket? I'm not having any luck.

  • @karinabaez30
    @karinabaez30 3 роки тому

    hi. How can I add a check list too?

  • @cornebistouille
    @cornebistouille Рік тому

    i cant see the trigger when a row is added to excel... is there one anymore?

  • @anilyadav-rt4sr
    @anilyadav-rt4sr 3 роки тому

    Hi friends,
    I just want to know how to save the Excel attachment from outlook mail on desktop in Power Automete Desktop

  • @ruthfabian
    @ruthfabian 3 роки тому +1

    Sorry for my English, but, I see an error in the dates. because they don't match your excel. The same thing has happened to me every time I want to migrate dates from an Excel table, I still can't find the solution.

    • @JonJLevesque
      @JonJLevesque  3 роки тому +1

      Yeah sorry we didn’t account for the date/time variances in flow - check out this article - www.flyingpolymath.com/post/moving-targets

    • @vaibhavsrivastava3174
      @vaibhavsrivastava3174 2 роки тому

      @@JonJLevesque I am complete step by step task and after your watching videos but when I refresh my planner these task does not updated on planner

    • @vaibhavsrivastava3174
      @vaibhavsrivastava3174 2 роки тому

      @@JonJLevesque can you provide watts up no

  • @TheNabob57
    @TheNabob57 3 роки тому

    Why are the start and end dates in the actual task NOT what you created with PA?

    • @TheNabob57
      @TheNabob57 3 роки тому

      its really difficult to follow a tutorial when it appears something is wrong. You put start 12/01 and end 12/02 but after you run the PA, it shows up as start 11/30 and end 12/01. Do you guys even check your work before posting your vids?

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

    The dates from excel did not go into Planner correctly - you can see bug between 11:49 and 20:10 - Surprised they didn't notice this during this live session....