Store form names in a collection to submit form dynamically

[Lars1990]

Hi all,

I saw a post about being able to dynamically navigate to a screen

ClearCollect(screenIndex,
    { Name: "ScreenA", Screen: ScreenA },
    { Name: "ScreenB", Screen: ScreenB },
    { Name: "ScreenC", Screen: ScreenC },
    { Name: "ScreenD", Screen: ScreenD },
    { Name: "ScreenE", Screen: ScreenE })

Navigate(
    LookUp(screenIndex, Name = ThisItem.Screen).Screen,
    ScreenTransition.Fade)

I would like to do something similar with submiting a form like the example below. Unfortunatly it gives an error in the collection. Anyone with ideas how to do this?

ClearCollect(formIndex,
    { Name: "FormA", Form: FormA},
    { Name: "FormB", Form: FormB },
    { Name: "FormC", Form: FormC },
    { Name: "FormD", Form: FormD },
    { Name: "FormE", Form: FormE })

SubmitForm(
    LookUp(formIndex, Name = varForm).Form)

[RandyHayes · Accepted solution]

@Lars1990 

The problem is that your forms have different schemas to them, so you will not be able to store more than one form in your table.  In other words, it's not the submit form that has the issue, it is the schemas of the forms in your Form column of your table.

Please consider changing your Formula to the following:

SubmitForm(
    Switch(varForm,
        "FormA", FormA,
        "FormB", FormB,
        "FormC", FormC,
        "FormD", FormD,
        "FormE", FormE
    )
)

I hope this is helpful for you.

[Lars1990]

Perfect! Thanks 🙂