Unanswered

Dealing with brackets and spaces in filter query

(0) Share

Report

Posted on by Yort

Hi All

We have a sharepoint column that we need to filter query on. Unfortunately the column name is Type (SLA or Billable) . Yes I know that it is agains best practice to name columns like this, but it was inherited and can not be changed. I have tried the following to filter out items that are 'Billable', but it is not working:

Type_x0020_(SLA_x0020_or_x0020_Billable) eq 'Billable'

Is my syntax correct here?

Thanks

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Expiscornovus 33,189 Most Valuable Professional on at

Like (0)

Report

Hi @troyrowlands,

Also try to url encode the brackets. These are _x0028_ and _x0029_

Was this reply helpful? Yes No
Verified answer

tom_riha 10,185 Most Valuable Professional on at

Like (0)

Report

Hello @troyrowlands ,
you need that column's internal name, so go to the List settings -> Edit column and take the internal name from the URL on the Edit column page, it's the part after 'Field=' at the end.
If the column was created as 'Type (SLA or Billable)' it'll be probably 'Type_x0020__x0028_SLA_x0020_or_x'. As already mentioned, brackets are not valid in the column internal name so they'll be replaced in a similar way as spaces are, and the whole internal name is limited to 32 characters.

Was this reply helpful? Yes No
Yort 33 on at

Like (0)

Report

Thanks so much. This worked perfectly...and I learned something.

Was this reply helpful? Yes No