Power Apps Workout 10 - Search fields

[henry.habib]

In this workout, we will work import in static data from Excel and create a custom gallery that is filtered dynamically from a Search box.

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). The Gallery should be filtered based on a textbox, where a user can type in a First Name.

Please submit your solution in by taking a screenshot of your Power App, showing the “formula” you used on the Items parameter in the Gallery.

File:

ImportFile.xlsx

Enjoy! Let me know if you have any questions.

Henry

[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 Items parameter of the Gallery and use the Search field (see below images).

Best,
Henry