Enquiry on Sharepoint ticketing system power automate flow

Like (1) Share

Report

Posted on 5 Oct 2024 04:45:13 by AT-05100439-0

Hi Team,

Im trying to setup a ticketing system using sharepoint, Microsoft Forms and Power Automate

1) I need some advise how to allow attachment in Microsoft Forms, and uploaded in SharePoint?

2) Is there a way each time the assigned IT support staff change the status of the ticket or add in updates in the ticket remarks, email will be triggered to the Requestor so that the Requestor is aware of the progress of his ticket.

Thank you

Categories:

Business Process Flows

All responses (1)

Answers (1)

Verified answer

Michael E. Gernaey 42,623 Super User 2025 Season 1 on 06 Oct 2024 at 07:53:45

Like (1)

Report

Enquiry on Sharepoint ticketing system power automate flow

HI

Yes you can do all of that, although.

1) You can easily share attachments into SharePoint, either as an attachment to an item, OR into a Document Library. There are hundreds of examples of this.

--You would need a Triggered Flow for "When a response is submitted" forms action

----Then you grab the Attachment(s) and then use a loop to create them in SharePoint

2) Yes, you can setup another flow that will trigger any time your ticket status changes or the ticket remarks are.

You would use the when an item is created or update Trigger for SharePoint

--Add a Trigger Condition that checks if either of the fields you mentioned have changed, if NOT it won't trigger

----Then use the Send Email and you would have to use a Get Items, to pull back the original REcord in #1, so you can grab the email address to populate to To

-------In the body you can add whatever you want.

Done