You’re offline. This is a read only version of the page.
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.
Share
Report
All responses (
Answers (
474
