How to Bulk Import to SharePoint from Excel with a Choice Field

How to Bulk Import to SharePoint from Excel with a Choice Field

400 level, Excel, SharePoint, SharePoint Designer, Workflow
[wp_ad_camp_1] [wp_ad_camp_4] Scenario: Import to SharePoint from Excel Do you have a large SharePoint list with dozens, hundreds, or even thousands of items? And, are some of the columns in your list choice fields based on lookup values from other SharePoint lists? If you have data from an Excel file that you need to import to SharePoint from Excel, you’ll quickly find that a straightforward copy and paste operation won’t cut it. However, with a bit of prep work you can absolutely do a bulk import of your data without having to write code, or buy a special add-in. Setting up for the Import You will need to do a bit of prep work before you can do the actual import. But this setup work is trivial compared to trying…
Read More
Editing Text in a SharePoint List View or Data View

Editing Text in a SharePoint List View or Data View

InfoPath, SharePoint, SharePoint Designer, Workflow
[wp_ad_camp_1] [wp_ad_camp_4] Having Your Cake and Eating It Too SharePoint text fields (Multi line) have some limitations. In SharePoint, you can enable your text fields (of type Multiple Lines of Text) to keep a running revision history of all the changes in that field. This is great when you need to see the history of comments provided, for example. There are some limitations, however, that come along with that when viewing and editing text in a SharePoint list view. First, you cannot directly view the most recently text entered. You instead see a link to View items which just opens up the associated form for the item where you could see the text field and its history (not really that helpful). If you need to be able to show the most…
Read More
How to Get Notified of Workflow Errors in SharePoint or Project Server

How to Get Notified of Workflow Errors in SharePoint or Project Server

Project Server, SharePoint, SharePoint Designer, Workflow
[wp_ad_camp_1] [wp_ad_camp_4] How to Set Up Workflow Error Alerts The process is almost identical for both SharePoint and for Project Server. The only difference is that the URL to the view of the workflow history differs between the two. Open Your Workflow History List The first step in setting up the alert is to navigate to the SharePoint list that has the workflow history. Project Server Workflow History URL <yourserver>/Project%20Server%20Workflow%20History/Allitems.aspx SharePoint Workflow History URL <yourserver>/Lists/Workflow%20History/Allitems.aspx Create Your Custom Workflow History List View Next, create a custom view of the workflow history list. Click Create View on the List tab in the ribbon. Click All History in the Start from an existing view section. Enter a View Name. Call it something like "Workflow Status" or something. Select the following fields (add…
Read More
How to Erase or Blank a Text Field with a Workflow in SharePoint Designer

How to Erase or Blank a Text Field with a Workflow in SharePoint Designer

SharePoint, SharePoint Designer, Workflow
[wp_ad_camp_1] [wp_ad_camp_4] Use a Workflow to Erase or Blank a Text Field in SharePoint Sometimes, you come across a situation where you need to erase or blank out the contents of a text field in SharePoint. You don't need to delete the item. Instead, you just need to blank a text field. Using a whitespace character just won't cut it. To accomplish this, you will need to create a simple workflow using SharePoint Designer. Presented below are two specific ways. I've used one of them with SharePoint Designer 2010. I've used the other with SharePoint Designer 2013. How to Blank a Text Field with a Workflow in SharePoint Designer 2013 First, create a workflow variable containing a single space character and use the Trim function to blank the variable. Select…
Read More
Send email when specific field changes in SharePoint

Send email when specific field changes in SharePoint

SharePoint, SharePoint Designer
[wp_ad_camp_1] [wp_ad_camp_4] How to send email if a specific field changes in SharePoint (versus just any field in the list item) You need to send email when specific field changes in SharePoint, based on a field changing instead of just any field in the list item. SharePoint has provision for users to set up alerts when items in a SharePoint list change. However, sometimes you only want an alert when a specific field changes. For example, you may only want to know when a field such as Target Delivery Date changes. You can set up this email trigger by performing the following (each described more fully further below). 1. Set up a “helper” column that will serve as the basis for keeping track of any pre-change state. 2. Set up…
Read More