Updating a planner task with FLOW

%3CLINGO-SUB%20id%3D%22lingo-sub-202267%22%20slang%3D%22en-US%22%3EUpdating%20a%20planner%20task%20with%20FLOW%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-202267%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20strating%20using%20planner%20and%20would%20like%20to%20use%20planner%20to%20help%20customers%20to%20easily%20follow%20their%20tickets.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eto%20do%20that%20i%20would%20like%20%3A%3C%2FP%3E%3CUL%3E%3CLI%3Eto%20create%20planner%20tasks%20sending%20an%20email%20%3A%20OK%3C%2FLI%3E%3CLI%3Eto%20Update%20planner%20tasks%20by%20sendign%20emails%20%3A%20I%20do%20not%20see%20how%20i%20can%20do%20that%2C%20because%20the%20only%20way%20to%20update%20or%20retrieve%20tasks%20information%20is%20to%20give%20planner%20the%20task%20ID.%3C%2FLI%3E%3C%2FUL%3E%3CP%3EIs%20the%20any%20way%20to%20get%20the%20task%20ID%2C%20from%20task%20despription%2C%20for%20exemple%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethanks%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-216716%22%20slang%3D%22en-US%22%3ERe%3A%20Updating%20a%20planner%20task%20with%20FLOW%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-216716%22%20slang%3D%22en-US%22%3Ei%20create%20the%20same%20case%20%2C%20but%20i%20found%20alot%20of%20issues%20.%3CBR%20%2F%3E-update%20task%20doesn't%20work%20.%3CBR%20%2F%3E-task%20creation%20is%20limited%20within%20one%20plan.%3CBR%20%2F%3E-after%20around%2020%20success%20flow%20%2C%20fail%20due%20to%20limitation%20in%20storage%20%2C%20i%20don't%20know%20why%3CBR%20%2F%3E-general%20limitation%20in%20planner%3CBR%20%2F%3E*it%20doesn't%20restrict%20assignee%20person%20to%20change%20the%20due%20data%20also%20does't%20send%20notification%20to%20creator%20that%20assignee%20change%20time%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-203633%22%20slang%3D%22en-US%22%3ERe%3A%20Updating%20a%20planner%20task%20with%20FLOW%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-203633%22%20slang%3D%22en-US%22%3E%3CP%3EI%20found%20the%20way%20%3A%20there%20is%20just%20to%20use%20the%20foreach%20action%20in%20flow.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-750193%22%20slang%3D%22en-US%22%3ERe%3A%20Updating%20a%20planner%20task%20with%20FLOW%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-750193%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F152037%22%20target%3D%22_blank%22%3E%40Jean-Baptiste%20JACQUES%3C%2FA%3E%2C%20is%20it%20possible%20to%20update%20tasks%20directly%20in%20Planner%20from%20an%20Excel%20file%20%3F%20I%20created%20Planner%20tasks%20with%20an%20Excel%20file%20%3A%20it%20works%20fine.%20But%20now%20I'ld%20like%20to%20update%20these%20tasks%20with%20actions%20'update%20task%20details'%20and%20'update%20task'.%20I%20wrote%20a%20flow%20for%20this%20%3A%20it%20doesn't%20work%20fine.%20I%20used%20'foreach%20action'%20but%20at%20the%20end%20all%20actions%20had%20all%20their%20fields%20identical%20!%26nbsp%3B%26nbsp%3B%20%3A%5C%3C%2Fimg%3E%26nbsp%3B%26nbsp%3B%20And%20it%20seems%20not%20to%20be%20a%20pb%20of%20delay%20between%20each%20action.%26nbsp%3B%20May%20you%20precise%20how%20do%20you%20do%20to%20succeed%20in%20your%20workflow%20%3F%20Thanks%20a%20lot%20for%20your%20response%20!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1021974%22%20slang%3D%22en-US%22%3ERe%3A%20Updating%20a%20planner%20task%20with%20FLOW%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1021974%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F374792%22%20target%3D%22_blank%22%3E%40PhilG44%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDid%20you%20find%20a%20solution%20to%20your%20question%3F%20I%20have%20been%20battling%20for%20the%20last%20few%20hours%20to%20get%20my%20planner%20updated%20from%20an%20excel%20spreadsheet.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1651343%22%20slang%3D%22en-US%22%3ERe%3A%20Updating%20a%20planner%20task%20with%20FLOW%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1651343%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F436158%22%20target%3D%22_blank%22%3E%40MattR1605%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F374792%22%20target%3D%22_blank%22%20rel%3D%22noopener%22%3E%40PhilG44%3C%2FA%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EHey%20guys%2C%20Have%20any%20of%20you%20resolved%20the%20issue%3B%20I%20am%20trying%20to%20do%20the%20same%2C%20update%20planner%20tasks%20from%20an%20excel%20file.%20cannot%20find%20the%20way.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EThanks%20in%20advance%2C%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EPatrick%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

Hello,

 

I am strating using planner and would like to use planner to help customers to easily follow their tickets.

 

to do that i would like :

  • to create planner tasks sending an email : OK
  • to Update planner tasks by sendign emails : I do not see how i can do that, because the only way to update or retrieve tasks information is to give planner the task ID.

Is the any way to get the task ID, from task despription, for exemple?

 

 

thanks

 

 

5 Replies
Highlighted

I found the way : there is just to use the foreach action in flow.

Highlighted
i create the same case , but i found alot of issues .
-update task doesn't work .
-task creation is limited within one plan.
-after around 20 success flow , fail due to limitation in storage , i don't know why
-general limitation in planner
*it doesn't restrict assignee person to change the due data also does't send notification to creator that assignee change time
Highlighted

Hello @Jean-Baptiste JACQUES, is it possible to update tasks directly in Planner from an Excel file ? I created Planner tasks with an Excel file : it works fine. But now I'ld like to update these tasks with actions 'update task details' and 'update task'. I wrote a flow for this : it doesn't work fine. I used 'foreach action' but at the end all actions had all their fields identical !   :\   And it seems not to be a pb of delay between each action.  May you precise how do you do to succeed in your workflow ? Thanks a lot for your response !

Highlighted

Hi @PhilG44 

 

Did you find a solution to your question? I have been battling for the last few hours to get my planner updated from an excel spreadsheet.

 

Thanks in advance

Highlighted

@MattR1605 

@PhilG44 

Hey guys, Have any of you resolved the issue; I am trying to do the same, update planner tasks from an excel file. cannot find the way.

 

Thanks in advance,

 

Patrick