I have a flow which is taking the account name field from Salesforce via the connector, then using get items with an ODATA filter to find the relevant account in a SP list
This works fine for account names with no apostrophe in, but I get this error (using an example of McDonald's Corporation') when they contain them
The expression "Title eq 'McDonald's Corporation'" is not valid. Creating query failed.clientRequestId: 9c24c620-41b9-4f62-8875-dd4a54ffed17serviceRequestId: 9c24c620-41b9-4f62-8875-dd4a54ffed17
What would be the best way to make this query work, ideally without changing the original name in Salesforce?
Go to Solution.
Please refer to the thread below for the solution:
Single quote in OData Query need to present in pairs.
To replace a single quote in an dynamic OData Query String value where the example field is Department.
I hope this helps !
View solution in original post
Learn how to create your own user groups today!
Check out the new Power Platform Community Connections gallery!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.