ekai-8146 avatar image
0 Votes"
ekai-8146 asked AllenXu-MSFT commented

how to view the lookup result of sharepoint online listItems


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?

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

I'm currenly looking into this thread and testing on my site. I wiil get back to you ASAP.

0 Votes 0 ·

1 Answer

AllenXu-MSFT avatar image
0 Votes"
AllenXu-MSFT answered AllenXu-MSFT commented

Hi @ekai-8146 ,

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 151279-image.png > 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.

image.png (743 B)
image.png (11.8 KiB)
demogif.gif (239.5 KiB)
· 5
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi, AllenXu-MSFT

Thank you for the answer.
I was thinking of using view too, but the rule isn't pridictable.
It's depend on what site user want to look.

Sometimes it may be looked up by the name of the student, others, may be the date or the subject of the test that was taken.
So in order to answer the user's request, I want to make the list searchable by any colums value.

If you have additional suggestions for this, please let me know.

Thank you so much again for your help.

0 Votes 0 ·

@ekai-8146 ,

I want to confim with you all column types contained in your list. Kindly share here.

0 Votes 0 ·

Hi, AllenXu-MSFT

Thank you for the message again.

I should have listed the all the colums in the first place.
I'm sorry I took your extra time.

The Colums I have are below

・Name of sutudents text
・Grade of students choice( 9th, 10th, 11th, 12th)
・Subject choice( Biology, Chemistry, Bioethics, Art, Music....)
・Date of test Date(the time isn't involved)
・Test Score Number
・Remarks  MultiText

Some of the teachers want to see the result by the student name and the period(like this semester how the student is doing)
Other want to know by the subject and Scores so that they know who to be helped.
Other want to know by the Grade in order to support the students out for applying Univ.

Something like this.

I know how to put List of all data on the site page, but I don't know how to make lookup page for the ListData.
I am familiar with JavaScript so I try to make some look up page by JavaScript, but it seems I need Visual Studio( which I don't have license) to embed code in the site.

I can use Office 365 E3 license.
if combination with other software from Office 365, I can try like Power Apps.( I just start learning about what it is)

I hope there is a way to solve this problem.

0 Votes 0 ·
Show more comments