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

All responses (5)

Answers (1)

Sort by

charlessexton 11 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

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.
charlessexton 11 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
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, "[", "%"), "]", "%")
RobChilds 94 on at

Like
a
(0)

Report
Copy link

Link copied!

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
Verified answer

charlessexton 11 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
Like this:

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

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

Like
a
(1)

Report
Copy link

Link copied!

@charlessexton

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