Hi @nm2023 ,
Please make sure you have a dropdown on your landing screen that displays the list of candidates. This dropdown will be used to select a candidate.
Edit Form Binding:
On the Editform1 and Editform2 screens, make sure they are connected to your SharePoint list "Table 2".
OnSelect Property of the Dropdown:
In the OnSelect property of your dropdown, you need to set the context for the edit forms. You should set the Default property of your edit forms to the selected item from the dropdown. This will load the data of the selected candidate into the edit forms.
EditForm1.Default = Dropdown1.Selected;
EditForm2.Default = Dropdown1.Selected;
Navigate(EditScreen1);
Clear Edit Forms:
You should clear the forms when navigating to the landing screen or when a new candidate is selected. You can do this in the OnVisible property of your landing screen:
ClearCollect(CandidCollection, { Dummy: "Value" });
EditForm1.Default = CandidCollection;
EditForm2.Default = CandidCollection;
With these steps in place, when you select a candidate from the dropdown on the landing screen, it should populate Editform1 and Editform2 with the selected candidate's data.
Thanks!!!
If my response has been helpful in resolving your issue, I would suggest you consider clicking "Accept as solution" and "Give it a thumbs up" as a token of appreciation.