How to use Choice type column in search function?

(0) Share

Report

Posted on by GUOGUO

389

Hi all,

How to use the Choice type column in the below search function?

Search(DEISTRS,TextBox1.Value,"cr5f1_itowner","cr5f1_countrysite","cr5f1_topic","cr5f1_name","cr5f1_category")

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

WarrenBelz 154,799 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @GUOGUO ,

You would need something like

Search( AddColumns( DEISTRS, "category", cr5f1_category.Value ), TextBox1.Value, "cr5f1_itowner", "cr5f1_countrysite", "cr5f1_topic", "cr5f1_name", "category" )

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.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
GUOGUO 389 on at

Like (0)

Report
Copy link

Link copied!

Hi Warren.
Thanks.
I have no idea why I cannot find the Value properties of cr5f1_category .

Was this reply helpful? Yes No
WarrenBelz 154,799 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Hi @GUOGUO ,

You did not state your data source - my response was for SharePoint and if it is a Choice field, it will have a Value property.

Was this reply helpful? Yes No
GUOGUO 389 on at

Like (0)

Report
Copy link

Link copied!

Hi Warren,
Thanks ,
If it is in Dataverse for Teams ,how to do with it? Thanks.

Was this reply helpful? Yes No
WarrenBelz 154,799 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@GUOGUO ,.

I am a SharePoint user, but this blog may be useful to you.

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.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No