News and Announcements icon

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

Power Apps - Building 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 🙂

All responses Img

All responses (3)

Answers Img

Answers (1)

v-mengmli-msft on at

Like (0)

Report

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

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
kriscachia 73 on at

Like (0)

Report

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

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
Verified answer

v-mengmli-msft on at

Like (0)

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

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