Hi all,
this is an interesting one for me.
I have a combined search and filter function applied to gallery items.
Search(Filter(Table1, ProductTypeID='Product Type Gallery'.Selected.'Type ID'), Searchbox.Text,"ProductNumber","ProductName")
The code above works perfectly when the Excel data source is uploaded as static data (Image label 2), but it does not work using the same file from SharePoint (Image label 1).
Is this expected behaviour? If not, what may be causing this issue?
Thanks
Resolved using the below instead.
With(
{
MyData: Filter(
Table1,
ProductTypeID = 'Product Type Gallery'.Selected.'Type ID'
)
},
Search(
MyData,
Searchbox.Text,
"ProductNumber",
"ProductName"
)
)