Automated Flow: Create MS planner tasks from incoming email input

[Lina_Ju]

Hi all,

my flow should perform the following:

When I move an email into a specific folder in Outlook, the flow will be triggered. It should then analyze the email-field "To", "CC" and the "Subject" and create several tasks in my MS Planner. The Planner has different columns for different people. If the E-Mail has 3 people in the "To" field, the same task should get created in their planner columns for all of them. The "Subject" field defines the name of the tasks. The E-Mail addresses may differ from mail to mail.
My trigger is "When a new email arrives (V3)", after that I added the action "Get email" but I do not come any further. Which actions need to be performed?

 

[v-yetonggu-msft]

Hi @Lina_Ju ,

When you move a received email to a specific folder, 'When a new email arrives' cannot trigger the flow because the email is not a newly arrived email.
I suggest you change the trigger to 'When an email is flagged', so that you can trigger the flow by moving the received email to a specific folder and marking the email.

In my scenario:

split(triggerOutputs()?['body/toRecipients'],';')
split(items('Apply_to_each'),'@')[0]
length(body('Filter_array'))

Best Regards,

Sunshine Gu

[Lina_Ju]

Dear @v-yetonggu-msft,
thank you that worked but it is not creating any tasks.
Maybe it has to do something with the fact that I needed to enter a custom value in the last part and the Group and Plan ID were not suggested in the Drop Down?
Best,
Lina

 

[v-yetonggu-msft]

Hi @Lina_Ju ,

Why do you need to enter the Group ID and Plan ID manually? Can't I use a drop-down list to select?

Best Regards,

Sunshine Gu

[Lina_Ju]

Hi @v-yetonggu-msft,
I have now chosen it from the drop-down but the tickets are still not created in the planner, although there are no errors in the flow. This is what it currently looks like:

 

 

 

I am not sure why the last part "Apply to each" is skipped.

Best Regards,

Lina

[v-yetonggu-msft]

Hi @Lina_Ju ，

Because the output of the Filter array is empty, the second Apply to each is skipped.
I know where your problem lies.

Your Bucket Name does not contain the person's name before the '@' symbol in the email address.

You can create a compose in the first Apply to each and Put the 'split(items('Apply_to_each'), '@')[0]' expression in, run the flow, look at the output of compose, compare it with the 'BucketName' in the Planner, and check whether there is a correctly named Bucket in the Planner.

If your 'BucketName' has capital letters, it will not work.

Because the names in the email address are all lowercase, the 'BucketName' must be in the same case as the names in the email address.

Could you please post a screenshot of 'BucketName' in your planner?

Best Regards,

Sunshine Gu

[Lina_Ju]

Dear @v-yetonggu-msft,

thanks for your answer, I am not sure if I completely get it.
Here is a screenshot of the buckets in my planner.

Best Regards,
Lina

 

[v-yetonggu-msft]

Hi @Lina_Ju ,

What we use the split function to extract is the name of the recipient. The BucketName in your Planner is office1, 2, 3, etc.

Therefore, there is no record returned in Filter Query whose BucketName is equal to the person's name.

Best Regards,

Sunshine Gu

[Lina_Ju]

Dear @v-yetonggu-msft,

so you mean this split function in the first apply to each filter array should look like this:

 

[Lina_Ju]

Hi @v-yetonggu-msft,

Will you have a chance to check my reply?

Thank you in advance!

[v-yetonggu-msft]

Hi @Lina_Ju ，

The spilt function is to get the name of the person in front of the @ symbol of the email address, and then determine whether the name of the person is equal to the name of the bucket, and if it is equal, create a new task in the bucket.

My Bucket Name:

Your Bucket Name:

The names of the buckets in my Planner are all the names of the recipients, and the names in your buckets are office1,2,3etc.so the filter array keeps showing up empty, and there are no matches, because split function Get the recipient's name.

I did another simple test to descript my idea:

My Archive Inbox:

My Flow:

I added a ‘compose 2’ to Apply to each on the original flow to view the recipient's name more intuitively.

split(triggerOutputs()?['body/toRecipients'],';')
split(items('Apply_to_each'),'@')[0]
length(body('Filter_array'))

I have added a task to each of my two buckets named after recipients:

Best Regards,

Sunshine Gu

[Lina_Ju]

Dear @v-yetonggu-msft,
thank you that helped. Is it also possible to automatically assign the tasks in the buckets to the people?