Updating Planner task description from list in Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-2541513%22%20slang%3D%22en-US%22%3EUpdating%20Planner%20task%20description%20from%20list%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2541513%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20successfully%20created%20a%20flow%20that%20allows%20me%20to%20create%20tasks%20in%20Planner%20with%20customised%20checklists%20for%20the%20type%20of%20task.%26nbsp%3B%3C%2FP%3E%3CP%3EE.g.%3C%2FP%3E%3CP%3EProject%20Title1%20-%20Project%20Task1%20-%20Checklist%20Item%201%3C%2FP%3E%3CP%3E%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20-%20Checklist%20Item%202%3C%2FP%3E%3CP%3E%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20-%20Checklist%20Item%203%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20like%20to%20extend%20on%20this%20to%20update%20the%20decription%20of%20the%20task%20based%20on%20the%20Project%20Task%201%20variable%20in%20the%20table.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22SS0.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F295387i97DAA4ABDB266D20%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22SS0.png%22%20alt%3D%22SS0.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22SS1.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F295389i6B7BF683D2298B97%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22SS1.png%22%20alt%3D%22SS1.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22SS2.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F295393iB668FDAC96F79530%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22SS2.png%22%20alt%3D%22SS2.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%E2%80%83%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22SS3.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F295394iD21FC738CB7D9CF1%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22SS3.png%22%20alt%3D%22SS3.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%E2%80%83%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22SS4.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F295395iB76DEA5FEC77203C%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22SS4.png%22%20alt%3D%22SS4.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%E2%80%83%3C%2FP%3E%3CP%3E%E2%80%83%E2%80%83%E2%80%83%E2%80%83%E2%80%83%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2541513%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPlanner%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPower%20Automate%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2541601%22%20slang%3D%22en-US%22%3ERe%3A%20Updating%20Planner%20task%20description%20from%20list%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2541601%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1101986%22%20target%3D%22_blank%22%3E%40Microsoft410%3C%2FA%3E%26nbsp%3Bafter%20you%20create%20the%20task%20add%20in%20%3CSTRONG%3Edelay%3C%2FSTRONG%3E%20control%20and%20set%20it%20to%20something%20like%2010%20seconds%20then%20you%20can%20add%20the%20%3CSTRONG%3EUpdate%20task%20details%3C%2FSTRONG%3E%20action.%20The%20delay%20is%20needed%20because%20otherwise%20the%20actions%20happen%20so%20fast%20the%20update%20won't%20find%20the%20newly-created%20task.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERob%3CBR%20%2F%3ELos%20Gallardos%3CBR%20%2F%3E%3CFONT%20size%3D%222%22%20color%3D%22%23006400%22%3EMicrosoft%20Power%20Automate%20Community%20Super%20User%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I have successfully created a flow that allows me to create tasks in Planner with customised checklists for the type of task. 

E.g.

Project Title1 - Project Task1 - Checklist Item 1

                                              - Checklist Item 2

                                              - Checklist Item 3

 

I would like to extend on this to update the decription of the task based on the Project Task 1 variable in the table.

SS0.png

 

SS1.png

SS2.png

SS3.png

SS4.png

     

2 Replies

@Microsoft410 after you create the task add in delay control and set it to something like 10 seconds then you can add the Update task details action and add the description. The delay is needed because otherwise the actions happen so fast the update won't find the newly-created task.

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User

@RobElliott Thank you for your reply and advice. I've added the delay but unfortunately that didn't work. 

 

Below is a copy and paste from the table that holds the checklist items for further clarification, if it helps.

 

CheckListTitle                                                                       Completed  UserStory          StoryDefinition

Discussion with TES Initiator prior to meeting with SME and SponsorFALSE1Analysis WorkshopMeeting with SME/Sponsor to confirm details of training need and gather additional information for completion of TES
Review Training Consultation section of the TES with SME and SponsorFALSE1Analysis Workshop 
Confirm details in Training Consultation of the TES are still currentFALSE1Analysis Workshop 
Gather information and make notes for Development Requirements section of the TESFALSE1Analysis Workshop