Unanswered

Very simple question for a beginner

(0) Share

Report

Posted on by water-guy-5

101

I have connected my project to a sharepoint list - the sharepoint list is set up to align with certain inputs within the app I am building.

Let's say I have a column in sharepoint list called "Name of Respondent".

when I input a textbox in the power app, how do I get it to save to the specific column in sharepoint titled "Name of Respondent". I have read up on the patch function, but it feels like that's to save the ENTIRE form and I am confused on how to direct certain inputs with certain sharepoint list columns.

Thanks!

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

zmansuri 6,048 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

SubmitForm is to save entire form. If you want to save just one column. Take a button set it's OnClick property to:

Patch(ListName,Defaults(ListName), {"Name of Respondent":TextInput1.Text})

Was this reply helpful? Yes No
water-guy-5 101 on at

Like
a
(0)

Report
Copy link

Link copied!

There is no OnClick just OnSelect, and when I use that exact formula my sharepoint column name in the " " is not recognized

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@water-guy-5

I'd recommend using a Form over trying to build out all the controls yourself. PowerApps will tie all the record columns and controls together for you. Then a simple SubmitForm will put all the data exactly where it needs.

Building it out yourself just is a lot more work than you need to do.

As for your specific response to the last post, your formula is wrong and the behavioral action is not correct. You would have put this on the OnSelect action of the button:

Patch(ListName, Defaults(ListName), {'Name of Respondent' : TextInput1.Text})

Note, if you are trying to create a record with the above formula every time, then you can also use:

Collect(ListName, {'Name of Respondent' : TextInput1.Text})

I hope this is helpful for you.

Was this reply helpful? Yes No