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.
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
Was this reply helpful?YesNo
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.
2
Share
Report
All responses (
Answers (
