Exercise – Create a canvas app with data from an Excel file


In this exercise, you’ll create a mobile application by using data from an Excel table. Download the RealEstateProperties.xlsx for use in this exercise.


Microsoft Power Apps requires a Microsoft 365 license or a free trial. Learn more about your licensing options. Microsoft products include Power Apps and Power Automate.

  1. Go to make.powerapps.com and sign in with your Power Apps credentials.

  2. From the Power Apps home screen, select Start with data.

  3. Select Upload an Excel file.

  4. Select the Select from device option. Go to the location where you saved the RealEstateProperties.xlsx Excel file and then upload it. (The maximum file size limit is 5 GB.)

  5. Power Apps generates a table that's based on the data from the RealEstateProperties.xlsx Excel file. Notice how Power Apps has named it Real Estate Property and has defined seven columns of data.

  6. Select the Create app button in the lower-right corner of the screen.

    Screenshot of the imported Real Estate Property table showing seven columns and the Create app button highlighted.

  7. When the app first loads, a dialog might appear stating Welcome to Power Apps Studio. If so, select the Skip button.

    The generated app should display in Edit mode.

    Screenshot of the generated app in Power Apps Studio.

  8. Select the Data icon from the left navigation bar. A Dataverse table is created based on the RealEstateProperties.xlsx Excel file.

    Screenshot of the Data icon on the left navigation bar.

  9. Select the Tree view icon to return to the Tree view.

    Screenshot of the Tree view icon on the left navigation bar.

  10. On the app's main screen, select the gallery that's displaying the Real Estate Properties details and then select RecordsGallery1 in the Tree view to expand it.

    Screenshot of the gallery displaying the Real Estate Property details.

  11. Select the ellipsis (...) next to the NextArrow option and then delete it.

    Screenshot showing the delete Next Arrow action.

  12. Select RecordsGallery1 and then select the edit button to put the gallery in edit mode.

    Screenshot showing the action of placing the gallery in edit mode.

  13. Reduce the width and move the position of the Title component so that it's toward the right side of the template cell.

    Screenshot showing the action of adjusting the size and position of the Title component.

    Other components should reposition alongside the Title component. If not, move them until they resemble the preceding screenshot.

  14. Make sure that the gallery is still in edit mode. Select the Title.

  15. Verify that the Text value of the Title component is set to the following formula:


    Screenshot of the text property in the formula bar.

  16. Select the Subtitle component in the gallery.

  17. Set the Text value of the Subtitle to the following formula:


  18. Using the tool bar in the upper part of the page, change the Size to 13.

    Screenshot of the size being set to 13 in the toolbar.

  19. Select the Body component in the gallery.

  20. Set the Text value of the Body to the following formula:


    Your gallery should now resemble the following screenshot.

    Screenshot of the Real Estate Properties gallery correctly formatted.

  21. With the first item in RecordsGallery1 selected, select Insert, search for Image, and then select the Image component. This will add an image to the gallery.

  22. The image should show as being added to your gallery. Reposition and resize the image so that it's in the center of each gallery cell.

    Screenshot of the centered image in the gallery.

  23. To use Microsoft Power Apps Ideas, make sure that the gallery is still in edit mode. Select the gallery body that contains the price. Select the arrow next to the copilot icon that appears above the price component. Select Text formatting.

    Screenshot of the gallery with the price component selected.

  24. Enter the following value for Desired format and press enter from your keyboard.


  25. Select the generated formula and then select Apply.


    With copilot's help, the example ($350,000) value that you entered generated the following formula, which now shows in the formula bar for the price gallery control:

    (Text(ThisItem.Price, "$#,##0", "en-US"))

  26. Complete the same steps for the Size control in the gallery subtitle. Make sure that the gallery is in edit mode. Select the subtitle that contains the size. Select the arrow next to the Copilot icon that appears above the size component. Select Text formatting.

  27. Enter the following value for Desired format:

    Size: 1,800 sq ft

    Press the Enter key on your keyboard.

    You might notice that the ideas section is empty. The cause might be a lack of information or context that's required for generating a formula.

    Screenshot of an empty formula.

  28. Because the ideas section is empty, you'll add more examples. Select + Add examples at least two more times.

    Screenshot of the Add examples button inside Power Apps Ideas.

  29. Select two current formats and then provide two corresponding desired formats.

    Screenshot of Current format options matching the Desired format options.

  30. With the added context, Power Apps Ideas generates a suitable formula for you, as shown in the following image.

    Screenshot of the Power Apps Ideas generated formula.

  31. Select the generated formula and then select Apply.

    Your gallery should resemble the following image.

    Screenshot of the formatted gallery.

  32. Save the app.

  33. Exit the app to return to the Power Apps home page.

    Screenshot of the Back button to exit the app.