New answers tagged

0

The best way to validate the SharePoint Tenant Admin URL is using ConditionalScope Class Example Code using (ClientContext SPOClientContext = new ClientContext(SPOUrl)) { SPOClientContext.Credentials = new SharePointOnlineCredentials(SPOCredential.UserName, SPOCredential.Password); Tenant oTenant = new Tenant(SPOClientContext); ConditionalScope Scope = ...


0

the formula should be like this: =IF([Column]="<string>", "<string>", "<string>") I tested your formula in my O365 tenant (copy pasted from your post) and it works with no issue. Can you please check if you mispelled something? the other thought is that the data type you are using is not a single line of text.


4

Your formula is perfectly valid code Language settings? Most non-english environments require a ; instead of , On English environments you can install a Bookmarklet to enhance the Calc editor This blog might be of help too


0

It would seem that in Office 365 you have to use semi-colons instead of commas. Here's the working formula: =IF("Foobar"="Foobar";"Foo";"Bar")


0

You can create a WCF service layer which basically talks CRUD to your SQL database tables. Once this is in place you can use service calls from SharePoint. Later once you move to SP online expose the on premise WCF to internet. Make sure you have proper authentication in place. Alternatively you can make use of Azure.


0

you could use the Business Connectivity Services - BCS. It allows you to create CRUD operations based on and connected to external databases. msdn Link


0

I successfully retrieved items from the SharePoint list to .ASPX page of my external website using the following piece of code: using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using Microsoft.SharePoint.Client; using Microsoft.SharePoint; using System.Security; ...


2

There are 2 groups which you can leverage inside a SharePoint group, they are Everyone and Everyone except external users. Everyone is everyone in your tenant, including external users. Everyone except external users is everyone in your tenant that is not an external user. If you place one of these groups into a read only SharePoint group, then they will ...


0

The best thing is to not try to alter default behavior of SharePoint. It will break the user experience (different functionality on same type of action). I would create a JavaScript function for this using the SharePoint JavaScript API or REST API. You can then add a "script editor" web part on the page with a "Create new document" button in html. The ...


1

You can do the followin in PowerShell: #retrieve the SPO Operation return value during creation $spOnlineOperation = $tenant.CreateSite($properties) #load the tenant object $ctx.Load($tenant) #load the SPO operation $ctx.Load($spOnlineOperation) #run the command $ctx.ExecuteQuery() #wait for SPO Operation to complete while($spOnlineOperation.IsComplete ...


2

You can use the following to copy site to another site within the site collection Site Setting --> Site Administration --> Content and structure --> Select the site from the left navigation and move To copy to another site collection: try using copy site as a template (include content) and then use the template file to create a new site under the other site ...


2

The powershell coverage is weak, so you aren't going to have export options like you would on prem. You would have to create a script with CSOM, as a compiled exe or in powershell, to perform the provisioning and copying data around. If this is a one off scenario that might be ok, if you foresee the need to do this often, you might want to invest in a ...


0

Problem Solved When I was specifying the site to run against: I had to use https for it to work. Silly mistake really: It connects properly now.


0

I don't think you can do this with express edition. You need the higher version of all the SharePoint built-in templates will be prebuilt in those. Otherwise, you have to write the complete code. I read somewhere you can use the 2013 or 2015 community edition. technet


0

The feature should be enabled in SharePoint Online. I suggest you troubleshoot the issue with the following steps: Have you ever opened two or more SharePoint sites at the same time when you test the InfoPath form? If so, please close all the sites, clear the browser cache, and test it again. Close the local firewall, and test the issue. ...


2

Perhaps you can use the client-side People Picker control. From MSDN: The client-side People Picker control lets users quickly search for and select valid user accounts for people, groups, and claims in their organization. The picker is an HTML and JavaScript control that provides cross-browser support. Adding the picker to your add-in is easy: ...


3

Answers of your questions: You will need FullControl permission to create group. No. You can take reference from here. No. SharePoint uses an App Only context it really doesn’t matter what rights the end user has on the content – all that matters is what rights have been granted to the App. Because the App can effectively run with elevated privileges ...


0

$limit and $top query options could be applied only for a collection of entries such as FolderCollection resource (Top System Query Option), for example: /_api/web/GetFolderByServerRelativeUrl('<url>')/Folders?$top=2 //working but not for a single resource like Folder in your example: /_api/web/getfolderbyserverrelativeurl('<url>')?$top=2 ...


0

Any reason why you wouldn't created a Site Template that has the web part you need and then call that template from the app? I think that would be the best solution for you. Other than that you would have to create a feature stapler that would run after the site was created to then populate it with the CEWP.


0

This is the only source where I have found an answer, it is from 2013: http://nondeprecatingly4.rssing.com/chan-3754326/all_p127.html It says: SPCascadeDropdowns does not work with the "Quick Edit" view - aka the new Datasheet view - in SharePoint 2013 as of SPServices 2013.01.


0

Check whether the below link can help you. https://www.dynamics101.com/adding-content-editor-web-part-programmatically-sharepoint/


1

You would have a few options, you could have a service in Azure that handles this. The advantage here is that you can deploy services in the same region as your tenant for fast performance. Another option would be to create your timer job solution as a compiled executable and use a central server in your environment as a "scheduling hub". Here you would ...


0

As far as I know, timer jobs are not allowed on O365. However, you can create Microsoft Azure WebJobs. You can find a sample console application in the link below that will give you a good start on how to implement/deploy one: https://msdn.microsoft.com/en-us/library/office/dn986826.aspx


2

Yes it is possible to connect MySQL with BDC using ODBC driver. You can refer this Integrating SharePoint with MySQL using Business Data Catalog Please let me know if it help you. Thanks


2

Password protected documents cannot be opened within Office Online. You must use the Office client application (Word, Excel, etc.) instead.


0

Go into the task list settings and check the advanced settings. The option to email on assignment is probably enabled. If it is not enabled and there are no workflows on the list, then it has to be an alert configured. It should be pretty apparent if it is an alert email versus an assignment email, they are drastically different.


1

For ASPX Pages The short article shows a common code snippet to retrieve the data from SharePoint 2013 Online List. This is for Office 365 SharePoint Online or some other people call it SharePoint 2013 Online. The code below is retrieve the Id and DisplayName from the List named NewList. See the comments in line with the code then you will understand ...


0

Well, the description of the Summary Links Column is as follows: Summary Links is a site column created by the Publishing feature. It is used on the Welcome Page Content Type to display a set of links. maybe this answers your question. My Suggestion is: Use Summary Links Web Part (Under Content Rollup) OR Use Multi line of text column (choose ...


0

Check the Site Collection Audit log Report under Site Collection Administration. The screen shots give you an idea of what you will be getting:


0

It's a Limitation in SharePoint 2013 REST filter, You have to use CAML with REST - url: "/_api/web/lists/getbytitle('ListName')/getitems" method: "POST", body: "{ 'query' : {'__metadata': { 'type': 'SP.CamlQuery' }, "ViewXml": "<View><Query><Where><BeginsWith><FieldRef Name='URL'/><Value ...


1

i believe you can't filter hyperlink column via rest. What you can do is use caml query with Rest api, that will solve your issue. Here are the important things about it: A REST request with a CAML query is always a POST request A REST request with a CAML query has always to have X-RequestDigest http header (actually because it is a POST request) A REST ...


0

I am not sure what programming language you are using. Assuming JavaScript and jQuery query.RestQuery = "getbytitle('RFA')/Items?$select=ESI_ProjectSeqNoLookup/Id&$expand=ESI_ProjectSeqNoLookup&$filter=ESI_AFENo/Id eq '" + $('#txtAFENo').val() + "'";


1

Let me clarify some things first: You are correct, Auto-Hosted is no longer supported. If you get the newest Office Developer Tools for Visual Studio 2013 or 2015, you will see the option to create an Auto-Hosted App has been removed. You can get the latest tools using the Web Platform Installer. You do not need a SharePoint VM to build an App (also known ...


2

It seems you ESI_ProjectSeqNoLookupId is lookup column. If it is true, then your approach is not correct. Correct Approach Let's say, lookup column name is ESI_ProjectSeqNoLookup. Now the query should look like query.RestQuery = ...


0

Up front to answer your question from 2013.... Yes there is - see below and No, you wont need to In your first paragraph you seem to imply that from the eDiscovery Center in SharePoint, you will need to query out separately from SharePoint to Exchange (via EWS). After researching this, I found that you should be able to do a single search within your ...


1

You can find the way for changing the MasterPage from How to give a subsite a specific master page? If the MasterPage option is missing under Look and Feel then you need to verify few things Your parent Site Collection must have SharePoint Server Publishing Infrastructure Feature activated from Site Collection Feature Your subsite must have SharePoint ...


0

You can not add Sharepoint online page in an iframe because of the same origin policy that most of the sites on internet adopted this days. This is mainly for security reasons to avoid from web attacks like Clickjacking and XSS. If you want to display the content of the sharepoint online into different domain, than try to use provider hosted app in windows ...


0

For SharePoint Addin, you need to given appropriate permissions rights like tenant, site collection, web etc. In your Addin you need to use app-only context while connecting to SharePoint, in this way you can elevate the privileges.


0

How bad does it stink that you can’t elevate to the application pool account in Office 365. It used to make things like cross site reads so much easier but from a security perspective totally makes sense it doesn’t exist. There really is no delegated replacement you can make the process slightly less painless by using the relevant objects within an ...


2

It is little bit tricky task. You can use Content Editor WebPart for this and do some tricks. For more detail please see SharePoint change Save button to Send Another Approach for you may be : Create a JavaScript file and keep the code from above link. Upload it into Document Library and get the link Edit the page and WebPart where you want to change ...


1

Write If condition in workflow Remember to edit WF Settings and check Start WF when an item is added or Changed according to the requirement If Priority is equal to High, Pause for duration, Send email If Priority is Low, Pause for duration, Send email


2

You can use the MAX function and output it in Date format. =MAX([date1],[date2]) If the two dates are blank, it will output a default date in 1899, so maybe put in a IF condition in there.


0

I believe these are all related to the Compliance Center roll out, that shows as previously released on the roadmap, http://fasttrack.microsoft.com/roadmap. The Office 365 Compliance Center is one place to manage compliance across Office 365 for your organization. You can define central policies that apply across your data in Office 365, such as ...


0

You have to develop Snadbox soltution with CSOM to deploy on Office 365. I can't give exact logic for your requirement. But get logic from following link: http://www.codeproject.com/Articles/399156/SharePoint-Client-Object-Model-Introduction


0

If the list item is a document then you can use the MapToIcon method of the SPUtility class if (Item.File != null) { SPUtility.MapToIcon(Web, Path.GetExtension(Item.File.Name), string.Empty, IconSize.Size16); }


2

Please follow the following approach. Create a Sandbox solution rather then creating the SharePoint App Deploy your solution to your SharePoint Online Solution Gallery Activate your solution Activate the feature of your newly activated solution I know this is not the ultimate solution but this solution worked at my end. Let me know whether it helped you ...


0

SharePoint Online/Office 365 doesn’t currently support "Cross Site Publishing" features.Below link will outline several alternatives for delivering cross-site and search-driven content in SharePoint Online and how to template these views for reuse. ...


3

Break permission inheritance of that document library. Remove other users. Then only assign permission to the owners. This will hide the library from other users.



Top 50 recent answers are included