Microsoft List New VS Update

[wm-thompson]

In Microsoft List, there is a button for adding a new row in the upper left-hand side of the window.

What is a user only wants to update a record?

How can I provide the functionality where a user can either scroll through the list and pick one item to update or have the ability for the user to input an ID and look up the item to update that way?

[#2]

A user can select any item in the list and the item should open and be editable. They can also select Edit in grid view and edit like its an Excel file. And they can use the search box at the top of the window to search by ID or any other metadata.

[#3]

@wm-thompson You can select the list item and edit it like: 

You can filter the list items based on supported column in SharePoint list like: 

---

Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.