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.
Solved! Go to Solution.
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.
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.
Perfect! I wouldn't have thought of Patch. Thank you so much for the quick response.