Unanswered

Custom connector data not displaying in powerapps

(1) Share

Report

Posted on by BKGOUD

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()

Categories:

Building Power Apps

I have the same question (0)

All responses (10)

Answers (0)

v-bofeng-msft Microsoft Employee on at

Like (2)

Report
Copy link

Link copied!
Hi @BKGOUD :
Could you tell me:
Have you tested this custom connector?
Does the test return the records you need?
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

Was this reply helpful? Yes No
BKGOUD 95 on at

Like (1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
v-bofeng-msft Microsoft Employee on at

Like (2)

Report
Copy link

Link copied!

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:
Best Regards,
Bof

Was this reply helpful? Yes No
BKGOUD 95 on at

Like (1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
v-bofeng-msft Microsoft Employee on at

Like (2)

Report
Copy link

Link copied!

Hi @BKGOUD ：
This looks more like a data structure than a value. Can you provide a screenshot of the test?
Best Regards,
Bof

Was this reply helpful? Yes No
BKGOUD 95 on at

Like (1)

Report
Copy link

Link copied!

Hi @v-bofeng-msft ,

Please find the attached screenshot.

Was this reply helpful? Yes No
v-bofeng-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
meghav93 48 on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
devangchheda 10 on at

Like (1)

Report
Copy link

Link copied!

I am also facing the same issue. Data loads sometimes into powerapps and sometimes doesn't. Issue is intermittent. Any help would be appreciated. Thanks !

Was this reply helpful? Yes No
CU02080718-2 27 on at

Like (1)

Report
Copy link

Link copied!

Hi @BKGOUD,

Have you found any resolution to this? I am also facing the same issue testing is getting proper response but when calling it from canvas app, its not returning any data just column names

Was this reply helpful? Yes No