Answered

Patch to Update Existing Record - SharePoint List Data Source

Like (0) Share

Report

Posted on 28 Apr 2021 15:55:41 by Community Power Pla...

I have an occasion to use Patch() to update an existing record outside of the context of a form or a gallery. I have a file uploader using an attachment control and when upload is successful (i.e., OnAddFile), I need to execute a Patch() to update a choice field, 'Status' in SP. My issue is that Power Apps does not recognize 'Title' the default single line text column inherent with every SP list. The formula throws an error saying it does not recognize the Title as a valid column in the SP list. The dropdownOppName.Selected.Title is working and retrieving the correct record so it's just the Title column is not recognized. Any recommendations?

Patch('Signatures', 'Title' = dropdownOppName.Selected.Title, {Status.Value: 'Contract Docs Received'})

Categories:

General Questions

All responses (5)

Answers (1)

andrewmccourt64 14 on 13 Jul 2022 at 13:58:39

Like (1)

Report

Re: Patch to Update Existing Record - SharePoint List Data Source

How can you get this to work if your base sharepoint list is >10,000 records? Lookup() will only check the top 2000 rows or so won't it?
Community Power Pla... on 29 Apr 2021 at 12:57:18

Like (0)

Report
Re: Patch to Update Existing Record - SharePoint List Data Source

@v-qiuyu-msft - Thank you for the detailed response! You provided the solution as shown below.
Patch('Signatures', LookUp('Signatures','Title' = dropdownOppName.Selected.Title), {Status: {Value: "Contract Docs Receieved"}} )
Verified answer

v-qiaqi@microsoft.com on 29 Apr 2021 at 02:39:57

Like (3)

Report
Re: Patch to Update Existing Record - SharePoint List Data Source

Hi @Anonymous,

Do you want to patch an existing record to you SP list?

Could you please share a bit more about the scenario?

Here is a standard Patch function, a base record is required if you want to update an existing record.

Patch( DataSource, BaseRecord, ChangeRecord1 [, ChangeRecord2, … ])

The formula you provided does not have a record, the parameter you referred in invalid.

'Title' = dropdownOppName.Selected.Title

Do you want to update the record that title has the Dropdown selected value?

Please modify your formula as below:

Patch('Signatures', LookUp('Signatures','Title' = dropdownOppName.Selected.Title), {Status: {Value:"xxx"}} )

Note that you should update a Choice column as below

{ChoiceColumn:{Value:"xxx"}}

Note that you should specify a certain value rather than a column name for the Choice column.

Check if it helps.

Regards,

Qi
Community Power Pla... on 28 Apr 2021 at 18:16:05

Like (0)

Report
Re: Patch to Update Existing Record - SharePoint List Data Source

Thanks for the response. That dropdown menu has the Items property set to display OppName while also making related columns available and that is working as expected (see code below). The issue is Title is not recognized within the Patch() formula which is very odd behavior.
Filter(SortByColumns(ShowColumns(colSignatures, "OppName", "OppID", "Status", "DueDate", "SignatureName", "LegalRep", "Requestor", "Title"), "OppName"), Status.Value <> "Archived")
C-Papa 1,836 on 28 Apr 2021 at 16:08:32

Like (0)

Report

Re: Patch to Update Existing Record - SharePoint List Data Source

Does it work if you change
dropdownOppName.Selected.Title
to
dropdownOppName.Selected.Value
or
dropdownOppName.Selected.Result