Salesforce Connector - Error using Pagination

(0) Share

Report

Posted on by jeromesabety

When using the Salesforce connector and the setting to enable pagination, a get records action will fail if there is an account with a single quotation at the end of its name.

Error message from Power Automate is the following:

Salesforce failed to complete task: Message: 
(unig__XXXXXXX__c = 'Something' AND Name > 'Something'') OR (unig__XXXXXXX__c
                                                     ^
ERROR at Row:1:Column:296
expecting a right parentheses, found ') OR (unig__XXXXXXX__c = '
clientRequestId: 7a906259-c2be-460d-9627-ba96fc384155

That trailing single quote should be escaped and it is not something that the Flow author can control from what I could divine.