24 Days of PowerPlatform – Day 17 – Build your PowerPlatform Whish-App

24dopp_day17Welcome to today’s PowerPlatform blog post!

Christmas is approaching very fast and with the use of the PowerPlatform tools I would like to build a Christmas WishApp using PowerApps, PowerBI and Microsoft Flow.

We will build a PowerApp that gathers wishes from the requesters. Those wishes are displayed in a Power BI realtime dashboard which is filled by the use of a Microsoft Flow.

Create the Power BI Dataset

  • Open a browser and navigate to: powerbi.com
  • Log in with your Power BI User Account
  • We need to create a Power BI Streaming dataset (which serves as the datasource for the Santa Wish Dashboard)


  • Add a new streaming Dataset to your Workspace (Select API option)
  • Create the dataset with the following settings


Dataset name:   SantaWishes

WishName      TEXT

Quantity          NUMBER

Requester        TEXT

Historic data analysis     ON

  • Create a new Power BI report based on the data set


  • Create a report with a bar chart
    • X-Axis= WishName
    • Value = Quantity



  • Save this report “SantaWishReport”
  • For real-time DataVisuals we need to pin the chart on a dashboard
  • Switch to the Dashboard (to be prepared for real-time data)


Create Power Apps


  • PowerApps Studio starts in a new browser window -> “Create a form”


  • Add a Data Source to the form


  • New Connection -> SQL Server


  • Select WishProposals -> Connect


  • Close the Dialog and Select the Form
  • DELETE the contained placeholder
  • Add a “Dropdown” control and bind the datasource to the ‘dbo.Wishproposals’ element
  • Add Text Input control and change the default values


  • Rename the Dropdown AND the TextInput


  • Add a Label (that will hold the name of the Requester)
  • Bind the Text property to the current User’s fullname


  • Design the form – see an example below


  • Add a Button to the Form and assign an action
    • Select the Button , select the menu entry “ACTION” and select “FLOWS”


  • Create a new flow -> a new browser tab opens with the flow development environment
  • In the Flow Designer – add a new Step after the PowerApps trigger


  • Add a Power BI – “Add rows to a dataset” action


  • You are now signed into PowerBI.com
  • Configure the RealTime table in the dataset we created in the initial step


  • Now we need to data bind the destination columns using the variable values from the PowerApps source
  • Click into the textbox next to the WishName column -> “See more” -> “Ask in PowerApps”



  • Select the column names and bind them the PowerApps data fields (Requester = empty)


  • Save the flow
  • Switch back to PowerApps
  • Select the Flow created and Edit the OnSelected Action


  • The Flow needs some Parameters -> the WishName and the Quantity


  • Save the PowerApps and Test it



  • Switch to the Power BI dashboard and your wish should appear in the Power BI dashboard



Integrate PowerApps in Power BI

  • Save an Share the PowerApp (File Menu)
  • Switch back to Power BI
  • Open the Santa Report and switch to Edit Mode
  • Add the PowerApps custom visual (Import from Marketplace)
  • Add an instance of the PowerApps visual AND map at least one field from the data source to the PowerAppsData property


  • The visual changes – PowerApps is running in a custom visual
  • Use “Choose app” and select your SantaWishApp
  • Save the report and PIN the PowerApps Visual to the Santa Dashboard


  • Change the size of the Dashboard tiles and test your PowerPlatform Wish Solution!



Happy PowerPlatform-ing,




About wolfgang

Data Platform enthusiast
This entry was posted in 24 Days Of PowerPlatform, Power Platform. Bookmark the permalink.

4 Responses to 24 Days of PowerPlatform – Day 17 – Build your PowerPlatform Whish-App

  1. Pingback: 24 Days of PowerPlatform – Day 24 – Wrap Up | workingondata

  2. Alan Gilman says:

    Thanks for the demonstration. Very good use of all power platform apps working together. Trying to follow along and not sure what I’m doing wrong, but where did the SQL connection come in to play? Is the streaming dataset stored in an Azure SQL db?

    • wolfgang says:

      Hi Alan,
      The SQL Connection is used to fill the DropDown for the product selection with values.

      It is used for assigning the ‘dbo.WishProposals’ data object to the Items Collection of that DropDown.

      best regards

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s