New answers tagged list
0
Currently, there is no OOB ways to have a tooltip displaying the full column name when hovering the column headers. I would suggest you submit a feedback in user voice here: https://sharepoint.uservoice.com/forums/329214-sites-and-collaboration
0
Here is what you can do:
Create a standard view containing [Title] column, Group by [Title], and Totals [Count] on [Title]
Then filter the view by selecting [Title]s in the headers of the view for which count >=3
See the screenshots below
0
The "Get changes for an item or a file (properties only)" action is something relatively new that I have used with success. This provides me fields that have changed.
Starting with the "When an item or a file is modified" action. I initialize 2 variables 1st is varID as an integer and value is set to the ID and the 2nd is an array to ...
0
Modern Sharepoint listview werbpart you can't do a search unless you click the 'See All' link located at the top right corner of the webpart and redirected to the list itself and from there you will do the search.
Options you can do is modify the SharePoint search results source , its located in the site settings
(but that I won't recommend since you all ...
0
As far as I know, for SharePoint in Microsoft 365, the Search Box Web Part is available only in classic experience.
So we couldn't add the list search box in modern site page.
Reference:
https://support.microsoft.com/en-us/office/about-configuring-the-search-box-web-part-b167ca75-b493-4f8b-8af6-ec94de1feb12#:~:text=To%20add%20a%20Search%20Box%20Web%20Part&...
0
Are you talking about below list view web part?
https://support.microsoft.com/en-us/office/use-the-list-web-part-ef0a1b80-f8b3-443d-b04a-1e76c70b5537
If so, it's possible to update its properties via code. For example, we can update it through PnPjs:
https://pnp.github.io/pnpjs/sp/clientside-pages/
public async UpdateSitePage(): Promise<void> {
...
0
Short answer to your question is No.
There is no index associated with the choice/option inside the choice column.
For a column configured as a Choice column, the order in which the items in the Choice list are presented is the order in which they are entered and listed in the Type each choice on a separate line text box in the Additional Column Settings ...
0
According to my experience, it should not be possible.
0
No, the custom javascript/html based form only works for classic view. It would not work in modern view.
The best way is using powerapps to custom the modern form: https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/gateway-management
0
In addition to Rune answer (appreciate that), I have found another way to accomplish this in a more practical way as demonstrated here:
Is there a way to stop editing an item when the approval status is pending in SP online list?
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?
1
Content editor web part won't work with Modern view...Customizing the default list form with what you need is only possible with a classic view where you can add javascript/HTML.
For the modern view - this kind of customization is not possible, you will have to build a form using SPFx web part to achieve this.
Another alternate way would be to have the ...
0
You could use Get-PnPListItem get all items you want to delete,
then you can use ListItem.DeleteObject method in the loop, or you could choose use Remove-PnPListItem in the loop.
1
Just run the condition for the third option first, use ISBLANK function to identify if “Actual Finish Date” is blank:
IF(NOT(ISBLANK([Actual Finish Date])), "Completed",
IF([Projected End Date] > TODAY()-1,"On Schedule","Project Slip")
)
Reference: IS functions.
0
I am answering as per my understanding from your question (correct me know if I am wrong).
If you want to show the Project State as "Completed" when "Actual Finish Date" has some value then try below formula:
=IF(ISBLANK([Actual Finish Date]), IF([Projected End Date] > [TodaysDate]-1, "On Schedule", "Project Slip"), ...
1
You can delete a list item/row using below command:
Remove-PnPListItem -List "Demo List" -Identity "1"
Where -Identity is the ID of the list item, or actual ListItem object.
Microsoft Official Reference: Remove-PnPListItem
If you want to remove all items from a SharePoint Online list then check below reference:
Remove all items from a ...
4
I think this is what you are asking for:
Remove-PnPListItem -List "[Your list Title goes here]" -Identity ($TheItemId)
0
With Microsoft's retirement of 2010 workflows, I replaced my 2010 workflow with a PowerAutomate (Flow). I was able to set the date field to null as per the picture below:
0
Sharing solution here for others dealing with in 2020 - need to fix registry key to adjust infopath client for multifactor settings:
Registry keyType Value
HKCU\SOFTWARE\Microsoft\Office\15.0\...
1
If you are using the OOB Events web part, the page to create new event from the "Add event” button is _layouts/15/Event.aspx and does not support customization.
These are built-in controls on this modern page and cannot be modified or removed.
Removing the columns from the Event content type will not have influence on this page or the Event list.
In ...
0
I am working on a similar problem with my SP team today! For a specific list in a workflow navigate to:
Settings>> Information Management Policy Settings>> WorkFlow History
Retention settings allow Stage property changes to configure when to archive or delete a list item.
Good luck!
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.
0
Retention has to be enabled through Central Administration
Central Administration > Security > Configure Information Management Policy (Under Information Policy) > Retention > Change the Status to "Available for use in new site and list policies."
1
If you want to change the column header and keep the list view as a standard SharePoint list view then No.
It is not possible to just change the column headers using JSON formatting.
If you want to customize the complete view and create a custom header then you can do that using view formatting. Check below View sample for reference:
Custom Header
Note: ...
1
There is no OOB setting in SharePoint for this requirement.
If you want to change the open behavior for the “Attach File” button in the list, you will need to use custom solution, which will be rather complicated since the item needs to be selected first.
0
If it is the creator, there may be no way to prevent him from accessing the data.But for visitors,you can try to add a permission level with only add permission to test.
0
This is the default value if you don't select the time you need.
You could change the time as needed:
Or if you want to capture the current time, go to list settings> choose the date column> set the default value as now:
After this, when we add a new list item, the date and time column will show current time as default value:
0
From my knowledge: No, you cannot protect an item from being modified by its creator.
However, there are means to deal with that. One method might be to change the ownership of an item, I read about different ways using EventHandler or Powershell tricks. But I cannot replicate them thorouhgly.
Nowadays I recommend using MS Flow, as a Flow is easy to set up ...
0
Here is my complete MS Flow/Power Automate example showing how to send alert email when a specific column value is changed. In the example, the current value is compared with the previous value by retrieving item's versions from the history using [Send an HTTP request..]
Please see the screenshots and explanation below
MS Flow triggers by [When an item is ...
0
It is hard to say where goes wrong without any information about how you create the new workflow. If you can provide the structure of your new 2013 workflow, we may be able to provide some help.
And as you are using SharePoint Online, I will suggest you to use MS Power Automate (Also called as Flow) instead of using 2013 workflow. It is more integrated with ...
0
Here is a post with similar request for your reference:
Send an Alert only when a specific column changes.
As is suggested in the post, you can use an additional column to compare with the column values to be followed, and send an email if they do not match the original value.
Top 50 recent answers are included
