Hi there,
I'm new to power automate and I have a flow that uses the Execute Soql Query action with the salesforce connector. But when I try to access the results, the "dynamic expressions" area doesn't let me drill down into the response. How can I do that?
I assume you either found a way to do this or moved on, however I thought I'd post my solution to this and see if it helps..
In the flow, you will have an action which calls the Execute SOQL Query. What will be returned from that is json that looks like the following:
Share
Report
All responses (
Answers (
8
{
"totalSize": 1,
"done": true,
"records": [
{
"attributes": {
"type": "Opportunity",
"url": "xxxxxxxxxxxxxxxxxx"
},
"Id": "XXXXXXXXXXXXXXXXXX",
"Name": "XXXXXXXXXXXXXXXXXXXX"
},
]
}
You access that using the Dynamic Content "Body" from that step in a follow up action. Personally, I then write that to a file on OneDrive, but you could email it or use it to send to an on premise SQL server etc...
Hope that helps?
