Hide Passwords In Power Automate Flows (and API Keys, Secrets)

Imported reference from Matthew Devaney's blog for learning purposes. Original: https://www.matthewdevaney.com/hide-passwords-in-power-automate-flows-and-api-keys-secrets/. Author: Matthew Devaney.

Hide Passwords In Power Automate Flows (and API Keys, Secrets) Posted by - Matthew Devaney on - September 26, 2021 10 Comments

The HTTP action in Power Automate often requires a secret password (also known as an API key) to be input. But we don’t want others to see the password when browsing the flow history. By using Azure Key Vault and securing the flow inputs and outputs we can hide this password so no one can view it. In this article I will show you how to hide passwords in Power Automate Flows Table of Contents

Introduction: The Currency Exchange Rate Flow What Is Azure Key Vault? Create An Azure Key Vault Add A Password To An Azure Key Vault

Get A Password From An Azure Key Vault In A Power Automate Flow

Hide A Password In Power Automate Flow Inputs and Flow Outputs Hide The Password For An HTTP Action

Introduction: The Currency Exchange Rate Flow

Employees at a multi-national company use a Power Automate flow to get the current exchange rate between US Dollars (USD) and Japanese Yen (JPY) from the Alpha Vantage API . Access to the API requires a password which must remain hidden from anyone who is browsing the flow history. What Is Azure Key Vault?

Azure key vault is a service that allows you to securely store passwords, keys, secrets, etc. that are used by other apps and cloud services. We will use it as an online password manager that can interact with Microsoft Flow. When you sign up for an Azure trial you receive a free billing credit which allows you to use Azure Key Vault for free. After the billing credit is fully consumed you can continue to use key vault and it will be added to your monthly Azure bill. It’s extremely cheap – we’re talking pennies on the dollar for most use cases and its well worth it. Create An Azure Key Vault

We will begin by creating a new Key Vault. Login to Azure and select key vaults from the services category.

Click the create button on the key vaults home screen.

Input a resource group and a key vault name . The resource group helps you track Azure costs on your monthly bill whereas the key vault name identifies the key vault. One finished select the Review + Create button at the bottom of the form.

Validation of the key vault will take a few moments to be completed. Once validation is passed click the Create button to end the key vault setup.

Upon creating the key vault we are taken to a deployment overview screen. Press the Go to resource button to open the key vault (or alternatively search for it in the search bar). Add A Password To An Azure Key Vault

We want to use Power Automate to get the Alpha Vantage password (i.e. API key) from the Azure Key Vault. The next step is to add a password to the vault. Click on the key vault name to open it.

Use the left-navigation menu to browse to the Secrets page. Generate/Import a new secret.

Choose to manually type in a secret name and value . The secret name is the identifier we will see in Microsoft Flow. The value is the password we want to hide. Input value as the 4-letter lowercase word demo and click the create button.

Get A Password From An Azure Key Vault In A Power Automate Flow

Now that we have setup our Azure key vault and creating a secret to store the password its time to create our Power Automate flow. Start a new Instant Flow and add an action called Azure Key Vault – Get Secret . Select the alphavantagekey name from the dropdown.

Run the flow to see what happens. The Get secret flow action exposes the secret password. Oops! We need to secure the flow inputs and outputs so users can’t see this information in the flow history.

Hide A Password In Power Automate Flow Inputs and Flow Outputs

To hide the password click on the three dots within the Get secret action and choose Settings.

Toggle the Secure Inputs and Secure Outputs options On . Then select the Done button.

Re-run the flow. Now when we browse the flow history our password is hidden and the message “Content not shown due to security configuration” shows in its place. Hide The Password For An HTTP Action

Employees at the multi-national company use the Alpha Vantage API to get the current exchange rate between US Dollars and Japanese Yen. Create a new HTTP action in the flow and fill-in the parameters as shown below. Information about how to use the Currency Exchange Rate endpoint of the Alpha Vantage API can be found in its API documentation .

Open the HTTP action settings and toggle Secure Inputs On. We want to see the output of the HTTP action so leave Secure Outputs toggle Off. Click Done at the bottom of the form.

Run the Power Automate flow to give it a test. All of the passwords are successfully hidden and we only see the flow output.

For reference, the resulting JSON object from the flow looks like this and can be used in subsequent flow actions. { "Realtime Currency Exchange Rate" :{ "1. From_Currency Code" : "USD" ,

"2. From_Currency Name" : "United States Dollar" , "3. To_Currency Code" : "JPY" ,

"4. To_Currency Name" : "Japanese Yen" , "5. Exchange Rate" : "109.42800000" ,

"6. Last Refreshed" : "2021-09-22 01:25:02" , "7. Time Zone" : "UTC" , "8. Bid Price" : "109.42610000" , "9. Ask Price" : "109.43200000" } } Code language: JSON / JSON with Comments ( json ) Did You Enjoy This Article? 😺

Subscribe to get new Copilot Studio articles sent to your inbox each week for FREE Enter your email address Sign Me Up Questions?

If you have any questions or feedback about Hide Passwords In Power Automate Flows (API Keys, Secrets) please leave a message in the comments section below. You can post using your email address and are not required to create an account to join the discussion. Azure HTTP Action Key Vault Matthew Devaney Power Automate

Save Docusign Document To SharePoint With Power Automate