Build next-gen apps with OpenAI and Microsoft Power Platform
Published Feb 15 2023 09:00 AM 23.6K Views

Today, we will talk about OpenAI and the Microsoft Power Platform and how to build next-gen application with it. Over the past few weeks, social-media feeds and newsletters have been filled with stories and conversations about artificial intelligence (AI). ChatGPT and OpenAI were often center of these conversations and today we will take a look at an exciting OpenAI and Power Platform scenario. We will discuss how developers can leverage OpenAI's APIs to build next-gen application using Microsoft Power Apps. For our scenario, we will use DALL·E 2 (a new AI system model) to create realistic images and art from a text description in natural language.


What is OpenAI

OpenAI is an AI research and deployment company. Developers can use OpenAI's APIs and build applications using their different trained models. OpenAI offers a spectrum of models with different levels of understanding or generating natural language or code. These models can be used for everything from content generation to semantic search and classification. Their current most popular model is GPT-3 that can understand and generate natural language. For today's scenario, we will use DALL·E 2 (a new AI system model) to create realistic images and art from a text description in natural language.

Note: Like GPT-3, DALL·E is a transformer language model. DALL·E is a 12-billion parameter version of GPT-3 trained to generate images from text descriptions, using a dataset of text–image pairs.

Power Apps integration with OpenAI and Azure API Management

We want to build a Power App and leverage OpenAI's trained model DALL·E 2 to create a realistic image from only a text description. All of this can be done by just a simple API call for OpenAI's image creation. We will use Azure API Management to help us securely expose OpenAI's API to the Microsoft Power Platform.

Azure API Management

Web APIs have experienced an exponential increase in popularity and usage in the past few years. APIs exist at the intersection of business, products, and technologies and have transformed the way businesses interact with each other and the way they provide value to their customers. The need for organizations to securely manage, deploy, monitor and share APIs has increased as well. Azure API Management helps to create consistent and modern API gateways for existing back-end services hosted anywhere, secure and protect them from abuse and overuse, and get insights into usage and health.



Step 1: Add OpenAI's API into your Azure API Management instance

  1. Sign into Azure portal and go to your API Management instance.
  2. In the left menu, select APIs > + Add API and select HTTP.


  3. Enter the following settings. Then select Create.
    Settings Value
    Display name openAIAPI
    Name openaiapi
    Web service URL
    API URL suffix openaiapi
  4. Navigate to the newly created API and select Add Operation. Enter the following settings and select Save.
    Settings Value
    Display name createimage
    URL for POST /images/generations
  5. Select your newly created operation and edit Frontend.
  6. Next, we need to add a Request Body to our API. For this, within our Frontend section scroll down and select Request. Now Add representation and insert the following information:
    CONTENT TYPE application/json
    DEFINITION {"prompt":"A cute baby sea otter","n":1,"size":"512x512"}


  7. Next, we will add a Response to our API. Select Responses and insert the following information via + Add response for 200 OK:
    CONTENT TYPE application/json
    DEFINITION {"created": 1589478378,"data": [{"url": "https://..."},{"url": "https://..."}]}


  8. Select Save.

Step 2: Configure a policy in Azure API Management

  1. Next, we need to assign a policy to our API to make sure we are passing along an API key for authentication.
    • Note: OpenAI API uses API keys for authentication. Visit your API Keys page to retrieve the API key you'll use in your requests.
  2. Select your operation and in the Inbound processing section, select the (</>) (code editor) icon:
            <base />
            <set-header name="Authorization" exists-action="override">
                <value>Bearer YOUR_API_KEY</value>
            <base />
            <base />
            <base />
  3. Select Save and we can now test our API in Azure API Management:
    • Select your operation.
    • Go to the Test tab.
    • Select Send.


Step 3: Create a custom connector via Azure API Management

As soon as your API was tested successfully, you are now able to export your web API to the Microsoft Power Platform. Please find a detailed guide here: Export APIs from Azure API Management to the Power Platform. If you want to add additional security to your API, check out our blog post on 10. Secure Connectors with API Management.


Step 4: Call your web API via your Power App

Next, we want to integrate our newly create custom connector in our Power App and make an API call.

  1. In your Power App, add your custom connector to your Power App via the tab data > + Add data.customconnectorpower.png
  2. Next, we modify our Generate Picture Button with the following PowerFX formula:
    ClearCollect(_datacollection, OpenAIAPI.createimage({prompt:TextInput1.Text,n:1,size:"512x512"}).data); 
  3. Next, we modify our Image2 with the following PowerFX formula:
  4. Now, you are able to test your Power App and create a picture via your text input parameters. This picture will be generated using OpenAI's DALL·E model. Enjoy generating some fun pictures.

Let us know what you think! @Julia Kasper

Version history
Last update:
‎Feb 14 2023 10:46 AM
Updated by: