Hello all and thank you in advance for your time. I am trying to submit multiple forms simultaneously to the same data source, but excluding the blank forms. Basically, I am creating a checklist of sorts where sometimes all forms need to be filled out but often only 1 or 2 are required and in those cases, I'd like the blank forms to NOT make a blank entry into my Sharepoint backend list.
This is the formula I'm using to submit all the forms to my SP list with one button click, but can't figure out how to exclude blank forms when they don't all have values within them. I also included a screenshot of my forms to give some context. When the Toggle is set to 'NO' then that form doesn't need to be submitted. Thank you!!!
Patch('Bridge Close Out List Main',
Defaults('Bridge Close Out List Main'),// Assume that you want to create new records
EditFormJob.Updates,
EditFormEnviro.Updates
);
Patch('Bridge Close Out List Main',
Defaults('Bridge Close Out List Main'),// Assume that you want to create new records
EditFormJob.Updates,
EditFormConc.Updates
);
Patch('Bridge Close Out List Main',
Defaults('Bridge Close Out List Main'),// Assume that you want to create new records
EditFormJob.Updates,
EditFormAsph.Updates
);
Patch('Bridge Close Out List Main',
Defaults('Bridge Close Out List Main'),// Assume that you want to create new records
EditFormJob.Updates,
EditFormSite.Updates
);
Navigate('Entry Selector')
Hi @Keegancurrie,
I want to explain to you that the formula I provided does patch a single record including info from multi forms.😂
Sorry for that misunderstanding.😅
Since you want to create a new record for each operation and submit job forms every time, we need to modify the formula as below:
Patch('Bridge Close Out List Main',
Defaults('Bridge Close Out List Main'),// Assume that you want to create new records
EditFormJob.Updates,
If(Toggle_Enviro,EditFormEnviro.Updates)
);
Patch('Bridge Close Out List Main',
Defaults('Bridge Close Out List Main'),// Assume that you want to create new records
EditFormJob.Updates,
If(Toggle_Conc,EditFormConc.Updates)
);
Patch('Bridge Close Out List Main',
Defaults('Bridge Close Out List Main'),// Assume that you want to create new records
EditFormJob.Updates,
If(Toggle_Asph,EditFormAsph.Updates)
);
Patch('Bridge Close Out List Main',
Defaults('Bridge Close Out List Main'),// Assume that you want to create new records
EditFormJob.Updates,
If(Toggle_Site,EditFormSite.Updates)
);
Navigate('Entry Selector')
WarrenBelz
637
Most Valuable Professional
stampcoin
570
Super User 2025 Season 2
Power Apps 1919
473