'How to filter Microsoft Graph API JSON response using Power Query language?

My request is

GET https://graph.microsoft.com/v1.0/applications?$select=appRoles

enter image description here

Because of this I have a problem in PowerApps, I can't show the objects.

microsoft-graph-apiazure-ad-graph-apipowerapps-canvas


Solution 1:[1]

Assuming you have...

  • ... a working Custom Connector named myCustConn
  • ... with a GET method called GetRoles

try this:

In the PowerApp, insert a Button control and set its OnSelect property to:

  • ClearCollect(colAppRoles, myCustConn.GetRoles().value.AppRoles)

Then insert a Gallery control and set its Items property to:

  • colAppRoles

Then insert a TextBox control into the Gallery template and set its Default property to:

  • ThisItem.description (or ThisItem.id, etc.)

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 SeaDude

Related Questions