This article willl explains updating list items in SharePoint 2013 and Office 365 using PowerShell. Here we will see how to update all the list items in a list when a requirement of such comes in.
I have a PowerShell script here that you just need to add using Notepad and save it as a .ps1 file. In this script I am updating a choice field from a look up field.
Script
Add-PSSnapin Microsoft.SharePoint.PowerShell -EA SilentlyContinue
$webURL = “Your Site Url”
$listName = “Name of your list”
$web = Get-SPWeb $webURL
$list = $web.Lists[$listName]
$items = $list.items
Foreach($item in $items)
{
$prim = $item["Look Up Column field"]
if(!$prim)
{
write-host “Null”
}
else
{
$trim = $prim.split(‘#’)[1]
write-host $trim
$item["choice field"] = $trim
$item.Update()
write-host $item["Your Result You want to see"]
}
}
How to run
- You need to change the fields Site Url, List Name and Fields.
- You might have a question, why am I using a split function?
The field value when fetched from a look up field has characters like “1,#”. Using split we eliminate that extra data by giving us a correct variable.
- Run the SharePoint PowerShell as Administrator
- Run the .ps1 file
It will be executed and you will see the updated field values.
Here is a time saver article for my readers. Keep learning and happy coding 
Best Recommended SharePoint 2013 Hosting
ASPHostPortal.com
ASPHostPortal.com is Perfect, suitable hosting plan for a starter in SharePoint. ASPHostPortal the leading provider of Windows hosting and affordable SharePoint Hosting. ASPHostPortal proudly working to help grow the backbone of the Internet, the millions of individuals, families, micro-businesses, small business, and fledgling online businesses. ASPHostPortal has ability to support the latest Microsoft and ASP.NET technology, such as: WebMatrix, WebDeploy, Visual Studio 2015, .NET 5/ASP.NET 4.5.2, ASP.NET MVC 6.0/5.2, Silverlight 6 and Visual Studio Lightswitch, ASPHostPortal guarantees the highest quality product, top security, and unshakeable reliability, carefully chose high-quality servers, networking, and infrastructure equipment to ensure the utmost reliability
In SharePoint 2013 workflow architecture is drastically changed when compared with SharePoint 2010. Some new activities like “HttpSend” are introduced for the platform and some activities are improved a whole lot. On the other hand some scenarios became quite hard to implement.
Let’s assume that we’ve a SharePoint 2013 Visual Studio primarily based workflow and require to assign a task to a user. We count on the notification e mail to contain the hyperlink to respective task. is not it ?
In SharePoint 2010 it was quite easy to include the process url in the mail. But which is not the case anymore. It’s not achievable to include the task url in the default mail. As an alternative it’s sent like below that is not user friendly.
In this post I’ll show a workaround to resolve the problem. Following are the steps we need to perform
- Add “SingleTask” activity and configure necessary parameters
- Modify WaitForTaskCompletion property to false
This will avoid the “SingleTask” activity to wait until the approval. Furthermore change “WaiveAssignmentEmail” property value to “Yes” which avoids the notification email.
- Compose an email manually
In this email I’ll include a link to assigned task. To get the guid of task list, I will use “GetTaskListId” activity. Furthermore I’ll get the task id from “SingleTask” activity output.From those elements I’ll construct the url of the assigned taske.g.: “http://sp13/sites/dev/DOAApprovalForm.aspx?List=”+taskListId.ToString()+”&ID=”+taskItemId+”
Then I’ll construct the email body as I wish
“<html><body style=’font-size:11pt;font-family:Segoe UI Light,sans-serif;color:#444444;’><div>Contract comment is : ” + contractComment+ ” </br>Please approve this <a href=”+siteUrl + “SitePages/DOAApprovalForm.aspx?List=”+taskListId.ToString()+”&ID=”+taskItemId+”>Task</a></div></body></html>”
- Handle Approve or Reject actions using a “Pick” activityWe will use “WaitForFieldChange” activity to pause the workflow until user presses Approve or Reject buttons. Since there are two possible values in the pausing field we need to use a “Pick” activity
- As mentioned earlier, we will use “WaitForFieldChange” activities on both branches, configured for “TaskOutcome” field.
For the first “WaitForFieldChange” activity, the FieldValue is set to “Approved” and for the other one it is “Rejected”
- I’ll update the taskOutcome with respective values to continue the workflow
This will allow us to modify email as we wish and pause the workflow until the task is approved or rejected
Best Recommended SharePoint 2013 Hosting
ASPHostPortal.com
ASPHostPortal.com is Perfect, suitable hosting plan for a starter in SharePoint. ASPHostPortal the leading provider of Windows hosting and affordable SharePoint Hosting. ASPHostPortal proudly working to help grow the backbone of the Internet, the millions of individuals, families, micro-businesses, small business, and fledgling online businesses. ASPHostPortal has ability to support the latest Microsoft and ASP.NET technology, such as: WebMatrix, WebDeploy, Visual Studio 2015, .NET 5/ASP.NET 4.5.2, ASP.NET MVC 6.0/5.2, Silverlight 6 and Visual Studio Lightswitch, ASPHostPortal guarantees the highest quality product, top security, and unshakeable reliability, carefully chose high-quality servers, networking, and infrastructure equipment to ensure the utmost reliability
In this article I would like to share the procedure to create an Enterprise search center site collection in SharePoint 2013 online using an admin portal.
Enterprise Search Center
A Search Center is where users enter search queries and view the search results. In SharePoint Online, a Search Center site is automatically available at <host_name>/search/. You’ll have a default search home page and a default search results page. In addition, there are several pages known as search verticals. Search verticals are customized for searching specific content, such as People, Conversations, and Videos. Search verticals display search results filtered and formatted for a specific content type or class.
Use the following procedure to create an Enterprise Search Center site collection.
Step 1: Open the “Microsoft Online Portal” (Admin Center) in your browser.
Provide the username and password to login the portal, then you will be navigated to the online portal (Admin Center) as shown below.
Step 2: Then click on the “Admin” DropDown on the portal. On the DropDown select the “SharePoint” as shown below.
Step 3: When you click on the SharePoint, you will be navigated to “SharePoint Admin center” as shown below.
Step 4: Click on the “New” from the ribbon bar as shown in the following, and then select the “private site collection”.
Step 5: Then you will get the dialog box to create the site collection, when you select the private site collection as shown below.
Step 6: On the dialog box select the enterprise tab to create an enterprise search center, by default the team site collection will be selected in your dialog box.
Step 7: Then select an Enterprise Search Center template on the dialog box as in the following:
Step 8: Then provide the following details in the dialog box depending on your requirements:
- Title
- Web site address
- SharePoint version
- Language
- Type of template
- Time zone
- Administrator of site collection
- Storage Quota
- Server Resource Quota
After providing all the preceding details, click “Ok” to create the site collection.
Finally a Community site collection will be created in SharePoint Online.
Summary
In this article we explored how to create an Enterprise Search Center site collection in SharePoint 2013 online.
Best Recommended SharePoint 2013 Hosting
ASPHostPortal.com
ASPHostPortal.com is Perfect, suitable hosting plan for a starter in SharePoint. ASPHostPortal the leading provider of Windows hosting and affordable SharePoint Hosting. ASPHostPortal proudly working to help grow the backbone of the Internet, the millions of individuals, families, micro-businesses, small business, and fledgling online businesses. ASPHostPortal has ability to support the latest Microsoft and ASP.NET technology, such as: WebMatrix, WebDeploy, Visual Studio 2015, .NET 5/ASP.NET 4.5.2, ASP.NET MVC 6.0/5.2, Silverlight 6 and Visual Studio Lightswitch, ASPHostPortal guarantees the highest quality product, top security, and unshakeable reliability, carefully chose high-quality servers, networking, and infrastructure equipment to ensure the utmost reliability
As a technology focused web host, ASPHostPortal are designed to support popular web development technologies. Windows and ASP.NET hosting are at the core of its business practice. They have over 10 years combined experience in .NET, PHP, Network Administration, System Integration and related technologies to support mission critical hosting for applications built on these platforms. Today, they launch Sitefinity 7.3 hosting with powerful network and affordable price.
Sitefinity by Telerik is an ASP.NET web content management platform engineered to make managing your website a more positive, empowering and usable experience. Sitefinity is the first and only CMS to enable enterprises to take full advantage of all three mobile development strategies— Responsive Web Design, mobile websites, and mobile apps, easily and effectively—and all from one CMS user interface.
Sitefinity 7.3 introduces lead scoring, integration with SharePoint Online, extended ASP .NET MVC support and more.
Directly Impact Revenue With Lead Scoring
Manage your lead scoring criteria according to various data points collected across channels.
Complement SharePoint Online
Provide a natural extension to all your SharePoint workflows and wrap a compelling presentation around your core business documents.
Build fast, and light with new ASP .NET MVC Features
MVC based widgets for each of your dynamic modules with automatically generated Razor templates.
With 7 data centers that located in USA Europe, Australia and Asia, ASPHostPortal is superior provider in the hosting market. They provides Sitefinity 7.3 Hosting only from $5/month with 30 days money back guarantee. In addition, ASPHostPortal has been awarded as one of the best hosting companies in the industry because of the good hosting performance this web host provides. To provide best hosting performance, this company always maintains the server with expert team in ASP.NET Technology. To learn more about Sitefinity 7.3 Hosting, please visit http://asphostportal.com/Sitefinity-7-3-Hosting
About ASPHostPortal.com :
ASPHostPortal.com is The Best, Cheap and Recommended ASP.NET Hosting. ASPHostPortal.com has ability to support the latest Microsoft and ASP.NET technology, such as: such as: WebMatrix, WebDeploy, Visual Studio 2015, .NET 5/ASP.NET 4.5.2, ASP.NET MVC 6.0/5.2, Silverlight 6 and Visual Studio Lightswitch. ASPHostPortal include shared hosting, reseller hosting, and sharepoint hosting, with speciality in ASP.NET, SQL Server, and architecting highly scalable solutions. ASPHostPortal.com strives to supply probably the most technologically advanced hosting solutions available to all consumers the world over. Protection, trustworthiness, and performance are on the core of hosting operations to make certain every website and software hosted is so secured and performs at the best possible level.
In this article will learn how to hide settings under site settings page in SharePoint 2013.
Here we will take a example of hiding the “Change The Look” setting under [Look and Feel].
Few cases where you do not want to change the theme of sites by site collection administrators because theme needs to same for all sites in entire organization. But there is a chance that site collection admin can change the theme.
So you want to hide that option using CSS so that even the site collection will be not able to change theme by hiding the “Change The Look” feature.
Follow the below steps to hide the “Change The Look” feature.
- Open Site settings of your site
- Fire IE developer tools and find the ID of the “Change The Look” feature. Refer below figure.
- Edit corev15.css file and add the below css and save the file. Its always advised to take the backup of the corev15.css file before making any changes.
Code
#ctl00_PlaceHolderMain_Customization_RptControls_Theme
{
display:none;
}
Best Recommended SharePoint 2013 Hosting
ASPHostPortal.com
ASPHostPortal.com is Perfect, suitable hosting plan for a starter in SharePoint. ASPHostPortal the leading provider of Windows hosting and affordable SharePoint Hosting. ASPHostPortal proudly working to help grow the backbone of the Internet, the millions of individuals, families, micro-businesses, small business, and fledgling online businesses. ASPHostPortal has ability to support the latest Microsoft and ASP.NET technology, such as: WebMatrix, WebDeploy, Visual Studio 2015, .NET 5/ASP.NET 4.5.2, ASP.NET MVC 6.0/5.2, Silverlight 6 and Visual Studio Lightswitch, ASPHostPortal guarantees the highest quality product, top security, and unshakeable reliability, carefully chose high-quality servers, networking, and infrastructure equipment to ensure the utmost reliability
These days I got phoned up by a buddy who asked how on earth he could programmatically produce a web site collection in 2010 mode in SharePoint 2013. Why he wanted to do this I’m not confident, and it is not the point of this post
It’s truly pretty uncomplicated if you appear at the documentation of some of the SPSiteCollection.Add() strategies which take an int as a compabilityLevel parameter. Passing in 14 in this parameter will make certain you get the 2010 appear and really feel. For reference the SPSite.SelfServiceCreateSite() technique has equivalent overloads.
SPWebApplication webApp = new SPSite(<a href="http://host/">http://host</a>).WebApplication;
SPSiteCollection siteCollections = webApp.Sites;
uint lcid = 1033;
int compatLevel = 14;
string webTemplate = "STS#0";
SPSite newSiteCollection = siteCollections.Add("sites/test", "Title", "Description", 1033, compatLevel, webTemplate,
"DOMAIN\\User", "Name", "Email_Address", "DOMAIN\\User", "Name", "Email_Address");
If you want to do it I PowerShell you can use the following command:
New-SPSite -Url http://host/sites/test -OwnerAlias "DOMAIN\User"
And via Central Admin:
Best Recommended SharePoint 2013 Hosting
ASPHostPortal.com
ASPHostPortal.com is Perfect, suitable hosting plan for a starter in SharePoint. ASPHostPortal the leading provider of Windows hosting and affordable SharePoint Hosting. ASPHostPortal proudly working to help grow the backbone of the Internet, the millions of individuals, families, micro-businesses, small business, and fledgling online businesses. ASPHostPortal has ability to support the latest Microsoft and ASP.NET technology, such as: WebMatrix, WebDeploy, Visual Studio 2015, .NET 5/ASP.NET 4.5.2, ASP.NET MVC 6.0/5.2, Silverlight 6 and Visual Studio Lightswitch, ASPHostPortal guarantees the highest quality product, top security, and unshakeable reliability, carefully chose high-quality servers, networking, and infrastructure equipment to ensure the utmost reliability
You will notice that everything chosen is below the Shared Functions section, which signifies that it’s not installed as component of a SQL instance. In reality, you’ll notice that we do not possess the data engine installed at all. The two Reporting Services possibilities shown would be the only items which can be truly needed for SSRS Integrated mode to work. As you’ll be able to see, I’ve also chosen SQL Server Information Tools (formerly BIDS) and Management Tools at the same time. I prefer to install these tools as a matter naturally on SharePoint servers, as they can come in handy for connectivity testing or rapid BI project creating.
Fill out the resulting form as appropriate, and select OK. Make sure that you navigate to the bottom of the form and select the applications to activate SSRS on.
Once the service application and proxy have been created, click on it to access the management screen.
You will want to access every single of the sections and fill out the proper alternatives for your installation. The directions are pretty self-explanatory, so I will not go into them here. At a minimum, you should back up your encryption important in the crucial management section, Set your unattended execution account (the default account to utilize when no credentials are accessible), as well as your e mail server settings if you would like to be able to provide reports by way of e mail. If you’d like to enable self service subscriptions and alerts, fill out that section, and it contains guidelines for setting up the SQL agent service to support it.
