Filtering with toLower Error

(0) Share

Report

Posted on by OkanMTL

703 Super User 2024 Season 1

Hello,

We have a Business Central Table which can output projects. The projects have customernames, I can find these projects based on customernames. But, sometimes the customername within Business Central has for example a uppercase at the start and the searchvariable I'm using has not.

See the Example below, I need to find the customername in LowerCase within BC.

The first Expression is the error, this is the column im trying to filter and in which the output has to be in lowercase in order for the second Expression to work. Is this even Achieveable? Right now I'm getting the error because i am trying to LowerCase the column name, not the name within BC.

Any help is appreciated.

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

CU22040918-0 195 on at

Like (0)

Report
Copy link

Link copied!

Hi @OkanAT
The left part of eq should use Odata native tolower() function, instead of the flow one.

see reference: https://stackoverflow.com/questions/13495905/odata-query-filter-conditions-and-case-sensitivity

Hope this help
Nelson

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

Like (0)

Report
Copy link

Link copied!

Hello,

Thanks for your reply.
This doesn't give back the sellToCustomerNames in lowercase values

Was this reply helpful? Yes No
Verified answer

CU22040918-0 195 on at

Like (1)

Report
Copy link

Link copied!

Hi @OkanAT

BC does support Odata filter tolower() function.
https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/webservices/use-filter-expressions-in-odata-uris

Could you please share your filter expression?

Nelson

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

Like (0)

Report
Copy link

Link copied!

Hi Nelson,

Thanks for the link to the docs, I was giving the column between '', which must have not been done in order to have the values in BC in lowercase. It works. Thanks

Expression i have now: tolower(columnnamewithoutdoublequites) eq toLower'value to search'

Was this reply helpful? Yes No