Power Apps Workout 09 - Custom Galleries

[henry.habib]

In this workout, we will work import in static data from Excel and create a custom gallery.

The objective is to create a sample Canvas app that has the following Gallery with the static data source of “Table 1” from Excel (see attached file). Note that the first text box should concatenate the First Name and Last Name together, as well as the date picker should default to the date the customer joined.

Please submit your solution in by taking a screenshot of your Power App, showing the “formula” you used on the First and Last name field.

File:
ImportFile.xlsx (10.5 KB)

Enjoy! Let me know if you have any questions.

Henry

[tweinzapfel]

@henry.habib -

Attached is my screenshot:

[henry.habib]

After you import in the Static data from Table1 from the attached file into your environment (see below), the next step is to adjust the “Fields” to Title and SubTitle only, to set the Title field to the concatenate of First Name and Last Name, and finally the Date Picker to the record’s Date (see below images).

Best,
Henry