create a ticketing system in SharePoint

I need to create a ticketing system in SharePoint that follows this flow: 1. SharePoint form filled in and submitted (fields include: TASK NAME (single line of text), DEPARTMENT (choice), REQUES...

Microsoft Flow

PowerApps

sharepoint

kenright

Copper Contributor

Dec 11, 2023

Hi Rob_Elliott. Is there a way of adding a people list from an active directory to the form to pick from instead of having to manually input your name and email address, so an email can be sent to the person submitting the form with the details of what they submitted?
🙂

Rob_Elliott

Bronze Contributor

Dec 11, 2023

kenright As they are internal to the organisation Microsoft Forms knows who they are and the flow in Power Automate picks that up, saves their details into the SharePoint list with the user's email address in the Title column:

Then later in the flow there is an action that sends them the email with what they submitted. The details in the email are automatically populated from the columns in the item that was created earlier in the flow. It's all automatic, there's no manual inputting and no need for a person column in the SharePoint list. But there's nothing to stop you adding one.

Rob
Los Gallardos
Microsoft Power Automate Community Super User.
Principal Consultant, SharePoint and Power Platform WSP (and classic 1967 Morris Traveller driver)

Forum Discussion

create a ticketing system in SharePoint

Resources