Get data from the second list with the same ID

[Oleh_Z]

Hi all,

I am a newbie and hope for your help in solving the following problem:

I have two sharepoin lists (sharepointlist1 and sharepointlist2).

These two lists are data sources for PowerAppsForm.

After all the data has been filled in and saved, an ID is assigned in sharepointlist1, which is also added to sharepointlist2 in the ParentItemID column.

I need to get data from sharepointlist2 with ParentItemID = ID (sharepointlist1) when starting an item from sharepointlist1

Sorry for my English.

Thanks!

[mahoneypat]

Please see this article for how to do that.

Parent Child Lists in SharePoint - Klarinet Solutions®, LLC

Also, you could consider using Dataverse for Teams as your datasource where relationships between parent-child tables is much easier.

Regards,

Pat

[v-qiaqi-msft]

Hi @Oleh_Z,

Based on the issue that you mentioned, do you want to populate the field from sharepointlist2 based on the ParentItemID in sharepointlist2?

Could you please share a bit more about the scenario?

I have a test on my side, please take a try as below.

Not sure about the control you have to populate the aimed item value, just assume it as a Text input control.

Set the Default property as below:

LookUp(sharepointlist2,ParentItemID=ThisItem.ID).ColumnName

Hope it could help.

Regards,

Qi