Submit and Patch Function not working

[apeawakening]

I'm creating a one to many relationship using Sharepoint list ,
I'm having a parent form using SubmitForm Function I'm saving the data into the data source , 
On click of button I have SubmitForm(formA);

Patch(

    MhRebooking,

    UpdateIf(

        colGridData,

        Created = Blank(),

        {ID: Blank()}

    )

);
I have grid for collecting all child record into collection name colGridData.
But my collection is not getting patch into my Child SP list
Also 
ForAll(
colGridData As item,
Patch(
MhRebooking,
item,
{
ParentID: varRecord.ID,
MHRebooking_Status: {Value: "Waiting For Department head Approval"},
Personnel_No: varRecord.'Personnel No.',
EmployeeName: {
'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
Claims: Office365Users.UserProfileV2(varRecord.'Employee Name'.Email).displayName,
Department: "",
DisplayName: Office365Users.UserProfileV2(User().Email).displayName,
Email: Office365Users.UserProfileV2(User().Email).mail,
JobTitle: "",
Picture: ""
}
}
)
);
Also I want to patch ParentId column which is there in child SP list with parent ID is not working
Please help me with it

[v-jefferni · Accepted solution]

Hi @apeawakening ,

Please try and use below formula OnSelect of the Submit button if you would like to create child list items along with parent list item:

SubmitForm(formA);
Set(varRecord, formA.LastSubmit);
ForAll(
colGridData As item,
Patch(
MhRebooking,
Defaults(MhRebooking),
{
ParentID: varRecord.ID,
MHRebooking_Status: {Value: "Waiting For Department head Approval"},
Personnel_No: varRecord.'Personnel No.',
EmployeeName: {
Claims: varRecord.'Employee Name'.Email,
Department: "",
DisplayName: varRecord.'Employee Name'.DisplayName
Email: varRecord.'Employee Name'.Email,
JobTitle: "",
Picture: ""
}
}
)
);

Best regards,

[mmbr1606 · Accepted solution]

hey @apeawakening 

you can also try this version if the first suggested does not work:

ForAll(
    colGridData As item,
    Patch(
        MhRebooking,
        Defaults(MhRebooking), // Use Defaults function if you are creating new records
        {
            ParentID: varRecord.ID,
            MHRebooking_Status: {Value: "Waiting For Department head Approval"},
            Personnel_No: varRecord.'Personnel No.',
            EmployeeName: {
                '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
                Claims: Office365Users.UserProfileV2(varRecord.'Employee Name'.Email).displayName,
                Department: "",
                DisplayName: Office365Users.UserProfileV2(User().Email).displayName,
                Email: Office365Users.UserProfileV2(User().Email).mail,
                JobTitle: "",
                Picture: ""
            },
            // Other fields from item as needed
        }
    )
);

Let me know if my answer helped solving your issue.

If it did please accept as solution and give it a thumbs up so we can help others in the community.



Greetings

[MarkBandR · Accepted solution]

Hi @apeawakening 

The only thing I would add because you already have great answers from @v-jefferni and @mmbr1606  is that you should put the "ForAll" code in the "OnSuccess" property of you form so it is only being called when the SubmitForm has succeeded.

From the code that @v-jefferni  provided, you want to make sure you are getting the last item submitted using the code: 

Set(varRecord, formA.LastSubmit);

This should also go in the "OnSuccess" property and will only run when the form submitted successfully.

Here is a great article by Matthew Devaney that talks about both of these things and has some other great tips:

https://www.matthewdevaney.com/10-things-you-should-know-about-power-apps-forms/

If someone was able to answer your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response or any of the others from users that took the time to try to help you, please consider giving it a thumbs up.

Thanks.

-Mark

[apeawakening]

Thank you @mmbr1606 for the input, formula is working perfectly , but for me colgrid collection that stores data from Gallery grid, is not getting patch, but when I copied that same collection into a new collection and then I tried the to patch using same ForAll function it worked , I really dont know how and why ,if you help me understand this behavior , I would love to hear and get guidance from you

[apeawakening]

Thank you @v-jefferni  for your input, formula is working perfectly , but for me colgrid collection that stores data from Gallery grid, is not getting patch, but when I copied that same collection into a new collection and then I tried the to patch using same ForAll function it worked , I really dont know how and why ,if you help me understand this behavior , I would love to hear and get guidance from you