New answers tagged

1 vote

How to detect enabled QuickEdit on a List or Library from client?

If you want to restrict the users from modifying list settings (ie, changing the Quick Edit settings) , why can't you restrict them using permission levels? If you provide 'Contribute' permission to ...
user avatar
0 votes

How to detect enabled QuickEdit on a List or Library from client?

For the time being, we surely can and will parse the list's Advanced settings page, but a more elegant solution is very welcome.
user avatar
2 votes

How to detect enabled QuickEdit on a List or Library from client?

You can get the Quick Edit property value of list using SharePoint REST API. For all lists on the site: https://tenant.sharepoint.com/sites/siteName/_api/web/lists?$select=Title,DisableGridEditing ...
user avatar
  • 27.7k
0 votes

Sharepoint Limited-access user permission lockdown mode is enabled, open word file in desktop app

Please go to Library settings -> Versioning Settings -> Check whether set "Require documents to be checked out before they can be edited?" as "Yes".
user avatar
0 votes

How to find the largest number from a sharepoint list column?

Huu: welcome to Sharepoint.stackexchange. You can create a view in the list settings and then sort the list by Action Reference, descending. This default is to show 30 items in the list so not sure ...
user avatar
0 votes

Is there a way to create calculated column in sharePoint based on an excel export list?

I have tested the issue and I could not reproduce the error in my end. You can check my operation steps as following. 1.Create a SharePoint list based on an excel file. 2.Create a calculated column ...
user avatar
0 votes

How to display image in Sharepoint List from SQL Server

I am not sure whether Power Automate supports the SharePoint "Image" column type (As on 12/May/2022). See the screenshots below. Even the Power Apps started supporting the SharePoint list ...
user avatar
0 votes

What is the most efficient approach to pulling data (using Vue) from a SP list to then export it to Excel?

JavaScript arrays are more memory efficient than objects, so the data takes less memory. Reference: https://blog.kowalczyk.info/article/i/optimizing-javascript-by-using-arrays-instead-of-objects.html
user avatar
1 vote

How to Share a SharePoint list item to specific external user?

Per my research, 'Create sharing link for a file or folder' only supports files or folders in a document library. List items are not supported yet. You can refer to following document. https://docs....
user avatar
0 votes

How to hide certain fields in sharepoint list

You are asking how to hide column names in a grouped view. This was answered at SharePoint Online list - format group headers to remove column name. Use below JSON to format list view: { "$...
user avatar
0 votes

SharePoint list column formatting schema do not resolve

I tried to use your column formatting and it works successfully. I recommend you do troubleshooting, please try to change the formatting and then apply it to the other columns, check if the error ...
user avatar
0 votes

List element: allow multiple editos

My answer assumes you are referring to the Advanced setting, Item-level permissions. When Create and Edit access is set to Create items and edit items that were created by the user, the following ...
user avatar
0 votes

How do I view the "Created by" and other default columns?

While viewing the list, click on the down arrow next to any individual column, and find "Show/hide columns". This is confusing because that arrow is next to each individual column header, ...
user avatar
  • 101
0 votes

Trying to use WEEKDAY function to make a column always return a Friday date, based off another date column

I don't think the syntax of your formula is correct. Try something like this: =IF(IsBlank([Est. Stock Date]),"",IF(WEEKDAY([Est. Stock Date])=1,[Est. Stock Date]+5,IF(WEEKDAY([Est. Stock ...
user avatar
  • 502
0 votes

Creating Column conditional formatting that are only visible in specific views

This is not possible using a single field. Column formatting applies to the field (list or site column level) and is utilized in every view (unless completely overridden with a rowFormatter). However, ...
user avatar
  • 5,308
0 votes

Creating Column conditional formatting that are only visible in specific views

Column JSON formatting is applied at the column settings level and it cannot be controlled at list view level. If you want to highlight the row based on column values, you can use view formatting (...
user avatar
  • 27.7k
1 vote
Accepted

list formatting: multiple mailto-links break code

Are you putting them inside a div element? I've taken your code and modified it slightly and it seems to be working for me. The only things I've done are wrapping the two a elements in a div and ...
user avatar
  • 502
0 votes

Create an index that restarts in the beginning of each year

Firstly, create a column in your list called "Year" to store the year value (which will be used for filtering). In Power Automate, I hope you're using the "When an item is created" ...
user avatar
0 votes

Creating an auto-increment column in Lists which resets when value changes in another Column

The ID column is auto-generated and doesn't depend on any particular column value. It's basically an identifier that helps in fetching the particular list item. Solution - You can create a separate ...
user avatar
0 votes

Asset Management App - How do I filter a collection of lists displayed in a PowerApps gallery using a comboBox of people names?

You can use the filter function on the Gallery datasource to achieve this. Use the syntax like - Filter(colGallery, 'Created By'.Email = ComboBoxName.Selected.User.Email) colGallery is the list item ...
user avatar
0 votes

SharePoint List Advanced mode JSON Syntax for CC email to

You have to add CC part like cc=abc@xyz.com. Try using this JSON: { "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json", "...
user avatar
  • 27.7k

Top 50 recent answers are included