Power Apps - Building Power Apps

Is It Possible To Use Multiple Forms and Submit To Only One Form

Like (1) Share

Report

Posted on 26 Jul 2024 03:59:57 by I0-23070210-0

Hi, I'm new to edit forms.

Can I use multiple forms for each list in one screen and submit them to only the CGR Quality list? General steps would be appreciated. Thank you.

Categories:

Connectors

Using Apps Using Formulas

Connecting to Data

General Questions

Dataflows

All responses (4)

Answers (0)

I0-23070210-0 20 on 30 Jul 2024 at 01:06:36

Like (1)

Report

Is It Possible To Use Multiple Forms and Submit To Only One Form

@mstavra Hi, thank you for you suggested solution. But may I know where to put all those code? In a OnSelect submit button or what?
Suggested answer

mstavra 247 on 29 Jul 2024 at 07:39:15

Like (1)

Report
Is It Possible To Use Multiple Forms and Submit To Only One Form

Yes, i have done a similar thing where i have 2 forms in a power app screen and i want both to be submitted on the same item. You can do the same for 3 forms etc. I guess the same can be done for different list forms, but you will have to test it.

This is what you need:

// Collect data from Form1 Set( Form1Data, { Title: DataCardValue21.Value, IPDusers: ComboBox4.SelectedItems, BOusers: ComboBox5.SelectedItems, ADusers: ComboBox6.SelectedItems, ComplianceUsers: ComboBox1.SelectedItems, QAUsers: ComboBox2.SelectedItems, CCDUsers: ComboBox3.SelectedItems // Add other fields from Form1 here } ); // Collect data from Form2 Set( Form2Data, { VendorName: DataCardValue11.Value, EvaluationDate: DataCardValue12.SelectedDate, EvaluationEndDate: DataCardValue1.SelectedDate // Add other fields from Form2 here } ); // Combine both data sets Set( CombinedData, { Title: Form1Data.Title, IPDusers: Form1Data.IPDusers, BOusers: Form1Data.BOusers, ADusers: Form1Data.ADusers, ComplianceUsers: Form1Data.ComplianceUsers, QAUsers: Form1Data.QAUsers, CCDUsers: Form1Data.CCDUsers, VendorName: Form2Data.VendorName, EvaluationDate: Form2Data.EvaluationDate, EvaluationEndDate: Form2Data.EvaluationEndDate // Add any other fields that need to be combined } ); // Patch combined data to data source Patch('DataSource', Defaults('DataSource'), CombinedData);
I0-23070210-0 20 on 29 Jul 2024 at 05:17:12

Like (1)

Report

Is It Possible To Use Multiple Forms and Submit To Only One Form

@FLMike

Hi, sorry I don't elaborate enough.

I'm saying to use multiple forms because all the datacard would be from different SharePoint List. As per picture attached above, the lists I want to use are Employee List, Shift List, Machine List, Article List, Customer List, and CGR Quality List. All the fields needed are from different list and the fields will be used in a single screen page. That's why I'm asking I need to use different form for each of the list I want to use right?

I think you already answered my question, I'm just trying to explain to you why I needed to use different forms.
Suggested answer

Michael E. Gernaey 42,466 Super User 2025 Season 1 on 28 Jul 2024 at 03:24:47

Like (1)

Report
Is It Possible To Use Multiple Forms and Submit To Only One Form

Hi,

I do not know what you mean. Why would you use Multiple Forms attached to the same List???

And I do not know what you mean by submit them to only 1 list, that doesn't make sense.

HOWEVER, if what you are saying is, that you want to create multiple Rows in the Same List, so you think adding lets say, 3 Forms and each one be pointed at the same table, and would have the same fields. And you want to click a single Button to submit them ALL (3) to the same table.

Yes this is possible, while I don't know why would do that it is.

Put a single button and in the OnSelect put

Concurrent( SubmitForm(Form1), SubmitForm(Form2), SubmitForm(Form3) );

And with that all 3 are submitted to the same table.