Patch multiple new records with Dataverse lookup.

[michaelpaul]

Hello, I am at a bit of a loss on how to do this as it seems like it should work but I suspect there is an issue with the relationships between tables that is causing it to not work. I have an app that we use to track equipment on projects. It contains 2 tables relevant to this inquiry. Equipment and Equipment Projects: They of course contain more columns but I have included the relevant ones as an example

Equipment

Unit Number	Equipment Type	Parent Equipment (lookup from same table)	isAttachment
TRAC1	Tractor		false
BUCK1	Bucket	TRAC1	true
FORK2	Forks	TRAC1	true

Equipment Projects

Project	Start Date	End Date	Equipment(lookup from Equipment Table)
22314	June 1, 2022		TRAC1
22314	June 1, 2022		BUCK1
22314	June 1, 2022		FORK2
22313	May 1, 2022	June 1, 2022	TRAC1
22313	May 1, 2022	June 1, 2022	BUCK1
22313	May 1, 2022	June 1, 2022	FORK2

The problem that I am having is that I need each attachment unit to be tracked with its parent. So when I assign "TRAC1" to a project, it needs to also create a new project record for BUCK1, and FORK1 as in the table above. Similarly, when TRAC1 is done at the project, I need it to also update the attachments.

Currently I have an Equipment details screen: (top black line would be TRAC1, bottom 2 lines would be BUCK1 and FORK1)

When I select 'New Project' the onSelect is:

If(!IsEmpty(AttachmentsGallery),
ClearCollect(colAttachments,AttachmentsGallery.AllItems);Set(varHasAttach,true),
Set(varHasAttach,false)
);
Navigate('New Project',ScreenTransition.None,{cvarUnit: cvarUnit})

Basically creates a collection of the Attachments, navigates to the new project screen, and passes the Parent Unit context variable (cvarUnit) to the next screen. 

On the 'New Project' screen the user inputs the project details in a form to assign the unit to a project:

Then onSelect of the submit button I am trying the following code which submits the form for the parent equipment (TRAC1) just fine but does not patch the new records for the attachments:

SubmitForm(Form8);
    If(varHasAttach,
        ForAll(colAttachments,
            Patch('Equipment Projects',
                Defaults('Equipment Projects'),{
                        Equipment:ThisRecord,
                        Project:ProjectCard.Selected,
                        'Start Date': StartDateCard.Value}
)))

I have tried to use only the Patch on it's own (without the SubmitForm) and it will still not create the new records for the Attachments. I am also getting the following issue:

I am hoping someone is able to tell me what I am doing wrong. 

[michaelpaul · Accepted solution]

So I Managed to get it:

I needed to create a collection from my attachment collection with custom named fields that match the fields in the table that needs the new records. I also needed to use LookUp to pull the Project Record. Then I could do a ForAll for that new collection and it patches the new records:

If(varHasAttach,
 Clear(colAttachNew);
 ForAll(colAttachments,
   Collect(colAttachNew,
      Table(
            {crd13_startdate: DateValue13.Value,
             crd13_project: LookUp(Projects,
                    'Project Number' = DataCardProject.Selected.'Project Number'),
             crd13_equipment: ThisRecord}
)));
 ForAll(colAttachNew,
    Patch('Equipment Projects',
           Defaults('Equipment Projects'),
                {Project: crd13_project,
                'Start Date': crd13_startdate,
                Equipment: crd13_equipment}
)));
SubmitForm(Form8)