Answered

PowerApps filter function works with startswith but doesn't without it

(0) Share

Report

Posted on by hasahmad

So I have a screen with a searchbar on top and a sharepoint list form view at bottom. As the user types they can see the result live in the list form view

Filter('Input Form', StartsWith('Project ID', TextInput4.Text)

However when I use the formula

Filter('Input form', 'Project ID'. TextInput.Text)

it shows the list form view with text: "We didn't find any data to show at this time"

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@hasahmad

I'm not surprised. Your second formula doesn't mean anything. What are you trying to do with it?
timl 37,287 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
@hasahmad

It isn't clear from your post what your exact question is.

If you want to return a list of records with a project id that matches exactly the value in the TextInput control, this is the syntax you would use.

Filter('Input form', 'Project ID' = TextInput.Text)
hasahmad 59 on at

Like
a
(0)

Report
Copy link

Link copied!

Currently, the list shows all the result and as I type in the text field it starts to filter as I type a project ID. I want it to function in a way that when the column has 2 project id's entered with a coma such as PRJ1234, PRJ3456 and when I type in the search. the filter would populate PRJ3456 when I enter PRJ345. Right now the filter is picking up the data from the left side of the field and if it doesnt see PRJ3456 as the first project ID it will not populate. I want it to pick value from anywhere in the populated field
Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @hasahmad,

Do you want to filter the Gallery based on each project id within the TextInput?

If you want to filter the Gallery based on both PRJ1234 and PRJ3456, we should set the Items property of Gallery as below:

If(IsBlank(TextInput6.Text), RenameColumns('Input form',"Project ID","Result"), Distinct(Ungroup(ForAll(Filter(Split(TextInput6.Text,","),!IsBlank(Result)),Filter('Input form',!IsBlank(Find(TrimEnds(Result),'Project ID')))),"Value"),'Project ID'))