cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Oleh_Z
New Member

Get data from the second list with the same ID

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!

2 REPLIES 2
mahoneypat
Solution Sage
Solution Sage

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





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about the Power Platform, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


v-qiaqi-msft
Community Support
Community Support

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

Best Regards,
Qi

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (5,026)