You’re offline. This is a read only version of the page.
4
Hi
I am having trouble using SharePoint Get Items, filter query = [SP item] eq 'Mother's Day'
Please refer to the following for a real life sample.
After eq the content has ' in it
What is the correct syntax to handle the single quote after eq? Please assist.
Thanks in advance
DW
You do not need to "manipulate the excel cell".
You have to modify the value of the cell before comparing, as you have been suggested.
Thanks for the prompt response.
What you suggested will work, however the "mother's day" is embedded in an Excel cell. The only way would be to manipulate the excel cell from "mother's day" to "mother''s day" is not desirable from the business point of view.
Please point me to the right direction.
Thanks again
Hi @davidwong ,
You just need to replace single quote with double quotes as follows:
Please take a try again.
Best Reards,
#1
WarrenBelz
146,522
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,890
Most Valuable Professional
Share
Report
All responses (
Answers (
