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)

24dopp_day17_WishApp_01

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

24dopp_day17_WishApp_04

Dataset name:   SantaWishes

WishName      TEXT

Quantity          NUMBER

Requester        TEXT

Historic data analysis     ON

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

24dopp_day17_WishApp_05

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

24dopp_day17_WishApp_06

 

  • 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)

24dopp_day17_WishApp_09

Create Power Apps

24dopp_day17_WishApp_10

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

24dopp_day17_WishApp_11

  • Add a Data Source to the form

24dopp_day17_WishApp_12

  • New Connection -> SQL Server

24dopp_day17_WishApp_13

  • Select WishProposals -> Connect

24dopp_day17_WishApp_14

  • 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

24dopp_day17_WishApp_17

  • Rename the Dropdown AND the TextInput

24dopp_day17_WishApp_18

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

24dopp_day17_WishApp_19

  • Design the form – see an example below

24dopp_day17_WishApp_20

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

24dopp_day17_WishApp_21

  • 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

24dopp_day17_WishApp_22

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

24dopp_day17_WishApp_23

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

24dopp_day17_WishApp_24

  • 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”

24dopp_day17_WishApp_25

24dopp_day17_WishApp_26

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

24dopp_day17_WishApp_27

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

24dopp_day17_WishApp_28

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

24dopp_day17_WishApp_29

  • Save the PowerApps and Test it

24dopp_day17_WishApp_30

24dopp_day17_WishApp_31

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

24dopp_day17_WishApp_32

 

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

24dopp_day17_WishApp_37

  • 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

24dopp_day17_WishApp_40

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

24dopp_day17_WishApp_41

24dopp_day17_final

Happy PowerPlatform-ing,

Wolfgang

 

Advertisements

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
      Wolfgang

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