You’re offline. This is a read only version of the page.
Hello Everyone,
My datasource is an excel table in OneDrive. I am working on a combined search and filter.
This is my formula and i can't seem to get it right. Kindly help out and thank you in advance.
Search(
Product,
SearchInput.Text,
"ProductName",
"ProductNumber"
&&
Filter(
Product,
'ProductCategory ID' = 'Product Categories'.Selected.'Category ID'
)
Hello @Yemice :
First try only this formula:
Share
Report
All responses (
Answers (
Filter(
Product,
'ProductCategory ID' = 'Product Categories'.Selected.'Category ID'
)If this worked correctly, Issue would be with the search function.
Please check the column names are spelled correctly.
try to type the column names. So that intelligence can help you with correct name.
@theapurva and anyone,
Search( Filter( Product, 'ProductCategory ID' = 'Product Categories'.Selected.'Category ID' ), SearchInput.Text, "ProductName", "ProductNumber" )
The Search function returns a blank. Please help! thanks in advance
Thank you for your time, with your formula, the search function does not work but the filter works however there are no error messages.
Both functions independently but when i combine them i get error messages.
Hello @Yemice ,
Please try below code:
Search(
Filter(
Product,
'ProductCategory ID' = 'Product Categories'.Selected.'Category ID'
),
SearchInput.Text,
"ProductName",
"ProductNumber"
)
#1
WarrenBelz
294
Most Valuable Professional
#2
MS.Ragavendar
169
#3
stampcoin
130
