Patching Data Highlighting All Rows

(0) Share

Report

Posted on by CC-19121430-0

240

Hello,

Hope you are all good!

I have a gallery that has a checkbox assigned to it.

When the checkbox is selected the row in the gallery is highlighted using:

If(Checkbox1.Value,Color.Yellow, RGBA(0, 0, 0, 0))

This part seems to work as desired, The problem is arising when i go into my 'View info' popup that appears on selection of a 'view info' button (this screen has text input controls for updating info).

When a piece of information is updated and patched back to data source using OnChange:
Patch(tbl_Eng,Gallery1_1.Selected,{'Colleague Category':Skillset_drp.Selected.Value})

I can see when i return to my gallery that all rows are now highlighted not just the selected row.

This only happens if a row is highlighted before entering the popup and amending a textinput, it doesn't occur if the row isn't highlighted prior.

Any help with this is really appreciated, i have had so much trouble with using checkboxes i have really lost confidence with them.

Thank you
Chris

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

BCBuizer 22,496 Super User 2025 Season 2 on at

Like (1)

Report
Re: Patching Data Highlighting All Rows

Hi @Appy1 ,

Try changing the formula for highlighting to:

If(ThisItem.Checkbox1.Value,Color.Yellow, RGBA(0, 0, 0, 0))

Was this reply helpful? Yes No
CC-19121430-0 240 on at

Like (0)

Report

Re: Patching Data Highlighting All Rows

Hi @BCBuizer ,

Thank you so much for your reply and suggestion.

I have given it a go, unfortunately it doesn't seem to highlight the row anymore.

There isn't an error but when i do hover over the formula itself it does say 'The function If has some invalid arguments'

Thanks
Chris

Was this reply helpful? Yes No
BCBuizer 22,496 Super User 2025 Season 2 on at

Like (0)

Report

Re: Patching Data Highlighting All Rows

Hi @Appy1 ,

I was able to replicate the issue and found that whenever the datasource is refreshed (such as after patching it), the gallery will take the checkbox value from before the refresh of the first item in the gallery and apply it to all items, regardless of the current value of their checkboxes.

This is why I suggested to reference the checkbox associated with the item, but that apparently does not work.

I think the only way to make this work is by saving the data source to a collection, add a column in which you save the selection value and then use this column to set the Default property of the checkbox and the TemplateFIll property of the gallery.

If you go for this option, don't forget to update both the data source and collection when making changes.

Was this reply helpful? Yes No