'Office 365 groups mail' connector: how to get the body, attachments of new emails

[efialttes]

Hi!

I'm working on a Proof of Concept with connector 'Office 365 Groups Mail' that is currently in Preview.

My goal is to check if trigger 'When a ne email arrives to a group' or any other related action block can provide me the Subject, Email body, attachmants, DateTime received, as I can do with Outlook, Gmail related triggers.

Since the trigger itself does not provide such info, I have tried to check if either conversation, or thread or related posts store such info with no success in the case of the body (I can just find a PReview with the first characters from Body) and no success in the case of the attachments.

Any suggestions?

Thanx!

[fchopo · Accepted solution]

Hello @efialttes 

You could use MS Graph API to get the "conversations" of a Group using the following url: https://graph.microsoft.com/v1.0/groups/{group_id}/conversations

Therefore, you could create a flow that uses a Graph API call and try to get this information.

Hope it helps!

Ferran

[efialttes]

Thanx for the tip @fchopo !

I have a limitation to use 'Graph API'  the way Laura suggests, since admins in my organization have blocked access end users like me to Active Directory, so I cannot perform app registration 😞

Please also note the preview connector supports 'get conversation' action block, but as far as I understand from the official doc, this object does not provide neither the email body (just a preview, with a limited nr of characters) nor the attachments

https://docs.microsoft.com/en-us/graph/api/group-get-conversation?view=graph-rest-1.0&tabs=http

However, Microsoft has just recently posted an article in the Power Automate Official Blog describing this new connector, and explaining how to get Email body and attachments. I just followed the steps, implementing the branch on the right, and overcome my challenge

https://flow.microsoft.com/es-es/blog/use-our-new-office-365-groups-mail-connector/

So for some reason 'Get a Conversation thread' does not provide value to 'HasPosts' attribute, which was my initial approach.

Thanx!

[VictorIvanidze · Accepted solution]

Hi @efialttes, try to use the premium connector "HTTP with Azure AD"  - it doesn't required to register an application in Azure.

[MacGyver]

Hallo efialttes,

the link: https://flow.microsoft.com/es-es/blog/use-our-new-office-365-groups-mail-connector/

describe how to save the attachments. But not the email body.

And your solution with "Get a thread post:" does not really get the complete message. 

I use "Export email (V2)" with "Post ID" as Message Id and it is working. But I don't really understand from where "Export email (V2)" is taking the email. I'm not following the email of the group in my inbox and the email are send from outside my company. 

I save the email than on SharePoint "Create file" with the ending ".eml".

[rob7785]

I have spent countless hours trying to develop a way to save from groups email to Sp library and that little post ID post ID workaround to use export has done it. you've just become my favourite person lol 

[ThomasSpie]

@rob7785 How did you do it? My loop just gets stuck looking for the post? Can't seem to get this working.

[rob7785]

I haven't worked on this solution for a while, came back to it today to finish it off and it no longer works, Microsoft must have changed something with the connector, very frustrating if I find a new work around will add it here.

[rob7785]

I have managed to create a work around to the issue its not ideal but it works, As the groups mail will no longer export using the outlook connector using Post ID, I had to create another email account for the group email to be forwarded to which can then be exported. Use group mail connectors to forwarduse outlook connectors to find emailExport with outlook connector and creates new File on SPNew file created in location shownOpened email showing contents and attachments.