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?
@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
Proud to be a Flownaut!
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.
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?
User | Count |
---|---|
90 | |
41 | |
22 | |
20 | |
16 |
User | Count |
---|---|
134 | |
54 | |
47 | |
36 | |
25 |