Forum Discussion

chudson002's avatar
chudson002
Brass Contributor
Dec 08, 2021
Solved

SUBMITTING MULTIPLE FORMS

Hello Community.

Current issue...Complete Form 1, submits - Forms 1 & 2 submits - Form 2 was not completed

Complete Forms 1 & 2, submits - Forms 1, 2 & 3 submits - Form 3 was not completed... and so forth

 

Need to submit only the forms that are completed. 

If(IsBlank(QtrSel1.Selected.Value), SubmitForm(Form1), !SubmitForm(Form1);

If(IsBlank(QtrSel2.Selected.Value), SubmitForm(Form2), !SubmitForm(Form2);

If(IsBlank(QtrSel3.Selected.Value), SubmitForm(Form3), !SubmitForm(Form3);

If(IsBlank(QtrSel4.Selected.Value), SubmitForm(Form4), !SubmitForm(Form4);

If(IsBlank(QtrSel5.Selected.Value), SubmitForm(Form5), !SubmitForm(Form5);

 

Any recommendations?

Thanks,

chudson002

PowerApps
  • chudson002's avatar
    chudson002
    Dec 09, 2021
    BrendanE1535,
    Thanks for the assistance. It put me further than I was.
    The above submitted every form "except" the one that was filled out.
    Did the above and added (!) .... and it all works perfectly!!
    If(!IsBlank(QtrSel1.Selected.Value), SubmitForm(Form1));
    If(!IsBlank(QtrSel2.Selected.Value), SubmitForm(Form2));
    If(!IsBlank(QtrSel3.Selected.Value), SubmitForm(Form3));
    If(!IsBlank(QtrSel4.Selected.Value), SubmitForm(Form4));
    If(!IsBlank(QtrSel5.Selected.Value), SubmitForm(Form5));

    Thanks again for your assistance. This app is now fully functional and can move on to the next one.
    Appreciate your guidance.

    V/R
    chudson002

2 Replies

  • BrendanE1535's avatar
    BrendanE1535
    Copper Contributor
    Dec 09, 2021

    Hi chudson002 ,

     

    Assuming that "IsBlank(QtrSel1.Selected.Value)" indicates that Form 1 has been filled out?

     

    If so: 

    If(IsBlank(QtrSel1.Selected.Value), SubmitForm(Form1));

If(IsBlank(QtrSel2.Selected.Value), SubmitForm(Form2));

If(IsBlank(QtrSel3.Selected.Value), SubmitForm(Form3));

If(IsBlank(QtrSel4.Selected.Value), SubmitForm(Form4));

If(IsBlank(QtrSel5.Selected.Value), SubmitForm(Form5));

     

    • chudson002's avatar
      chudson002
      Brass Contributor
      Dec 09, 2021
      BrendanE1535,
      Thanks for the assistance. It put me further than I was.
      The above submitted every form "except" the one that was filled out.
      Did the above and added (!) .... and it all works perfectly!!
      If(!IsBlank(QtrSel1.Selected.Value), SubmitForm(Form1));
      If(!IsBlank(QtrSel2.Selected.Value), SubmitForm(Form2));
      If(!IsBlank(QtrSel3.Selected.Value), SubmitForm(Form3));
      If(!IsBlank(QtrSel4.Selected.Value), SubmitForm(Form4));
      If(!IsBlank(QtrSel5.Selected.Value), SubmitForm(Form5));

      Thanks again for your assistance. This app is now fully functional and can move on to the next one.
      Appreciate your guidance.

      V/R
      chudson002

Resources