Unanswered

Linking List A with List B

(0) Share

Report

Posted on by Moe69

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.

Categories:

Using Apps Using Formulas

All responses (3)

Answers (0)

Moe69 on at

Like (0)

Report

Re: Linking List A with List B

Hello Community,
I’m getting desperate for please
Any reasons why I’m getting this error now please
This Patch formula used did work previously, but now its not working due to an error with the Patch formula.
The error points to Network error when using Patch function. The specified record was not found.
I have checked and both lists are connected and the formula that worked previously has not changed or has been touched. However I’m now getting this error now.
I have checked on the web, and no help or advise with this issue.
I have attached a screen shot of the Patch formula and below too.

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:
BrowseGallery1.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 = BrowseGallery1.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: BrowseGallery1.Selected.ID},
SharePointForm1.Updates,
SharePointForm4.Updates,
SharePointForm5.Updates,
SharePointForm6.Updates);

Patch(ListB, {ID:BrowseGallery1.Selected.ID},
SharePointForm2.Updates,
SharePointForm3.Updates));

Please help...

Error With Patch.png
Moe69 on at

Like (0)

Report

Re: Linking List A with List B

Good morning community,
Hi @Rajkumar_18,
Thank you for responding back,
I have taken on board your feedback and checked and I cant find any issues with either the connection or the formula.

However, I’ve even created new lists with different names and again, I’m able to populate all 6 forms when creating a New Item. List B details are showing in the form and I can populate them with details.

The issue is when I put the form is in Edit mode, List A, form 1,4,5 and 6 and showing, but List B form 2 and 3 are not showing still. I’m getting “Getting your data”.

This is very frustrating, as I know the formula did work up until a few weeks ago. any idea of alternative ways perhaps?

Thanking you all in advance
Rajkumar_18 19 on at

Like (0)

Report

Re: Linking List A with List B

Hi @Moe69

Based on the information provided, it is difficult to determine the exact cause of the issue.

However, it is possible that there may be an issue with the connection between List B and PowerApps, or there may be an issue with the formula used to retrieve data from List B.

It is recommended to check the connection and formula used to retrieve data from List B.

Thanks!