Forum Discussion
Anonymous
7 years agoNot applicable
How to reference field with spaces in name
Hi,
i have the following query: -
let
Source = OData.Feed("https://NAME.sharepoint.com/sites/pol/SUBSITENAME/_api/web/lists/GetByTitle('Issues')/Items()?$Select=Title,Priority", null, [Implementation="2.0"])
in
Source
The current query selects the fields Title,Priority. I wish to add a field that has spaces within its name (e.g. "field with spaces"). How do i reference such a field as this in M?
I have tried
"field with spaces"
'field with spaces'
[field with spaces]
issues[field with spaces]
"field%20with%20spaces"
with no luck...
Hi Anonymous,
Please try to replace the space by _x0020_.
Reference: Special characters in URL filters
Best regards,
Yuliana Gu
1 Reply
- v-yulgu-msft
Microsoft Employee
Hi Anonymous,
Please try to replace the space by _x0020_.
Reference: Special characters in URL filters
Best regards,
Yuliana Gu