web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Create Collection from...
Power Automate
Unanswered

Create Collection from a power automate flow

(0) ShareShare
ReportReport
Posted on by 13

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.

Noob01_0-1704478331295.png

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.

 

Categories:
I have the same question (0)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 538 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 405 Moderator

#3
abm abm Profile Picture

abm abm 252 Most Valuable Professional

Last 30 days Overall leaderboard