Connecting Microsoft PowerApps to CoreView Workflows
Modified on Fri, 30 Sep 2022 at 09:13 AM
Categories
-
What's New
-
Release Information
- CoreView Release Notes September 2023
- CoreView Release Notes August 2023
- CoreView Release Notes July 2023
- CoreView Release Notes June 2023
- CoreView Release Notes May 2023
- CoreView Release Notes April 2023
- CoreView Release Notes March 2023
- CoreView Release Notes February 2023
- CoreView Release Notes January 2023
- CoreView December 2022 Release Notes
- CoreView November 2022 Release Notes
- CoreView October 2022 Release Notes
- September 2022 Release Notes
- August 2022 Release Notes
- Release 22.06 Key Features
- Release 22.05 Key Features
- Release 22.04 Key Features
- Release 22.03 Key Features
- Release 22.01 Key Features
- Release 21.12 Key Features
- Release 21.11 Key Features
- Release 21.10 Key Features
- Release 21.09 Key Features
- Release 21.08 Key Features
- Release 21.07 Key Features
- Release 21.05 Key Features
- Release 21.04 Key Features
- Release 21.03 Key Features
- Release 21.02 Key Features
- Release 21.01 Key Features
-
Release Information
- Getting Started with Customer Care
-
Getting Started with CoreView
-
Configuring
- Configuration Overview
- Creating CoreView Tenant Administrators
- CoreView Operator Uses Cases & Dependencies
- Creating a License Pool
- Understanding Virtual Tenants
- "Send As" DNS Requirements for CoreAdoption Campaigns (Optional)
- How to enforce MFA on CoreView service accounts
- Creating a License Pool
- How to ensure security for CoreView service accounts
- Disabling MFA for CoreView service accounts
- Set Conditional Access to grant access only inside the CoreView data center
-
Configuring
-
How to
-
Exchange Online
- How to check and analyze the Message Trace
- How To Configure Email Forwarding
- How to convert a Shared Mailbox to a User Mailbox
- How to convert a user mailbox to a shared mailbox in Exchange Online
- How to Create Microsoft 365 Groups for Improved Collaboration
- How To Create Shared Mailbox
- How To Create User Mailbox
- How To Grant Access To Mailbox
- How to List all the Mailboxes a User has access to in Microsoft 365
- How to remove delegates from Mailbox
- How to remove user access to Mailbox
- How to review and manage Exchange online mailbox permissions
- How to verify if a user has updated the Password
- Read Permission for Mailbox
- What are security groups and How to create it
- What is a Distribution Group and How to create it
-
Exchange Online
- Custom Actions Library
- Getting Started with CoreHybrid
-
Knowledge Resources
-
Understanding CoreView - Quick Start Guides.
- CoreView Quick Start Guide Overview and Index - Tenant Admins
- CoreView Quick Start Guide Overview and Index - Operators
- Understanding CoreView Tenant Configuration – Management
- Understanding the CoreView Operator Profile
- Understanding CoreView Operator Roles (New UX)
- Understanding CoreView Operator Roles
- Understanding CoreView Operator Delegation
- Understanding CoreView - Report Column Filtering
- Understanding CoreView Tenant Configuration - V-Tenant User Filters
- Understanding CoreView Tenant Configuration - Portal Information
- Understanding CoreView Tenant Configuration Options
-
Troubleshooting Common Issues
- Unable to see OneDrive, SharePoint and Exchange Data
- Remote Office 365 PowerShell session can Conflict CoreView Management Actions
- Why I cannot save the changes on existing License pool?
- Error when attempting to perform a Management Action
- Unable to modify the Assigned Licenses in my License Pool Report
- Enabling Permission for Endpoint Manager Actions
- How to enable permission for BitLocker keys report
-
Tenant Administration
- How to recreate Admins Read-only
- How to add an operator to the portal?
- How to enable and configure CoreView management session
- How to provide a consent to activate Azure AD Reports Feature and activate Partial Import?
- Tips & Tricks: Leverage Pivot Reports to Prototype License Pool Criteria Filter
- Tips & Tricks - How to manage email notifications for newly added Operators.
- Disable MFA from Read Only Service Accounts
- How To: Report on "Consumed Portal Licenses"
- How to Configure Allowed IP Addresses for CoreView Service Accounts
- Tips & Tricks: How to merge License Pools
- How to Use CoreView's Global Report Filters
- How to use the What If tool to check Azure AD conditional access policies
- How to Configure Allowed IP Addresses for CoreView Service Accounts
- How to Archive a Teams Group
- How to Restore a Teams Group
- On-demand Import for a Single Device in Endpoint Manager (Intune)
- Custom Actions using the Microsoft Graph API
- How to set up your tenant for the switch to Microsoft Graph API
- GraphAPI configuration: How to get Client ID and Client Secret
- How to provide consent to import exchange information
-
Reporting and Analytics
- How do I Check and Manage Calendar Permissions for a User?
- How CoreView can help you with your Microsoft 365 Chargeback Goals.
- New UX: Understanding the new License Centers
- Understanding the Savings Opportunities Dashboard
- Understanding the License Optimization center
- Understanding License Pool Snapshots report
- Understanding Call quality dashboard
- Understanding Call quality report
- Understanding User call quality report
- Understanding Teams groups activity report
- Understanding Teams Adoption Growth Report
- Understanding Endpoint Manager reports
- Understanding Teams dashboard
- Understanding Risky Users report
- Understanding Storage Dashboard
- Troubleshoot Active Users (License Usage) data
- Legacy Protocol Management
- Report Columns: Is active 30/60/90
- Quarantined Messages Report - Understanding The Reports
-
Managing and Administration
- Teams Voice: Direct Routing Support
- How to enable management function?
- Forward SMTP Address vs Forward Address management actions
- How to add the users in bulk while executing Users management actions?
- How to Create & Manage Custom Actions
- How to schedule a report to be sent automatically, and how to modify its scheduling options?
- How to schedule an alert report for the License Count
- Tips & Tricks – How to read and modify license pool report?
- Overview of CoreView Workflow
- How to delegate Workflow management using roles
- How to configure CoreView and ServiceNow integration
- How to Enable Multi Factor Authentication for Operators and Admins who Access the CoreView Portal
- How Can I Migrate from Group-Based Licenses to Direct Licenses Managed by CoreView?
- Naming convention rules
- Custom Actions: Forbidden and Warning Values
- How to add users to Distribution Group in bulk using via CSV
- Not able to manage licenses error
- Using custom action json output as an input in the workflow
- Setting the Sensitivity Label on SharePoint as a Mandatory Field
- DistinguishedName vs OnPremisesDistinguishedName
-
Understanding CoreView - Quick Start Guides.
- CoreView Product Manual
- Health Check
- Actions
-
Playbooks
-
Out-of-the-Box playbooks
- Introduction
- Overview
- Configuring predefined policies
- Edit policy settings: Set and monitor thresholds
- Edit remediation settings: Manual and automatic remediation
- Edit remediation settings: Configure attestation
- Remediation settings: Security & Identity policies
- Remediation settings: Teams Management policies
- Remediation settings: License Management policies
- Remediation settings: SharePoint & OneDrive Management policies
- Remediation settings: Exchange Management policies
-
Out-of-the-Box playbooks
- Workflows
- Learning Platform
- Internal Customer Care Resources
- Archive
- PowerShell
- Webinars and Events
- CoreVoice
- Internal Support
A Guide to connecting Microsoft PowerApps to CoreView Workflows
TABLE OF CONTENTS
- Introduction & Prerequisites
- Phase 1 – Generate API Key
- Phase 2 – Gather Information from Workflow in CoreView
- Phase 3 - Microsoft PowerAutomate
- Phase 4 - Testing
Introduction & Prerequisites
This KB Guide is intended to provide an example of how Microsoft PowerApps can be connected to the CoreView API to execute CoreView Workflows.
Prerequisites:
• PowerAutomate License which includes Premium Connectors
Phase 1 – Generate API Key
- From within CoreView, click on your initials in the top-right corner > Manage API Keys
- Manage (drop-down menu) > Add New App
- Click the blue checkbox in the top-right corner.
- Click the copy button on the Success screen that pops up to copy the API key, and paste it in a safe
- place for later use.
Phase 2 – Gather Information from Workflow in CoreView
- Navigate to your Workflow for your PowerApps use case.
- In the top-right, click on Actions > Edit > Configure Execution Inputs
- Copy the name of each input into a notepad for use later.
NOTE: If any inputs are the “List” type, you will want to mimic those list options within the PowerApp.
Phase 3 - Microsoft PowerAutomate
NOTE: This step requires a PowerAutomate Premium license. If you do not have this already, you will need to procure the appropriate licensing to allow for Premium Connectors.
- From PowerAutomate > click Create > Instant cloud flow
- Set the appropriate Flow name; we advise making this unique to the CoreView Workflow that you will be triggering.
- Choose PowerApps (V2) for the trigger > click Create
- Click on the PowerApps (V2) step. From here you will build all of the inputs that come over from PowerApps, and eventually communicate over to the CoreView Workflow. While you can use any of these inputs, the most common use cases will utilize the Text input.
Select the Text input for this example:
In the Input field, remove the word “Input” and copy/paste in the first input title that you are bringing over from Phase 3.
NOTE: The order of the inputs must be the same as the submit button command within your PowerApp or the field data will communicate improperly to PowerAutomate and the CoreView Workflow.Once you finish creating your inputs, click on the + symbol under the step to add another step. Search for and select the HTTP action:
Method: GET
URI: https://www.loginportal.online/api/auth
Headers:Accept application/json Authorization Bearer Insert_CoreView_API_Key NOTE: Be sure to include a space after the word, Bearer.
Click the + symbol below the HTTP step > search for and select the Parse JSON action:
Click in the Content field > insert the dynamic input: Body
Copy and paste the following code starting with { and ending with } into the Schema box:
{ "type": "object", "properties": { "userId": { "type": "string" }, "sessionId": { "type": "string" }, "userName": { "type": "string" }, "displayName": { "type": "string" }, "bearerToken": { "type": "string" }, "refreshToken": { "type": "string" }, "profileUrl": { "type": "string" }, "roles": { "type": "array", "items": { "type": "string" } }, "permissions": { "type": "array" }, "responseStatus": { "type": "object", "properties": {} } } }
Click the + symbol and add another HTTP step:
Method: POST
URI: https://<DATACENTER>.coreview.com/api/executions/INSERT_WORKFLOW_ID_HERE
> DATACENTER Prefixes for above URL: > United States: wfusapi
> United States Gov: wfus2api
> Canada: wfcaapi
> EMEA: wfeuapi
> Workflow ID: Navigate to your CoreView Workflow > Id: > copy the Id and paste into the URL.Headers:
Acceptapplication/jsonAuthorizationBearer DYNAMIC_BEARER_TOKEN_INPUTx-scompanyAsk CoreView support for your company ID> For the Authorization header, insert the Bearer dynamic input, per the screenshot below.
> For the x-scompany header, open a ticket with CoreView Support inquiring for your Company ID for use within API connectors, and they will send you the unique Company ID for your tenant.
In the body field, use the following template format to build your JSON input for the CoreView Workflow:
{ “CoreView_Workflow_Input_1”: <Insert_Dynamic_Input_1>, “CoreView_Workflow_Input_2”: <Insert_Dynamic_Input_2>, “CoreView_Workflow_Input_3”: <Insert_Dynamic_Input_3>, }
NOTE: The final line has no comma at the end.
Click the + symbol; search for and add the Respond to a PowerApp or flow, and type True into both fields:
From within your PowerApp > click on PowerAutomate in the side command bar > Add flow > select your newly created flow.
Select the button that you are using for submitting to PowerAutomate.
Use the following code template to build your submission:
NAME_OF_YOUR_POWERAUTOMATE_WORKFLOW.run(INPUT_1.Text, INPUT_2.Text, INPUT_3.Text); Reset(INPUT_1);Reset(INPUT_2);Reset(INPUT_3);
Phase 4 - Testing- Click the play icon in the top-right of PowerApps
- Fill out your inputs and click your submission button.
- Go to your Workflow and confirm that it is running / has ran. If it did not, then you will need to review the steps above to ensure that you did not overlook anything.
PLEASE NOTE THAT COREVIEW SUPPORT IS UNABLE TO SUPPORT THIS PROCESS IN ANY WAY. IF YOU CANNOT DETERMINE THE ISSUE ON YOUR OWN, PLEASE CONSULT WITH YOUR COREVIEW Customer Success Manager (CSM) TO DETERMINE TROUBLESHOOTING OPTIONS, IF ANY.