Add SQL Records, Advanced Calculations, and (Even More) Easy References to Your SharePoint Workflows with Workflow Conductor 1.5

Since the release of Workflow Conductor 1.5 last month, I’ve been writing about all the exciting new features in this version. In case you missed the previous posts: so far, we’ve covered:

I’ll be wrapping up this month-long series about Workflow Conductor 1.5 with a few of the updates to existing Workflow Conductor widgets and features. Without further ado…

New Date, String, and Mathematical Calculations

In Workflow Conductor 1.5, we’ve greatly expanded the functionality of the Calculate Widget to support 20 Microsoft Excel-style date, string, and mathematical functions. Functions can be combined and nested any way you want, to enhance your workflow logic. The new Calculate formula builder supports lookups, too, so your formula can adapt to current conditions.

Support for SQL Records and SQL Insert/Update/Delete Statements

Workflow Conductor has always had the ability to retrieve a single value from an external database using the Query Database Widget. With Workflow Conductor 1.5, you can now retrieve an entire record, and use that record to create new items in SharePoint lists. Also new in this release is support for insert, update, and delete statements, making it even easier to keep your SharePoint and external data in sync. As before, the Query Database Widget supports SQL Server, Oracle, OLEDB, and ODBC connections.

Even More Easy References!

We love making things easy, and Easy References are one of our favorite ways to easily customize workflows with values that are updated every time the workflow runs. Insert Easy References in task descriptions, task e-mails, and Widget properties – anywhere you see the lookup icon or Add Lookup button. For more on Easy References (and other types of lookups), take a look at this previous Conductor blog post or the Workflow Conductor online documentation. We have Easy Reference lookups for everything from the current time to the current item URL, with a dozen more added just for this release. For a complete list of Easy References, click here.

Now that you’ve read about all the new features, head on over to the Workflow Conductor product page to download a free 30-day trial so you can check them out for yourself.

Look for an announcement soon about Workflow Conductor 1.5 for SharePoint 2010 – coming later this month! I’m excited, are you??


All SharePoint Versions

The web parts are functional components that extend your SharePoint environment whether it’s hosted, on-premises, or part of Microsoft® Office 365.

SharePoint 2013, 2016, 2019, Online (Office 365)

On-Premises Only

These web parts extend SharePoint beyond its out-of-the-box capabilities by tailoring it to your requirements with Bamboo Solution’s growing portfolio of SharePoint Web Parts.

SharePoint 2013, 2016, 2019


Product Suites

Experience greater power and savings by bundling our SharePoint apps and web parts.

Essentials Suite

Essentials Plus Suite

Bamboo Premier Suite

Project Management Suite

Knowledge Management Suite

External User Manager


For more information on our product suites, contact us.

Featured Services

SharePoint Health Check

A SharePoint Health Check will identify the causes of issues and risks associated with your specific environment, and is custom tailored to provide you with the best recommendations to optimize your SharePoint environment.

SQL Health Check

Document recommendations relating to performance, stability, availability, or a specific focus you request of your SQL Server database instances.

My SharePointXperts

The truth is that each SharePoint skill may not be a full time job for many organizations, and it is nearly impossible for one person to do everything you need – so augment your team with SharePointXperts; providing the skill sets you need when you need them!