cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Resident Rockstar
Resident Rockstar

OData syntax for sharepoint column with a space - Get Items action.

I really am not thrilled that I have to learn an entirely different language to do filters in Flow.  But, that is what we have to live with, so I have to bother everyone with how to do this.

 

My Sharepoint column has a space in it.  How do you format the filter statement with a space in a column name.  I have tried these methods without success.

 

Part Number eq DVPartNumber

'Part Number' eq DVPartNumber

Part_x0020_Number eq DVPartNumber

 

Its hard to believe there are yet other ways to do this.  I need to know the right way.

2 ACCEPTED SOLUTIONS

Accepted Solutions
Highlighted
Community Support
Community Support

Re: OData syntax for sharepoint column with a space - Get Items action.

Hi @martinav,

 

Please try to enter the following code:

Part_x0020_Number eq ‘DynamicContentColumnName’

 

If you are trying to use a dynamic content in the code, please surround it with a single quote.

 

Please try it on your side.

 

 

Best regards,

Mabel Mao

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Highlighted
Resident Rockstar
Resident Rockstar

Re: OData syntax for sharepoint column with a space - Get Items action.

I have learned with further experience that the single quotes are required for text columns, and no quotes are required for number columns.  

View solution in original post

8 REPLIES 8
Highlighted
Resident Rockstar
Resident Rockstar

Re: OData syntax for sharepoint column with a space - Get Items action.

This is now urgent.  I hope for some help on this asap.  How to write this filter to account for a space in the column name.  I have way too much on this sharepoint list to change the name of the column.  I need the answer on how to include the space.  Please advise!!!image.png

Highlighted
Resident Rockstar
Resident Rockstar

Re: OData syntax for sharepoint column with a space - Get Items action.

Of course, my band aid to make another column, calculated to contain the information of the other did not work either.  Flow does not like the calculated type.  HELP!!!

 

Thank you.

Highlighted
Resident Rockstar
Resident Rockstar

Re: OData syntax for sharepoint column with a space - Get Items action.

More failed attempts... HELP!!!!

 

PartNumber eq DVPartNumber "Column 'PartNumber' does not exist. It may have been deleted by another user."
'Part Number' eq DVPartNumber "Column 'T900004' does not exist. It may have been deleted by another user.
Part_x0020_Number eq DVPartNumber "Column 'T900004' does not exist. It may have been deleted by another user."
Part_Number eq DVPartNumber "Column 'Part_Number' does not exist. It may have been deleted by another user."
{'Part Number'} eq DVPartNumber
{'Part_x0020_Number'} eq DVPartNumber
{Part Number} eq DVPartNumber "The $filter expression \"{Part Number} eq T900004 and Rev eq 3\" is not valid."
{Part_x0020_Number} eq DVPartNumber "The $filter expression \"[Part_Number] eq T900004 and Rev eq 3\" is not valid."
['Part_Number'] eq DVPartNumber "The $filter expression \"['Part_Number'] eq T900004 and Rev eq 3\" is not valid."
[Part_Number] eq DVPartNumber "The $filter expression \"['Part_Number'] eq T900004 and Rev eq 3\" is not valid."
[Part Number] eq DVPartNumber "The $filter expression \"['Part_Number'] eq T900004 and Rev eq 3\" is not valid."

Highlighted
Community Support
Community Support

Re: OData syntax for sharepoint column with a space - Get Items action.

Hi @martinav,

 

Please try to enter the following code:

Part_x0020_Number eq ‘DynamicContentColumnName’

 

If you are trying to use a dynamic content in the code, please surround it with a single quote.

 

Please try it on your side.

 

 

Best regards,

Mabel Mao

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Highlighted
Resident Rockstar
Resident Rockstar

Re: OData syntax for sharepoint column with a space - Get Items action.

Thank you so much.  That did work.  The nuacne of syntax is overwhelming.  I do not even know how to define what dynamic content is.  It is still a matter of trial and error.  The next column used in my statement, Rev, requires no quote.  This is my resulting statement that works.  

 

image.png

Highlighted
Resident Rockstar
Resident Rockstar

Re: OData syntax for sharepoint column with a space - Get Items action.

I have learned with further experience that the single quotes are required for text columns, and no quotes are required for number columns.  

View solution in original post

Highlighted
New Member

Re: OData syntax for sharepoint column with a space - Get Items action.

End Date ne null

 

How to rewrite it

Highlighted
Resident Rockstar
Resident Rockstar

Re: OData syntax for sharepoint column with a space - Get Items action.

@casparLi ,

 

I'm not quite following your question.  if this is a sharpoint column named End Date, then use End_x0020_Date.  Null good as-is.  That turns into this:

 

End_x0020_Date ne null

 

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors
Users online (5,896)