Power Platform Community Forum Thread Details

Hello All -

I'm very very new to Power Automate. We have a situation where we need to retrieve account information from Sales Force and integrate it into SQL Server for use downstream in PowerBI reports. This data will be used across multiple reports so it's better for us to move the data from Sales Force into a database first.

The problem i'm having is that the Sales Force connector only returns objects. From this object i'm unable to return full tables. For example, account managers are missing from my returned data sets, indicating that i'm not getting everything I need. I get that the Sales Force API offers objects, but how do I just return full tables via a flow? This seems to be rather limiting. There isn't much documentation on this out there from what i've found.

Can anyone help?

Categories:

Using connectors