SharePoint 2013 – Get sum of number fields and lookup field with Javascript

I’m creating a list that helps track employees projected hours they spend on projects as well as holiday, training and vacation hours. However the holiday field is part of a look up from another list. I also need the totals to show as employees fill out the form, not after they save it. So the Calculate Column does not work for this particular form. I know JavaScript can help but do not know how to have it calculate the regular columns and the lookup column. I will also then need to compare and validate against another lookup column. Can anyone help write that code?


Modernize SharePoint 2019 classic sites to modern experience team site

We are using SharePoint 2016 and are going to migrate to SharePoint 2019. After the migration all the existing sitecollections will still be in classic mode. We are using the classic team site template. How can I migrate all the existing classic sitecollections to the modern experience team site template?

How to display the SharePoint “Live Persona Card”?

In our SharePoint Framework web parts we want to show people information just like SharePoint does:

live persona card

When hovering over the name or image of somebody a popup like this should open. Looking at the source this thing seems to go by the moniker “Live Persona Card”:

live parsona card source code

Searching for LivePersonaCard yields few results. One is a blog post describing how to load and include this standard component via SPComponentLoader and some hard-coded IDs.

Since information is rare on this subject my question is: is this the way to go? Or is there an alternative component we should use, like from PnP oder Office UI Fabric (doesn’t seem so)?

Get value from Column and cut the duplicates using SharePoint Rest API

I’ve multiple folders inside the pages library enter image description here

Within each folder I have pages enter image description here

Grupo de produtos is of type taxonomy. I run the function GetPagesProd and for each item I get the value from Grupo de produtos, is it possible to get all the values from that column without searching one by one and cut the duplicate ones?

function GetPagesProd(FirstFolderProd, FirstFolderWithoutSpaceProd, GetTagFolder, valuri, SearchURIPagesFilesWS, PageTag){         jQuery.ajax({             url: SearchURIPagesFilesWS + "?$  select=ListItemAllFields&$  expand=ListItemAllFields",             type: "GET",             headers: {                 "accept": "application/json;odata=verbose",                 "content-type": "application/json;odata=verbose",             },              success: function (data) {                 var dataresult = data.d.results;                 dataresult = [];                 dataresult.forEach(function (key, value) {                     var TagIndividualPage = (key.ListItemAllFields.Intranet_SubCategoria.results["0"].Label);                      console.log(TagIndividualPage);                 });             },             error: function (error) {                 console.log(error);             }         });     } 

create hyperlink column default with button or image on sharepoint list 2013

We had one list name as “Data” with columns. under list, one column (Access) we need to fix with default data(URL). means when user click on “New Item”, access column data must be default URL. And also in place of URL column, can we put image or button. So when user click on default “Access” column, it will open new form.

Please suggest, how to achieve with SharePoint designer 2013.

Error While Initializing sharepoint tenant site collection names

Need Help Here is my Code:

    public List<string> LoadTenantSiteCollectionNames(Action<string> status)     {          try         {             this.SPBOXUITenant = new SharePointTenant(this);// Error there             return this.SPBOXUITenant.StrSiteCollections;         }         catch (Exception ex)         {             throw ex;         }         return null;     } 

It is giving below error,

Could not load file or assembly ‘Microsoft.Online.SharePoint.Client.Tenant, Version=, Culture=neutral, PublicKeyToken=71e9bce111e9429c’ or one of its dependencies. The located assembly’s manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)

Fetching modern sharepoint page comments and likes count using search api

I can’t seem to find the correct managed property for both modern Comments Count & Likes Count at all as all managed property within schema returned 0 counts. enter image description here

enter image description here

I would like to avoid additional query again just to get each items likes/comments count when querying news posts using search api.

How to display .eps file in the SharePoint picture library?

I have a picture library in which I will have .eps files as a record document.

After uploading the .eps file I am seeing the blank document thumbnail. But, however I want to see the document. Is there any way to see it? I searched over internet but could not find better solution. Are there any third party tool available to view the .eps file?