Hello,

concat("https://sharepoint.com/_vti_bin/ListData.svc/Contacts?Select=LastName,FirstName, FullName, Title$filter=substringof('", TextField, "',LastName)")

It works fine, but I get error when I search a text with apostrophe. How can I search a text with apostrophe?

Thanks

John

Hi John,

Please try with escape sequences

http://blogs.msdn.com/b/csharpfaq/archive/2004/03/12/what-character-escape-sequences-are-available.aspx

Do you mean try it when you search text like "o'connor" in infopath? If you meant this, it did not work.

Hi John,

Does this concat function used in the InfoPath form for SharePoint list?

Is the value calculated by the concat function saved back to SharePoint list or the value calculated can be displayed in list view?

If yes, I recommend to run a full crawl in Search Service Application and then search to see if the issue still occurs.

If above cannot work, could you please provide a screenshot of the list view with the value set by concat function for further research?

Best regards,

Victoria

Hi John,

How is everything going?

Is there anything update about this issue?

Thanks,

Victoria

Hi Victoria, 

I've just found the solution!

I used double quote while I'm typing, and it worked!

Thanks

John

• Edited by John_35 15 hours 28 minutes ago
• Proposed as answer by Victoria XiaMicrosoft contingent staff, Moderator 1 hour 53 minutes ago