Unanswered

Need help with filter function

(0) Share

Report

Posted on by paxdolphin

hi,

I am trying to create an app with search/filter function using Powerapps via Ms Teams. I have inserted a sharedpoint List by inserting a "Data Table" and a "Text box" to key in the search text.

With the "Data Table" selected, for Items, i key in "Filter(Proposal, StartsWith(ProposalAbstract_Column1,TextBox2.Text))". When i clicked preview, only row header seen. All my data disappeared and nothing happens when i type in the search box.

Is there anything that i forgot to do? Thanks in advance.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

rubin_boer 4,841 Super User 2024 Season 1 on at

Like (0)

Report

hi @paxdolphin

Your function is correct but please check your default value does not read "Text Box" 😉 and secondly i see you have TextBox2.Text - do you have any errors as TextBox2.Value is expected.

Hope it helps,

R

Was this reply helpful? Yes No
bapala 247 on at

Like (0)

Report

Hi @paxdolphin,

I tried with same formula (with textcolumn) as yours and it worked fine for me without any issue:
Filter(Employees,StartsWith(Username,txtUserName.Text))

In addition to @rubin_boer response, please try below also:
May be worth to remove/refresh your datasource connection and try again. Sometimes this trick helps.

Try these checks as well if the column is People or Choice:
if people: ProposalAbstract_Column1.DisplayName
if it is choice type: ProposalAbstract_Column1.Value

Was this reply helpful? Yes No
paxdolphin 14 on at

Like (0)

Report

Thanks for all your replies. However I still cannot figure out where i went wrong. I have no programming background so sorry if I am doing really silly mistakes.

I created a very simple table to troubleshoot. Table name is Tests. only 3 rows of data. Once i keyed in the filter code, I get a blank screen as shown below. My text box has been cleared empty value =""
Really not sure what went wrong 😞
Also when i created my columns, I named them as "Address" and "Name". How come they became "Address" and "ThisItem.'Name........"? and there is a 3rd field as well.

I am using the MS Teams version of Power Apps. Is this different from the web version? Lesser features? Been watching some youtube videos and noticed some differences. For example for my text box, i cannot find "Fill" attributes.

Any help is much appreciated. Thanks

Was this reply helpful? Yes No