Skip to main content

Notifications

Community site session details

Community site session details

Session Id : IsFSe6XlvQs3ZTI1hUPXvX
Power Apps - Building Power Apps
Suggested answer

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

Like (1) ShareShare
ReportReport
Posted on 26 Jul 2024 03:59:57 by 20
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.
  • I0-23070210-0 Profile Picture
    20 on 30 Jul 2024 at 01:06:36
    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 Profile Picture
    247 on 29 Jul 2024 at 07:39:15
    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 Profile Picture
    20 on 29 Jul 2024 at 05:17:12
    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 Profile Picture
    41,832 Super User 2025 Season 1 on 28 Jul 2024 at 03:24:47
    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.
     
     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Apps - Building Power Apps

#1
MS.Ragavendar Profile Picture

MS.Ragavendar 10

#2
LC-26081402-0 Profile Picture

LC-26081402-0 6

#3
EE-04041031-0 Profile Picture

EE-04041031-0 4

Overall leaderboard
Loading started