I'm having another issue with my Filter formula. I have a gallery and I added a control (an icon) called FilterToggle which has a simple toggle action -- the OnSelect says
UpdateContext({FilterToggle:!FilterToggle})
This appears to work correctly as I have the color of the icon toggle on and off, based on an IF statement in the Color formula.
On my Gallery, my Items formula is set to:
If('FilterToggle'=false,
{SortByColumns(
Search(
'Inbound RM Inspection',
SearchBox.Text,
"Title"
),
"Title"
)
},
{SortByColumns(
Search(
Filter('Inbound RM Inspection','INSP-NOW'=YES),
SearchBox.Text,
"Title"
),
"Title"
)
}
)
The purpose is to include all Items if the FilterToggle is False and to include only those items who have INSP-NOW set to YES if FilterToggle is True.
Now all I get is an Invalid Argument Type.
Prior to adding this filter component, my Items formula was a just:
SortByColumns(
Search(
'Inbound RM Inspection',
SearchBox.Text,
"Title"
),
"Title"
)
and it worked fine, so it's either the way I have the IF statement formatted, or the Filter command.
Thanks, gpence