Filter Function not Working

(0) Share

Report

Posted on by Community Power Pla...

I am new to Power BI and have added a data label as shown below:

I have been trying to add a search functionality on the ID Column as shown below using the input field functionality:

But this doesn't seems to be working

Can anyone please help and let me know what is wrong here ?

Thanks in advance 😀

Categories:

Building Power Apps

I have the same question (0)

All responses (10)

Answers (1)

Verified answer

WarrenBelz 153,026 Most Valuable Professional on at

Like (2)

Report
@jaideepnema

ID is a Number - StartsWith only works on Text. If you want to find the ID from the Text box, put this

Filter( Table5, ID = Value(SearchBox.Text) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi @WarrenBelz ,
Yes this seems to be working , i also wanted to know how to add a search functionality on the basis of two columns ie: refresh Type and Status in my case ?

I tried the following but this is not working:
Search(Table5,"Report_Type","Status")

Can you please help ?

Was this reply helpful? Yes No
WarrenBelz 153,026 Most Valuable Professional on at

Like (1)

Report
@jaideepnema ,

You need to tell it where to Search (note you will get a Delegation Warning here as Search is not Delegable

Search( Table5, SearchBox.Text, "Report_Type", "Status" )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi @WarrenBelz ,
Thanks for your reply ....I used the same code

but it doesnt seems to be working ...not sure what is wrong !!

Was this reply helpful? Yes No
WarrenBelz 153,026 Most Valuable Professional on at

Like (1)

Report

@jaideepnema ,

That is the correct syntax - refer this document

How many records are there is Table5 ?

Was this reply helpful? Yes No
marmarno 4 on at

Like (0)

Report

Hello @WarrenBelz
I've read the article and wrote the syntax as you showed it but it throws an error, n idea what´s wrong:

Was this reply helpful? Yes No
WarrenBelz 153,026 Most Valuable Professional on at

Like (0)

Report

@marmarno ,

This is an old closed post, please post a new thread with specifics of what you are trying to do, and what the error is (there does not seem to be one on the code you have posted)

Was this reply helpful? Yes No
AyaTarek Microsoft Employee on at

Like (0)

Report

I am facing the same issue although syntax is correct:
Search(
test,
TextInput1.Text,
"Column1",
"Column2",
"Column3"
)

any idea if something has changed?

thanks in advance..

Was this reply helpful? Yes No
AyaTarek Microsoft Employee on at

Like (0)

Report

okay replaced it with the workaround here:
Solved: multiple search functions - Power Platform Community (microsoft.com)

Was this reply helpful? Yes No
ShubhamMukunde 4 on at

Like (0)

Report

1. "StartsWith" function only works for text datatype, whereas ID column in SharePoint is of type "Number".
Instead of using "StartsWith" function in the "Filter" condition, you can directly compare the ID with textinput text. (Also you will need to convert textinput value to number)

Below is the example:
Filter(
Table5,
ID = Value(SearchBox.Text)
)

2. Better option to implement the search functionality is to use the "Search" function. Please refer to the below link.
Filter, Search, and LookUp functions - Power Platform | Microsoft Learn

Hope this will help! 🙂

Was this reply helpful? Yes No