Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x

Microsoft SharePoint

37K

Solutions

19K

Contributors

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

Hi, I need a SP2013 calendar with three main categories: Department, Events and Other. This part I can achieve by creating 3 calendars and using overlays to combine them into a single view.
But then I need subcategories of John, Hayley, Mary and Victor for each of the 3 main categories so if I create a calendar entry for Events for example, I can associate John and Hayley to the entry.
How can I then create a view for each of the subcategories e.g. a view for John that shows all items where John is associated for Department, Events and Other?
0
Keep up with what's happening at Experts Exchange!
LVL 11
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

I'm struggling with overcoming the 5000 document limit on libraries for SharePoint O365.

We're using the Document Center flavor of SharePoint and had thought that we could configure it to support greater than 5,000 documents (if we used indexes on key metadata fields) to 20,000 (or ideally even more) documents per library.

It doesn't seem that's the case.  There's a note with the articles we've found where SharePoint OnLine doesn't support doing this (whereas all non-MS hosted SparePoint versions do).

Is this a limit we can't adjust to 20,000 with SharePoint O365 or are we just missing on where we can modify it?
0
I am using SharePoint 2013.  

I am using Handlebars to display my SharePoint list into a table, which works.  But when I try to turn it into a dataTable, it does not transform into a dataTable.  I was able to do it in jsFiddle and it works.  Can you see what I am doing wrong?  

siteAdmin.html
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">

<head>
<script type="text/javascript" src="https://cdnjs.cloudflare.com/ajax/libs/jquery/3.2.1/jquery.min.js"></script>
<!-- Handlebar Js Template Starts Here --> 
<script type="text/javascript" src="https://cdnjs.cloudflare.com/ajax/libs/handlebars.js/4.0.10/handlebars.min.js"></script>   
<script type="text/javascript" src="https://cdnjs.cloudflare.com/ajax/libs/moment.js/2.18.1/moment.min.js"></script>
<script type="text/javascript" src="https://cdn.datatables.net/1.10.16/js/jquery.dataTables.min.js"></script>
<script type="text/javascript" src="http://understandsp.com/spdev/SiteAssets/siteAdmins.js"></script>

<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/datatables/1.10.16/css/jquery.dataTables.css" />
<script id="siteadmin-template" type="text/x-handlebars-template">
 
<table border=1 width="100%" id="example" class="display"> 
<thead>
	<tr>
		<th>Picture</th>
		<th>First Name</th>
		<th>Last Name</th>
		<th>Email</th>
		<th>Phone</th>
	</tr>

Open in new window

0
Trying to create a List called 'Contact List' on a SharePoint site, https://mainsite.sharepoint.com/sites/Client/List/ContactList, that has a number of columns (Phone -single line of text w/ length 12, Notes - multiple lines of text, Position - managed metadata, Active -
 Yes/No, Sign Date - Date (Date Only))  and I can create the list via PowerShell PnP but I cannot create the columns no matter what I have tired.  I am using SharePoint Online and Powershell Pnp.  I cannot find one place with an example that will work.  Does anyone know of a web site of examples or have an example they can share?

Thanks,
John
0
Hi,

We have a client who has moved their file structure to Sharepoint. They have a file structure that holds their products and want to share these folders with clients.

I can see that you can share individual folders but when I highlight more than 1 folder the 'Share' option blacks out.

Is there a way of sharing multiple folders?
0
We rely heavily on an Access database within our team to control actions that we need to undertake.  This is basically recording the action to be undertaken, its status, its completion by date and a progress log.  The action to be undertaken and completion by date remains static but the users assigned to the action are responsible for updating the status and progress log.
The database is secured on a share file so no other departments can gain access.  As a result the database doesn’t utilise usernames or passwords.  Instead there is a table of network usernames and the email addresses (so email reminders can be sent), it’s a static team of about 10 people so doesn’t require any maintenance.  There is then a procedure when the database loads that determines the windows username the user has logged in with and uses this to filter the actions only allocated to them (=environ("username").  Actions are assigned to the users username basically.

The problem we have is that we are starting to allocate these actions to people outside our department.  The current process which is now separate to the above is that the action is set to an email address and when the completion by date is passed, an email is sent asking them for an update on progress.  Once this update has been received by our department, someone must manually go and update the records based on the email response.  This is becoming a more time consuming task as we asign more and more actions to people outside our …
0
We rely heavily on an Access database within our team to control actions that we need to undertake.  This is basically recording the action to be undertaken, its status, its completion by date and a progress log.  The action to be undertaken and completion by date remains static but the users assigned to the action are responsible for updating the status and progress log.
The database is secured on a share file so no other departments can gain access.  As a result the database doesn’t utilise usernames or passwords.  Instead there is a table of network usernames and the email addresses (so email reminders can be sent), it’s a static team of about 10 people so doesn’t require any maintenance.  There is then a procedure when the database loads that determines the windows username the user has logged in with and uses this to filter the actions only allocated to them (=environ("username").  Actions are assigned to the users username basically.

The problem we have is that we are starting to allocate these actions to people outside our department.  The current process which is now separate to the above is that the action is set to an email address and when the completion by date is passed, an email is sent asking them for an update on progress.  Once this update has been received by our department, someone must manually go and update the records based on the email response.  This is becoming a more time consuming task as we asign more and more actions to people outside our …
0
We installed windows updates on server 2008 R2 with SharePoint 2010. Everyone has their assigned permission but no one can upload or modify intranet. When we are trying to modify it give us read only access but when we are checking the actual permission we have admin privileges..

Regards
0
We are in the process of Migrating from On-Premise Exchange and Sharepoint to Office 365 with Sharepoint.

We currently have an On-Premise Sharepoint 2013 Servers. We host Mail and Sharepoint for a few Companies, so the Sharepoint server is home to several Root level Sites:
team.domain-A.com
team.domain-B.com
team.domain-C.com
team.domain-D.com

Each root site is Managed by their own Administrators and the users are different for each site.
All users are part of the same Activity Directory Domain.
I have all of the domains Validated in Office 365 and mail is flowing to all of them.

I just dont see where I can Add a new Root level Domain  and separate site for each of the existing sites I have.
0
We have an O365 environment with Sharepoint for shared files and OneDrive for redirected folders.  However, on one user's computer, the old OneDrive for Business client will not install and there is an icon in Explorer for OneDrive - <TenantName> where the user's profile folders are properly redirected and show up.  However, there is also a OneDrive link in windows explorer that links to C:\users\<user>\OneDrive (not in use) above the OneDrive - <TenantName> (C:\Users\<user>\OneDrive - <TenantName>).  How do I either completely uninstall the old OneDrive for Business client or at a minimum remove the old link from explorer?  Reinstalling the latest OneDrive client fixed the library locations and default Documents link in Explorer, but there's still the old OneDrive that could cause the user confusion.

Thanks,
Patrick
0
What is SQL Server and how does it work?
LVL 1
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Experts,

I've created a highly customized task list, saved it as a list template, and am now trying to deploy it to other sites. The default new form and default edit form pages for the list both have custom web parts deployed on the pages. When I deploy the list, the web part on each of the pages has been removed. For each deployment of the list, I have to manually edit the new form and edit form pages and add the web parts back in. Does anyone know why this is, or if there's a way around this?

Many thanks in advance for any help with this.
0
I have setup three columns, one number, two calculated.  Seq (number), NextNum(calculated Seq+1), SerNum(calculated conat"text"&000&NextNum

What I am trying to do in sharepoint with a workflow or any other suggestion is to set the seq to the next in a seq based on SerNum as it will start with 0 in seq but use the Max NextNum for seq when a new item is entered but a different type EX: (I am using submit to start WF in the infopath form)

Type      Seq                  NextNum                 SerNum
999                0                              =B2+1     =CONCATENATE(A2,"_","000",C2)
999      =IF(A3=A2,B2+1,0)      =B3+1      =CONCATENATE(A3,"_","000",C3)
999      =IF(A4=A3,B3+1,0)      =B4+1      =CONCATENATE(A4,"_","000",C4)
777      =IF(A5=A4,B4+1,0)      =B5+1      =CONCATENATE(A5,"_","000",C5)
777      =IF(A6=A5,B5+1,0)      =B6+1      =CONCATENATE(A6,"_","000",C6)
777      =IF(A7=A6,B6+1,0)      =B7+1      =CONCATENATE(A7,"_","000",C7)
777      =IF(A8=A7,B7+1,0)      =B8+1      =CONCATENATE(A8,"_","000",C8)
888      =IF(A9=A8,B8+1,0)      =B9+1      =CONCATENATE(A9,"_","000",C9)
888      =IF(A10=A9,B9+1,0)      =B10+1      =CONCATENATE(A10,"_","000",C10)
999      =IF(A11=A10,B10+1,0)      =B11+1      =CONCATENATE(A11,"_","000",C11)
 with results:
Type      Seq      NextNum      SerNum
999                  0             1             999_0001
999                  1              2             999_0002
999                  2             3             999_0003
777              0             1             777_0001
777                  1             2             777_0002
777                  2             3             777_0003
777                  3             4             777_0004
888                  0             1            …
0
Edited:
I solved this by using string-length: concat(substring("Yes", 1, (string-length(myFields/LookupColA) > 0) * string-length("Yes")), substring("No", 1, (string-length(myFields/LookupColA) = 0) * string-length("No")))

Original:
I have an InfoPath form on a SharePoint list.  One of the cols in the list is a lookup col. I want to display "Yes" if the list's item is connected to the other list and "No" if it is not.

I used: concat(substring("Yes", 1, (myFields/LookupColA != 0) * string-length("Yes")), substring("No", 1, (myFields/LookupColA = 0) * string-length("No"))). The result is Yes even if no lookup was set for the item. I displayed the value and it is a number if the lookup was set and what appears to be null if not.

What should my formula be to work?
0
Hi Expert

I need your help to create a workflow and a form (using Infopath and SharePoint List )  for Leave request approval.

I need to apply a workflow/List/Infopath form that process like below:

1. After the user fill-out and save the Leave application form, it will automatically start the workflow.

2. Send a notification email to the APPROVER (e.g. Manager), then APPROVER will Approve or Reject the request.

IF Approved, it will automatically send a notification email to HR Department regarding the request.

IF Rejected, the requester will received an email of rejection.

Using SharePoint Designer 2013 to create a Worlflow.

Thanks in advance
0
When accessing a sharepoint site on our intranet some users see a popup box asking them to enter their credentials.  When they enter credentials the box reappears.  After several attempts they will see an error 410- unauthorized access.

In our environment we have two domains, say Lemon and Peach.    Users in the Peach domain can always access sharepoint OK.  Users in  the Lemon domain can only access sharepoint from a Lemon domain PC.  eg

                    User domain
                 Lemon    Peach
PC domain
Lemon           OK       OK    
Peach             Fail     OK


Can anyone give some clues about how to solve this?


Cheers

Simon
0
Hi, We have a site that we want to make into a template. it uses a SPFX app that we have built ourselves.

When trying to save the site as a template, we get the  error "Sorry, this site can't be saved as a template. It contains apps that don't work in templates".

I understand that this is because the site is using the app. i know the solution is to not use the app, then export it as a template.

my question is - are there any work around? is there anything we can do in the app to allow it to be exported in a template? We assume not as we understand that the template can be used anywhere - even on a different SP instance, where the app would not exist.

the template in this instance is simply to provision new subsites on the same SP instance. we Ideally don't want the admin to have to add the app (in reality there are 5) and then add the app to the 8 or so pages they want them in manually.

is there any work around that we can use? I guess we could deploy the apps via code, but that would not update the content of the pages and add the apps into the pages.

i expect the answer to be "no" but thought it's worth a qucik query as someone might have a good procedure if not a work around.
0
Is it possible to actively sync a SharePoint list to a Microsoft SQL Database?
0
Hello,

I'm having trouble adding the Wiki Library app my SharePoint site. When attempting to search for app in SharePoint Store, app does not appear. I've attempted to make test sites to see if I am able to search for it but no luck.

Had a co-worker of mine create a page and then searched for app on that new test site and we were able to search for it. Went back to our SharePoint site to see if he could search for it and add but still wouldn't appear.

I also tried to search the SharePoint Store page by page in all categories by name but I dont get a full listing of apps. It stops around the letter D section.

Any ideas?
0
I have set up a list in SharePoint with about ten columns. All of the columns except one can be answered with one to four words. Therefore, they take up little room in the list.

One of the columns, which asks for upgraded information, can take, say, 280 characters. When you save it, the comment just goes out to the right in one long paragraph. If you open in Excel or another program, it shows up in a wraparound format, which means I can see everything to the right of it on one page. Now, you have to scroll over. I suppose I could move it to the end.

I realize if it saved with the comments in four lines, for example, entries would take up four lines.

This seems like a huge limitation in SharePoint. As an FYI, I will be switching to O365 with SP in the cloud soon. Thanks for any help.
0
Free Tool: Port Scanner
LVL 11
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

I am trying to import an Excel 2016 file to Sharepoint 2013 but I am receiving next message: The list cannot be imported because a Microsoft SharePoint Foundation-compatible spreadsheet application is not installed or is not compatible with your browser.

My office is 64 bits.
IE 11

Some weeks ago I was able to apply this procedure normally, but today I received this Message error.
0
I need to come up with a way to notify a list of employees that a new policy has been uploaded and needs their acknowledgement.  I want to loop through a SharePoint list of employees and send them each an email letting them know of the new policy.  So far, I have not been able to find a way to do this.   Any ideas?  Or alternatives?

Thank you.
lq
0
On premises SharePoint 2013 - using 2010 workflows.
I have an alert on a special view of the Workflow History - which will alert me when the description contains "Failed" or "Error" - etc.  So I get an an email when any workflow encounters an error or is canceled.  That works fine.  (This doesn't work for SP 2013 workflows by the way).  I can even issue a log message from the workflow and I'll get a notification using this approach.
However, occasionally (not consistently) some of my workflows generate "Failed on start (retrying)" and just hang.  I must manually cancel the workflow so that it can run again on a modification.  The same workflow will not retrigger and rerun on modification when it's in this state.  If I re-run the workflow, it runs fine.  So it's a mystery why I'm getting failed on start.  I get this every few hundred executions of the workflow and on different records.  
Unfortunately, in this case - no workflow history is created - hence I don't get an alert.
So anyone know how to get a notification when a workflow 'fails on start'?  
You can't set an alert on a view which is filtered by a workflow status column so that approach evidently won't work.
Any ideas?
It's very important I know of failed workflows on this application.

I don't have the option of using SP 2013 workflows - which I understand are less flexible for this kind of alerting anyway.
0
We have SharePoint Services 3.0 running alongside IIS version 6.0.3790.3959 and SQL Server 2005 (9.0.5069) on a Windows 2003 Server.

We need to migrate this to a supported OS, e.g. at least Windows Server 2008. Is SharePoint 3.0 and this version of IIS and SQL compatible with Windows Server 2008? Can everything be migrated? How would you migrate?
0
I understand the 5,000 item view limit and what do about it for generally "Viewing" purposes.

How does the 5,000 item limit apply to using a Lookup column to find and store a value from a list that has more than 5,000 items?

My data structure is an "Opportunity" which looks up and stores its  associated Contact from a Contact with more than 5,000 records.

Thanks.

Ken
0
I have SharePoint 2013 running on Server 2012 R2 Standard.
We have a fairly basic site that consists almost exclusively of document repositories.
I've been trying to configure the Search Service Application to crawl the site for search indexing.
Initially, I followed recommendations found online to create a Default Content Access Account for the Search Service, and gave it permissions to both the SQL databases, as well as full read permissions to the Web Application for the site.

After adding the site as a Content Source, I started a crawl and received the following error:
Access is denied. Verify that either the Default Content Access Account has access to this repository, or add a crawl rule to crawl this repository. If the repository being crawled is a SharePoint repository, verify that the account you are using has "Full Read" permissions on the SharePoint Web Application being crawled.

To try and narrow down the permissions issue, I switched the Search Service to use an account with full administrative permissions to the Web Application, and received the same error.

So far, I've tried using an account that has explicit Full Control permissions both on the Web Application and the Site Permissions. As well as Full Control permissions on the Search Service Application itself, same error.
I've tried using the Farm account as well, same error.

I've tried creating a new Application Pool for the Search Service.
I've tried creating a new Search Service …
0

Microsoft SharePoint

37K

Solutions

19K

Contributors

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.