Create SharePoint List item from PowerApps using Power Automate
Another Query from a Client of mine that wondered how they could create a PowerApps to input Data to SharePoint list but didn't want the users to have any access to that list. So how do we do that?
First off, we need an account to trigger the flow. Preferably a Service account (or use your account)
Secondly A SharePoint list!
So let's get started, I'm guessing you already know the basics of PowerApps:
-
Create a PowerApps
-
Add what kind of Input fields you have to use. Label them correctly to make it easier to keep track!
-
Now we create a flow by pressing the flow icon on the left bar and then Creating new flow
-
Create from Blank, you can also use finished templates if you like.
-
Press the new step and then search for Create item
-
Select your SharePoint list and then choose "Ask in Powerapps" for each field you want to input
-
Press save And it should show up in PowerApps
-
Go to your button and press on select, and search for your Flow, Mine is called 'Powerapps -> Create item'.
-
Choose run and input your fields.
-
Save and now it will save it to the list! :-)
-
And this is what the SharePoint List looks like.
Remember to add a reset after inputting as well. This is to clear the information for the user. Also, add a notification or screen to inform the user that it has been saved.