Others

Create a SharePoint List Lookup Tool with Power Apps

John WilsonJohn Wilson Nov 20, 2026 869 views

Question details

Create a searchable tool that displays related learning records from a SharePoint list without requiring users to browse the list.

Create a SharePoint List Lookup Tool with Power Apps
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.
Before you start

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.

Solution 1Recommended

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.

1
Create a canvas app

In Power Apps, select Create and choose a blank canvas app. Give the app a name and choose a layout.

2
Connect the SharePoint list

In Power Apps Studio, open Data, select Add data, and choose SharePoint. Select the site and the list containing the learning records.

3
Add search and results controls

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.

4
Filter the gallery

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.

5
Show the related fields

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.

6
Test and share the app

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.

Build a Searchable Canvas App Connected to the SharePoint List
Check delegation and permissions: A delegation warning means Power Apps may evaluate only part of a large list. Test the formula with your column types and data, and use delegable filters where possible. Sharing the app does not replace access to the underlying SharePoint data.
Free Microsoft Office alternative

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.

Filter spreadsheet columns to find learning objectives, events, or lesson codesOpen and edit Microsoft Excel XLSX filesUse a familiar spreadsheet interface for an easier transitionWork with a free, lightweight office suite
microsoft office alternative - wps office

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.