cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Super User
Super User

Append to String Variable Size Limits: Workaround?

Hello,

I followed the blog post here to download 35k records from Sharepoint List. As part of the final "Apply to Each", I need to recompile the 5k chunks of json into a single json doc. 

Unfortunately, with Append to String Variable, I hit the size limit! Any ideas for how to overcome this?

image.png

2 REPLIES 2
Gristy
Level 10

Re: Append to String Variable Size Limits: Workaround?

Thats a lot of json 🙂

 

Maybe you could write a azure function to do that final step? Assume you just want to end up with a big .json file?

Super User
Super User

Re: Append to String Variable Size Limits: Workaround?

Hi @Gristy,

Thanks for the idea. I've tried my hand at Azure Functions, but haven't gotten the grasp yet. Any recipes you can think of to get started?

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors
Users Online
Currently online: 448 members 5,999 guests
Please welcome our newest community members: