Pattern choices
- Child SharePoint list: best for reportable, editable repeating rows.
- Power Apps gallery: best for editing child rows in the app.
- JSON column: acceptable for small, non-reporting data where fidelity matters more than SharePoint views.
- Manual rebuild: best for deep nested repeating structures or relational data that belongs in Dataverse/SQL.
What Form Migrator can do
The analyzer identifies repeating structures and can produce review notes or a first-pass scaffold. The final data architecture should be confirmed by a maker or architect because it affects permissions, reporting, performance, and long-term maintenance.
Questions to answer
- Do users need to add/remove rows after submission?
- Do repeated rows need approvals or workflow of their own?
- Will SharePoint views or reports filter by repeated row values?
- How should child rows be related to the parent item?

