ServiceNow Integration with Microsoft PowerApps and Flow
ServiceNow connector to Microsoft PowerApps and Flow is in Preview (Connector Reference). I thought I will give it a try to see how easy that ServiceNow can be integrated into Microsoft Cloud apps. Since there wasn’t much of documentation for this, so I wanted to share my experience here in case someone is interested in the steps:
- How to create a ServiceNow connection in PowerApps
- How to create a Microsoft Flow using the ServiceNow connection
- How to call Flow from PowerApps
How to create a ServiceNow connection in PowerApps/Flow
- Launch Powerapps design Studio and create a New Connection
- Search ServiceNow
- Typing your instance name and username and password.
- I had to connect to the instance with a local account and I wasn’t able connect using my Azure AD account
After the Connection is created, you can use it in Microsoft PowerApps, Flow or Azure Logic Apps. I found Flow is a way better option than connecting directly via PowerApps, since you can easily debug the output in Flow. I think there are limits on how many calls you can make with Flow per month, so you might want to evaluate the cost if you decide to deploy this to production.
How to create a workflow using Microsoft Flow using the ServiceNow connection
- In PowerApps design studio, Go to Business Logic and Click Flows and Create from Blank
- Create a new Action and search for ServiceNow, select ServiceNow – List Records
- Select the record type you want to pull from ServiceNow, such as Requested Item
- Click Test
- Copy the result Array (starting and ending with square brackets) out into notepad. You will need this for creating output JSON Schema.
- Next, add the Request - Response action as the output of the Flow
- This step is necessary and important. I missed this step in my first try so I couldn’t get the response I expected in PowerApps. It just shows ‘True’ value as a return for the Flow in PowerApps. Even when I added this step later, PowerApps still couldn’t pick up the change. I had to recreate a new Flow with Response output and then PowerApps was able to consume the output. I think it is a bug in PowerApps.
- This step is necessary and important. I missed this step in my first try so I couldn’t get the response I expected in PowerApps. It just shows ‘True’ value as a return for the Flow in PowerApps. Even when I added this step later, PowerApps still couldn’t pick up the change. I had to recreate a new Flow with Response output and then PowerApps was able to consume the output. I think it is a bug in PowerApps.
- In Response Body, Click Add dynamic content and select result under List Records panel.
- Click Use sample playload to generate schema and paste the Array from Step 5
- Change Flow name to Request Items
Now you are ready to consume the Flow in PowerApps
How to call Flow from PowerApps
- In PowerApps Studio, create a new app and Select Phone layout under Blank app
- Add a Gallery, Select Blank vertical
- Add a Button and under OnSelect , paste ClearCollect(requests,RequestItems.Run()). This will create a “requests” collection, which then can be hooked into the Gallery control.
- Select the Gallery, and under Items, type requests
- Run the PowerApps, and Click the button, you should get requests back from ServiceNow.
Getting the following error when setting up an action to ServiceNow:
Any idea why this is happening? The trigger list is empty.
Thank you!
There aren't any ServiceNow triggers for Flow at this time. So i assume you are connecting this Flow to a PowerApp, use the PowerApps trigger for the first step of the flow. After that you can use the ServiceNow actions and then also be able to call outputs from the Power app into the ServiceNow actions. Make sure to use Response action above that Shawna mentions.
Flow below:
I have the trigger and action setup, as well as the result as laid out. I am now in studio trying to create the app, but there is nothing coming up in my gallery when I click the button.
My flow is named "Enhancement Items".
The "Items" property of my gallery has a formula of "enhancements".
The "OnSelect" property of my button has a formula of "ClearCollect(enhancements,EnhancementItems.Run())"
What am I missing here? Where does the app tie into the Flow? Your formula had "RequestItems" in it, where is that coming from?
Thank you
EDIT: Could this be an issue? My Gallery wants me to connect to data, but when I go to make a data connection, the following is displayed. Checking my license with PowerApps, I am on a "PowerApps Plan 2 Trial":
EDIT 2:
Closing and re-opening the app, it looks to be pulling in data, but it is not displaying (look at the scrollbar):
You probably need to format the gallery. Since it looks like a blank gallery, try inserting a label and set it up to read the data. For example, I have a text label displaying 'Assigned To' and then another text label set to ThisItem.assigned_to.
I've done this, but still no data is coming up. I can confirm that it is making a connection to my PDI, however, as when it was sleeping I got a very obvious error that said it couldn't connect to the upstream server. I am no longer getting errors with my PDI awake:
EDIT: Spoke too soon, it's working now! Had to reload my app, after adding in the label with the thisitem.field.
Do you know how I can grab a reference value's display value? I'd normally use .getDisplayValue() in ServiceNow, but this is not working in PowerApps.
I can't find what to use for Instance Name. I tried the values below and get an error:
Hi all,
I know this is an old conversation but I may have a simple solution. As serveral of you I also got empty collections in my PowerApp but when I changed to body instead of result in my response in Microsoft Flow I started to get the data in also. Please try that and see if you get the data.
Hi,
When I try to connect to the instance it says "Please check your account info and/or permissions and try again".
Can i please know what permissions or access should i have?
Hello Shashwathi,
I believe you need to have the system administrator account to be able to connect to flow, because that's what I did.
In the connection name I copied and pasted the instance URL, and on the instance name I coped the name which is in my case "dev72802". Also, the username and password I used is of the system administrator. Hope that helps somehow.
Have a good day!
