How to update value to data source in backend

(0) Share

Report

Posted on by StevenZhang

155

Hi,

I am struggling with updaing value to data source in backend which is when I submit a form.

I created a list form and connected to a Sharepoint list as data source, I want to update value to a field automatically in background when user clicking on submit button, tried many of ways but not work. can anyone give some iedas?

Can I use like DataCard.text = "abc" or something like that.

Regards

Steven

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

Meneghino 6,949 on at

Like
a
(0)

Report
Copy link

Link copied!

I never use forms, try Patch() instead.
Some reference here:
https://baizini-it.com/blog/index.php/2017/09/28/powerapps-101-create-your-own-forms/
v-micsh-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @StevenZhang,

Could you please explain a bit for the scenario of updating data?

Which record that you would like to update with, is it the one just submitted by the form control?

If yes, and you would like to modify the value of the newly submitted record, then you could take use of Patch to deal with that.

For example:

Patch(DataSource, EditForm.LastSubmit, {Field:Value})

For form control, the corresponding field is associated with the Form DataCard, and the value needed to update to the proper field is placed at the Update property of the DataCard.

You may take a look at the following article regarding how to deal with Card control and the form control:

Understand data forms in Microsoft PowerApps

Card control in PowerApps

Regards,

Michael
StevenZhang 155 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Michael,

please see picture below, the form connected to a Sharepoint list, I'd like to update "ReqStatus" to "Revised" from current one when user clicking on "Submit" button. tried to use Patch function but did not work.
I don't want user to modify ReqStatus manually.

Regards
Steven
Verified answer

StevenZhang 155 on at

Like
a
(1)

Report
Copy link

Link copied!

Finally I found an approach,
1. Create one more field in Sharepoint list, like Status_internal, set "Revised" as default value.
2. Add the filed in Powerapps editform.
3. Set original filed.udpate = Status_internal. like, Datacard1.update = Datacardvalue2.Selected.
then it will auto-update when user clicks the Submit button.
4. Hide the second Datacard.

Regards
Steven