Prepopulating Form Based On Content From Another Form

[tomasdileo]

I am trying to create a PowerApps Edit Form that is prepopulated based on the information within another form.

I have a dropdown bar connected to an excel data source. When a Position ID is selected, the form below the dropdown is populated with the info located on  that Position IDs row.

To prepopulate the form fields I used this code.

I want to copy the data from the prepopulated form into the form next to it. The data in the unpopulated form is being saved to a SharePoint List. How do I do this? (Excuses the question, I am fairly new to PowerApps)

[MudassarSZ365]

Hi @tomasdileo ,

Set up your first form (Form1) to display the selected data from the dropdown. You've already done this part.

Create context variables when an item is selected in the dropdown. For example, when an item from the dropdown is selected, you can use the OnSelect property of the dropdown to set the context variables:

UpdateContext({
    varPositionTitle: Dropdown1.Selected.PositionTitle,
    varPositionDescription: Dropdown1.Selected.PositionDescription,
    // Add other fields as necessary
});

Set up your second form (Form2) which will save the data to SharePoint. In this form, set the Default property of each data card to the corresponding context variable you've created. For example, for the Position Title card in Form2:

Default: varPositionTitle

Copy the data into the second form when the item in the dropdown is selected. For this, you might want to add a button that, when clicked, submits Form1 and also updates Form2 with the new context variables, or just updates Form2 if Form1 is not meant to be submitted.

SubmitForm(Form1); // If you need to submit the first form
// Update Form2 fields
UpdateContext({
    varPositionTitle: Form1.LastSubmit.PositionTitle,
    varPositionDescription: Form1.LastSubmit.PositionDescription
    // Add other fields as necessary
});

Refresh Form2 after setting the context variables so it shows the latest data

ResetForm(Form2);

If this works for you, please mark it as the "Accepted Solution."