
Announcements
Hello ,
I have data stored in Azure Table Storage almost 30k entities and would like to get all rows / entitties in MS Flow. I tried using getEntities but seems it only retruns 1k rows at max. When i researched further i found table max returns 1k and get all entitties it needs to be batched operation but i couldn't find anything helpful in MS Flow for it. I also thought of using http connector to use Rest api for table storage but it has issues authorization header. It required Shared key which needs to be base64 signature.
Any help will be appreciated.
Thanks,
Mahesh
Hi @maheshkhisteLiv,
Could you check the capacity limit of your storage account?
Currently, the looping and debatching limits of flow is 100,00 for Apply to each items if you are using premium plans:
https://docs.microsoft.com/en-us/flow/limits-and-config
If it hits the limit of the connector that flow connects to, then that is the maximum limit for that service.
By the way, please try turning on Pagination of action Get entities and set the max number of items to retrieve to see if it will work:
https://flow.microsoft.com/en-us/blog/four-connector-action-settings/
Best regards,
Mabel