Skip to main content

Notifications

Community site session details

Community site session details

Session Id : JfPuOgIiUGRakCy+t9tiNt
Power Automate - Building Flows
Unanswered

Building an automated ticket-system within Teams (Planner)

Like (0) ShareShare
ReportReport
Posted on 21 Nov 2023 11:51:53 by 2

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!

  • acmiller1 Profile Picture
    2 on 16 Apr 2024 at 16:45:35
    Re: Building an automated ticket-system within Teams (Planner)

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

     

  • random_IT_Admin Profile Picture
    2 on 21 Nov 2023 at 13:38:03
    Re: Building an automated ticket-system within Teams (Planner)

    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.

  • Geeks_D Profile Picture
    1,169 on 21 Nov 2023 at 12:57:50
    Re: Building an automated ticket-system within Teams (Planner)

    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 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Automate - Building Flows

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 66 Super User 2025 Season 1

#2
stampcoin Profile Picture

stampcoin 65

#3
rzaneti Profile Picture

rzaneti 41 Super User 2025 Season 1

Overall leaderboard
Loading started