Creating a planner task from a flagged outlook email

[tylerlacanle]

Greetings all,

I am currently using the template provided by Microsoft to create planner tasks from flagged emails in outlook.

It works fine, however it creates errors when there are multiple receivers of the email in the 'to' field that are outside the organization.

I am looking for a way to exclude those people from the assigned task id field.

Perhaps something like only assign the task to the email/person whose email has '@corp.test.com' etc.

What's a good way to do this?

Thanks in advance. 

[v-litu-msft · Accepted solution]

Hi @tylerlacanle,

So you want to remove these emails which not contains '@corp.test.com', right? You could refer to the following steps to do it:

split(outputs('Compose'),';')

string('@cory.test.com')

join(body('Filter_array'),';')

Run result:

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[tylerlacanle]

Hi, thanks for the reply!

For the filter array action, what should be the input for the item() function? I am currently stuck on that part.

[tylerlacanle]

"The 'from' property value in the 'query' action inputs is of type 'String'. The value must be an array." The error message that points at the filter action.

[v-litu-msft · Accepted solution]

Hi @tylerlacanle,

There is nothing needs to input in the item() function, it just contains item().

The From field in the Filter query action is output of Compose 2 action.

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[tylerlacanle]

Cheers!