Record Limit for Salesforce connector

Anonymous · ‎01-20-2023

Hello Everyone,

I'm building a flow to extract Accounts information from salesforce to a CSV file but no mather what I do it just brings 200 results into the file.

Any idea on why ?

PS: Although my License information say its Free , in the connectors session it says I can have access to premium Connectors as per screenshot attached.

thanks in advance

nitishsh91 · ‎01-23-2023

Hi @Anonymous

The flow you're building is likely limited to 200 results due to the Salesforce connector's default query limit.

There is a limit of 2000 rows that can be returned by a query, this limit applies to the number of rows returned, not the number of rows that match the query. If a query returns more than 2000 rows, the remaining rows are ignored.

You have a few options to retrieve more than 200 results:

Use the "List records" action with a filter query that is more restrictive, and use the "List records" action multiple times to retrieve all of the records.
Use the "List records" action with the "Limit" parameter set to a higher value (up to 2000) to retrieve more records in one query.
Use the Salesforce Bulk API to retrieve large data sets, this API allows you to retrieve more than 2000 records at a time.
You can also use the "Get more results" action after the "List records" action to retrieve additional records.

It's also worth noting that your license information is correct, with a free license you have access to premium connectors.

As a final note, it is important to consider the performance of your flow and the impact on your Salesforce instance when retrieving large amounts of data.

Anonymous · ‎01-24-2023

Hi nitishsh91,

I have included a screenshot from the salesforce connector action I'm performing in my flow. Please note I'm using a Get Records and I"m limiting it to 10.000 records ... Salesforce Flow.png

nitishsh91 · ‎01-24-2023

You have set it to 10,000 as Top Count, so the flow should be retrieving up to 10,000 records.

If you are not getting the expected result, this might be related to the query you are using to filter the records. Make sure that you are using the correct filter conditions and that your query is returning the expected set of records.

You can also try reducing the number of records and test the flow, it may be possible that the flow execution is taking too long to finish.

It's also worth checking if you have any filters on the Salesforce view you are getting the records from, it could be limiting the number of records retrieved.

As part of the free plan, you will have access to a limited number of connectors, and some connectors may be rate limited. However, it can be possible that you have a free trial of Power Automate premium features enabled.

Anonymous · ‎01-24-2023

I believe it's something related to my license, although it's saying that I have access to premium connector , the other information saying my account is free may be limiting my querie