Answered

Submitting Multiple forms, but excluding blank ones

(0) Share

Report

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

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

v-qiaqi@microsoft.com on at

Like (0)

Report
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) );

Was this reply helpful? Yes No
Keegancurrie 96 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com on at

Like (1)

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

Was this reply helpful? Yes No