Hi @illmatic ,
My Approach works Like below.
You had a multiscreen with multiple Form
First Approach - On YOu Filled the Data for First Form then On Next button you submit the First Form and OnSuccess Property you can get the Last Submit ID.
Set(LastRecord,Form12.LastSubmit)
Now For the rest of the Form Set the DefaultForm Mode Edit.
and in Items Property you can set the last record.
and once the data Filled then Submit this form also, so Once you submit this automatically it will Update the Same Record remaining Field but if the source is different then you can use the last submit ID as Mapping Purpose. and Keep the Form Mode as New.
Second Approach (You can use your Logic) But- For Patching Complex Field Like Lookup Column / Or Choice Column / Or People Group Column then you can use Code Like below -
//For Patching Lookup/Complex Field into SP
'Project Name':{
Id:ProjectID,
Value: Project,
'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference"
}
//For Patching Choices/Complex Field into SP
WorkType:{
Value: WorkType,
'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference"
},
//For Patching People or Group /Complex Field into SP
varCurrentUser = User() function
User: {
'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
Claims: "i:0#.f|membership|"&Lower(varCurrentUser.Email),
DisplayName: varCurrentUser.FullName,
Email: Lower(varCurrentUser.Email),
Picture: varCurrentUser.Image,
Department: "",
JobTitle: ""
}
Thanks,
Vijay
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."-Vijay
