SQL Limits?

Anonymous · ‎04-28-2020

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 · ‎04-28-2020

@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

Did I answer your question? Please consider to Mark
my post as a solution! to guide others

Proud to be a Flownaut!

If you want you can follow me at www.christianabata.com

Quieres contenido en español? Síguenos en Power Automate LA

alrez · ‎04-28-2020

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 · ‎04-28-2020

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?

SQL Limits?

Helpful resources

2022 Release Wave 1 Plan

Community & How To Videos

Calling all User Group Leaders!