Question regarding changing a planner task by changing the outlook agenda

[Anonymous]

Hello.

So as the title sugests i have the folowing question, is it possible to update a planner task by changing a task in outlook, or vice versa ( updating the planner task and it updating outlook event automaticaly)

At the moment i have this flow "done" but i can't seem to figure out how to get the flow task ID from the outlook event (as the folowing imagine shows)

It has

When you modify a event > Obtain details of task > update task details.

Is there any way to get the id? 

If so how?

Also is there any way to update the task directly on planner ( for example i want to change the date, or add more team members) and it will update the events on outlook?

Since planner at the moment only has 3 triggers (when a new task is created, when a task is assigned to me and when a task is finished)

[v-bacao-msft]

Hi @Anonymous ,

The Outlook calendar does not include a planner task id, so you cannot specify a task and update it.

Is there any correlation between the Outlook event and Planner task? We need to use the relationship that may exist between them to obtain tasks so that we can achieve the need to update task details.

Hope that makes sense. Please provide more details.

Best Regards,

[Anonymous]

It does make sense but after hours i don't have any idea on how to relate them in order to achieve my end is that any way on how to?

(I have a already function flow that connects planner to outlook calendar, even tho i don't think it's possible to relate outlook to planner that way)

Would you have any idea on how to proceed?

[fchopo]

Hello @Anonymous 

How about storing the Task Id inside the Subject of the event? For example, something like 'Review proposal (107)' where 107 would be the TaskId in Planner.

In this way, you could get the Task Id using some substring functions:

In the first variable, we get the length of the Task Id number (for example, 107 would return 3). In the second one, we read the subject, find the first ocurrence of '(' character and get the number inside it.

The functions used in text are:

 - Get Task Id length: 

sub(sub(indexOf(triggerBody()?['subject'],')'),indexOf(triggerBody()?['subject'],'(')),1)

- Get Task:

int(substring(triggerBody()['subject'],add(indexOf(triggerBody()['subject'],'('),1),variables('taskIdLength')))

Hope it helps!

Ferran

[Anonymous]

@fchopo  i've tried like you posted to give a test and currently i'm having the error 

The inputs of workflow run action 'Initialize_variable_2' of type 'InitializeVariable' are not valid. The variable 'taskIdLength' must be initialized before it can be used inside action 'Initialize_variable_2'.



[fchopo]

@Anonymous You have to use "Initialize variable" action, and not "Set variable" in both cases (before setting a value in a variable, you must always initialize it).

[Anonymous]

@fchopo in my case i'm using initialize variable

[fchopo]

Hi @Anonymous 

Could you share the expressions you are using in both cases? It must be something with them...

[Anonymous]

@fchopo  

First initialize variable:

sub(sub(indexOf(triggerBody()?['subject'],')'),indexOf(triggerBody()?['subject'],'(')),1)

Second initialize varaible:

int(substring(triggerBody()['subject'],add(indexOf(triggerBody()['subject'],'('),1),variables('LarguraID')))

i have passed that error but i have a new one ( ill leave prints with the error)

[fchopo]

The first expression returns "-1", so it means it doesn't find '(' nor ')' characters in the subject field. Therefore, the initialize_variable_2 action can't be executed. Are you testing the flow with an event like "title of the event (1111)" where 1111 should be the task id?

[Anonymous]

Yes i do believe so, i tried testing the event, by changing the date of the event on outlook on the test run

[fchopo]

I tried with an event like this and it works!

Hope it helps!

Ferran

[ChristianAbata]

Hi @Anonymous  what I did to solve this flow is just when I create a task I add the task ID into the tittle or inside the outlook event. Then in the other flow when I modify an outlook event just get the task planner ID.

[Anonymous]

@fchopo Did you change anything?

I've been trying and i get the error what did you do diferently?

[fchopo]

Hello @Anonymous 

I changed nothing. It works with all the information I shared previously:

Don't know what else I can do to help you :S

Ferran

[Anonymous]

Still trying to find the solution...

Since now im back at the office might try the one with the task id on the directly 

@ChristianAbata how did you manage to put the task id on the title for example?

[Anonymous]

@fchopo  the id i get is far diferent from the one you get in my case, im assuming you get 4 numbers i'm getting a big mix of caracthers and numbers.

[Anonymous]

After some tries i'm stuck on this error

The task id ( is still showing numbers and letters, i don't know why) 

@fchopo 

[fchopo · Accepted solution]

Hello @Anonymous 

As the Task Id is a combination of numbers of letters, you don't need to convert it to an integer (int function). Therefore, the expression to get the Task Id should be:

- Get Task:

substring(triggerBody()['subject'],add(indexOf(triggerBody()['subject'],'('),1),variables('taskIdLength'))

Hope it helps!

Ferran

[Anonymous]

@fchopo  I've tried as you said and got this error, i guess it's still indicating it's "interger" i don't know but it's rather complicated