cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
tylerlacanle
Frequent Visitor

Creating a planner task from a flagged outlook email

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. 

2 ACCEPTED SOLUTIONS

Accepted Solutions
v-litu-msft
Community Support
Community Support

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'),';')

Screenshot 2020-10-12 171831.jpg

 

Screenshot 2020-10-12 171845.jpg

 

Run result:

Screenshot 2020-10-12 172119.jpg

 

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.

View solution in original post

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.

View solution in original post

5 REPLIES 5
v-litu-msft
Community Support
Community Support

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'),';')

Screenshot 2020-10-12 171831.jpg

 

Screenshot 2020-10-12 171845.jpg

 

Run result:

Screenshot 2020-10-12 172119.jpg

 

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.

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.

"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.

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.

Cheers!

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Users online (6,001)