Filter query with an icon in the title

(1) Share

Report

Posted on by RH-07080703-0

Hello,

I'd like to retrive all Sharepoint pages of a site with a specific icon in the title. I proceed like this:

But it returns all the lines. So it works only with Filter array action but how it can works with filter query to improve performance of this flow?

Categories:

Business Process Flows

I have the same question (0)

All responses (5)

Answers (1)

RH-07080703-0 96 on at

Like (0)

Report

Filter query with an icon in the title

Thanks @Tomac for the explanation so I'll keep my filter array action.

@VictorIvanidze unfortunately, the use of contains for a Sharepoint list never work for me. Maybe it works for Excel.

Was this reply helpful? Yes No
Verified answer

Tomac 2,059 Moderator on at

Like (0)

Report

Filter query with an icon in the title

SharePoint ODATA filters don't support emoji. The filter will automatically strip any emoji from the search string and return results for any matching field that contains the search string without the emoji.

For example, in your search you're only looking for the emoji character, so SP strips that and returns all rows containing the value of '' (nothing), which is all that are not NULL.

If you set a Title field to '123456🆕' and ran the ODATA filter Title eq '123456' you would get the row containing the emoji, even though it's in the Title and not in the filter query, because SP strips it from the searched field.

There is currently no way to accomplish what you're trying to do other than ditching the emoji and using text instead.

1 people found this reply helpful.

Was this reply helpful? Yes No
VictorIvanidze 12,619 on at

Like (0)

Report

Filter query with an icon in the title

Hi @RH-07080703-0

what about this: https://community.powerplatform.com/forums/thread/details/?threadid=2f828870-2058-41bf-bdae-d6e7babda19e

Was this reply helpful? Yes No
RH-07080703-0 96 on at

Like (0)

Report

Filter query with an icon in the title

Hello Victor,

contains is not recognized as operator for OData filter.

Was this reply helpful? Yes No
VictorIvanidze 12,619 on at

Like (0)

Report

Filter query with an icon in the title

Hello,

if you mean a letter in the title., try to use the contains() function.

Was this reply helpful? Yes No