Submit button to update all gallery items based on radio button selection

[Anonymous]

Hi,

I am new to powerApps development, want to create a submit button that will update all the gallery items based on radio button selection.

Using below formula to update the SharePoint list, but it is updating all the records based on first selection only. not sure how to do it, can anyone please help.

UpdateIf('Review database accounts', ' Manager Name'= Dropdown1_2.SelectedText.Value && 'Request Status' = Dropdown1.SelectedText.Value, {Action: Radio1.Selected.Value, 'Request Status': "Approved"})

[RandyHayes]

@Anonymous 

Consider the following change to your formula:

ForAll(Filter(yourGallery.AllItems, Radio1.Selected.Value = "Approved"),
    UpdateIf('Review database accounts', 
         ' Manager Name'= Dropdown1_2.SelectedText.Value && 'Request Status' = Dropdown1.SelectedText.Value, 
         {Action: Radio1.Selected.Value, 
          'Request Status': "Approved"
         }
     )
)

If you do not use the AllItems as the basis for your formula, you will only get the first row of your Gallery repeated in all records.

I hope this is helpful for you.

[Anonymous]

Hi @RandyHayes ,

Thanks for your response.

I have updated the formula but still, the result is same. 😞

Regards,

Mayank

[RandyHayes · Accepted solution]

@Anonymous 

Your formula does not appear to be what I had suggested. (with the exception that I notice that your Radio button has "Retain" or "Revoke" now and that would be the filter value rather than "Approved" as I originally suggested). Also, I notice that you are on SharePoint so criteria based on the ID is much more preferable.

ForAll(
    AddColumns(
        Filter(Gallery1.AllItems, 
            Radio1.Selected.Value = "Retain"),
        "id", ID
    ),
    UpdateIf('Review database accounts', 
         ID=id, 
         {Action: Radio1.Selected.Value, 
          'Request Status': "Approved"
         }
     )
)

The formula you have replied back with is still trying to filter outside of the gallery...that will not work.  Please use the formula above and test.

Also, you are filtering on the Manager Name and Status - is there a particular logic to that?  It's fine if there is and we can incorporate that in, but my impression is that you have a list of items, a user click on "Retain" for those that need to be changed and then when you submit, you want all of those to be Updated.  The assumption is that you are already filtering the list by the Manager Name and the Status...in which case there is no need to filter again - AllItem on the Gallery will be a list of all the filtered items.

[Anonymous]

@RandyHayes 

Thank you so much for your assistance.

The below solution works as expected. 🙂

Regards,

Mayank

[LaiCBRE]

it worked for me! I just had to modify some of the parts (not the structure).