cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

How to create a function that allows users to create their own items?

Suppose there is a list of information. If the users want to add a new item by clicking the "+" button on the screen and it will be shown at the bottom, how can I do that?

1 REPLY 1
Highlighted
Anonymous
Not applicable

Re: How to create a function that allows users to create their own items?

 

To enter data into a list with PowerApps, the data source must first exist somewhere.  PowerApps does not create data sources, but links to them.  There are a variety of data sources you can connect to.

 

The easiest way to do this is to use one of the creation templates with PowerApps, connect to a data source and let it build the basic screens to view, edit or add data for you.

 

 

Create a blank spreadsheet.

Create three column headers by typing in Title, Author, Description in three separate cells next to each other.

Select the three cells and push ctrl+T to create a table (this is what powerapps will connect to in your spreadsheet)

Make sure the tick-box "My Table has Headers" is ticked, click OK and save your spreadsheet on OneDrive for Business

 

Sign into PowerApps.com (preferably with the same account you used to save the spreadsheet to OD4B).

Select "Create New App" and select the OneDrive for Business template.

Select your spreadsheet, then select the Table you created (should be Table1 if you didn't rename it)

Hit Connect

 

You're done.  PowerApps will connect to your data and set up some screens that will allow you to view, edit, delete or add data to your list.  If you run the app and hit the "+" sign, it will take to you the add item screen and you can add away.

 

If you have an existing app with an existing data source, then just insert an Edit Form on a Screen and link it to your data.

Menu [Insert->Forms->Edit]

With the form selected check the options on the right of the screen and click the database icon to select your data source.

Check the name of the Edit form, (usually an iteration of 'EditForm1', feel free to rename it or leave it as it) then create a button or icon to upload the data and set it's OnSelect value to SubmitForm(youreditformname)

 

When you enter values into the fields and click the button, it will update your source with a new row/item.

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors
Users online (6,511)