Unanswered

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

(0) Share

Report

Posted on by 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!!

Categories:

Building Power Apps

form template.PNG

form in powerapps...

I have the same question (0)

All responses (3)

Answers (0)

tly 400 on at

Like (0)

Report
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:
Stack a gallery and a form together on the same screen (it doesn't matter which is on top or bottom)
Create a button or label for (+). For this example, let's say it's a button
In the button's OnSelect property, use the syntax:
SubmitForm(yourFormName)
In the gallery's Item property, type in your datasource name

Was this reply helpful? Yes No
asdeev on at

Like (0)

Report

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?

form.PNG

Was this reply helpful? Yes No
BenFetters on at

Like (0)

Report

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

Was this reply helpful? Yes No