
Announcements
I built several flows with Salesforce connectors that were running perfectly. In the last month or so, I have started seeing frequent errors when connecting to Salesforce. This happens when I create a Salesforce trigger or when I use a Salesforce action in my flow. I will get the error: "Salesforce failed to complete task: Message: The table contains a large number of fields with long names which can't be used in a query to Salesforce. Please try to decrease the number of fields in the table or specify desired fields to retrieve in the select query option."
I am not sure what change happened in the Salesforce or Power Automate interface that this error started to become frequent. Hopefully someone from the Microsoft side can fix this connection issue or reconfigure the Salesforce connection. Nothing about my flows have changed - the error is definitely systematic of some issue with the connection between Salesforce and Microsoft.
Hi All,
In case you are seeing this message, I figured out how to fix it!
If you do "Get records", within the "Advanced Options" section you should see a field called "Select Query". I add in the relevant field names that I am trying to pull and it works. Make sure to know what they are called within Salesforce (so "Ultimate_Parent_Acount_c" for example). You can do a compose action to figure out what these fields are titled within Salesforce and then use that in the Select Query box. (Then delete the compose action).