Hi guys,
I use logic App function "SQL Insert row" for storing my SharePoint data into SQL. So when I create new record in SP List its then stored into SQL database where I need it for further use.
Problem is that this connector has a limit around 2 MB - this is officialy known limitation. So when I have an attachment (or multiple attachments) bigger than 2 MB in total, the connector crashes with this error:
Bad Gateway. Without compression algorithm, the uncompressed data size in a packet exceeds the max ServiceBus limit: Request packet size of 11218414 exceeded limit of 8500000.
How do you guys deal with this limitation? I cant find anywhere a solution, that could let me store at least 8 MB of images in total, is there any way to solve this? I tried using Power automate desktop on server, where it should not have a limitation but it does not work either, cause it is not storing whloe base 64 code, but just some part of it.
Thanks in advance for any help