Answered

Patch function patching row below

(0) Share

Report

Posted on by quinncain

I'm having a problem with my patch function. There is an if statement that determines whether or not the patch function creates a new row or updates an existing row in my table. Creating a new row works, but for some reason when updating an existing row the row below the one selected in my gallery control is being modified rather than the row that was selected in the gallery. Here is the code I am using to patch the table:

UpdateContext({tempsave:1}) ; If(NewGate = 2, Patch('datasource', {cpcId:Gallery1.Selected.cpcId}, SummaryFormLCG1.Updates, PlanningFormLCG1.Updates, FinancialsFormLCG1.Updates), Patch('datasource', Defaults('datasource'), SummaryFormLCG1.Updates, PlanningFormLCG1.Updates, FinancialsFormLCG1.Updates))

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

quinncain 59 on at

Like (0)

Report
Copy link

Link copied!

It could also be noted that cpcId is the primary key. It is incremental and generated whenever a new row is added to the table.

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!
@quinncain

UpdateContext({tempsave:1}); If( NewGate = 2, Patch( 'datasource', cpcId=Gallery1.Selected.cpcId, SummaryFormLCG1.Updates, PlanningFormLCG1.Updates, FinancialsFormLCG1.Updates ), Patch( 'datasource', Defaults('datasource'), SummaryFormLCG1.Updates, PlanningFormLCG1.Updates, FinancialsFormLCG1.Updates ) )

Was this reply helpful? Yes No
quinncain 59 on at

Like (0)

Report
Copy link

Link copied!

@Drrickryp
Thank you formatting this in a more readable way. I am having trouble with this still though. There is an error on "cpcId=Gallery1.Selected.cpcId". The error I got on this was "cpcId" not recognized. I created a datacard on my one of the forms that is passed the cpcId of the row selected from the gallery, and realized that comparing that to the database would just be a boolean true or false and not a record being selected from the table. How can I select a record/row based on matching the cpcId of the form being edited to a row in the table?

Was this reply helpful? Yes No
Verified answer

Drrickryp Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

@quinncain

It should be Lookup(datasource, cpcid=Gallery1.Selected.cpcid) or maybe just

Lookup(datasource, ID=Gallery1.Selected.ID)

Was this reply helpful? Yes No
quinncain 59 on at

Like (0)

Report
Copy link

Link copied!

This works. I feel really dumb; Gallery1 is a different gallery for a different function on my app, and since I wasn't selecting from there the updates just kept posting to the same row. Thank you for your help and being so patient.

Was this reply helpful? Yes No