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. 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. 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>” Best Recommended SharePoint 2013 Hosting ASPHostPortal.com
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. 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. After providing all the preceding details, click “Ok” to create the site collection. In this article we explored how to create an Enterprise Search Center site collection in SharePoint 2013 online. 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 Complement SharePoint Online Build fast, and light with new ASP .NET MVC Features 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 : In this article will learn how to hide settings under site settings page in SharePoint 2013. 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. 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 If you want to do it I PowerShell you can use the following command: And via Central Admin: ASPHostPortal.comSharePoint 2013 Hosting – ASPHostPortal.com :: Customize Process Approval Email to Consist of Link to Respective Job
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 this post I’ll show a workaround to resolve the problem. Following are the steps we need to perform
This will avoid the “SingleTask” activity to wait until the approval. Furthermore change “WaiveAssignmentEmail” property value to “Yes” which avoids the notification email.
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+”
For the first “WaitForFieldChange” activity, the FieldValue is set to “Approved” and for the other one it is “Rejected”
This will allow us to modify email as we wish and pause the workflow until the task is approved or rejected
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 reliabilitySharePoint 2013 Hosting :: How To Create Enterprise Search Center Site Collection in SharePoint 2013 Online
Enterprise Search Center
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:
Finally a Community site collection will be created in SharePoint Online.
Summary
Best Recommended SharePoint 2013 Hosting
ASPHostPortal.com
ASPHostPortal.com Announces Powerful Sitefinity 7.3 Hosting Solution
Manage your lead scoring criteria according to various data points collected across channels.
Provide a natural extension to all your SharePoint workflows and wrap a compelling presentation around your core business documents.
MVC based widgets for each of your dynamic modules with automatically generated Razor templates.
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.SharePoint 2013 Hosting :: 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.
Follow the below steps to hide the “Change The Look” feature.
Best Recommended SharePoint 2013 Hosting
ASPHostPortal.com
SharePoint 2013 Hosting – ASPHostPortal.com :: Developing a Site Collection in 2010 Mode in SharePoint 2013
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");
New-SPSite -Url http://host/sites/test -OwnerAlias "DOMAIN\User"
Best Recommended SharePoint 2013 Hosting
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