New answers tagged

0

Unfortunately, we cannot sort the multichoice columns. Some workarounds: Workaround For each choice, create a new "Yes/No" column. For example, if you have Red, Green, Blue choices, then create new three columns: Name: Red, Type: Yes/No Name: Green, Type: Yes/No Name: Blue, Type: Yes/No Then you can sort and filter by individual columns you have ...


0

We can't short by count value since this is dynamically load based on the Group By field in View. In addition, we could only use default sort syntax(A,B,C OR 1,2,3) in group by.


0

Are you handling SharePoint list view with caml query? If so, you can use 3rd party tools like Caml designer to help you build the query you need. Source:https://www.biwug.be/resources


-1

You can set Item Level Permissions based on Column and Field values by using SharePoint Designer Workflow. You could refer to the following article to learn more infomation: How to Set SharePoint Item Level Permissions based on Column and Field Values


0

This is not recommended for large lists, but you want to set item level permissions using a Flow. The basic Flow would be: On item created or changed if field X = confidential run steps to set item-level permissions Google this: Set list item-level permissions in SharePoint using Flow


0

In addition to Ganesh answer (Which I really appreciate that), I also found another way to automate this in Power Automate (MS Flow) as mentioned in this post (Thanks to Chelsea and Rohit): Is there a way to stop editing an item when the approval status is pending in SP online list?


0

This gets a little tricky because the CSR cycle happens very early as a page is loading (it is rendering the contents of the page, after all), and making an AJAX request to SharePoint for additional data takes a while (in computer time), and it's very difficult to get the CSR process to wait for an asynchronous call to the server. So usually, my approach (as ...


0

Connections on lookup columns will not be affected. The list name under “Get information from:” will be automatically updated to the new list name, no data would be lost.


0

No. Changing list name will not affect any lists using lookup from this list. It will be automatically handled by SharePoint.


Top 50 recent answers are included