Answered

Add Filter for only first 3 characters in a dropdown box

(0) Share

Report

Posted on by jaanihsm

300

Hi! I'm trying to create a multi-filter for my 'Search' gallery to include only the first 3 characters of my 'Filter by FLR Doc Code' dropdown. Could you please help me with the code? Thank you!

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

WarrenBelz 153,073 Most Valuable Professional on at

Like (0)

Report
Hi @jaanihsm ,

The value you want would be

=Left(drpFiLterByFLRDocCode.Selected.Value,3)

I note .Value is wrong in your post, so you would need to fix this.

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.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
jaanihsm 300 on at

Like (0)

Report

Thanks Warren!
I tried but still results in error...

The values in this dropdown is of another SP List. Can that affect the concat formula?

Was this reply helpful? Yes No
Verified answer

WarrenBelz 153,073 Most Valuable Professional on at

Like (0)

Report

Hi @jaanihsm ,

The issue is not the Left( . . ., 3) part - it is (as I mentioned) the output of the Combo Box is not .Value (the error was in your initial post). What is the name of the field displayed in this Combo Box - you need to use that instead of Value

Was this reply helpful? Yes No
jaanihsm 300 on at

Like (0)

Report

It's working now! Thanks Warren! Just needed some deeper explanation.

Was this reply helpful? Yes No
jaanihsm 300 on at

Like (0)

Report

Oh nvm, I just needed to add the Blank() part! Thanks Warren! So helpful and quick!

Was this reply helpful? Yes No