Unanswered

How to add Multiple records using single form ?

(0) Share

Report

Posted on by swapnajapatil77

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 form

Thank you

Categories:

Power Apps portals

I have the same question (0)

All responses (2)

Answers (0)

v-jefferni on at

Like (0)

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

Was this reply helpful? Yes No
Christian Leverenz 1,214 on at

Like (0)

Report

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 🙂

Was this reply helpful? Yes No