Complex two part form has me struggling

(0) Share

Report

Posted on by ConnM

260

Hello

I am trying to convert a paper form into a power app. Its to monitor the pouring of concrete

It will have a top header section of information that is relevant to all pours that day i.e. Location, structure and weather. And then a bottom section for each individual pour i.e. volume, how it did in the testing, time of pour

I want each pour to have a row on SharePoint, with both the shared data and the unique data.

I have a vague idea of a "Start new pour" button that opens up the second form in a new window

Thank you very much for your help

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Drrickryp Super User 2024 Season 1 on at

Like (2)

Report

@ConnM

It sounds like a one to many relationship. You should have a table for jobs and one for pours. The pours table will need a number column, jobID, that links to the ID of the Jobs list. You will need two forms, one for jobs and one for pours.

Was this reply helpful? Yes No
ConnM 260 on at

Like (0)

Report

Thanks for the assistance. I'll do a bit a research on this and see if it clears up my problem

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like (1)

Report

@ConnM

Check out my blog series here starting with the overview Database Design Fundamentals and PowerApps: An Overview

Was this reply helpful? Yes No
ConnM 260 on at

Like (0)

Report

I split the form in two using this solution
Absolute Best Way To Make Multiple Page Forms In Power Apps (matthewdevaney.com)
Then the second part saves and redirects to the second page. The each time it saves both parts of the form are added to my SharePoint list

Was this reply helpful? Yes No