New answers tagged list
0
If you mean to use Person or Group column to auto-populate the manager, default values for People fields are not possible:
SharePoint O365/Online Default value for Person or Group field with XML or CSOM
Consider using Flow to update the list column with manager’s user account, or use PowerApps forms instead.
Please see the references here:
Set a people field ...
0
Need to avoid Double Bookings?
With JavaScript and jQuery you can query your calendar for conflicting events
Based on this image, the 'Event' needs a query that finds Events A,B,E and F (C and D don't overlap 'Event'). To determine if they are conflicts.
Start of Other Events are with the Start and End of this Event
End of Other Events are with the Start ...
0
Select the item, in the ribbon, click list tab, then click From Web Parts.
0
It's not recommend to create or add ungoverned code on modern SharePoint pages, you need to get started with SPFx:
https://sharepoint.uservoice.com/forums/329214-sites-and-collaboration/suggestions/17290130-bring-back-script-editor-web-part-in-modern-shar
You could consider using json formatting as shown below to increase the width of list column:
{
"$...
0
Instead of using "Contains" I used "is equal to" and I was able to filter the people picker using [Me] even with other names in the field.
0
i am using sharepoint 2010. I have a list where I use validation for my columns.
I want to hide field "Contract Extension Reason" when Type of Contract is equal to "Contract Extension"
I tried this but it says, "The formula contains a syntax error or is not supported."
=IF([Type of Contract]<>"Contract Extension"...
0
list = the primary "row" is data, and there may or may not be a document to attach.
library = the primary "row" is a document, and there may or may not be additional data fields to enter.
Also, while lists store attachments, the attachments aren't version controlled, and the user experience is not so great.
1
In the error message, it shows you use "contains" in the filter action.
Whether you use "contains" in the filter action in the two list, please check it.
Per my test in my end, this behavior is by default.
As a workaround, you could create a single line of text column in the list. Text column have the same value as person and group column....
0
Here is a sample formula for your reference:
=IF([Risk Score]="","",
IF([Risk Score]<=6,"Low",
IF([Risk Score]<=12,"Medium",
IF([Risk Score]<=19,"High","Extreme")
)
)
)
And the outcome:
0
(I am putting this here as I am new and do not have enough Rep to add a comment)
You have a few errors in the Syntax of your formula. Parenthesis in the incorrect places and OR functions in the wrong place as well as incorrect use of OR in the IF Statements.
The OR Function should come after the IF Function for those that require an OR comparison and each OR ...
0
Tally's suggestion is great for simple scenario.
As you have access to flow, I will suggest you to create a new list for recording the user leave balance and using flow to update it with your leave request.
The new list, let us call it Leave Balance list. You can use it to hold all the employees with detailed information of leave balance.
As you have already ...
0
Create a list of Employees, just with columns like Employee Name, DOB, Start Date, End Date. In list 2, which I'll call the 'Leave' list, create a look-up column that points towards the Employees list - you can select the Employee Name field; this will 'borrow' the Employee Name field for use on your Leave list.
For the 'calculation' of remaining leave you ...
0
I assume using Power Automate will be more handy to you. Two flows will be enough handling you task. One is to fill in the counter column with a auto increment variable. One is to reset the counter once a year.
There is type of flow called schedule flow which you can easily set it to run once a year at a certain time so this part is very easy.
Reference:...
0
In order to get this to work, you will need to store two numbers:
The current value of the auto-increment number
What year that auto-increment number is from (because you will need to check - if it's a new year, you need to reset the auto-increment number)
The way that I have gotten this to work most effectively is by storing those numbers as properties on ...
0
I'm a huge fan of Flow (PowerAutomate) so if you're up for it, you could:
Trigger flow on list item creation
Get list items & ID the highest value
Use a compose or variable to pull in the current year
Concat & update item
It's a little bit of parsing work, but shouldn't be a huge flow.
1
For now, SharePoint Online list validation does not support lookup column. If you need that, You may need to use Power Apps.
You can start from here:
https://techwizard.cloud/2020/02/08/powerapps-sharepoint-online-list-field-validation/
0
There is no such method to migrate classic items to modern list using Microsoft migration tool, we could only migrate the announcement list to modern site.
https://docs.microsoft.com/en-us/sharepointmigration/sharepoint-migration-supported-list-templates
For the ShareGate tool, I suggest you seek support in its official page.
0
You could check that under more details. Like the below screenshot shows:
0
I’m afraid not.
The Mailto: link is used to call the Outlook client on the local machine and then create a new email item. It can only be assigned with the contents we can fill in after we click the New Email button in the Outlook client.
The user who clicks the Mailto: link will need to configure the Outlook accounts manually on their end to be able to send ...
0
@Adam has provided a good method, and you can take a referecne of below csom powerhsell script:
Add-Type -Path 'C:\Program Files\Common Files\microsoft shared\Web Server Extensions\16\ISAPI\Microsoft.SharePoint.Client.dll'
#Mysite URL
$site = 'https://abc.sharepoint.com/sites/sbdev'
#Admin User Principal Name
$admin = 'admin@abc.onmicrosoft.com'
#Get ...
1
You need to include them in the context query so they will be initialized. By default not all properties of and object are initialized. I don't quite remember how to do include in plain PowerShell CSOM (I think it was not that easy).
For SharePoint Online I would suggest you to use PnP PowerShell which makes many things very easy, and always if something is ...
0
You will need to apply custom code via the SharePoint Framework (SPFx) on modern pages in SharePoint Server 2019.
See the reference here for a tutorial: Inject Custom CSS on SharePoint Modern Pages using SPFx Extensions.
Also see the link here for what customization is supported for the time being: Customizing "modern" site pages.
Please note that ...
0
I've made an answer upon Julie's suggestion:
{
"$schema":"https://developer.microsoft.com/json-schemas/sp/column-formatting.schema.json",
"elmType":"div",
"attributes":{
"class":{
"operator":"+",
"operands":[
...
0
What type of template is that , either Classic site or Modern site?
If it is Classic site you can add it into your master page else If it is modern site you need to create Application Extension customizer(SPFx) and add that app to your site collection
1
you need to merge them up so that you select items that you need in view. You can make this as
(Status equals to "Cancelled" OR Status equals to "Rejected" ) AND
(Cancelled Date >= [TODAY]-180 OR Rejected Date >= [TODAY]-180) AND
(Region equals to "1")
That should give you correct items.
0
You can do this with Column Formatting directly on the PromotedState column using this format:
{
"elmType": "span",
"txtContent": "=if(@currentField == 0, 'Sitepage', if(@currentField == 2, 'Newspage', ''))"
}
The double check is there to account for folders.
You can apply this format by adding the Promoted State ...
2
All Excel-style expressions begin with an equal (=) sign. This style of expression is only available in SharePoint Online (not SharePoint 2019).
https://docs.microsoft.com/en-us/sharepoint/dev/declarative-customization/column-formatting#excel-style-expressions
You need to use basic styled syntax, please refer to https://social.technet.microsoft.com/Forums/...
0
You could use a 'count related' lookup column to get close to what you need
to do this, you'll need to split in to two lists: one called 'devices' and on called 'reservations'
Now, create a lookup from reservations to device, so that when you make a reservation you can select a device.
Next, make a lookup from the device list to the reservations list. Make ...
1
It would be hard to render listforms in webparts directly, but if you look into PnP controls, you will find React List Form WebPart to render list form. It dynamiclly renders the list form with Display,New & Edit modes. The webpart is pretty much new.
https://github.com/pnp/sp-dev-fx-webparts/tree/master/samples/react-list-form
0
If we call this rest api directly,it reports this error.
Soluation:
https://developer.mozilla.org/en-US/docs/Web/Security/Mixed_content/How_to_fix_website_with_mixed_content
Updated code:
<script src="https://code.jquery.com/jquery-3.1.1.min.js"></script>
<script>
$(document).ready(function () {
$.ajax({...
1
Trigger = Recurrence (i.e. once a Month)
Action 2 = List rows present in a table (Excel Online for Business)
For each: ['value']
Action inside for each = Delete item (SharePoint) where id = int(items('For_each')?['Column1'])
Top 50 recent answers are included
