Hi All,
I have a requirement to filter filenames from sharepoint site with searched filename (eg: Jennette Walls - XXXXX (O) May 14'24) in PAD. Searched_FileName:Jennette Walls - XXXXX (O) May 14'24
But, when i'm trying to use get file properties using filter query, it is throwing an error as
substringof('%Searched_FileName%',FileLeafRef). This is because , i'm not able to ignore/skip apostrophe Jennette Walls - XXXXX (O) May 14'24 while filtering filename in sharepoint.
----------------------------
{
"StatusCode": "400",
"Message": "",
"Body": {
"status": 400.0,
"message": "The expression \"substringof('Jennette Walls - XXXXXX (O) May 14'24\r\n',FileLeafRef)\" is not valid. Creating query failed.\r\nclientRequestId: 56b0dba6-c618-4cc3-8a35-7d3407c5ee0a\r\nserviceRequestId: 56b0dba6-c618-4cc3-8a35-7d3407c5ee0a"
},
"Headers": {
"Vary": "Origin",
"X-NetworkStatistics": "0,525568,0,0,61674,0,34854",
"X-SharePointHealthScore": "2",
"X-MS-SPConnector": "1",
"X-SP-SERVERSTATE": "ReadOnly=0",
"DATASERVICEVERSION": "3.0",
"SPClientServiceRequestDuration": "60",
"SPRequestDuration": "60",
---
}
Files available in sharepoint as
Jennette Walls - xxxxxx (O) May 14'24
Jennette Walls - xxxxxx (O) May 14'24 (1)
Jennette Walls - xxxxxx (O) May 14'23
Expected output is:
Jennette Walls - xxxxxx (O) May 14'24
Jennette Walls - xxxxxx (O) May 14'24 (1)
Can someone help how to achieve this?
-Thanks
