Power Apps

Unable to save to child table using Patch with gallery in Powerapps

(1) Share

Report

Posted on by RVoller

222

Hi,

I have a main gallery that links to a child table based on a 'Master ID'.

Filter( 'RV Requests Details','Master ID' = RVUpdate.Selected.'Master ID')

I would like to update fields in the child table and am not able to save using Patch.

The Patch (sample) is as follows:

Patch('RV Requests Update',LookUp('RV Requests Update', ID=Gallery5_1.Selected.ID), 
{
KM:txtKM.Text,  
Term:txtTerm.Text,   
'RV Percent':  txtRVPerc.Text,  
'RV GST Incl':  txtRVGST.Text,  
'End Age':txtEndKm.Text,  
'End KM': txtEndAge.Text,  
'Purchase Price': Value(txtPurchasePrice.Text)
});

Kind regards

Rene Voller

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Vish WR 3,748 on at

Like
a
(1)

Report
Copy link

Link copied!

If(
IsError(
Patch(
'RV Requests Update',
LookUp('RV Requests Update', ID = Gallery5_1.Selected.ID),
{
'Current KM': Value(txtKM.Text),
Term: Value(txtTerm.Text),
'RV Percent': Value(txtRVPerc.Text),
'RV GST Incl': Value(txtRVGST.Text),
'End Age': Value(txtEndAge.Text),
'End KM': Value(txtEndKm.Text),
'Purchase Price': Value(txtPurchasePrice.Text)
}
)
),
Notify("Save failed - check field types or record ID", NotificationType.Error),
Notify("Saved successfully!", NotificationType.Success)
);
Refresh('RV Requests Update');

Was this reply helpful? Yes No
Suggested answer

11manish 3,333 on at

Like
a
(0)

Report
Copy link

Link copied!
you can also try below :

With( { rec: Gallery5_1.Selected }, Patch( 'RV Requests Details', rec, { KM: Value(txtKM.Text), Term: txtTerm.Text, 'RV Percent': Value(txtRVPerc.Text), 'RV GST Incl': Value(txtRVGST.Text), 'End Age': txtEndKm.Text, 'End KM': txtEndAge.Text, 'Purchase Price': Value(txtPurchasePrice.Text) } ) )

If Patch STILL doesn’t work

Check these:

A. ID column mismatch : Make sure you are matching correct key column

SharePoint uses ID

Dataverse uses GUID

B. Permissions issue: List may allow read but not edit
C. Column internal name mismatch

Example:

'RV GST Incl' might actually be:

RV_x0020_GST_x0020_Incl

D. Lookup table confusion

If 'Master ID' is a lookup:
You may need:

'Master ID'.Value = ...

Was this reply helpful? Yes No
Suggested answer

MS.Ragavendar 7,431 Super User 2026 Season 1 on at

Like
a
(2)

Report
Copy link

Link copied!

@RVoller,

The issue is not associated with Master–Child relationship however this could be casting issue with the record you are patching with the table (DataSource).

IfError(

    Patch(

        'RV Requests Update',

Gallery5_1.Selected,

        {

            KM: Value(txtKM.Text),

            Term: Value(txtTerm.Text),

            'RV Percent': Value(txtRVPerc.Text),

            'RV GST Incl': Value(txtRVGST.Text),

            'End KM': Value(txtEndKm.Text),

            'End Age': Value(txtEndAge.Text),

            'Purchase Price': Value(txtPurchasePrice.Text)

        }

    ),

    Notify(

        "Save failed for this record. Please check values.",

        NotificationType.Error

    ),

    Notify(

        "Record saved successfully.",

        NotificationType.Success

    )

)

✅If this helped, please Accept as Solution to help others ❤️ A Like is appreciated 🏷️ Tag @MS.Ragavendar for follow-ups.

Was this reply helpful? Yes No
Vish WR 3,748 on at

Like
a
(1)

Report
Copy link

Link copied!

@RVoller

Just wanted to check in and see if everything is working now. If you still need any help, feel free to let me know.

Vishnu WR

LinkedIn - My Tech Space

Please ✅ Does this answer your question 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 answering Yes to Was this reply helpful? or give it a Like ♥

Was this reply helpful? Yes No