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,

Can you please assist me.

I have designed a Leave Request form in InfoPath 2013.
I want to disable dates (holiday dates) in the Datepicker control.
I also have 2 time fields (Start and End time).
How can I calculate the time difference between these 2 fields?
0
Python 3 Fundamentals
LVL 12
Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

I'm trying to map a sharepoint site as a network drive using Kixtart. Here's my syntax...

Use W: \\con-fs01\Admin
Use X: "\\contoso.sharepoint.com@ssl/Projects" /Persistent:Yes

Drive W maps just fine, but X does not map at all. Any suggestions?
1
I have a SharePoint list with two columns that I want to multiply (QTY - numeric and Unit price - currency).  I want the result to go in a third column (_Line total - currency).  The SharePoint list Flow is "When an item is created or modified."  This used to be pretty easy with SharePoint Designer but because I'm new to Flow, it seems overly complicated.  A calculated column is out because I want to use the third column to group and sum in list views.

Here is the expression I'm using but it errors out when run:
mul(triggerBody()?['QTY'],triggerBody()?['Unit price'])

Open in new window


Update list item flow
0
Has anyone had success performing a tenant to tenant migration from SharePoint Online to Office 365?

I have ran across several articles stating that FastTrack for Microsoft doesn't allow tenant to tenant migration.  Other than Metalogix and Sharegate are there other 3rd party tools that others have used with success for migrating SharePoint?
0
Hi

SP2013

I have single text field as part of a list and I need some validation setting up on it

The field has a default value of Unknown. The user can also input values such as 12345678-02.

The validation will be that the value in the field can be Unknown or if it is not Unknown the 9th character must be a dash i.e. -, as in the example above.

Any suggestions welcolme
0
I need to link to a SharePoint list from within Access and only retrieve the records for a particular view of the list.
It is not practical to pull down the entire list and then filter/SQL search within Access.
I want Access to only see the records in a particular view and only those columns in that view.

This is all working using Excel with a linked table and refresh all to update it from SharePoint I'd like to avoid the users
having to open a workbook at all  - just open access and the data is there (perhaps asking them if they want to refresh the data from SP)

I know to how directly link to a SharePoint list from Access - but that tries to bring down all records and all fields
(over 2000 records and 240 fields)  - not practical for end users.

I'm experienced in VBA, SharePoint, .. etc so a VBA solution is fine.
Environment:
Excel/Access 2016, SharePoint 2016, full control on the site w tons of workflows, JS, etc..
No infopath, No Access web apps, must work in FF and IE

so to summarize -
How to establish a link to a particular view of a SP list in access  - including refreshing etc
Specific examples, VBA code, ... sought
thanks
0
Hi all,
I would like to know more about the SharePoint Cloud Hybrid Search Configuration. I am trying to configure cloud hybrid search between SharePoint 2016 On-Premises and SharePoint Online. There seems to be bit of confusion for me as I see that Azure Subscription is needed and looks for the Azure ID needs service admin privileges.  Can someone point me to more comprehensive article or steps to achieve this (other than MSDN or TechNet articles please). Thank you in advance.

Regards,
Kumar
0
Have to find a search engine for our intranet.  
We have  .NET and a small SharePoint server (2016 on premise) .  It maybe moving to the cloud next year.

Any key things I should look for?
Have no idea how long it takes to set something like this up or maintain.
Asked if there was a $$ limit.  They said no.

Any ideas or thoughts appreciated.  

JS
0
I am trying to force a Edit Form Attachment link in SharePoint Online to open in a new tab/window. I have tried a number of solutions but none of them see to override the onclick attribute that is associated with that link,

Any suggestions to force a new window to open from my custom EditForm?

My most recent attempt was to try and wipe out any references to onclicks or mousedowns in this table:

<script type="text/javascript">
$("a").prop("onclick", null).off("click");
$("a").prop("mousedown", null)
$("a").attr("target","_blank");
</script>

Open in new window


This code didn't see to do anything meaningful. Maybe there is an easier way? Hide this link and create a new one dynamically using the href value from the SharePoint link?
 
<table border="0" cellpadding="0" cellspacing="0" id="idAttachmentsTable">
			<tbody><tr id="{96639D2F-BE46-4CE2-8C00-D35B1AC2384C}"><td class="ms-vb"><span dir="ltr"><a tabindex="1" onmousedown="return VerifyHref(this, event, '1', 'SharePoint.OpenDocuments.3', '1https://xxx.sharepoint.com/teams/lms_help/portaldev/_layouts/15/Doc.aspx?sourcedoc=/teams/lms_help/portaldev/Lists/Requests/Attachments/140/Italy_MAPS_2015.xlsx&amp;action=default&amp;mobileredirect=true');return false;" onclick="DispDocItemExWithServerRedirect(this, event, 'FALSE', 'FALSE', 'FALSE', 'SharePoint.OpenDocuments.3', '1', 

Open in new window

0
I'm looking for a detailed project plan to migrate from a hybrid SharePoint environment (SharePoint 2010 and SharePoint Online) to Office 365 SharePoint.  Anyone have a project plan sample or template for this type of migration?
0
Exploring SharePoint 2016
LVL 12
Exploring SharePoint 2016

Explore SharePoint 2016, the web-based, collaborative platform that integrates with Microsoft Office to provide intranets, secure document management, and collaboration so you can develop your online and offline capabilities.

We are using the SharePoint hub sites and want to be able to create a template for a Team site. How can we do this?
0
Unable to edit sharepoint documents on iPad -

I need to be able to access sharepoint documents from an ipad. The iPad can connect to our internal sharepoint server and can open up the sharepoint pages in the browser. The issue is that when you click/tap on the document you wish to edit it will open in the browser but you cannot edit it.
It will give you the error below: (received this in both safari and chrome)

"To open this workbook, your computer must have a version of Microsoft Excel installed and your web browser must support opening files directly from excel in the browser"

 the only workaround I have found is:

1. copy the URL to of the SharePoint site you want to be able open documents from
2. open the office application you want to be able to open SharePoint documents from e.g. excel , word
3. tap on 'Add a place' paste in the URL and then when prompted enter in your credentials

this is a very convoluted way of accessing and editing sharepoint documents so I need to know if there is a simpler way.

ipad model - MNV62B/A
version of OS : 11.4.1
0
I am in a need to get a calculated field that will accommodate the following:

If Opp Type = Extension Renewal or On Contract Growth AND If TnC Change = No AND If Fin Pro = Yes Then set value to Yes

I am using the following but it does not appear to be working: =IF(AND(OR([Opp Type]="Extension Renewal",[Opp Type]="On Contract Growth"),[TnC Change]="No",[Fin Pro]="Yes"),"Yes","No")
0
All,

I am creating a SharePoint Online request form. I have the layout of what is needed for this form.  Not having any experience on how to do this I need direction on where to start.  I believe that I already have Office 365 installed I just need first steps.
I have read on this and it seems that I will need the following:
1. Add the site (somewhat straight forward).
2. Create the Excel List with the fields for the data (somewhat straight forward).
3. Create the form - This I do not have any idea how to do or where to start.

There is alot of information out there, but I need to complete this task rather quickly.

If I could be provided with Youtube videos or other documents that get to the step by step that would be greatly appreciated.

Again, any help is greatly appreciated.
0
Dear Experts, I'm testing the Sharepoint 2016 on-premises, I tried to share the document like these screenshots but the user who was shared COULD NOT receive any notification email of this sharing. I was loggin as Sharepoint Admin and it has functional mailboxa account. How can  we fix it?

sp1.png
sp2.PNG
I also CANNOT share it with external user???

sp4.PNG
One more thing, I'd like to redirect the http: site to https: site in Sharepoint but I could not configure it. I tried 2 methods but they both did not work!

1. Add both http and https links in default zone of mapping site

2. Add redirect http in IIS management


 sp3.PNG
0
I need to set and verify SharePoint Online user profile properties using PowerShell. I am currently using the PNP module using Set-PNPUserProfileProperty and Get-PNPUserProfileProperty. My problem is validating properties whose visibility is set to "Only me". I can set such properties for any user using Set-PNPUserProfileProperty, but Get-PNPUserProfileProperty is not retrieving any of the "Only me" settings.

Is this a permissions issue? If so, what permissions need to be granted to the service account to allow it to see "Only me" user profile properties for all users?

Or is this a shortcoming of the PNP command (or the API is leverages)? If so, is there a different command or method or API that I can use to see these properties?
0
In a SharePoint list, I have fields that are hyperlinks to images stored in SharePoint as well.  I am using Microsoft Flow to format emails and want to see those images in the email (the images are essentially icon shapes).

When i look at the SharePoint list, they all display as correct images.  However, I can't seem to get that image to display properly in the HTML formatted email.

Let's say the field name is imagename.  If I use that name in the email, a text URL displays.  So I tried <img src="imagename"..> and i got an image alright, but it could not be displayed.  Is this possible a permissions error because of no access to SP or something in the HTML formatting, and how can I tell?

What is another way to accomplish this?
0
I am formatting HTML email within Microsoft Flow.  I have fields from a SharePoint list that are currency fields, but Flow doesn't support currency and the fields have float type.  I can easily get them to an integer which truncates the two decimals or to a string which displays way too many.

My question is how to do this using HMTL code?  CSS and java script look like they may work but I don't want to depend on recipients to have it set up properly/.  Ideally I want to round to two decimal places (optional for currency fields), then format in US$.  

One thought was to multiply the value by 100, convert to type integer, then use substring() to chop it up into whole number and decimal pieces, then concatenate with $ but that woudn't handle comma delimiters.  And I have about ten such fields to email, so it's a lot of Flow code if not HTML code to accomplish.

Hope you have some suggestions.
0
I have Sharepoint 2013 with workflows2010
problem:
i have a list with attchments..i want to copie some items into a new list via workflow
i can't select the attchment field in Sharepoint Designer.
How to copie (or better a link) to the orign attachments into the new list?
0
10 Tips to Protect Your Business from Ransomware
10 Tips to Protect Your Business from Ransomware

Did you know that ransomware is the most widespread, destructive malware in the world today? It accounts for 39% of all security breaches, with ransomware gangsters projected to make $11.5B in profits from online extortion by 2019.

Hi Experts

I have created some symbolic links to different SharePoint libraries using the DavWWWRoot paths. This works in terms of opening files, however once you modify that file it becomes unable to open. The same thing happens when a file is created. Is there a solution for this or an alternative?
0
I am running WSS 3.0 SP2 and SQL 2005 Workgroup edition along with IIS 6.0 on my domain controller running Windows Server 2003 SP2. Recently, I demoted the domain controller because I moved that role to a server running Windows Server 2016. The moment I demoted the windows server 2003, my share point site and the central admin console for share point both stopped working, throwing  an Application error message. I then disconnected Share point from the SQL using Share point config wizard and tried to reconnect it.  Every time I try to reconnect it, the config wizard keeps saying the username/password combo was incorrect though I know for a fact they are correct. What could be the reason for this and what would you suggest I do at this point? I really appreciate your help on this and if you need more info, feel free to request!

Thanks,
treost
0
I have Workstations here are Win 10 Pro and office 365 in which I use MS Sharepoint and MS Dynamics.

Often when using these I use google chrome as the browser and often I am asked to sign in with my office 365 account this may happen 5 times a day.  
One of the staff at site say if you want to open a word doc and don't want to get prompted by sign in just open a blank document before hand and it works.  
Is there a way to correct this.  I have tried to add an entry into the credential manager and turning off local firewall.  I do know it does work most of the time through MS Edge.
But most staff like chrome.

Cheers :)
0
For two days, I've been trying to get on to creating SiteTemplates in SharePoint 2016. When I'm creating the template, I get the error message as saying. "The 'AllowDeletion' attribute is not declared.". It comes from  SiteCoumns that I inserted them into SiteCollection. I have opened the cab file from wsp and then find fields containing attributes such as <FieldRef ID = "{23c92184-aa69-47ed-8685-2a9e7ac66c86}" Name = "ArendeType" AllowDeletion = "TRUE" /> All columns and content types were created in the same SiteCollection.

Is there enyone that can help me on this. This is a section of the ElementsContentType.xml file in the cabfile for the site template (wsp-file)

<ContentType ID="0x010100E24BBAB22E21AB4BB8CA45C9D77AA9B9" Name="PDSAdvokat" Group="PDSAdvokat" Overwrite="TRUE">
            <Folder TargetName="_cts/PDSAdvokat" />
            <FieldRefs>
                  <FieldRef ID="{c042a256-787d-4a6f-8a8a-cf6ab767f12d}" Name="ContentType" />
                  <FieldRef ID="{5f47e085-2150-41dc-b661-442f3027f552}" Name="SelectFilename" />
                  <FieldRef ID="{8553196d-ec8d-4564-9861-3dbe931050c8}" Name="FileLeafRef" Required="TRUE" />
                  <FieldRef ID="{8c06beca-0777-48f7-91c7-6da68bc07b69}" Name="Created" Hidden="TRUE" />
                  <FieldRef ID="{fa564e0f-0c70-4ab9-b863-0177e6ddd247}" Name="Title" Required="FALSE" ShowInNewForm="FALSE" ShowInEditForm="TRUE" />
                  <FieldRef ID="{28cf69c5-fa48-462a-b5cd-27b6f9d2bd5f}" Name="Modified" Hidden="TRUE" />
                  <FieldRef ID="{822c78e3-1ea9-4943-b449-57863ad33ca9}" …
0
I have a SharePoint table that lists out Terminal Servers, does anyone know of a way to check the status of a server, via a ping or something, then update the table with the status of said server using.  MS Flow.  I have written a service but I want something out in the world rather than a local server.
0
I installed the SharePoint 2013 Server on windows Server 2012 and the following service keeps stopping net.tcp port sharing service and have to manaully start but keeps turning off.
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.