Setup a Request System using SharePoint Lists, Power Apps and Flows

Ever wondered how we can connect SharePoint list data, Power Apps and Flows to create an end-to-end request system? Well, you are just about to find that out in this blog.

Also, you must be wondering 'what is a request system?!' yes,it is a generalized term for the sake of explaining the topics I want to cover here . You can turn this example as per your needs in your project.

The topics that I will be covering as part of this exercise are:

• SharePoint Online

• PowerApps

• Power Automate or Flows

Power Automate and Power Apps work on various data sources in which SharePoint is also a part . To find out or read more about Power Platform read my article here:

https://ashwininbhandari.wixsite.com/website/post/an-introduction-to-microsoft-s-power-platform

Sounds good?! Let's begin then....

> Create a SharePoint list with below list columns:

Note: Changed Title to Email and marked it to non-mandatory.

> To make use of PowerApps form on SharePoint list, go to List Settings -> Under General Settings select Form Settings

> Go to the SharePoint list and start configuring the PowerApps form as shown below:

> After clicking on Customize forms, the below screen appears (this will take few seconds):

The warning message on the top-left of the form says this:

To read more about the warning and how to fix this please refer to: https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/delegation-overview

> Rename the default screen, form and change the background color to:

> Duplicate ViewScreen twice and rename to CreateScreen and EditScreen as shown below:

> Now modify the card properties of CreateSharePointForm1_1 and EditSharePointForm1_1 as shown below:

DisplayMode : Parent.DisplayMode.Edit

> Next Save and Publish the form.

Now, let's create the Flow which triggers an email notification once request is created:

> Follow the below steps to create a new Flow:

> Select "Send a customized email when a new SharePoint list item is added":

At the final step and to test the PowerApps form and Flow, create a SharePoint List item. An email get's triggered to the requester.

Hope you found this helpful!

Sharing is Caring!

Thanks for reading!