Answered

I need help debugging this error on a Patch function

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Here is my Patch statement

Patch(
 'POC Submissions', 
 Gallery1.Selected, 
 {
 Title: SegDropClar_1.SelectedText.Value, 
 SubSegment: SubSegDropClar.SelectedText.Value, 
 Category: CatDropClar.SelectedText.Value, 
 BusinessType: Concat(DropDownListSub, " ~" & BusType & ", " & LOBType & ", " & RType),
 NatureOfTreaty: NatureRadio_1.SelectedText.Value, 
 CancellationType: CancellationRadio_1.SelectedText.Value, 
 Premium: If(IsBlank(FixedPremium_1.Text), PercentPremium_1.Text, FixedPremium_1.Text), 
 CreationDate:Today(), 
 Creator:DataCardValue49.Text, 
 Status: Patch('POC Submissions', Defaults('POC Submissions'), {Status: {Value: "BU Clarification"}})
 }
)

And here is the error I am getting

I have no idea why this isn't working and I've been staring at it for about an hour. Could anyone help me out and point out what I did wrong?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

mdevaney 29,991 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous
You must first isolate which column is giving you the problem. Remove the columns one-by-one until you find what is causing the issue. Let me know once you have identified the trouble 🙂

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
@mdevaney

Hi,

Not sure why I didn't think of that. It appears to be my last column (Status) I have a similar statement in another form and it works there but it is not working here. I went ahead and isolated the problem causer, any ideas on what to do?
Patch ( 'POC Submissions', Gallery1.Selected, { Status: Patch ( 'POC Submissions', Defaults('POC Submissions'), {Status: {Value: "BU Clarification"}} ) } )

Above is the same code as before but only including the statement that is causing issues.

Was this reply helpful? Yes No
Verified answer

mdevaney 29,991 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
@Anonymous
I don't think its possible to PATCH inside a PATCH.

Patch( 'POC Submissions', Gallery1.Selected, {Status:{Value: "BU Clarification"}} )

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No