Answered

Couldn't write my MasterID

(0) Share

Report

Posted on by N_Aainism

I tried to patch my repeating table and for submit i wrote this onSelect submit button.

Patch('Travel Request', Defaults('Travel Request'),RequestForm.Updates,RequestForm_1.Updates); Navigate('Thank you',ScreenTransition.Cover);
ForAll(TravelCollection, If(!IsBlank(LineItem), Patch(TravelDetail, Defaults(TravelDetail), {Title:LineItem, EstimatedCost:LineCost, Remark:LineRemark, MasterID:RequestForm_1.LastSubmit.ID})));

All is good, but it just doesn't read my LastSubmit.ID and when passed to sharepoint, the MasterID field is empty. 😭

Thank you so much

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

CNT 10,921 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@N_Aainism LastSubmit.ID will be available only when you use the SubmitForm() function. If you use Patch, use the return value to capture the patched record. Try this,

Set(varPatchedRecord, Patch('Travel Request', Defaults('Travel Request'),RequestForm.Updates,RequestForm_1.Updates)); ForAll(TravelCollection, If(!IsBlank(LineItem), Patch(TravelDetail, Defaults(TravelDetail), {Title:LineItem, EstimatedCost:LineCost, Remark:LineRemark, MasterID:varPatchedRecord.ID})));

Was this reply helpful? Yes No
N_Aainism 4 on at

Like
a
(0)

Report
Copy link

Link copied!

You are a life saver! It works like magic. Thank you so much!
May you have a wonderful life 🙂

Was this reply helpful? Yes No
CNT 10,921 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@N_Aainism Glad to help!

Was this reply helpful? Yes No