Answered

Potential issue with Parent_Lookup inside Patch Statement

(0) Share

Report

Posted on by jharville

Inside the Patch (which is inside the IF statement), the app doesn't seem to be liking the Parent_Lookup statement inside the last pair of curly braces (it runs fine without it). Does anybody have any similar experiences on suggestions for fixes? Thank you! 🙂

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

mdevaney 29,991 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@jharville
Please share the error message you are receiving for the red underlined code section. This information is always gives important clues about what has gone wrong.

---
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
jharville on at

Like
a
(0)

Report
Copy link

Link copied!
Set( varRecord, EditForm1.LastSubmit ); Navigate( BrowseScreen1, Fade ); Notify( "Thank you for submitting this form. It has been sent to approvers for review.", NotificationType.Success ); If( varRecord.FormStatus = "New", Patch( 'Promo Approvals', Defaults('Promo Approvals'), { Title: adCouncilPicker.Selected.DisplayName, Approver: { Claims: adCouncilPicker.Selected.Claims, DisplayName: adCouncilPicker.Selected.DisplayName, Email: adCouncilPicker.Selected.Email, Department: "", JobTitle: "", Picture: "" } } ) );
^^^ the above portion of code runs perfectly fine without the Parent_Lookup line of code

Was this reply helpful? Yes No
jharville on at

Like
a
(0)

Report
Copy link

Link copied!
Set( varRecord, EditForm1.LastSubmit ); Navigate( BrowseScreen1, Fade ); Notify( "Thank you for submitting this form. It has been sent to approvers for review.", NotificationType.Success ); If( varRecord.FormStatus = "New", Patch( 'Promo Approvals', Defaults('Promo Approvals'), { Title: adCouncilPicker.Selected.DisplayName, Approver: { Claims: adCouncilPicker.Selected.Claims, DisplayName: adCouncilPicker.Selected.DisplayName, Email: adCouncilPicker.Selected.Email, Department: "", JobTitle: "", Picture: "" }, Parent_Lookup: {ID: Value(varRecord.ID), Value: varRecord.ID}, Parent_ID: Value(varRecord.ID)} } ) );
^^^ the Parent_Lookup line of code (4th from the bottom) is what throws the error.

Was this reply helpful? Yes No
jharville on at

Like
a
(0)

Report
Copy link

Link copied!

^^^This is the error I get when inserting the Parent_Lookup line of code.

Was this reply helpful? Yes No
Verified answer

jharville on at

Like
a
(0)

Report
Copy link

Link copied!

SOLVED: The issue was that I used "ID" as a variable, when "Id" is the pre-populated variable allowed for use within PowerApps!

Was this reply helpful? Yes No