Answered

Duplicate records running Gallery ForAll function

(0) Share

Report

Posted on by RickMclamb365

I read on Google it should be a bug, but not sure the truth.

It is a responsive App. I have a container inside a gallery where I put my controls.
The problem is when I call the ForAll function, instead saving all records from the gallery it is duplicating the last record.

If I do the same without a container (only the Gallery) it works.
Checking the pictures you can see the container inside the gallery, then how it is organized on the screen Treeview, the result (duplicated of the collection "colAllDetails", and finally the body of the function associated to a OnSelect of a button.

Not sure, but as the controls are inside the Container, it can be the reason of the issue. I checked many tutorials on how to create responsive galleries and almost all of then are using the same approach, but none of them run a ForAll.
Does anyone can help me on that?

The code on the OnSelect of the button is below:

Clear(colAllDetails);
Select(Gallery4);
ForAll(
Gallery4.AllItems,
Collect(
colAllDetails,
{
Name: TextInput6.Text,
LastName: TextInput7.Text,
DOB: DatePicker1.SelectedDate,
RelationshipTo: Dropdown2.SelectedText,
BookingReference:TextInput10.Text
}
)
)

Thanks.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (2)

Sort by

Verified answer

cha_cha 4,932 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
Hello @RickMclamb365

I have tried your case and I can confirm that ForAll cannot retrieve row values of controls inside a container. You were right in your suspicion.

Had a play with it and found a work around.

You can add invisible Label that can reference their value to the current row's entry. Below is an example:

Your ForAll code will look like this:

ForAll(Gallery4.AllItems, Collect( colAllDetails, { Name: LabelFirstName.Text, LastName: LabelLastName.Text, DOB: DatePicker2.SelectedDate, RelationshipTo: LabelRelationship.Text, BookingReference: LabelBookingReference.Text } ) )

As for the DatePicker, you can add a hidden date picker outside the container so you use that as reference.

Was this reply helpful? Yes No
Verified answer

RickMclamb365 37 on at

Like
a
(0)

Report
Copy link

Link copied!

Many thanks @cha_cha working perfectly.

Cheers.

Was this reply helpful? Yes No