Answered

Submitting Multiple forms, but excluding blank ones

Like (0) Share

Report

Posted on 12 Sep 2023 19:37:51 by Keegancurrie

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')

All responses (3)

Answers (1)

Verified answer

v-qiaqi@microsoft.com on 14 Sep 2023 at 01:49:20

Like (1)

Report
Re: Submitting Multiple forms, but excluding blank ones

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')
Keegancurrie 96 on 13 Sep 2023 at 11:31:19

Like (0)

Report

Re: Submitting Multiple forms, but excluding blank ones

Hi Qi, really appreciate your response!
So, I think this is approaching the solution, but when I submit two forms at the same time only 1 shows up in my SharePoint list. I should mention that the Job form also needs to be submitted every single time whereas the other four vary. Each submission should create a new row in the SP list using the info from the job form as the first three values - I've included a screenshot of the list to hopefully clear that explanation up a bit. Please feel free to ask whatever comes to mind! Again really appreciate the help.
v-qiaqi@microsoft.com on 13 Sep 2023 at 02:25:51

Like (0)

Report
Re: Submitting Multiple forms, but excluding blank ones

HI @Keegancurrie,

Well, if the Toggle is set to 'NO' then that form doesn't need to be submitted, I think we could write a simple if statement to achieve your need:

Patch('Bridge Close Out List Main', Defaults('Bridge Close Out List Main'),// Assume that you want to create new records If(Toggle_Job,EditFormJob.Updates), If(Toggle_Enviro,EditFormEnviro.Updates), If(Toggle_Conc,EditFormConc.Updates), If(Toggle_Asph,EditFormAsph.Updates), If(Toggle_Site,EditFormSite.Updates) );