News and Announcements icon

Power Platform CommunityForums Power Apps - Error Handling Search function Error

Power Apps - Error Handling

Answered

Search function Error

Like (0) Share

Report

Report

Posted on 5 Apr 2025 15:51:47 by RR-05041550-0

74

I am trying to create a search function to search my choice column. how do i do it? i am using the formula before

All responses Img

All responses (6)

Answers Img

Answers (1)

Verified answer

RR-05041550-0 74 on 06 Apr 2025 at 21:23:16

Like (0)

Report

Search function Error

i used this code instead and it worked for me

Filter( 'Sales Tax Compliance Checklist', IsBlank(TextSearchBox2.Text) || State.Value = TextSearchBox2.Text )
Nirav Raval (Akira28) 150 Super User 2025 Season 1 on 06 Apr 2025 at 20:29:29

Like (0)

Report
Search function Error

Hi @RR-05041550-0

Do try the below code, if it works

Search( AddColumns( 'Sales Tax Compliance Checklist', "FavState", 'State'.Value ), txtInput.Text, "FavState" )

If this post solved your issue, clicking 'Does this answer your question' will help others discover the solution and close the topic. If you found it helpful, a Like would be awesome!

Regards,
Nirav J Raval (Akira28) 🤞
Suggested answer

vipuljain03 417 on 06 Apr 2025 at 18:18:34

Like (0)

Report
Search function Error

Few checks you can do:

Confirm the control is really named txtinput

Go to your data pane and make sure the list is properly connected

Make sure it’s a Choice field - test with just State.Value in a gallery first

Always type quotes directly in Power Apps - don’t copy-paste from Word or web

Search() only works on text columns - that’s why we use AddColumns() to create a temporary column of text values.

-------------------------

If this reply helped you, please mark this reply as suggested answer ✔️ and give it a like to help others in the community find the answer too!

Thanks,

Vipul
MS.Ragavendar 1,232 on 06 Apr 2025 at 08:35:32

Like (0)

Report

Search function Error

@RR-05041550-0,

Can you please help me with the schema of the table which you are trying.

I will try replicating the things from my end too.
RR-05041550-0 74 on 05 Apr 2025 at 16:26:17

Like (0)

Report

Search function Error

STILL GETTING SAME ERROR @MS.Ragavendar
Suggested answer

MS.Ragavendar 1,232 on 05 Apr 2025 at 15:57:44

Like (0)

Report

Search function Error

@RR-05041550-0,

Try this formula

Filter(
AddColumns('Sales Tax Compliance Checklist', "FavState", State.Value),
StartsWith(FavState, txtinput.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

Helpful resources

News and Announcements

🌸 Community Spring Festival 2025 Challenge 🌸

Welcome to the Power Platform Communities

Quick Links

Leaderboard

#1

WarrenBelz 146,518 Most Valuable Professional

#2

RandyHayes 76,287 Super User 2024 Season 1

#3

Pstork1 65,756 Most Valuable Professional

Leaderboard

Featured topics

Product updates

Microsoft Power Platform Community release plans