Loop through Gallery with textboxes and save it item in collection

(2) Share

Report

Posted on by emfuentes27

578

I have a Gallery which Items property is a collection. Each collection item is represented in a Textbox:

Then there are a couple textboxes that are empty by default, and will only be filled later, and other textboxes may be updated. I need to loop through the entire Gallery, ClearCollect the original collection, and recreated with the new textboxes in the collection. I created a button, and OnSelect I added:

ClearCollect(
 ExcellData, //Collection I'm using
 ForAll(
 ImpactSummaryFields.AllItems As Items, //This is the Gallery
 {
 State: Items.StateField.Text,
 County: Items.CountyField.Text,
 FIP: Items.FIPSField.Text,
 MFN: Items.MapFileNameField.Text,
 Crop: Items.CropField.Text,
 SubCounty: Items.SubCountyField.Text,
 CurrentAcres: Items.CurrentAcresField.Text,
 ProposedAcres: Items.ProposedAcresField.Text,
 Percent: Items.PercentageCounty.Text,
 CurrentFSN: Items.CurrentNoFSN.Text,
 ProposedFSN: Items.ProposedNoFSN.Text,
 ChangedFSN: Items.ChangeNoFSN.Text,
 CurrentRate: Items.CurrentRate.Text,
 ProposedRate: Items.ProposedRate.Text,
 }
 )
);

When I click on the button the updates are not added, and some of the rows are removed. What am I doing wrong? Is this even possible?

Thanks.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

WarrenBelz 155,283 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @emfuentes27 ,

Assuming you want all the fields in the Gallery

ClearCollect( ExcellData, ImpactSummaryFields.AllItems )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
StalinPonnusamy Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!
Hi @emfuentes27

I assume you have a Unique ID that represents each row. In my example, I have ID and renaming for name conflict.

ForAll( RenameColumns( ImpactSummaryFields.AllItems, "ID", "NewID" ), Patch( ExcellData, { ID: NewID, State: StateField.Text, County: CountyField.Text //Other fields } ) )

Was this reply helpful? Yes No
emfuentes27 578 on at

Like (0)

Report
Copy link

Link copied!

Thanks @StalinPonnusamy , but there is no Unique ID. Actually, some of the rows just differ in a couple of cell.

Was this reply helpful? Yes No
emfuentes27 578 on at

Like (0)

Report
Copy link

Link copied!

Thanks @WarrenBelz , but, how do I define whick each of the properties? E.g. State, County, etc. I intend to reuse the data, so I need it we'll defined.

Was this reply helpful? Yes No
Verified answer

WarrenBelz 155,283 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

@emfuentes27 ,

You do not need to - all the gallery fields will be collected and available for reference.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No