Updating a Gallery generates error

[Greg27]

I have a button that changes the filter on a gallery. My button starts with "Gallery1.Items=Filter(" however, I have a red line under Items and it says "Name isn't valid. This identifier isn't recognized".

[MatthiasL · Accepted solution]

You can't manipulate values directly.
One option would be to set a variable:

[myButton.onSelect]
Set(varFilter, 1)

Depending on the value of this variable you can now change your filter in the gallery:

[myGallery.Items]
Switch(varFilter,
       1, Filter([your filter statements]),
       2, Filter([your other filter statements]))

That's maybe not the most elegant way to do this but it demonstrates the functionality.

[Ashish-_-]

Hi ,

By introducing a variable in the  formula of the control's property, you can dynamically modify properties using other controls. But what you are trying to do is not possible , as the properties can't be manipulated in this fashion.

Button   [OnSelect] => {Change variable x }

  

Gallery   [Items] => {Filter(Source, include x in expression accordingly) }

[Greg27]

Thanks @MatthiasL !!

[Greg27]

Thanks @Ashish-_- !!