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:
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!
Commentaires