web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Patch a Field on the c...

Power Apps

Answered

Patch a Field on the current record in a Form (Sharepoint List)

(0) Share

Report

Report

Posted on by kriscachia

73

Hi all,

I am a bit new to the patch function and I basically have a form (called Form1😞

- Sharepoint List called RRF

- Field i need to update is called 'RRF Status'

- ID of the list is called 'RRF ID'

how do i: Patch('RRF' lookup the current record on form based on RRF ID, and update the RRF Status field with this text: "RRF Complete")

any help would be appreciated 🙂

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (1)

Sort by

Verified answer

v-mengmli-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @kriscachia ,

I assume that the RRF Status is text column.
About how to update data in Item of Form to List:
OnSelect of a button: SubmitForm(FormName)
Or
Patch(ListName,LookUp(ListName,'RRF ID'=Form.Updates.'RRF ID'),{'RRF Status':"RRF Complete"})

Best regards,
Rimmon

Was this reply helpful? Yes No
kriscachia 73 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi v-mengmli-msft

Thanks for your reply.

I put the patch command on the select of a button and it worked, The RRF Status is showing As RRF Complete

However for some reasons when i Submit(Form1) to save the data, its clearing out the RRF Complete and blanks it out.
The RRF Status field has Parent.Default setting. I dont know if thats correct. Maybe its causing the value to be blanked on save?

Any ideas

cheers

Was this reply helpful? Yes No
v-mengmli-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @kriscachia ,

Do you mean that data in Form display when you submit the form? This may have something to do with the settings of your Form and DataCard. Please check the mode of Form is "Edit".
If my previous answer worked for you, I hope you can accept it as a solution.😊

Thanks.
Rimmon

Was this reply helpful? Yes No

Join the conversation