Answered

How to search a string having a special character in between in gallery items

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi All,

I am facing an issue related to search functionality for the words having special character in between words like Group's , DVP&R.

The following is the formula that i used,

SortByColumns(
Filter(
MergedCollection,
If(
Dropdown_JobFunction.Selected.JobFunctionTitle = "All",
'Job Code:Job Function'.Value = 'Job Code:Job Function'.Value,
'Job Code:Job Function'.Value = Dropdown_JobFunction.Selected.JobFunctionTitle
),
'Job Code:Active/ Inactive'.Value = If(
Toggle1_1.Value,
"A",
"I"
),

Or(
TextSearchBox1.Text in 'Job Code'.Value,
TextSearchBox1.Text in 'Job Code:Job Description'.Value,
TextSearchBox1.Text in 'Job Code:Salary Grade'.Value,
TextSearchBox1.Text in 'Job Code:Active/ Inactive'.Value,
TextSearchBox1.Text in 'Job Code:Employee Type'.Value,
TextSearchBox1.Text in 'Job Code:Job Function'.Value,

)

),
gvarSortColumn,
If(
SortDescending1,
Ascending,
Descending
)
)

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

WarrenBelz 156,425 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous ,

I have a blog on detecting special characters in a text string - this 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
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Warren,
I read the blog which you shared, but my concern is different. It should show the appropriate results with items having group's. The user should be able to search with special character also example words like R&D, Forumula's.

Was this reply helpful? Yes No
Verified answer

WarrenBelz 156,425 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous ,

You could use the in function, however note it is not Delegable (I am also not sure what you mean by "Groups")

Filter( SPListName, "&" in YourFieldName || "'" in YourFieldName )

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