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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Not getting correct JS...
Power Apps
Answered

Not getting correct JSON response

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Hi,

 

I'm building an app that has a custom connector. This is the response I was supposed to get:

response.PNG

 

But when I trigger my request like this:

Set(
 AddActivity;
 'MyCustomConnector'.AddActivitiesToBusinessPartner( { params })
)

The AddActivity variable looks like this:

addactivity.PNG

 

I also tested the connector and got the correct responses.

testrequest.PNG

 

So my question is - does anyone understand, why I can get the correct response when I test the connector in the backend, but not when I trigger the request from within my application?

Categories:
I have the same question (0)
  • v-xida-msft Profile Picture
    Microsoft Employee on at

    Hi @Anonymous ,

    Based on issue that you mentioned, I think you have some misunderstanding with the data storage representation within PowerApps app.

     

    According to the correct response you mentioned (last screenshot), I think the dll property owns a Object value. When you executes your action within a canvas app, the Object value the dll property returned would be recognized as a Record type. Then within the variable, the dll property would be rendered as below ("table" icon):5.JPG

    you could click the "Table" icon as above to see the detail values within the dll property.

    Actually, it is a normal behavior that the Object record would be redered as a "Table" icon as above when your variable or Collection contains a Object value.

     

    If you want to reference the column values within the dll property, please take a try with the following formula:

    AddActivity.dll.retval
    AddActivity.dll.BUSSINESPARTNER
    AddActivity.dll.EMPLOYEE
    AddActivity.dll.SUBJECT
    AddActivity.dll.LOCATION
    AddActivity.dll.STARTDATE

    ...

    Note: The AddActivity represents the variable you set in your app.

     

    Currently, within PowerApps, only simple type column value could be displayed within a variable or Collection directly (e.g. the status property in your response), the complex type (Object, Array, ...) column would be rendered as "Table" icon as above.

     

    Best regards,

  • v-xida-msft Profile Picture
    Microsoft Employee on at

    Duplicated

  • seadude Profile Picture
    1,855 on at

    Hi @Anonymous , also try searching the forums here for "nested JSON". There is a plethora of examples that solve exactly what you're looking for.

    Good luck!

  • Verified answer
    Community Power Platform Member Profile Picture
    Microsoft Employee on at

    What solved the issue was when I deleted the connection to my custom connector and made a new one. Looks like it was still using the "old" version, ever though I've updated the connector.

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Thanks to everyone for your replies, really appreciate it!

  • v-xida-msft Profile Picture
    Microsoft Employee on at

    Hi @Anonymous ,

    Have you solved your problem?

     

    If you have solved your problem, please go ahead to click "Accept as Solution" to identify this thread has been solved.

     

    Best regards,

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 356 Most Valuable Professional

#2
11manish Profile Picture

11manish 225 Super User 2026 Season 2

#3
Mohsin Ali Profile Picture

Mohsin Ali 211

Last 30 days Overall leaderboard