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

(1) Share

Report

Posted on 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:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Michael E. Gernaey 53,969 Moderator on at

Like (1)

Report
Copy link

Link copied!
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.

Was this reply helpful? Yes No
I0-23070210-0 20 on at

Like (1)

Report
Copy link

Link copied!

@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.

Was this reply helpful? Yes No
Suggested answer

mstavra 247 on at

Like (1)

Report
Copy link

Link copied!
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);

Was this reply helpful? Yes No
I0-23070210-0 20 on at

Like (1)

Report
Copy link

Link copied!

@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?

Was this reply helpful? Yes No