Answered

Unable to filter table when a cell has square brackets in it

(0) Share

Report

Posted on by RobChilds

I have a Text Input search box, and a Gallery with a dataverse table as it's source.

I have a filter function applied to the Gallery which works fine until I try and search for something that has square brackets in it.

For example, in the name (primary) column called Clip_Name of the Dataverse table one of the clip name's is D001_C013_20220330_R[00000-00980].DNG When I search it doesn't find the clip. When I search D001_C013_20220330_R (removing the square brackets) it finds it.

It works fine when searching clip names that have rounded brackets in their name.

Any help greatly appreciated.

Many thanks,

Rob

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

charlessexton Super User 2024 Season 1 on at

Like (0)

Report

The reason why this happens is because when Power Apps requests the data from Dataverse it sends a request using a URL, and you're not supposed to send square brackets via a URL. So Power Apps encodes the [ to become %5B instead, but it doesn't get converted back by Dataverse.

That's why it's happening. Unfortunately, I don't see a simple solution. You could disallow square brackets and convert the existing ones. I'd almost say this is a Power Apps bug.

Was this reply helpful? Yes No
charlessexton Super User 2024 Season 1 on at

Like (0)

Report
Actually, I've just had a thought and tested it out, and it works. You can replace the square brackets with a wildcard (%) and the search will work.

Substitute(Substitute(TextInput3.Text, "[", "%"), "]", "%")

Was this reply helpful? Yes No
RobChilds 94 on at

Like (0)

Report

Thanks @charlessexton really good to know.

Where would I put this code please. Here's my current code on the Gallery..

Filter(
DataverseTable,
TextInput2.Text in Clip_Name
)

Thanks

Was this reply helpful? Yes No
Verified answer

charlessexton Super User 2024 Season 1 on at

Like (1)

Report
Like this:

Filter( DataverseTable, Substitute(Substitute(TextInput2.Text, "[", "%"), "]", "%") in Clip_Name )

If you've found my post helpful, please mark it as a solution. 😊

Was this reply helpful? Yes No
RobChilds 94 on at

Like (1)

Report

@charlessexton

Spot on!! Ah makes sense when you see it. Thanks so much, much appreciated!

Was this reply helpful? Yes No