how to view the lookup result of sharepoint online listItems

Question

Hello

This is my first time to ask a question in this site.
if there is something right, please let me know.

I am dealing with the site made by Sharepointonline recently.
This is my first time to use Sharepoint online.

I want to make the list in the site contents to be searchable.
But I can't find a way to make it right.

If there is anyone who can help me out, I am so happy.

In the list, there are too many data,so in the site page, I just want to show the results after seached by keywords.

For example, if there is a list named "test result" which have test scores of all students in each subjects.
I want to make the site page to show only the list data with the test socre is above 60 if I choose key to be above 60.( The search key may change everytime)

Is it possible to make a list data searchable in the Sharepoint online site like above?

Answer 1

Hi @e-kai ,

In this scenario, I think the best way is to create several list views based on your needs to display the filtered list items.

1. Go to the list, select Settings > List settings > Scroll down to Views section > Create view > Standard view.
2. Type the name whatever you want in View Name text box > Scroll down to Filter section > Select Show items only when the following is true: > Show the items when column [column_test score] is greater than 60.
   
3. Click "OK" at the bottom of the page to save.

As shown below, you can easily shift view to get the list items based on the filter condition you set in the view.

----------

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.