Answered

Patch Function Not Updating SharePoint List

(0) Share

Report

Posted on by Power_Ninja

I am trying to use the patch function in the OnSuccess property of my Form Control to update the status column in my 'Entry Form' SharePoint list.

For example, when the user completes the form for Phase 1 of the project the power app looks up the relevant project number in the 'Entry Form' and updates the 'Current Phase' to "Phase 1".

I am not getting any errors but it's not updating the list. Any ideas?

Patch(
 'Entry Form',
 LookUp('Entry Form', 'Project Number' = DataCardValue2.Text),
 {
 'Current Phase': {Value: "Phase 1"}
 }
)

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

WarrenBelz 154,889 Most Valuable Professional on at

Like (2)

Report
Copy link

Link copied!
Hi @Power_Ninja ,

The issue I believe is that the content in that control is not available after the form is submitted (assuming it is on the Form). You can use the field name you have just posted as below

Patch( 'Entry Form', LookUp( 'Entry Form', 'Project Number' = Self.LastSubmit.FieldName ), { 'Current Phase': {Value: "Phase 1"} } )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
elseb 774 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hi,

Have you confirmed that the value of

DataCardValue2.Text

Exists in your list?

I'd add Coalesce(LookUp('Entry Form', 'Project Number' = DataCardValue2.Text), Defaults('Entry Form')),

instead of just lookup, that way it will create new record if it wont find existing one and you'll know where the issue is

Was this reply helpful? Yes No
Power_Ninja 38 on at

Like (0)

Report
Copy link

Link copied!

@WarrenBelz you are absolutely right - thank you! It's been a long week.

Was this reply helpful? Yes No