Скачать с ютуб Create a Ticketing System in Sharepoint with Power Automate в хорошем качестве

Create a Ticketing System in Sharepoint with Power Automate

I take you through a way to create a simple yet powerful ticketing/tasking system using only SharePoint and MS Power Automate (MS Flow). The design uses no code and can be be customized to suit your business needs. First create a SharePoint List that will hold the tasks. I created the fields: Status - Choice Field Email Sender - Choice Field Assigned To - Person/Group Field Date Received - Date/Time Field Date Assigned - Date/Time Field Date Completed - Date/Time Field Then we create a Power automate (MS flow) which checks the shared inbox, and creates a list item, attaching the email file to the list item. You can see that flow here: https://www.sharepointpro.com.au/wp-c... We then create views for the Tasker in SharePoint. After this we create another Power Automate (MS flow) that triggers when the item is modified. This Flow updates the status when Assigned To is filled. You can see the flow here: https://www.sharepointpro.com.au/wp-c... Finally we test. More status's, and flows can be created to suit your needs. KPI's and reporting could easily be attached to the data collected here. Also you should consider indexing the status & Assigned To fields to prevent List View Threshold problems in the future. https://www.sharepointpro.com.au Update- In the comments I was asked how you can relate an existing email to task already created assuming it is a reply or a forward. I explain that in a blog here: https://www.sharepointpro.com.au/blog... *UPDATE* A few people have asked about blank .eml files. It should be getting the file contents from the Export Email (v2) action and not the trigger. Mine looks like Outputs(‘Export_Email(V2)’)[‘body’] when you hover over it.