cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
BKGOUD
Helper III
Helper III

Custom connector data not displaying in powerapps

Hi All,

 

I have created a custom connector to connect graph api and getting json data as response. I have added connector to powerapps and trying to fetch the data into a collection but i'm not getting data,only receiving column names. Can somebody help me on this.

 

 

Gallery.Items = GraphConnector.GetAllRooms()

8 REPLIES 8
v-bofeng-msft
Community Support
Community Support

Hi @BKGOUD :

Could you tell me:

  • Have you tested this custom connector?
  • Does the test return the records you need?

1.JPG

I assume everything is fine in the test.

Firstly,I think the cause of this problem is:

GraphConnector.GetAllRooms() is a behavior function but items is a non-behavior property.

Behavior funtions change the stat of the app by changing values elsewhere in the app.'OnSelect','OnStart',and other 'On……'

properties are common behavior-based properties.

Secondly,I suggest you store the value of GraphConnector.GetAllRooms() into a collection and then call the collection.

For example;

1\Set the app's OnStart property to:

 

ClearCollect(MyCollecton,GraphConnector.GetAllRooms()) /*My collection is my custom collection*/

 

2\Set the gallery's Items property to:

 

MyCollecton

 

Best Regards,

Bof

Hi @v-bofeng-msft ,

Thank you very for your help.

Please find the below details:

Could you tell me: Have you tested this custom connector?  - Yes it's working and returned the Json data.

Does the test return the records you need? - Yes, it returns the records as expected.

I have tried and loaded the data into collection but i could see the only columns names(not getting the data). 

 

Please suggest me how can i get the data.

Hi @BKGOUD :

I've made a test but did not encounted the problem you mentioned.Maybe you can try to put the code in the button, and then click the button.

GetTime is my custom connector:

66.gif

Best Regards,

Bof

Hi @v-bofeng-msft ,

 

While i'm testing connector getting the response as in below format.

{

  "address": {"@odata.type""microsoft.graph.physicalAddress"},

  "audioDeviceName""String",

  "bookingType""String",

  "building""String",

  "capacity""String",

  "displayName""String",

  "displayDeviceName""String",

  "emailAddress""String",

  "floorLabel""String",

  "floorNumber": 1024,

  "geoCoordinates": {"@odata.type""microsoft.graph.outlookGeoCoordinates"},

  "id""String (identifier)",

  "isWheelchairAccessible"true,

  "label""String",

  "nickname""String",

  "phone""String",

  "tags": ["String"],

  "videoDeviceName""String"

}

 

I have tried by using button onclick, loading collection but still no luck 😇.  PFA.

 

 

 

Hi @BKGOUD

This looks more like a data structure than a value. Can you provide a screenshot of the test?

1.JPG

Best Regards,

Bof

Hi @v-bofeng-msft ,

 

Please find the attached screenshot.

Hi @BKGOUD :

It's weird,everything seems to be fine. How is your app set up now?(Note: OnStart event needs to be triggered manually in the test environment)

If the problem cannot be solved. I suggest you create a Support Ticket:

https://powerapps.microsoft.com/en-us/support/pro/

Best Regards,

Bof

meghav93
Helper I
Helper I

Any updates on this topic? I am facing a similar problem as @BKGOUD. Any insights will be helpful. Thanks!

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (1,375)