0

I want a functionality where users can bulk edit the items in SharePoint list using Edit in grid view option but they can't add new item in the list from edit in grid view as i want them to add items only from PowerApps form.

Is it possible to hide the Add new item button from Edit in grid view?

Also is there a way to restrict users from adding duplicate values in SharePoint list based on a column?

Improve this question

2 Answers 2

Reset to default
0

There is no SharePoint out of the box setting available to hide/disable "Add new Item" button at the bottom of list in "Edit in grid view" mode.

You can hide "New" option from command bar using JSON formatting:

{
  "commandBarProps" : {
    "commands": [
      {
        "key": "new",
        "hide": true
      }
    ]
  }
}

Documentation: Command bar customization syntax reference

You can restrict users from adding duplicate values in SharePoint list based on a column value by setting the specific column as "Unique" column from column settings:

enter image description here

Improve this answer
4
  • Thank you for your quick response. I dont want to show duplicates based on concatenated value of 3 columns. But in Concatenated columns we dont get this Enforce unique values option. How we can restrict users from entering same concatenated value as duplicate. Commented Nov 18, 2022 at 5:52
  • You cannot do it using SharePoint out of the box options, you have to manage it using formulas in Power apps customized forms. Commented Nov 18, 2022 at 6:03
  • Yes, we can use PowerApps but in that case if someone adds record from Grid View then that formula will not trigger. Commented Nov 18, 2022 at 6:05
  • I understood your concern but this is the limitation in SharePoint. In that case, you have to think about other approach like developing canvas application for bulk edit as well. Check this article and this video for same. Commented Nov 18, 2022 at 6:12
0

You can hide the new button from command bar using PowerShell command if editing every view is not an option. Refer to -> https://sharepoint-tricks.com/hide-the-new-button-from-sharepoint-document-library/

Regarding hiding from grid view - this is not possible, however, you can disable the grid-view from library settings.

Improve this answer
0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.