Showing/hiding specific rows based on Where conditions in Sharepoint lists (online)

Anna-pcm you need to start learning about Views as these filter your list by criteria that you determine.

So if you want a view that shows just Lost items click the dropdown in the top right of the list where it says All items and select New View:

Give your view a name - I should have called this Lost but was too eager with the typing!

Click the dropdown again where your new view is now listed and select Edit current view:

This will take you to the List settings screen for your view:

Scroll down to the Filter section and click the radio button that says Show items only when the following true, so I've selected the column LostFound is equal to Lost. Then scroll down to the bottom of the screen and click OK:

This will be the result:

You could then create another view for Found.

Rob
Los Gallardos
Microsoft Power Automate Community Super User.
Principal Consultant, SharePoint and Power Platform WSP (and classic 1967 Morris Traveller driver)