Skip to main content

Notifications

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps - Connector Development / Problem with PowerApps...
Power Apps - Connector Development
Unanswered

Problem with PowerApps/PowerAutomate not returning nested JSON data, but custom connector test does with same parameters

(0) ShareShare
ReportReport
Posted on by GTW 28

Can't figure this one out. I have created a custom connector to retrieve transaction data from Plaid, and testing the connector works and returns the data including a nested JSON component called "added" (for transactions added since the last pull). All looks OK.

 

I then use that custom connector with the exact same parameters in both PowerApps and PowerAutomate (I've tried it both ways to get data) and the nested JSON is returned blank. The same call with Postman also returns data so it's something with how PowerApps or PowerAutomate process or pass back the nested JSON.

 

Here's the sample in the Custom Connector:


gwengreniuk_0-1697125526396.png

and the same in Power Automate missing the nested JSON:

gwengreniuk_1-1697125834082.png

 

Any idea what I could be doing wrong, or how I should handle this? The goal is to take the contents of the "added" object and store them into a dataverse table or a collection, however in both cases I'm just getting blank data returned. Immediately after I can run the test in Custom Connector or via Postman and get the results expected so it's definitely not a source issue.

Any ideas, insight or troubleshooting would be appreciated.

 

Garrett

 

  • YA-18101859-0 Profile Picture
    YA-18101859-0 12 on at
    Problem with PowerApps/PowerAutomate not returning nested JSON data, but custom connector test does with same parameters
    Garrett,
    Did you ever find the answer to this, I am having the same issue only I did not use my custom connector in power automate I created a flow based on the API that the custom connector uses.  That returned the results.  Postman returns the results, test function returns the correct results but power apps only give me all the column names and the nested columns and values, but not the values of the higher level.  When I call the custom connector I saved it to a collection that should allow for all records in my case 5 with nested last column and values.  But I get a blank row with a continuation character in the last field where I click and it gives me the nested columns and values of the last item returned.
     
    If you can give me any insight I would so appreciate it.
     
    Thank you,
    Yazmine
  • GTW Profile Picture
    GTW 28 on at
    Re: Problem with PowerApps/PowerAutomate not returning nested JSON data, but custom connector test does with same parameters

    gwengreniuk_0-1697170828333.png

     

    Same result -- body is there, but the "added" array is empty. Composing on "added" specifically just returns empty

  • GTW Profile Picture
    GTW 28 on at
    Re: Problem with PowerApps/PowerAutomate not returning nested JSON data, but custom connector test does with same parameters

    Not sure where you're referring to specifically, but I assume you mean Power Automate -- no, the data is returned but not the contents of the nested array. 

     

    gwengreniuk_0-1697161421480.png

     

  • GTW Profile Picture
    GTW 28 on at
    Re: Problem with PowerApps/PowerAutomate not returning nested JSON data, but custom connector test does with same parameters

    Hello,

     

    No, definitely not a timing issue. I did the following:

    1. Test via Postman, there is content in the "Added" array (it's a nested JSON container which has all the transaction details). 
    2. Test via Custom Connector "Test" function, there is content

    3. Run the connector from PowerApps, content is missing

    4. Test again via Custom Connector "Test" function, there is content

    5. Test in Power Automate, content is missing

    6. Test again via Custom Connector "Test" function, there is content

    7. Test again in Postman, there is content.

     

    So it consistently returns content to Postman and the Test function built in to the Custom Connector creator in PowerApps, and consistently does not return data for that array when called from PowerApps or PowerAutomate. 

     

    The trace in PowerApps monitor confirms it's the same body being sent each of the various ways, it's just the response that is missing.

     

    Added are any transactions since the last time they were marked "transferred" -- so each time should return the same records (in this case 8 of them) until I mark them, at which time it'll then return any records since the last time they were marked in an incremental fashion.

    Any ideas?


    Thanks,


    Garrett

     

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

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 791 Most Valuable Professional

#2
MS.Ragavendar Profile Picture

MS.Ragavendar 410

#3
mmbr1606 Profile Picture

mmbr1606 275 Super User 2025 Season 1

Last month Overall leaderboard

Featured topics

Product updates

Microsoft Power Platform Community release plans