Hello, Yumia.
Still no luck with this item.
I did though find a slight workaround:
In the OnChange event of the Search Text TextBox, I am updating a variable with the value in the text box. Instead of referring to the value of the text box itself in my original example, I use the variable instead. this seems to restrict the Gallery based upon what is in the Text box.
The only issue is that doing it this way, the user must click outside of the text box in order for the Gallery to filter.
Again, it worked find with the Collection. Did not work with the View until I invoked this work around noted herein.
If you folks can have a look at it from that perspective, it may help you all debug.
This is the Gallery | Items Property:
/*
SortByColumns(Filter('[dbo].[vwFTM_Service_Call_All_iPad]',
ServiceCallFilter_Txt.Text in Service_Call_ID ||
ServiceCallFilter_Txt.Text in LocationId ||
ServiceCallFilter_Txt.Text in LocationName ||
ServiceCallFilter_Txt.Text in Service_Description ||
ServiceCallFilter_Txt.Text in CallType ||
ServiceCallFilter_Txt.Text in Technician ||
ServiceCallFilter_Txt.Text in Resolution_ID ||
ServiceCallFilter_Txt.Text in Status_of_Call),
"Service_Call_ID", Ascending)
*/
SortByColumns(Filter('[dbo].[vwFTM_Service_Call_All_iPad]',
vServiceCallFilter_Txt in Service_Call_ID ||
vServiceCallFilter_Txt in LocationId ||
vServiceCallFilter_Txt in LocationName ||
vServiceCallFilter_Txt in Service_Description ||
vServiceCallFilter_Txt in CallType ||
vServiceCallFilter_Txt in Technician ||
vServiceCallFilter_Txt in Resolution_ID ||
vServiceCallFilter_Txt in Status_of_Call),
"Service_Call_ID", Ascending)
And the OnChange:
Set(vServiceCallFilter_Txt,ServiceCallFilter_Txt.Text)
