Skip to main content
Community site session details

Community site session details

Session Id :
Power Pages - Power Apps Portals
Unanswered

How to add Multiple records using single form ?

(0) ShareShare
ReportReport
Posted on by 10

I have a form to enter Goals by an Employee with the fields as Goal Name, Goal Desrciption,Goal Comments..But as the employee will have multiple goals ...Once the employee fills one goal the record is saved in Dataverse table.Again when the employee enter another goal the record should be saved in the same previous record but it should take another column.

Like it should be filled in goal 2 column in dataverse table.

Goal 1 is one column in my dataverse table and gaol2 is another column in same table.

once goal is filled it should be stored in goal1 column and again by using same form when employee fills goal2 it should be stored in goal2.

This is the formThis is the form

 

Thank you

  • Christian Leverenz Profile Picture
    1,214 on at
    Re: How to add Multiple records using single form ?

    Hi @swapnajapatil77 ,

    i am also a little bit confused like @v-jefferni  , may be you explain more 🙂 

     

    I recently finished a project where it really was required to have more than one form on the page. My forms were for the same table, but this is not the issue 🙂

     

    It is simply not supported to have more than one form on one page as the data is saved via post-back. I made a test and when you place more than one form Out Of The Box, you get multiple submitbuttons and each submitbutton will only post his form.

    You can not work around by code, because the submit submits 🙂

     

    How did we achive it: Wepapi to the rescue. 

    You can leverage the basic form building and just hide all submitbuttons. Create your own submitbutton and store the data via the webapi. 

    In your specific case i would go that far not to think about basic forms at all. You can create the html pages on your own and save the data via the webapi.

     

    Another approach could be: create a pcf as a field bound pcf and make use of the injected webapi there. Build the pcf to your needs and store the data via the injected webapi.

    You have to use field-bund stuff because table related pcfs are not supported in portals (yet).

     

    Hope it inspires you to a solution,

      Christian

     

    PS i did not write anything of the above and would never ever recommend to use that approaches 🙂 - ok, seriously: the multi-form approach is not supported and should be handled with care. The liquid and webapi case is fully supported. The pcf idea is a little bit hijacking technology. It works but its a little bit like opening a bottle with a screwdriver: it may work, but - well, you get the story 🙂

  • v-jefferni Profile Picture
    on at
    Re: How to add Multiple records using single form ?

    Hi @swapnajapatil77 ,

     

    When you say "Goal 1 is one column in my dataverse table and goal2 is another column in same table" do you mean in a single line there would be two fields for goal1 and goal2?

     

    But this doesn't make sense. Based on the title of the post, you will have only one column for goals and each record in this table represents for a goal along with its description and comments, and this would be the common practice. You can have an Edit form in New mode so that every time a user submitting the form will generate a new record for that one. 

    SubmitForm(FormName);NewForm(FormName)

     

    Common table structure:

    ID        Goal         Goal_Description        Goal_Comments

    1         Goal1                 abc                              aaa

    2         Goal2                 bcd                              bbb

    3         Goal3                 efg                               ccc

     

    Hope this helps.

     

    Best regards,

    Community Support Team _ Jeffer Ni
    If this post helps, then please consider Accept it as the solution to help the other members find it.

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

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Pages

#1
Lucas001 Profile Picture

Lucas001 60 Super User 2025 Season 1

#2
Fubar Profile Picture

Fubar 55 Super User 2025 Season 1

#3
surya narayanan Profile Picture

surya narayanan 35