How to add an item to a Sharepoint List without a form?

(0) Share

Report

Posted on by anthonys123

457

I have a simple list with the following columns: Firstname, Lastname, Emailaddress.

I've manually built a form in PowerApps that include the text fields: Firstname, Lastname, Emailaddress and a Submit button.

I know I can use the Customize with Power Apps option in SP. I want to create my own form with three text fields and one submit button - because that should be a very simple thing to do and I should know how to do it. I'm sure the instructions are straight forward and readily available but I'm having a hard time finding anything other than "building a form" and "build a simple form" that both utilize the built in Form screen.

So, what's the string to something like,

OnSelect: MySharePointList (NewItem [Firstname(firstname.text), Lastname(lastname.text), Emailaddress(emailaddress.text)]).

Obviously I'm lost with how to build a formula.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

RandyHayes 76,297 Super User 2024 Season 1 on at

Like (2)

Report
@anthonys123

You can use the following to create a record:

Patch(yourDataSource, {FirstName: firstname.Text, LastName: lastname.Text, Emailaddress: emailaddress.Text } )

Since you are not specifying the ID of the record, Patch will know to create the record.

Make sure you are providing any required column values as well.

Note: you will see some show doing this with the Defaults function...however, it is not needed.

I hope this is helpful for you.

Was this reply helpful? Yes No
anthonys123 457 on at

Like (1)

Report

Perfect! I wouldn't have thought of Patch. Thank you so much for the quick response.

Was this reply helpful? Yes No