Updating Dropdowns in Gallery

[jetlfjsdfag]

Hi,

My sharepoint list uses a power apps form to edit existing records. I am adding a new screen for voting during committee meetings. The Voting screen is accessed by clicking a "Voting" button and navigating to the Voting Screen. The screen has a gallery that shows the names of the members which are pulled from a table in an excel sheet stored on OneDrive. Each of the gallery items has a dropdown with 4 choices ["","Approve","Decline","No Vote"]. When I hit the Save button, it stores the names of the Commitee Members in 1 of 3 Collections based on what dropdown is selected. If the "" is selected, that member is not stored. Those collections are then stored in a corresponding choice column in the sharepoint list. So my record ends up with 3 columns that contain the names of the committee members based on how they voted.  All of that is working.

My issue is trying to populate these dropdowns when returning to this screen to enter more votes or change existing. Right now it just loads all dropdowns as blank. The code below is in the OnSelect for the button that navigates to the voting screen.

ForAll(Committee.AllItems,VoteStatusDropDown_1.Selected.Value=If(Title3_1.Text in 'Approve (Test)_DataCard1'.DataField,"Approve"));
ForAll(Committee.AllItems,VoteStatusDropDown_1.Selected.Value=If(Title3_1.Text in 'Decline (Test)_DataCard1'.DataField,"Decline"));
ForAll(Committee.AllItems,VoteStatusDropDown_1.Selected.Value=If(Title3_1.Text in 'No Vote (Test)_DataCard1'.DataField,"No Vote"));
Navigate(VotingScreen)

The first screen has all the fields from the SharePoint list Visible, the IF statement checks if Title3_1.Text (i.e Steve, Chris, Chuck...) is contained in the DataCard and if true then I want it to set the dropdown to the corresponding value. Right now, nothing is happening, the dropdowns just show up empty. I have tried applying a similar formula to the Default fields for the dropdowns but also no success. My code isn't throwing any errors but it also isn't working so I'm wondering if anyone could provide some help with either getting this to work or restructuring my screens to make this work another way? 

VOTING SCREEN                                   

Voting Screen Gallery with Dropdowns

   Stored Data in Choice Columns (column set to allow for multiple selections)

EDIT* The code below is from the Save button on the Voting screen. This code runs and stores the data successfully.

ClearCollect(ApprovalsCollect,ForAll(Committee.AllItems,If(VoteStatusDropDown_1.Selected.Value="Approve",Title3_1.Text)));
ClearCollect(DeclinesCollect,ForAll(Committee.AllItems,If(VoteStatusDropDown_1.Selected.Value="Decline",Title3_1.Text)));
ClearCollect(AbstainCollect,ForAll(Committee.AllItems,If(VoteStatusDropDown_1.Selected.Value="No Vote",Title3_1.Text)));

Patch('T.I.P.S Request Tracker',LookUp('T.I.P.S Request Tracker','Product Name'= DataCardValue3.Text),{'Approve (Test)':ApprovalsCollect});
Patch('T.I.P.S Request Tracker',LookUp('T.I.P.S Request Tracker','Product Name'= DataCardValue3.Text),{'Decline (Test)':DeclinesCollect});
Patch('T.I.P.S Request Tracker',LookUp('T.I.P.S Request Tracker','Product Name'= DataCardValue3.Text),{'No Vote (Test)':AbstainCollect})

Thanks!

[WarrenBelz]

Hi @jetlfjsdfag ,

I have read this several times and it is still unclear to me what you are doing here, but I will have a go. Where exactly are you using the code you posted - it is not complete, so can you please post the full code with a clearer description of where is it is being generated, the output and where/how this is being used.

[jetlfjsdfag]

Sorry, I will try to clarify the problem. I am trying to set the value of the dropdowns in the gallery based on the existing values in the record. The Sharepoint list column 'Approve (Test)', contains the names Steve, Chris, and Jeb. When I navigate to the Voting Screen using the "Voting" Button, I want the dropdowns in the gallery to be set to "Approve" for those names that are contained in the 'Approve (Test)' column.  The dropdowns are currently empty. I have tried using the default when I navigate to that page. The original code I posted above is in the OnSelect field for the "Voting" button. 

I also added more code to my original post(see above). The image below shows the main screen that contains the voting button. 

Main

[WarrenBelz]

@jetlfjsdfag ,

Your initial issue I believe is that the Patch would create a Record field as you have not used ForAll on the relevant collection. If (as I assume) this is not what you want, you should be able to do the same thing like this

With(
   {
      wVotes:
      ForAll(
         Committee.AllItems,
         {
            Approval:
            If(
               VoteStatusDropDown_1.Selected.Value = "Approve",
               Title3_1.Text
            ),
            Decline:
            If(
               VoteStatusDropDown_1.Selected.Value = "Decline",
               Title3_1.Text
            ),
            NoVote:
            If(
               VoteStatusDropDown_1.Selected.Value = "No Vote",
               Title3_1.Text
            )
         }
      )
   },
   Patch(
      'T.I.P.S Request Tracker',
      LookUp(
         'T.I.P.S Request Tracker',
         'Product Name' = DataCardValue3.Text
      ),
      ForAll(
         wVotes As aPatch,
         {
            'Approve (Test)': aPatch.Approve,
            'Decline (Test)': aPatch.Decline,
            'No Vote (Test)': aPatch.NoVote
         }
      )
   )
)

However, the piece I am still missing is the Items of your drop-downs and I am still not exactly clear on what you need here.

[jetlfjsdfag]

Drop-downs Items= ["","Approve","Decline","No Vote"]

Whenever the form is loaded or atleast when the user navigates to the voting screen, I want to set the selected value of the drop-downs to reflect the record. For any names stored in the 'Approve (Test)' column, their drop-down would be set to "Approve", for names stored in the 'Decline (Test)' column, their drop-down would be set to "Decline". For names stored in the 'No Vote (Test)', their drop-down would be set to "No Vote", and if a name is not in any of the columns, the drop-down would be set to "". 

[WarrenBelz]

@jetlfjsdfag ,

Assuming that gallery is based on the 'T.I.P.S Request Tracker' list, the Default of your Drop-down (I assume it is not a Combo Box)

If(
   !IsBlank(ThisItem.'Approve (Test)'),
   "Approve",
   !IsBlank(ThisItem.'Decline (Test)'),
   "Decline",
   !IsBlank(ThisItem.'No Vote (Test)'),
   "No Vote"
)

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