Microsoft SharePoint





Microsoft Sharepoint is a software platform and family of software products used for collaboration and web publishing combined. These capabilities include developing web sites, portals, intranets, content management systems, search engines, wikis, blogs, and other tools for business intelligence and collaboration. SharePoint has a Microsoft Office-like interface, and it is closely integrated with the Office suite.

Share tech news, updates, or what's on your mind.

Sign up to Post

SharePoint calculated field

I have three columns


I want field 3 to = complete if field1 and field2 are complete, otherwise the field should = initial

is that doable?
Free Tool: Path Explorer
LVL 12
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

environment sp 2010 workflows on 2013 - no farm admin support, full control only 2013 workflows not available. JS within a page is ok.

I have a workflow which emails out certain list record information.
In this email, I need to put a link which will start another workflow (set to manual) without displaying the initiation screen. This second one can't be set to new/modified triggers. On a private LAN - assume user who reads the email is also authenticated to the list and have permissions to the list. Mobile access etc not needed.  The link can include whatever information needs to be passed (ID, list guid, ... )

I've seen several posts about this but none seem to skip the initiation screen. I don't mind them linking to a page with parameters which tend runs JS and then afterwards directs to the home page of site if necessary. I know how to do the JS to update the record appropriately but was hoping for a workflow based solution entirely. After the JS finishes I don't want to leave the user in the editform - they should never see the editform - just click on the link in outlook and it does the rest without users being involved.

I do not want to put links in the view of the list - only in Outlook
How to copy files from o365 onedrive to customized sharepoint intranet
How to make customized share point default sharepoint landing page in o365 sharepoint.please help me urgent!!
Looking for some solid advice on starting to use O365. Currently have a company that has roughly 700 users. They have an on-prem data center that includes an Exchange 2010 array along with a SharePoint 2010 environment. They have purchased enough licenses at this time for O365 as they would like to move to SharePoint online. They would like to keep Exchange on-prem for the time being and start to utilize some of the other features of O365 like OneDrive and Teams. My questions is, what is the best way to setup the Azure AD connect at this time. Should I setup the Hybrid environment now for Exchange so that it is ready to move to Exchange online in the future or just wait until that time comes, if ever? I ran IDFX tool and it came back showing that all the users UPN and proxy addresses are showing the user@domain.local. I can easily fix the UPN addresses and add the but what should I do about the proxy addresses? I read that you can remove the @domain.local from Exchange but that may cause some other mail routing problems. Should I just leave it, what have others done? I Just don’t want to initiate an AD sync now, mess anything up or make more work for myself. I look forward to hearing from you.

Thank you!
I'm new to Sharepoint (online) design.  I've got a library of documents uploaded to my site and a set of pages that roughly correspond to subfolders of these files.  On each of these pages, I would like to include the "Document Library" web part and have it point by default to the subfolder that it corresponds to.  I would also prefer to not upload each of these subfolders as their own document libraries.  Is it possible to set the starting folder for the document library web part, either within the page itself or within a document library view?  If so, how?

I have an ASP.NET MVC app that is a SharePoint provider-hosted app hosted in Azure.

I am using Excel interop to create an Excel document that I am trying to download.

The code to generate the Excel document works fine, however I am not able to retrieve the file bytes directly from the Excel app. The workbook needs to first be saved to a file.

I tried using io.Path.GetTempFileName(); to save the file to a temp folder, but when the file is read back from that location, it reads 0 bytes[]. Another thing I tried is using Azure Storage, but I was still unable to get the file bytes.

using System.Web;
using Excel = Microsoft.Office.Interop.Excel;
using io = System.IO;

namespace Intervate.SharePointAppDemoWeb.Models
    public class ExcelOperations
        public byte[] GetATB()
            var excelApp = new Excel.Application
                Visible = true
            Excel._Worksheet workSheet = excelApp.ActiveSheet;
            workSheet.Name = "Test Worksheet";
            workSheet.Cells[1, "A"] = "Test";

            //string AccountName = ConfigurationManager.AppSettings["AccountName"].ToString();
            //string AccountKey = ConfigurationManager.AppSettings["AccountKey"].ToString();

            //CloudStorageAccount cloudStorageAccount = CloudStorageAccount.Parse("DefaultEndpointsProtocol=https;AccountName=" + AccountName + ";AccountKey=" + AccountKey + "");

Open in new window

Hi all,

Is there way to hide the Site Contents link in Sharepoint Online, specifically from the cog menu please?

Here's a screenshot:

Office365 support hasn't responded for 3 weeks.. so have given up on them.

And other articles online are all referring to the removal of Site Contents link from the Quick Launch menu.

The idea is to block them for everyone except site owners.

Any help / pointers highly appreciated.
We are looking for an alternative to SharePoint Foundation 2010 which is coming to end of life.
There is the possibility to move to Foundation 2013 (still free), but this also has only a few years of life left.

There are a confusing amount of possible alternatives out there and before I start sifting through them I thought I would ask the Experts what they thought.
We are happy to have either a cloud based or on premise solution and although what we have now is free we would be prepared to pay a little for something that has wow appeal.

We are a construction company and use SharePoint as a document store, photo gallery and very basic workflow (question/answer lists) for each of the 5 - 10 projects we are working on. What we like most is it is storage with meta data (who posted, who modified, when and various custom columns we have created) much more useful than just storing in folders as we did in the past. More document management than collaboration.

Our Intranet (only AD users are ever likely to to use it) needs are:

1. Storage for Word, Excel, PDF files with meta data we can add (Who, When, Where, Custom Columns etc), and batch upload/download.
2. Very simple Workflow. An uploaded or emailed document sits there until it has been actioned, after which it becomes easily identifiable as complete.
3. Photo Gallery - Single or multiple uploads, Albums, Thumbnail views, Auto Date stamping, Indexing.
4. Custom permissions on each site and within each site for …
SharePoint workflow limitations - won't associate - I have a long workflow (37 pages long) about  80 workflow variables, but the files are all less than 600KB (well below the 5M limit).
I reduced the number of workflow variables and that helped but still this problem if I try to add too much logic.
When I add additional statements sometimes the workflow fails association when attempting to publish.  However, when I take out those statements, it publishes fine.  
It doesn't seem to be dependent on what I add - even a simple log statement can cause this problem.  I'm not running into the limit of steps or how nested things are from my reading of the MS documentation.  Impractical to split this into 2 (or more) workflows as would take a lot of coordination between them to prevent inappropriate cross-triggering (they would both need to modify the record and are set to run on modification).
Environment :  SP 2013 with ONLY SP 2010 workflows, Full control only - no SCA, no support from farm admins - cannot change anything at farm level.
Get expert help—faster!
LVL 12
Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

how to implement in sharepoint?

To check special characters I think you need JS validation. To do that, just load or inject the following js function into your edit/new form .aspx

function PreSaveAction(){
    var format = /[ !@#$%^&*()_+\-=\[\]{};':"\\|,.<>\/?]/;
    var fldName = 'Title';
    var fldType = 'Text'
    var ctrl = $('[id^='+fldName+'_][id$='+fldType+'Field]');
    if(ctrl && !format.test(ctrl.val())){
       return true;
    return false;
SharePoint 2016 on premise - Can I have a global CSS file at the site collection or site level then just apply the .CSS (SASS) classes at the web part level?

I am reading that SharePoint 2016 is now supporting SASS, and it looks like in all the examples each web part has its own CSS file. Is this a requirement or can I have a single global and just assign the .class to the web part?

Also is there a reason having a global .css at the site or site collection level is a bad idea?
SharePoint 2016 on premise - is there any part of building new sites that will NOT work with responsive design?

With frameworks there is always a way to find a solution, but sometimes its just best to stay away from certain things on mobile. Does anybody have a SharePoint 2016 on prem horror story of something they thought would work great on mobile / responsive design that just went horribly wrong?

I have read that SharePoint 2016 support mobile design, but for fully responsive we should build the web parts using React or Angular for full responsive. However I am sure there are limits and things that we should never attempt to do on Mobile. Please share any of those experiances
SharePoint 2016 on premise - can the server side web service be anything that accepts JSON?

We are running SharePoint 2016 on premise and will stay on premise for at least the next 2 years. I have been reading that most of the development done with SharePoint 2016 is client side development meaning that the web part executes on the client endpoint, not server side language is needed.

However for some of the custom apps where we need the business logic in c# / WCF or something like that, will it work with anything that accepts and returns JSON?

Microsoft recommends using "Azure Functions" for this, but again we have web services in our environment that can JSON, so we want to leverage the existing infrastructure.
I have a sharepoint 2013 environment.  there is one database log file that gets very large over the weekend.  it is the transaction log for sharepoint config.
could i hurt the system operational if i limit the size of the transaction file to say... 4 gigs.  it grows to 26 gigs over the weekend.  all the db's for sharepoint are in simple mode.
We set up a taxonomy term store in SharePoint 2016 to be utilize for tagging documents with metadata within a document library.   One of the goals is to achieve a true cascading parent / child / grandchild relationship that will function in datasheet view to quickly assign metadata to the documents.

Parents in the terrm set include Hardware, Software, Disaster Recovery, etc.    Children of Hardware would be printers, servers, laptops, desktops and so on and grandchildren would be HP, Dell, Fujitsu, etc.  

Children of Software would be Revu Extreme, Acrobat Professional, Rapid Recovery and likewise grandchildren would be Bluebeam, Adobe and Quest.

Within the document library, three managed metadata coumn have been setup which reference the term store.   When fillng in the values you do get the nice flowchart diagram to assist in choosing the right value but honestly, you can put any value in any column, just as long as that value exists anywhere in the term set.   I can put Adobe in column 1, Fujitsu in column 2 and Disaster Recovery in the third column, all which are in the incorrect columns and unrelated.

Is there a way to lock column one values to only accept parent values, column two values to accept only related children values based on column one's selection, and column three values locked to grandchildren related to to the child record selected in column two?    

Thanks in advance for your assistance
I am trying to include some text blocks on a SharePoint 2013 Survey.  It would seem that there would be some functionality that allows for this, but there is not.  Is there a way around this?  I need to include some titles and directions at the beginning of the survey, and some informational text throughout the survey.
I need a formula to calculate the number of days past the Due Date in a SharePoint 2010 List.

I have successfully created the formula for calculating the number of days until the Due date:

=DATEDIF(TODAY(),[Due Date],"D"

But I need to be able to count the number of days that are past the Due Date.

Thank you
We have a SP 2013 Farm and there are some five service accounts password needs to change. I would like to know how to proceed for that and after changing of password the Farm should run smoothly. If any one has any idea about if and steps to follow for password change it would be helpful for me.
We have one Application, one WFE server and one DB server. All services are configured in App Server, web request resoled from WFE server and used SQL DB (2012) as database server.
Please let me know if you need any more information.
Free Tool: Subnet Calculator
LVL 12
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Long question for you all.

I am using AutoSPInstaller to install and configure a multi-server farm for a customer (SharePoint 2013 Enterprise). In my DEV environment it works perfectly (albeit with some slightly different names).

In the live environment, it gets as far as creating the first Site Collection in the first Web Application, and it errors out - "sharepoint autospinstaller feature with id c85e5759-f323-4efb-b548-443d2216efb5 is not installed in this farm". When I checked the Central Admin site, it was stopped in IIS - when I started it, I was able to access the site - and I am unable to create the Site Collection via the GUI - it returns the same error.

The customer does have various permissions locked down in the environment - this may have something to do with it, or it could be an issue with the SQL server.

Before I try and get the other teams to investigate their side of things, is there anything anyone can suggest that I can check to help me rule out any issues with the SharePoint servers and AutoSPInstaller?

SharePoint 2010 on Windows 2012 R2 Server

Trying to run a script that backs up the farm  (This script was posted to: )   using version 2.3

I run this using task scheduler  

-version 2 c:\util\farm-backup.ps1

This starts powershell in version 2 which is needed to run the scripts.

It starts and I receive this error:
09-Mar-2018 10:00:07      Info: Drive F: successfully mounted.
09-Mar-2018 10:00:07      Info: Determining if there is sufficient storage available for farm backup.
09-Mar-2018 10:00:07      Info: Total storage available for farm backup: 886.44 GB (95%).
09-Mar-2018 10:00:07      Warning: A problem occurred whilst determining the total storage required for the farm backup. Reason: Microsoft SharePoint is not supported with version 4.0.30319.42000 of the Microsoft .Net Runtime.
09-Mar-2018 10:00:09      Info: Dismounting drive F:.
09-Mar-2018 10:00:09      Info: Drive F: successfully dismounted.
09-Mar-2018 10:00:09      Info: Attempting to connect to SharePoint farm.
09-Mar-2018 10:00:09      Error: Unable to access farm. Reason: Microsoft SharePoint is not supported with version 4.0.30319.42000 of the Microsoft .Net Runtime.
09-Mar-2018 10:00:11      Result: SharePoint site/farm backup job exited prematurely with error(s).

Any ideas?


This is a PowerApps question.

I have a collection from a SharePoint list that is the source for a gallery.  Each item displayed also has an icon the gallery row which should change its status; that should update the record in the collection (which in turn will remove it from the gallery because of a Filter).  My problem is that ALL of the collection items are being updated, not just the single one from the gallery i want.

For OnSelect for the icon, I have

UpdateIf(collection, Title=galItems.Selected.lblItemName.Text

I am now believing that as UpdateIf processes all of the records in the colleciton, not just the single one.  I believe the above condition is TRUE as UpdateIf processes everything in the collection.  Tried all sorts of conditions but nothing changes.

How do I get a condition that specifies the one and only record in the collection?  Title would be unique in the collection and therefore in the gallery.
I have the following line I have used in the past to set a dashboard icon, how would I add another condition and if ttl_qsa_fin NE 0

<xsl:if test="normalize-space(@ttl_qsr_fin) = 0">

I am using the SharePoint _layouts/15/getpreview.ashx handler to create thumbnails of Word documents. The preview works well, but I am struggling to increase the resolution. Below is the img src value. No matter what I change the "resolution" querystring parameter to, the image size doesn't change.

I am using the image in a provider-hosted SharePoint MVC app.


Open in new window

By Application.ActiveWorkbook.Path

Yesterday I got

but today I had

within Citrix, to the same physical file inside Citrix. I know Citrix can be running physically on different Windows servers. Is there a way to ensure that we can ALWAYS HAVE ONE PHYSICAL PLACE (or path), to one file within Sharepoint?

Microsoft SharePoint





Microsoft Sharepoint is a software platform and family of software products used for collaboration and web publishing combined. These capabilities include developing web sites, portals, intranets, content management systems, search engines, wikis, blogs, and other tools for business intelligence and collaboration. SharePoint has a Microsoft Office-like interface, and it is closely integrated with the Office suite.