Building an automated ticket-system within Teams (Planner)

(0) Share

Report

Posted on by random_IT_Admin

Hello dear power automate community,

I currently have a problem that I hope someone has a solution for.

We're currently using Planner within Teams as our Ticketsystem for internal IT-Requests. Now we would like to make it possible, that users write tickets themselves. My plan was to create a flow with power automate, that turns an ingoing Mail to a shared mailbox ticket@ (exchange online) to a task in planner. I got it to work to that point, that the title and the description are correct. The part I am really struggling with is the attachments. I found a way to save attachments to sharepoint and paste a sharepoint link within the tasks description, but that's not really what I'm looking for. The perfect solution for me would be, that the .eml file of the sent Mail is saved and added to the task as an attachment. Does anyone know, if that is possible and could maybe help me out?

Thanks for every help in advance!

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

Geeks_D 1,169 on at

Like (0)

Report

Hello

Here is a solution @AlanPs1 that fit into the description

https://powerusers.microsoft.com/t5/Power-Automate-Community-Blog/Create-Planner-Task-and-Include-Attachments-From-Outlook-Email/ba-p/245121

Feel free to write back if you encounter any blocker in the flow

Was this reply helpful? Yes No
random_IT_Admin 2 on at

Like (0)

Report

Thanks for your reply!
I think that's pretty much what I currently use. The "problem" is, that I would prefer the original mail to be included as an attachment (.eml) in the task, rather than having a sharepoint link to the attachments of the original mail.

Was this reply helpful? Yes No
acmiller1 2 on at

Like (0)

Report

@random_IT_Admin, I'm not expert enough in Power Automate to give you the full solution but I have created a similar flow and you have to build an Attachment Array that pulls the files from either the SharePoint folder or the underlying OneDrive folder. Then you can add the array in the final attachment field.

Get file properties
Initialize variable type Array
Apply to each value > Get file content > append to array variable

Hope that helps.

Was this reply helpful? Yes No