Answered

How to get second record values from Gallery

(0) Share

Report

Posted on by samerhajjar

I have a gallery with an add button to dynamically add records to it. Each record has three dropdowns (company, department, employee) and a number text input to add the daily working hours.

What I want to do is to save these values into an entity with each record in the gallery on a separate row.

So the main question is, how can I get values from second, third... records of the gallery not just the first one.

Thanks for any help.

Categories:

Building Power Apps

All responses (5)

Answers (1)

Sort by

mdevaney 29,993 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
@samerhajjar
The AllItems property of the Gallery will give you access to all the rows.

Gallery1.AllItems

You would build a collection like this:

ClearCollect( colUpload, ForAll(Gallery1.AllItems, { Col1: Dropdown1.Selected.Value, Col2: Dropdown2.Selected.Value, Col3: Dropdown3.Selected.Value, Col4: TextInput4.Text } );

Then you can import the collection into your entity. The column names must match your entity.

Collect(yourEntityName, colUpload)

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."
samerhajjar 25 on at

Like
a
(0)

Report
Copy link

Link copied!

@mdevaney
Thanks for your help.
What you posted is part of what I want to do. I also wonder, when saving the data from the gallery, each row will also have separate data that is outside the gallery (i.e. datepicker, textinput...) saved with it, it would be same date and same text for all gallery rows.
Any idea how to do that? I'm new to powerapps and would appreciate any help.
Thanks.
Verified answer

mdevaney 29,993 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
@samerhajjar

Actually, its done the exact same way. If you reference the name of a datepicker or textinput outside the gallery it gets applied to all rows in the collection 🙂

ClearCollect( colUpload, ForAll(Gallery1.AllItems, { Col1: Dropdown1.Selected.Value, Col2: Dropdown2.Selected.Value, Col3: Dropdown3.Selected.Value, Col4: TextInput4.Text, Col5: DatePicker5.SelectedDate // outside the gallery Col6: TextInput6.Text // outside the gallery } );

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."
kamil_mac 4 on at

Like
a
(0)

Report
Copy link

Link copied!
I have the same problem ;(

When I change the one input field and perform onselect on the button, all values change to the value from the last edited input field.

My collection for creating a Gallery with one Input field:
ClearCollect( test2; { id: "1"; value: varGalleryViewItem.NumerFormy }; { id: "2"; value: varGalleryViewItem.NazwaDetalu }; { id: "3"; value: varGalleryViewItem.Item }; { id: "4"; value: varGalleryViewItem.Wtryskarka } )

Function for OnSelect for a button:
ClearCollect( test2; ForAll(Gallery1.AllItems; { value: CzasCykluZlecenieInput_1.Text; id: id }) );;

My gallery has four row:

When I change the first field to A999999 and click the test button, all values change to the same
kamil_mac 4 on at

Like
a
(0)

Report
Copy link

Link copied!

Znalazłem rozwiązanie, pomógł ten film:
https://learn.microsoft.com/en-us/power-apps/maker/canvas-apps/create-update-collection