cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
DaynaLitherland
Level: Powered On

Loading data into display form via the Foreign Key

Hello All!

 

I'm very new to PowerApps, and currently learning the basics. I've created a basic screen with two edit forms, and thanks to the help from Russel on this thread (https://powerusers.microsoft.com/t5/General-Discussion/Creating-a-form-and-pass-through-a-foreign-ke...), I was able to submit my form and create a row in both of my tables by passing through the Primary Key on the Header table, to the Foreign Key on my message table.

 

I now want to load this data in a read-only form. For the header table, which controls everything, and I've done this by speciifying on my header form 'ListOfRequests.Selected' (ListOfRequests is my gallery control on the homepage).

 

How do I then get my second form, the messagedetailform, to show the row where the HeaderId equals the Id on the header form / table? 

 

Any help would be greatly appreciated!

 

Kind Regards,

Dayna

1 ACCEPTED SOLUTION

Accepted Solutions
DaynaLitherland
Level: Powered On

Re: Loading data into display form via the Foreign Key

Hello,

 

I don't think so, as it would be to load the data, rather than what was submitted. If I've misunderstood your suggestion then I apologise. 

 

I managed to get the data in by performing a filter by passing through the Id on the header table as a parameter and querying this on the 'Item' property on the form:

First(Filter('[Request].[MessageDetails]', HeaderId=requestNumber))

Kind Regards,

Dayna

View solution in original post

2 REPLIES 2
Lisabel0
Level 8

Re: Loading data into display form via the Foreign Key

Will messagedetailform.LastSubmit.Id works the same way?

DaynaLitherland
Level: Powered On

Re: Loading data into display form via the Foreign Key

Hello,

 

I don't think so, as it would be to load the data, rather than what was submitted. If I've misunderstood your suggestion then I apologise. 

 

I managed to get the data in by performing a filter by passing through the Id on the header table as a parameter and querying this on the 'Item' property on the form:

First(Filter('[Request].[MessageDetails]', HeaderId=requestNumber))

Kind Regards,

Dayna

View solution in original post

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors
Users Online
Currently online: 345 members 5,412 guests
Please welcome our newest community members: