submit form in a forall loop

(0) Share

Report

Posted on by beniwal

120

Hi,

I have this requirement to send email to multiple recipients with a Note.

And this is a many to many type of relationship, so I need to save the note for all the recipients in my sql server.

I am thinking if we can run a loop on the list of recipients and edit the recipient field and save multiple forms in the loop. But inside forall i am not able to do it.

Formula:

ForAll(Gallery.AllItems.id ,If(true,UpdateContext({SelectedID: id }) , SubmitForm(Form9_3)))

I am using "SelectedID" as the default value of "id" field in my form.

Please guide me what to do ? If you have any better idea please suggest 🙂

Thanks,

Mohit

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

K-A-R-L 715 on at

Like (0)

Report
Hi @beniwal ,

I'm pretty sure you should be able to run a function inside a ForAll() by using the semi-colon character (;) to seperate each function.

Can you please run this code and check if it works for you.
ClearCollect( NewCollection1, {Wheels: 2,Type: "Bicyle"}, {Wheels: 3,Type: "Tricycle"}, {Wheels: 4,Type: "Quadricycle"} ); ForAll( NewCollection1, If(Wheels = 2,Collect(TwoWheelCollection, {Type: Type})); If(Wheels = 4,Collect(FourWheelCollection, {Type: Type});SubmitForm(Form1)) )
In your case you need to collect the Items on your gallery.
If(Collection, //Name of Collected Items on Gallery !IsBlank(Collection) //Use your formula UpdateContext({SelectedID: id }); //Updates the SelectedID Varaible on that Screen SubmitForm(Form9_3)) //Submits the Form )
----------------------------------------------------------------------------
Thanks,
K-A-R-L

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If you thought this post was helpful, please give it a Thumbs Up.

Was this reply helpful? Yes No
Verified answer

v-xida-msft on at

Like (0)

Report
Could you please share a bit more about your scenario?

Do you want to submit your form data for each recipient within your Gallery?

Further, could you please share a screenshot about your app's configuration?

Based on the needs that you mentioned, I think the SubmitForm() function could not achieve your needs. As an alternative solution, I think the combination of ForAll function and Patch function could achieve your needs.

I have made a test on my side, please consider take a try with the following workaround:

Set the OnSelect property of the "Submit" button to following:

ForAll( RenameColumns(Gallery.AllItems, "id", "id1"), Patch( 'YourDataSource', /* <-- The 'YourDataSource' represents the data source your Form9_3 connects to */ Defaults('YourDataSource'), { id: id1, Coumn2: Column2FromYourGallery, Column3: Column3FromYourGallery, ... } ) )

Note: The Column2FromYourGallery, Column3FromYourGallery, ... represents the column values from your Gallery. Within the '{}' part of the Patch function, you could reference column values from your Gallery. The id, Column2, Column3, ... represents the columns in your data source (your Form9_3 connects to).

More details about the ForAll function, Patch function and RenameColumns function, please check the following article:

ForAll function

Patch function

RenameColumns function

Best regards,

Hi @beniwal ,

Was this reply helpful? Yes No
beniwal 120 on at

Like (0)

Report

hi @v-xida-msft

Thanks it worked 🙂

Was this reply helpful? Yes No
Sage22 40 on at

Like (0)

Report

I have a new form that I would like to submit 1 or more times based on what number the user selects in a set of radio buttons. How can the Forall function work with the Submitform function?
@v-xida-msft

Was this reply helpful? Yes No