Create Collection from a power automate flow

(0) Share

Report

Posted on by Noob01

Hi All,

For a feature in my Canvas app I need the whole SP list (it has more than 2000 rows). I have created a flow to fetch the table as a Jason through the following flow.

The problem I m facing is that due to the SP list being a very big one I have to turn on the Asynchronous Response option in the Response connector otherwise the flow times out. But the moment I turn the setting on I m not able to collect the array into a collection in my app.

The following error is thrown:

JSON parsing error. expected array got object.

This is the code I have put on the onselect property of a button:

ClearCollect(Collection,flow.run())

As for the error, I have also checked that my response Json scheme is passing an array of objects and not one object.