URGENT!!!!! how on earth can I add multiple colums in a row and add a + sign to add more rows

[asdeev]

Hello PowerUsers!!

In my form, I am trying to add 3 coloums in each row and I want to have the abilily for the users to click (+) or something so the other row with coloums pops up??? 

And then I want to save all those coloums data in the sql. I have 3 coloums (job steps, potential accidents, recomendations) in sql table. I am just so confused of how to do this whole process. I attached my form template and the powerapps form I am working on for the reference.

Any help is very much appreciated!!!!

Thanks a lot!!

[tommyly]

From what I understand, you want the user to be able to enter in values for the 3 columns and when they click a (+) sign, it appends the user-input and is displayed on the screen (among previous entries) right?

In PowerApps, forms are designed to edit a single "record" and galleries are designed to display multiple records (aka "table"). It sounds like you are looking for both functional behaviors.

One way to do this is:

1. Stack a gallery and a form together on the same screen (it doesn't matter which is on top or bottom)
2. Create a button or label for (+). For this example, let's say it's a button
3. In the button's OnSelect property, use the syntax:

   SubmitForm(yourFormName)

4. In the gallery's Item property, type in your datasource name

[asdeev]

I want the users to have an option to enter as many rows as possible for those 3 coloums. For example, if the user decides to have some input in the first coloum which is  "sequence of jobs" and second coloum "potential hazards" for that particular job and "recomended safe procedures" for that job as the third coloum. 

And if they have more than 1 job steps (which is coloum 1 in this case) they should be able to click (+) or some button after the first coloumn to add another job( second row) and their corresponding potential hazards and recommended safe procedures ( as 2nd row's coloums)  . This is a part of my form ( see the picture)

I hope that makes sense?

[BenFetters]

Hi,

I believe the answer might be by using collections and galleries where you can continually add as many as you would like by clicking a button or ,in your case, a "+" button. There are three videos that Shane Young does that have helped me with similar problems like yours. Here is the link to the first one.

Video