web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details
Power Apps - Building Power Apps
Answered

Submitting Multiple forms, but excluding blank ones

Like (0) ShareShare
ReportReport
Posted on 12 Sep 2023 19:37:51 by 96

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

snip1.PNG

I have the same question (0)
  • Verified answer
    v-qiaqi@microsoft.com Profile Picture
    on 14 Sep 2023 at 01:49:20
    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')
    

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Telen Wang – Community Spotlight

We are honored to recognize Telen Wang as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 637 Most Valuable Professional

#2
stampcoin Profile Picture

stampcoin 570 Super User 2025 Season 2

#3
Power Apps 1919 Profile Picture

Power Apps 1919 473