Step1 : Create PowerApps's connector
- Click on PowerApps menu called "Data"> "Custom connector"
- Click on menu called " Create a custom connector"
- Name the connector
- Import the hereunder definition file
https://pilot-things.zendesk.com/hc/article_attachments/360008889791/Pilot-things_Connector.json
- Click on Continue to create the connector
- Click on the following boutton "Create the connector"
like on the example hereunder
Step2 : Host setup
- Click on the tab called "General"
- Fill in the fied named "Host" with your Pilot-things's URL
like on the example hereunder
Step3 : Add a connection
- Click on the tab called "Test"
- Click on "New connection"
- Fill in the fields with your account Pilot Things login and password
- Click on "Create"
- Select the connection that you have just created
The connection is ready.
- You must save the connector.
Test : Check the connectivity between PowerApps & Pilot Things
- Go on the menu "Test"
Example using GetAlerts operation :
- Select "getAlertsUsingGET" in operation's menu
- To check if your connector is well configured, look response code (200 ok)
Use case : Create an application with PowerApps
- Select "Home" and after select "Begin an application"
1. 2.
- Click ok "Insert" > "Data Table"
- Click on "Add data source"
- Double click on your connector that you have just created in the Step 1
- Then, double click on your connection
- Finnally, you can close the window.
- Insert a button in the menu "Insert">"Button"
- Click on the button
- Tape this line on the button's fonction field
Alerts is the collection's name. You can acces to this collection in the menu "Display">"Collection".
getAlertsUsingGET is the operation's name.
For more information about function "ClearCollect" consult this website :
You have to add your collection to your "data source"
- Step 1 : Click on your data source to add collection
- Step 2 : Select your collection's name
- Check fields that you want to see
- To extract "data" field, add this line on the button's function field
Data field is available in the new collection called "Data_alerts".
For more information about the function "Ungroup", go on this site: https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-groupby
Comments
0 comments
Please sign in to leave a comment.