SQL Limits?

[Anonymous]

I'm looking for answer for my flow what is max cap of reading SQL database by flow? I need to analyse arrays by filter based on very big sql databse. What is max cap of records per one flow?

[ChristianAbata]

@Anonymous  the limit is defined my looping when you get your data see the oficial doc

https://docs.microsoft.com/en-us/power-automate/limits-and-config

[alrez]

Hi,

In addition we have some limitations on the connector itself. Take a look at the documentation we have on the connector too.

https://docs.microsoft.com/en-us/connectors/sql/

Regards,

Alex

-------

Community Support Team _ Alex Rezac
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Can you tell me something.

How many records I can get by get table? For example my table have 20.000 records. It's possible to get them all? There are a lot of limits however I'm beginner of SQL 🙂 Can you explain me little a bit?