Showing results for 
Search instead for 
Did you mean: 
Regular Visitor

Response from custom connector is fetched but collection is blank

Hello creators.


I am creating a power app that utilizes a custom connector to retrieve data from a Sage300 API. Where i have successfully got the Custom connector to respond with the correct JSON data, but when attempting to save the collected data in Power apps with a Collection, the collection contains all the column headers but only contains a single blank row after performing a ClearCollect.


Here is the details on the Custom Connector, Power apps integration, current findings and tried fixes:


Connector action info:


(paths and filter query are fully functional)



This Thicc boi is the response body, it appears that no headers are required.

The response body has been pasted from Postman, so all response body names in the power app response, are identical to the names found in the API response body names.




After creating a connection and filling out the relevant fields...


The API responds with the correct data.


Power apps

After adding the Custom connector to Power apps as a Data source, i tested the response again and tried to store the response in a collection as seen below:



Note: the variables strCompany, strModule and strRecource have the correct values in them.

After clicking the button and waiting for the response i notice the collection that is supposed to contain the response is empty but contains all the column headers...



one interesting thing is that in Monitor, you can see the Network request successfully calling the correct data, is able to "Tablify" the JSON in Monitor, but when it gets to the ClearCollect stage, it only collects one row (Blank)





For some reason it appears that it loses the data between the Network request and the Function to store the data.


Any idea if this is a caching issue or is there something i need to do to the JSON before it is sent to Power apps.

Here is a detailed image of the response body:



I hope to hear from whomever knows something i dont soon. And thank you for the help in advance.






Frequent Visitor

Hi! Are you sure your schema is correct?


I just had the issue that the response was good, it just collected an empty row into a gallery. I then noticed that my schema (response in Custom Connector editor) was somehow changed. I messed around with the Swagger so maybe I just messed it up myself.

Helpful resources

Ignite 2022


Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Super User 2 - 2022 Congratulations

Welcome Super Users

The Super User program for 2022 - Season 2 has kicked off!

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Top Solution Authors
Top Kudoed Authors
Users online (3,212)