Connect two forms with a common column

[matteoooooapps]

Hi,

I'm making a form for contract management on PowerApps.

I have two lists:

• Contracts: it contains all the contract information
• Employee Notes: it contains all the contract notes. There are 21 columns: the first one is ContractID, the other twenty coloumns are Note1, Note2, Note3, … and so on.

The two lists have in common the column ContractID.

In the first screen (Screen1) I have an edit form called FormNew for submitting new contracts. Once submitted a form, the information will be stored in the list Contracts. In a second screen (Screen2) I made a gallery (GalleryContract), in which you can search for an existing contract and move to another screen (Screen3). In this third screen there is an edit form called FormOverview (in view mode) which summarises the selected contract information from the list Contracts. I want to add a new form, in the same screen (Screen3), which allows the user to add an note and record it on the Employee Notes list.

I'd like the form to pick the contract ID from the FormOverview and show (in edit form) the selected contract notes.

Can you please point me out how to connect the two forms?

And also, is there a better solution to store the employee notes?

Thank you

[NandiniBhagya20]

Hi,

In your Screen 2 where GalleryContract is there you can add below formula on Select of Gallery => Set(varContractRecord, ThisItem); Navigate(Screen3)
In Screen3, Set the Item property of FormOverview to varContractRecord and Datasource to Contracts.
Below FormOverview you can add new form to capture Employee Notes. To capture any column value from selected Contract you can use varContractRecord.Title or varContractRecord.ID. Just make sure to have one common field in both the lists so it will be easier for you to manage