Unanswered

How to embed Filter and StartsWith

(0) Share

Report

Posted on by Menyon

Howdy,

I'd like to add a text search box into my app but can't figure out how to add the formula within my existing formula. Any help would be very much appreciated.

Existing Gallery Items:

Ungroup(Table({Value: Blank()},{Value: Sort(ForAll(Distinct('Data List', 'Project Name'), {Result: ThisRecord.Value}),Result)}),"Value")

Need to embed:

Filter([@Data List], StartsWith('Project Name', TextInput2.Text))

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (2)

Talha_Dar 870 Super User 2024 Season 1 on at

Like (1)

Report
Hi @Menyon,

you can try using the following formula

Ungroup(Table({Value: Blank()},{Value: Sort(ForAll(Distinct(Filter([@Data List], StartsWith('Project Name', TextInput2.Text)), 'Project Name'), {Result: ThisRecord.Value}),Result)}),"Value")

If you found my answer helpful, please consider giving it a thumbs-up or a like. Your feedback is greatly appreciated!
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
Rajkumar_M 3,741 Super User 2025 Season 2 on at

Like (1)

Report

Hi

Try this

Ungroup( Table( { Value: Blank() }, { Value: Sort( ForAll( Filter([@Data List], StartsWith('Project Name', TextInput2.Text)), { Result: ThisRecord.Value } ), Result ) } ), "Value" )

(Or)

Ungroup(
Table(
{Value: Blank()},
{Value: Sort(ForAll(Distinct(Filter([@Data List], StartsWith('Project Name', TextInput2.Text)), 'Project Name'), {Result: ThisRecord.Value}), Result)}
),
"Value"
)

Thanks!

If my response has been helpful in resolving your issue, I kindly request that you consider clicking "Accept as solution" and "giving it a thumbs up" as a token of appreciation.

Was this reply helpful? Yes No
Verified answer

Menyon 29 on at

Like (0)

Report

Unfortunately, this didn't work. Startswith, distinct, Sort and Filter have invalid arguments.

Was this reply helpful? Yes No
Menyon 29 on at

Like (0)

Report

Unfortunately, neither work. Startswith, distinct, Sort and Filter have invalid arguments.

Was this reply helpful? Yes No
Verified answer

Menyon 29 on at

Like (0)

Report
Bah, I missed
Filter([@'Data List']

Was this reply helpful? Yes No