Sending Emails to create a conversation

[Nemrock]

Hey there,

I created some kind of ticket-system with the help of Power Automate, Planner, MS forms and Sharepoint. 

Now to give you some background info what's happening when:

1) user fills out the form

2) I create a task in planner

3) an Email will be send informing the user that their task has been created

4) when I'm done working on the task and closing it another Email with the same subject will be send informing the user that his task has been closed and the things that were done

Now to the problem of it:

these 2 emails, although having the same subject, don't get shown as conversation but instead are two separate emails.

Is there a way to fix that? 

I found a thread from 2019 where someone had the same problem and the answer back then was that it isn't possible. But there are many tools available that do exactly that. Like Jira for example.

Regards,

Jan

[v-yujincui-msft · Accepted solution]

Hi @Nemrock ,

Maybe you could consider creating two Flows, the first Flow is used to create a task and send an email, and save the task id and the message id of the mail to the SharePoint List. The second Flow gets the message ID of the previously sent mail in the List by the task id and replies to the mail. In addition, I added a timestamp to the email subject to make sure the subject is unique. 

I have made a simple test for your reference. 

Here is my SharePoint List. 

Flow1: 

formatDateTime(utcNow(),'yyyyMMddhhmmss')

Flow 2:

InternalColumnName eq 'Dynamic Content'

Result Screenshot:

In addition, here is a link for your reference.

https://powerusers.microsoft.com/t5/Building-Flows/Possible-to-get-the-Message-id-from-Send-an-email...

Best Regards,

Charlie Choi

[Nemrock]

Hey @v-yujincui-msft ,

thanks a lot for your response. That's a great workaround and I will definitely look into that.

Haven't considered replying to my own mail 😄

I'll test it within my setup as I do send the mails from a shared mail account and there's no option to reply from a shared mail account so maybe that could be an issue but I'll give it a shot.

Have a great day!

Regards,

Jan

[Nemrock]

Hey @v-yujincui-msft ,

just saw that there's no option to get emails from a shared mailbox so unless I send these mails to me as well (flooding my inbox, which could be solved by a different rule/flow) I have no way of getting the message ID.

And that's a bit too much of a hassle to be honest 😄

But thanks a lot nevertheless !

[v-yujincui-msft]

Hi @Nemrock ,

Maybe you could try as follows: 

Note: Please fill in the shared email address before selecting the folder. 

Flow 1: 

Flow 2: 

Result Screenshot: 

In addition, maybe you could also try to use another Action in Flow 2. 

Best Regards, 
Charlie Choi 

[Nemrock]

Good morning @v-yujincui-msft ,

Update: found the error. I was just stupid and selected "sent items" before entering the shared mailbox adress. I guess power automate now wanted to look into my personal sent items but with email adress of the shared mailbox or sth like that.

I did it again and it worked like a charm!

I did it the way you showed but I receive the following error:

As of May 6, 2020, shared mailbox support was added for certain operations with an optional 'Mailbox address' parameter, allowing you to specify a shared mailbox address for your operation to access. If you were using this operation prior to May 6, 2020, you will need to explicitly update your operations to specify the shared mailbox address. Please follow the Office 365 documentation for more information: https://docs.microsoft.com/en-us/connectors/office365/#shared-mailbox-support

When looking at the past runs the flow did within the get mails task I see the following:

"code": "ErrorInvalidMailboxItemId",

"status": 404,

  Item doesn't belong to the targeted mailbox

Any idea why?

Best Regards,

Jan