web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Search and Filter Func...

Power Apps

Unanswered

Search and Filter Function in Powerapps

(0) Share

Report

Report

Posted on by Yemice

6

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'
)

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (4)

Answers Img

Answers (0)

theapurva 970 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hello @Yemice ,

Please try below code:

Search( Filter( Product, 'ProductCategory ID' = 'Product Categories'.Selected.'Category ID' ), SearchInput.Text, "ProductName", "ProductNumber" )

Was this reply helpful? Yes No
Yemice 6 on at

Like (0)

Report
Copy link

Link copied!

@theapurva

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.

Was this reply helpful? Yes No
Yemice 6 on at

Like (0)

Report
Copy link

Link copied!
@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

Was this reply helpful? Yes No
theapurva 970 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hello @Yemice :

First try only this formula:

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.

Was this reply helpful? Yes No

Join the conversation