0

I have the following formula to add a Parent record (IT Access Form - Submission)>> get its ID >> loop through a child collections >> add the child collection and populate the lookup column inside the child record (Active Directory Access):-

Set(VarMasterId,Patch('IT Access Form - Submission',Defaults('IT Access Form - Submission'),
Form1.Updates,
Form2.Updates,
Form3.Updates,
Form4.Updates,
Form5.Updates,
Form6.Updates,
Form8.Updates,
Form9.Updates).ID);

Collect('Active Directory Access',ForAll(colADAccess As _item,
{
Title:_item.Title
,
ITAccessFormSubmission:{'@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
                        Id:VarMasterId,
                        Value:Text(VarMasterId)
                       }
              
}
));

currently the parent record will be added >> and i can see that its Id is been returned ,, and the colADAccess collection do have values.. but the child SharePoint list named Active Directory Access will not get populated.. any advice?

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.