D365 - List Record - Notes - How to loop through and get all records
I am writing a flow to get all the attachments in Dynamics before migrating all the documents to SharePoint.
Due to the limitation in the buffer size, the flow fails with the error: Http request failed as there is an error: 'Cannot write more bytes to the buffer than the configured maximum buffer size: 104857600.'.
I am looking for options to loop through and get the list - like get the 1st record, add a row into excel, loop through, get the 2nd record, add a row into excel and so on.
Is there any other way to loop through the whole list without this error?
I am looping through the Get Records like below - Get the 1 attachment from lead, create a Share Point file, delete it and loop through again for each attachment in the Leads. This works well because I am deleting it and the loop runs till there is no attachment for that Lead.
I am trying to extend this Flow to get the full list of attachments from all Leads and other entities without deleting the attachment and writing an excel output.