CODEWITHSUNDEEP
formspowerappspowerapps-canvas
Lucy
Lucy

Reputation: 31

PowerApps- how to create a form where users can edit or delete rows that have been submitted

What I have: As of now, I have created a Form (editable) where the user can enter their Name, Number, and Birthday, then hit the submit button, and that data is then entered into a Data Table. This information is also stored into Google Sheets for which I have created a flow. (when the user hits "submit", trigger the data to be updated into the google sheet).

What I need: I would like users to be able to mess with the submitted data in the app itself (add a row, delete a row when you click on it, edit the row's info, etc), so essentially my powerapp is a nice front end for the Google Sheet. Is it possible to mess with the data once it is entered into the data table?

Any help how to do this would be appreciated.

enter image description here

Upvotes: 1

Views: 2052

Answers (1)

Arun Vinoth PrecogTechnologies
Arun Vinoth PrecogTechnologies

Reputation: 22836

I believe you started building Canvas app from scratch, so the screen has list below and "Add screen" on top. This way you have to introduce the Edit screen/operation & save changes using PATCH command.

There is another way: Create an app automatically from your data in PowerApps. This will give you the Browse Screen, Detail Screen & Edit Screen (aka New record screen) by default with all the Create, Read, Update, Delete (CRUD) operations right away using the Connection - Google sheet in your case.

enter image description here

Video tutorial for assistance

Upvotes: 1

Related Questions