Good afternoon ,
Please, I need your help with this issue that has occurred recently.
The previously my SharePoint list A and List B were setup and worked perfectly since December using the below formulas, this month, List B is NOT loading up as it should do in edit mode. Keeps saying “Getting your data…”
The user is able to populate all 6 forms as a new item, but for 2 and form 3 from List B is not loading up?
List A.
I have 4 forms that are connected to List A, SharePoint Integration customized form, using Data Source bound to List A. For the Item properties of the 4 forms, they are set the same, as follows:
If(IsBlank(SharePointIntegration.Selected) || IsEmpty(SharePointIntegration.Selected),First([@'ListA']),SharePointIntegration.Selected)
List B
For the other 2 forms are bound to List B, and using Data Source bound to List B, users actually won't select anything from List B, the two lists share the same IDs, previously I got help with this setup from the PowerApps Community where I was able to link both list A and List B to use the LookUp function to get the specific List B item based on the selected List A item.
LookUp(ListB, ID = SharePointIntegration.Selected.ID)
I’m also using the Patch function to patch all 6 forms together, again this work perfectly when the user selected a new item to create and when editing the selected item, that the form was able to load up the specified item in both List A and List B
Below is the Patch function used.
If(SharePointForm1.Mode = New,
Patch(ListA, Defaults(ListA),
SharePointForm1.Updates,
SharePointForm4.Updates,
SharePointForm5.Updates,
SharePointForm6.Updates );
Patch(ListB, Defaults(ListB),
SharePointForm2.Updates,
SharePointForm3.Updates),
Patch(ListA, {ID: SharePointIntegration.SelectedListItemID},
SharePointForm1.Updates,
SharePointForm4.Updates,
SharePointForm5.Updates,
SharePointForm6.Updates);
Patch(ListB, {ID: SharePointIntegration.SelectedListItemID},
SharePointForm2.Updates,
SharePointForm3.Updates));
Notify( "Submitted Successfully!",
NotificationType.Success);
Navigate(HomeScreen);
RequestHide();
I would appreciate your help or your feedback as to why the system is now not able to load List B. I haven’t changed any functions or added any new columns to the form.
