How to unrelate in a forall loop

[dave-jorgensen1]

I have two related entities, let's call them Parent 1-to-many Child.
Assume I have a field in the Child record called ParentRecordId, that holds the Id of the Parent record

I have a collection of Child records that I am iterating through in a ForAll
What I want to do is Unrelate the children in the collection from the parent

What I'm trying to do is:
ForAll(ChildRecords,

  Unrelate(LookUp(ParentRecords, ParentId=ParentRecordId).OneToManyRelationship,ThisRecord)

)

and that throws error on the OneToManyRelationship of "The specified column is not accessible in this context"

What doesn't throw an error (but obviously doesn't work for my purposes) is 

ForAll(ChildRecords,

  Unrelate(First(ParentRecords).OneToManyRelationship,ThisRecord)

)

So it's not a problem with the relationship column, it's doing a LookUp inside a ForAll loop to get the parent record that's the problem. Any suggestions?

[v-xida-msft]

Hi @dave-jorgensen1 ,

Does the 'ParentRecords' represents your Parent CDS Entity?

Does the 'ParentRecordId' field store the Unique Identifier GUID value of Parent Entity records? Is it a Text type column in your Child Entity?

Regarding the formula that you provided, I think there is something wrong with your LookUp function. The 'ParentRecordId' field in your Child Entity is a Text type column, but the ParentId in your Parent Entity would be a 'GUID' type column (Unique Identifier type column), you could not compare a Text type value with a 'GUID' type value directly in canvas app.

Please consider modify your first formula as below:

ForAll(
       ChildRecords As LoopRecord,
       Unrelate(
                 LookUp('Parent Entity', 'Unique Identifier Column' = GUID(LoopRecord.ParentRecordId)).OneToManyRelationship,
                 LoopRecord
       )
)

Note: The 'Unique Identifier Column' represents the Unique Identifier type column in your Parent Entity, which could identify one record uniquely. You should replace it with actual column name from your Parent Entity.

Please take a try with above solution, then check if the issue is solved.

Regards,

[dave-jorgensen1]

Thanks for your reply.

there is nothing wrong with the formula, it's using the lookup function that is the issue. PS I was using pseudo code to demonstrate the bug.

Lookup function should return the first record that matches criteria, yes?

The record returned from "LookUp" function should be no different schema than the record returned from "First" function, yes?

But using LookUp creates an error whereas using First doesn't.

this is what I did to get around the bug. I do the LookUp, add the value there to a collection, then use Last() on that collection.

Look at that closely. I should be able to replace "Last(TraxCountTable)" with "LookUp(ProgramTraxes_v2,'MDM Launch ID' = cr6e6_mdmlaunchid)" as they literally are the same thing, but I can't, and that's the bug.

ForAll(
    StartingProgramProjects,
    If(
        Not(cr6e6_gsc_projectname in MDMProgramProjectsv2.cr6e6_gsc_projectname),
        Collect(
            TraxCountTable,
            LookUp(
                ProgramTraxes_v2,
                'MDM Launch ID' = cr6e6_mdmlaunchid
            )
        );
        Unrelate(
            Last(TraxCountTable).cr6e6_MAG_MDM_Trax_MAG_Trax_Projects_cr6e,
            ThisRecord
        );
    )
);

[mthenot]

Hello,

I face exactly the same issue with a Relate instead of an UnRelate

For one record, it works

Relate(
LookUp(
'Market Engagement Accounts',
'Account GUID' = Text(First(cbOpptyLookup.SelectedItems).Account.Account)
).'Market Engagement Opportunities',
LookUp(
'Market Engagement Opportunities',
'Opportunity GUID' = Text(First(cbOpptyLookup.SelectedItems).Opportunity)
)
);

 Inside the ForAll, I'm getting the error "The specified column is not accessible in this context"

ForAll(
cbOpptyLookup.SelectedItems As Opp,
Relate(
LookUp(
'Market Engagement Accounts',
'Account GUID'= Text(Opp.Account.Account)
).'Market Engagement Opportunities',
LookUp(
'Market Engagement Opportunities',
'Opportunity GUID' = Text(Opp.Opportunity)
)
)
);

Any ideas?

The odd thing is that using the same logic on a n:n relationship works fine...

ForAll(
cbOpptyLookup.SelectedItems As Oppties,
Relate(
LookUp(
'Market Engagements',
Engagement = [@ModelDrivenFormIntegration].Item.Engagement
).'Market Engagement Opportunities',
LookUp(
'Market Engagement Opportunities',
'Opportunity GUID' = Text(Oppties.Opportunity)
)
)
);