Create a SharePoint List Lookup Tool with Power Apps
Question details
Create a searchable tool that displays related learning records from a SharePoint list without requiring users to browse the list.

- Product
- Microsoft Power Apps and SharePoint
- Device & OS
- not provided
- Scenario
- Users need to enter a learning objective, event, or lesson code and view the associated records in an app.
- Observed behavior
- The desired tool displays matching SharePoint list records and their related fields through a Power Apps interface.
Confirm that the SharePoint list contains the code and related information columns you want to display. Check that you can connect to the list in Power Apps and that intended users can be granted access to the underlying SharePoint data.
Build a Searchable Canvas App Connected to the SharePoint List
Use a Power Apps canvas app to search list records and display matching fields in a gallery.
The example formula uses prefix matching on three text columns. Replace the list and column names with those in your SharePoint list, and check Power Apps for delegation warnings before using the app with a large list.
In Power Apps, select Create and choose a blank canvas app. Give the app a name and choose a layout.
In Power Apps Studio, open Data, select Add data, and choose SharePoint. Select the site and the list containing the learning records.
Use Insert to add a text input and a vertical gallery. Rename the text input to txtSearch, then select the gallery and set its data source to the SharePoint list.
Select the gallery and set its Items property to a formula such as Filter('Learning Objectives', StartsWith(LOCode, txtSearch.Text) || StartsWith(EventCode, txtSearch.Text) || StartsWith(LessonCode, txtSearch.Text)). Replace 'Learning Objectives', LOCode, EventCode, and LessonCode with your actual list and text column names.
Select the gallery and use Edit fields, or add labels inside the gallery, to display the objective, event, lesson, presentation, and source columns users need.
Select Preview, enter sample codes, and verify the results. Save and publish the app, then use Share to give users access to the app and grant them appropriate permissions to the SharePoint list.

Browse Learning Records in WPS Spreadsheets
For a spreadsheet-based alternative, WPS Office is a free, lightweight suite with a familiar interface. Open compatible Excel files and use filters to browse learning records; it does not replace a live SharePoint-connected Power Apps tool.

Frequently Asked Questions
Do users need SharePoint access if they only use the Power App?
Yes. Share the app through Power Apps and grant users appropriate permissions to the underlying SharePoint list. They do not need to browse the list directly to use the app.
Can users search by an objective, event, or lesson code?
Yes. Add a text input and set the gallery's Items property to a Filter formula that checks the relevant code columns. The StartsWith example matches codes beginning with the entered text.
Why might the app miss records in a large SharePoint list?
A nondelegable formula may process only a limited portion of the list. Check the formula for delegation warnings in Power Apps Studio and use supported filters and column types where possible.
How do I show presentations and source information in the results?
Select the results gallery in Power Apps Studio and choose Edit fields, or add labels inside the gallery and bind them to the presentation and source columns.




