Hello everyone,
Please Lend me your eyes, I need your help and advice please? I have spent the whole week reviewing threads on this site and You Tube and I'm still nowhere near sorting this problem.
I have two forms (Form A) and (Form B) linked to two SharePoint lists (SP List A & SP List B) because the original list exceeded the columns threshold and now, I’ve split the list in half, hence the reason why I’m using two Edit forms.
In total, there are 6 forms within six screens and the setup is as follows,
SP List A - has the following forms, SharePointForm1 (Screen 1), SharePointForm4 (Screen 4), SharePointForm5 (Screen 5), SharePointForm6 (Screen 6),
SP List B - has the following forms, SharePointForm2 (Screen 2), SharePointForm3 (Screen 3),
The problem I have here is this, the below formula only submits (SP List A) but need both forms submitted to SharePoint lists (SP List A & SP List B) together as this will be classed as one item of information on the data form.
And also, is it possible to edit both forms (Form A) and (Form B) at the same time using the above screens setup?
Because all 6 forms are continuous and will be update through different stages.
Please do let me know if you need any more info.
If(
SharePointForm1.Mode = New,
Patch(
ExcelForm,
Defaults(ExcelForm),
SharePointForm1.Updates,
SharePointForm2.Updates,
SharePointForm3.Updates,
SharePointForm4.Updates,
SharePointForm5.Updates,
SharePointForm6.Updates
),
Patch(
ExcelForm,
{ID: SharePointIntegration.SelectedListItemID},
SharePointForm1.Updates,
SharePointForm2.Updates,
SharePointForm3.Updates,
SharePointForm4.Updates,
SharePointForm5.Updates,
SharePointForm6.Updates
)
);
Notify(
"Submitted Successfully!",
NotificationType.Success
);
Navigate(HomeScreen);
RequestHide();
