How to Save Data Input into Canvas App into SharePoint List

(0) Share

Report

Posted on by EH-19031246-0

Hello Everyone!

Probably a very simple question, but I am having trouble finding an answer that matches what I am doing.

I am creating multiple Canvas Apps which all have the same Data Source, a single SharePoint list. Each app contains a different set of fields/columns from the list to capture data for a specific function (details not important to this question). In creating the app(s), I selected Edit Form and then hooked up to the SharePoint list as my Data Source. I added the appropriate fields for each app and then added a button that I am hoping will work as a Submit button. When someone opens the app, fills in the applicable fields, and hits Submit, I would like a new entry to be created in the SharePoint List containing the data they entered.

How do I set up the button to perform this action (save all data input into the app as a new entry in the Data Source SharePoint List)?

Thank you!

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Suggested answer

Pstork1 69,556 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

If you are splitting the fields across multiple apps you'll need to do a couple things

1) have a Unique index field, like ID, that is included as a readonly field in the form

2) Have no Required fields in the SharePoint list, or add any required fields to each form.

If you do those two things you should be able to use the ID to see if the record was created in a different app. If it was use EditForm, if it wasn't use NewForm.

Then you can use SubmitForm() in the button to submit the values entered either as a new record or edits to an existing record.

----------------------------------------------------------------------------------
If this Post helped you, please click "Does this answer your question" and give it a like to help others in the community find the answer too!

Paul Papanek Stork, MVP
Blog: https://www.dontpapanic.com/blog

Was this reply helpful? Yes No
Suggested answer

11manish 3,333 on at

Like
a
(0)

Report
Copy link

Link copied!
To create a new record in a SharePoint list from a Microsoft Power Apps Canvas App:

Set the form’s DefaultMode = FormMode.New

Ensure the form is connected to the correct DataSource (SharePoint list)

Set the button’s OnSelect = SubmitForm(FormName)

Best Practice

Use OnSuccess to show confirmation and reset the form

Use OnFailure to handle errors

This ensures that when users click Submit, a new record is created in the SharePoint list successfully.

Was this reply helpful? Yes No