Power Apps Gallery Issue Please HELP

[reidt1]

Hi there!  

This is my first post so I hope I do ok at explaining my situation!  I'm trying to create a cost center allocation tool at work.  I have several cascading dropdown menus that allow individuals to narrow down the cost center selection by selected a business area (cascade1) in one drop down and then a sub business area (cascade2 based on cascade1) in another cascading drop down.  I then have a gallery with my last cascading dropdown for the Cost Center (cascade3 based on cascade2).  Beside the cost center selection I have a text input for allocation %.  Lastly, I have a safe button with the below formula.  So let's say i select a business area and then go to the sub business area dropdown it only shows the sub business areas based on my first business area selection.  The same goes for the cost center dropdown in the gallery.  It's based off the other two selections.  When i select a cost center and enter an allocation % say 30% i then hit save and it creates me a new cost center dropdown box and allocation % for the next line in the gallery.  I was so excited and thought everything was working great, but when i go to change my first two cascading filters so that i can narrow down my next cost center selection it also changes my first selection in the gallery.  It's almost like i need some type of rule or formula that once i hit the save button it doesn't allow the formula to work from the first gallery fields.  Any help would be greatly appreciated

Patch(CostCenterCollection, ThisItem, {CostCenter1: CostCenterCC.Selected.Value,Allocation1:Value(AllocationCC.Text)});Collect(CostCenterCollection, {CostCenter1: "", Allocation1: 0})

[WarrenBelz]

Hi @reidt1 ,

What is the Default (if a drop-down) or DefaultSelectedItems (if a Combo Box) of the Cost Centre gallery ?

[reidt1]

Hi @WarrenBelz !  Thanks for the quick response.  So i followed this guys youtube video (link below) to get started.  In doing so i created a CoverForm screen with a new button and the below code.  Basically trying to follow the youtube video.  Once i created the gallery I used the default in the below image based on the CostCenter1 I created in the ClearCollect CostCenterCollection.  I don't necessarily know what this means. I was just following the video.

New Button Code:

OnSelect = NewForm(CostCenterForm);ClearCollect(CostCenterCollection, {CostCenter1: "", Allocation1: 0}); Navigate(MasterData,ScreenTransition.Cover)

https://www.youtube.com/watch?v=xgznk4XlPCo&t=7s

[WarrenBelz]

@reidt1 ,

I still need the information I asked for as I believe the issue lies there

[reidt1]

@WarrenBelz I'm so sorry!  I'm so new to powerapps it takes me a minute to figure out what your asking for.  Is this what you want to see? 

[WarrenBelz]

@reidt1 ,

No - I need the combo box in the gallery as that appears to be the issue.

[reidt1]

Hi @WarrenBelz ... Hopefully this is what you're looking for.  If not you may have to tell me where to go to get what you're looking for.  Thank you again for the help!

[reidt1]

.

[WarrenBelz]

@reidt1 ,

That is the Items - I need the DefaultSelectedItems
You can condense your Items to this, but that is not your issue

With(
   {_L6: Len(DataCardValue79.Selected.Value) > 0},
   Sort(
      Distinct(
         AddColumns(
            Filter(
               Table1,
               (_L6 && L6_DESC = DataCardValue79.Selected.Value) ||
               (!_L6 && L5_DESC = DataCardValue75.Selected.Value)
            ),
            "MyField",
            'Cost Center' & " - " & Description
         ),
         MyField
      ),
      Value
   )
)

[reidt1]

.