Answered

📃One Multi-step Form + One table & Multiple rows/entries

(0) Share

Report

Posted on by problex

Hi All!

I am working on a Power Page for signing up new customers and need some assistance on the best way to have multiple records created in the same table from the same multistep form.

Issue:

When I fill this out as it is, only the second reference is saved, its as if it is just overwriting the information from the first Reference.

Explanation:

I am using two tables, one for creating the Carrier, and then one for the references. I have the relationship between the two tables working correctly via the multistep form, but I would like to force the user to add multiple References.

Any help would be much appreciated, I have been developing Power Apps since its first inception but have only just started out with Power Pages. I could not find anything online about this, so maybe I am just doing it wrong and should just add reference 1 and reference 2 as columns in the same table.

Thanks!

Josiah

Categories:

Design & build

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

Fubar 8,487 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Not sure how the referees are related to the carrier - but when you need multiple records of the same type I would generally use a subgrid (and if you need to limit the number in the subgrid - or make sure at least 1 exists - add custom validation to count the rows in the grid).

I am assuming a structure like Carrier 1 to many Reference

E.g. first step captures general carrier details, second step would be a different dataverse form/tab for carrier that only has the references subgrid on it. In power pages you then configure the Step that has the subgrid on it to Create/Edit/Delete etc by configuring a Metadata record on the Step (Metadata is available from the Steps 'related' records in the Power Pages Management app).

https://learn.microsoft.com/en-us/power-pages/configure/configure-multistep-form-metadata

https://learn.microsoft.com/en-us/power-pages/configure/configure-multistep-form-subgrid

1 people found this reply helpful.

Was this reply helpful? Yes No
problex 28 on at

Like (0)

Report
Copy link

Link copied!
Thank you @Fubar I ended up using a Subgrid as mentioned, I found the process pretty time consuming but ended up getting it working by doing the following.

Create a form and view for your new table that has a relationship with the master table.

create a new form in the Master table with the subgrid. (It seems that Subgrids only show up on Update forms not Insert)

add form to the multistep form

create a new basic form in Power Pages, select the new table and the form you created in step 1

delete the new form from your page.

go into the multistep form in power pages management

open the new step that was created when we added the subgrid form to the multistep form

create all links and relationships in the Associated Table Reference tab and Record Source in the Form Definition Tab

go to the metadata tab and add the subgrid

at the bottom of the page, add Create, Edit and Delete

Set the form for the Create and Edit steps

Save and close the step

Save and close the Multistep form

Go to Power Pages and create all Permissions, include Child permission for the table relationships.

Sync the page and test it.

I used the validation check provided by @inogic here https://community.powerplatform.com/forums/thread/details/?threadid=9bd04efe-81e5-4dca-a47d-8937df5c8e41

Was this reply helpful? Yes No