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.
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.
To learn more about the Power Platform, follow me on Twitter or subscribe on YouTube.
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:
Hope it could help.
Keep up to date with current events and community announcements in the Power Apps community.
A great place where you can stay up to date with community calls and interact with the speakers.
Check out the latest Community Blog from the community!