Append to String Variable Size Limits: Workaround?

[ericonline]

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?

[Gristy]

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?

[ericonline]

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?