Power Platform Community Forum Thread Details

Hello!

I've watched multiple videos from @Shanescows and @RezaDorrani and am continuing to run into issues.

I have a gallery that contains a collection:

ClearCollect( colDetailedResourcing, Filter(CanvasImpacts, CanvasId.CanvasId = varEditCanvas.CanvasId));

Gallery Items:

Sort(colDetailedResourcing, FunctionalArea.FunctionalAreaName, SortOrder.Ascending)

The gallery includes each functional area in a label, and a combobox with choices of involvement levels, which is a single-select value. I want to loop through each item in the gallery and get the value from that combobox and update the matching record in my Dataverse table. When I use this formula, it updates each record, but uses the last selected choice for all records instead of updating each one based on it's selected choice.

ForAll(ResourcingGallery_4.AllItems As DETAILEDRESOURCING,Patch(CanvasImpacts,DETAILEDRESOURCING,{ResourceInvolvement: ComboBox4.Selected.Value})

I also attempted the editable grid option with a hidden save button that builds a secondary collection and patches those changes, but ran into errors about conflicts with the network (though I'm not sure how) and I do have some additional logic that autopopulates a default value in the combo boxes, so those wouldn't necessarily get picked up in the secondary collection. There's probably a way around this, but my brain hurts.

Please help! 😀

Categories:

Building Power Apps