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 😀

All responses (10)

Answers (1)

ShubhamMukunde 4 on at

Like (0)

Report

Re: Filter Function not Working

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! 🙂
AyaTarek Microsoft Employee on at

Like (0)

Report

Re: Filter Function not Working

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

Like (0)

Report

Re: Filter Function not Working

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..
WarrenBelz 146,524 Most Valuable Professional on at

Like (0)

Report

Re: Filter Function not Working

@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)
marmarno 4 on at

Like (0)

Report

Re: Filter Function not Working

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:
WarrenBelz 146,524 Most Valuable Professional on at

Like (1)

Report

Re: Filter Function not Working

@jaideepnema ,

That is the correct syntax - refer this document

How many records are there is Table5 ?
Community Power Pla... on at

Like (0)

Report

Re: Filter Function not Working

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

but it doesnt seems to be working ...not sure what is wrong !!
WarrenBelz 146,524 Most Valuable Professional on at

Like (1)

Report
Re: Filter Function not Working

@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.
Community Power Pla... on at

Like (0)

Report

Re: Filter Function not Working

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 ?
Verified answer

WarrenBelz 146,524 Most Valuable Professional on at

Like (2)

Report
Re: Filter Function not Working

@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.