News

This works with on-prem Nintex Workflow 2013Problem:  Upon archiving a document I use workflow to update the date/time field of when the archive happened.  When user wants to un-archive the document, I need to clear the date field to display as empty (or null). Resolution: Create variable vDateArchivedDate as Date and Time with blank default date Use Convert value action input "1/1/0001" and store in variable vDateArchivedDate Use Set field value to update the date column with workflow data > vDateArchivedDate

Recently I needed to create a schedule of dates, one week apart. I created a loop and added 7 days in each iteration. I noticed it took a very long time, so I added a Log in History task in the loop and saw that each iteration was taking 5 minutes. I realized that this was down to ‘Safe Looping’.This protective feature places some safety measures against the hazards of an infinite loop by adding a hidden delay..I didn’t want to disable this option, mainly because of the maintenance overhead involved, so I looked for another option.I realised that the Collection iteration (For Each) didn’t have any such restriction, so all I needed was to create a collection with the number of entries that I wanted to loop for.The Regular Expression task with the Split operator is the easiest way to create a collection; it simply splits text based on a character. All I had to do was to create a string with the right number of delimiters.This is where I got the idea for this article https://community.nin

The action Assign Flexi Task is under development for O365.Recently, the Task Outcome for Assign a Task was released.The Delegation of a Task becomes then more intuitive.Here is how I have implemented it. 1. Let's create a new Site column for the Task Outcome.Go to Site Settings of your Site Collection and under Web Designer Galleries, click Site columnsClick Create and name it like you wish. I have name it Task Outcome Approve.For The type of information, tick Task Outcome.For Group, the best practice is to create a New group to store your customized columns. I have name it My Company.For Type each choice on a separate line: addApprovedRejectedDelegatedRemove the Default valueClick OK 2. Add a new Site column DelegatedTo to the Workflow Approve content type.In my case, I have create a column of type Person or Group but it can be a lookup column from a list containing the names of the PersonFor Group, select the Group you justhave created.Click OK 3. Create a new Site Content Type.Go t

Applies to: Nintex Workflow and Nintex Forms for SharePoint 2016, 2013, and 2010 Note: The Nintex external platform includes the following external services: Nintex Live (connector actions), external forms (live forms), Document Generation, and External Start. OverviewIf you are running a previous version of Nintex Workflow for SharePoint, and are not yet ready to upgrade your installation to the latest product version, you can install the latest SSL certificates for the Nintex external platform using one of the following methods:Method 1: Automatically install the new certificates by running a script on the Central Administration server. Method 2: Manually download the certificates from the Digicert website, then upload and install each certificate in Central Administration.  This article describes both methods. PrerequisitesEnsure that you have a version of Nintex Workflow or Nintex Forms for SharePoint installed older than:Nintex for SharePoint 2016, version 4.3.3.0Nintex Workflow f

Dear all:I have been very confused about this topic for months:How to navigate from a parent form to child form and come back? How to navigate from a child form to a new one child form keeping the parent link? How to validate child form data before come back in both cases?I think I have now a good approach to do it without javascript.  How buttons workFirst of all, I would like to describe how buttons are working under my understanding, in the case of validation and redirection:Save and submit button / Save button:Both buttons have redirection parameter. You can build the URL dynamically, using a list field value and run-time functions. You can't use calculated fields or control values, this is a very important point.In the case of validation, both buttons can validate data, including list required fields and validation rules in the form. Save and continue button:Save and continue button hasn't redirection parameter. After saving data, the action is refresh page and you are in the same

Though I have been working with Nintex Forms and Nintex workflows for a long time I didn't happen to realize how versatile and fun to work with repeating sections on the forms in conjunction with Nintex workflows. Long story short, I always had this common requirement from Infopath form days till a new project I implemented purely with Nintex, that is none other than having an ability to report and update the repeating table rows using spreadsheet view in the SharePoint. Until I come across a great post written by Vadim Tabakman parse repeating section data I felt it is not possible help clients with such requirements without code, but Vadim Tabakman's posting changed the way how I looked at NIntex Forms. Though the idea of parsing data taken from his post, I wrote the workflow steps in little different way to not to use the loop action instead stick to for each action due to loop action being dependent on turning off safe looping setting which I personally dislike taking that setting

Products: Nintex Workflow for SharePoint (2016, 2013, 2010) Avoid “All” and “Item” Content Types To prevent lengthy content type evaluation when saving or publishing reusable workflow templates, avoid selecting “All” or “Item” for the content type. Instead, create a content type based on Item and then select the created content type when defining the reusable workflow template. For instructions on creating content types, refer to the SharePoint documentation. More Information For more information about reusable workflow templates, see “Set Title and Description for Reusable Workflow Template” in the Nintex Workflow Help (2016 | 2013 | 2010). For more information about the evaluation process that Nintex Workflow uses for content types, see the following MSDN article: http://msdn.microsoft.com/en-us/library/office/microsoft.sharepoint.spcontenttypecollection.bestmatch

Thanks to Sean Fiene‌ for assistance. Below is an example of how to perform Validation on specific controls based on their dates. The goal: If start date is less than or equal to 11 days from today andor If start data is more than 7 days before end date than prevent the form from being submitted. Step 1:Create a list with a “Start Date” and “End Date” column of data type “Date and time”. Step 2:Open Nintex Forms and choose “Forms Variables” from the ribbon bar. I named my variable ‘varStartDate” Type: Integer Connected To: Not Connected Recalculate formula on view mode: No Recalculate formula on new mode: Yes Recalculate formula on edit mode: Yes Formula: dateDiffDays(Current Date, StartDate)  Under the Formula Builder we choose “dateDiffDays” under the Runtime Functions tab and “Current Date” under the Common Tab. The “StartDate” is located under Named Controls tab and will vary depending on what column you are referencing in your list.Step 3:Select the “End Date” control and cli

There is currently a .Net update that has caused disruption on SharePoint 2007,2010,2013 and 2016 platforms.  After applying .NET Security Only patch to resolve CVE-2018-8421 (Remote Code Execution Vulnerability) , all SharePoint "out of the box" & Nintex Workflows fail to execute and the log will show an error like the below: ULS Log: System.CodeDom.CodeBinaryOperatorExpression is not marked as authorized in the application configuration file Publishing a Nintex workflow   ResolutionMicrosoft link to issue & resolution. Microsoft related update information:Microsoft .Net 3.5 Information.Microsoft .Net 4.X.X information.

When i am developing forms for applications, i like to have as much information on the new item form as possible. Workflow can update the item after submission but I think it adds to the user experience to see important information on the form. Whether it is a unique reference number as described here: Ensure Unique Reference On New Item‌ or other information.Another piece of important information, especially in an application that requires line manager approval is, yep, you guessed it, the line manager.With Nintex Forms People Picker API, described in detail here: People Picker Extensions - Nintex Forms‌ we can add the line manager to the people picker control,In my example i have an employee people picker field default to current user and a Client ID JavaScript variable name of varCurrentUser I have a manager people picker field with a Client ID JavaScript variable name of varLineManager Add this code to the custom JavaScript section of form settingsNWF.FormFiller.Events.RegisterAfte

I had these notes stored from a couple of years ago - they helped me at the time with a problem I had been banging my head with for ages, but I haven't needed to use them since.  Not sure if any use to anyone, but in the process of getting all my blog posts in one place, and what better place than the Community  Believe it or not, this is not straight forward.  For this blog I will paint the picture.  I have a request list which uses Managed Metadata to store Business Units.  I have a list on another site which stores approved and completed items from the original request list.  On this list, the same Business Unit Managed Metadata column is used.  I tried using the "Create item in another site" action in Nintex Workflow but could not just simply map the field from one list to the other.  Instead I had to query the TaxonomyHiddenList of the target site collection to get the ID and GUID for the term.  To find the hidden taxonomy list, simply use "Lists/TaxonomyHiddenList/AllItems.aspx"

This is just a reminder for me (if I need it in the future) or whoever need it so as to lose time I lost trying to do it. I tryied to customize a task form with Nintex Forms and I received this message.      Please update to the current version of Nintex Forms for Office 365 You are using an older version of Nintex Forms for Office 365 Update to the most recent version to customize task forms   And I asked myself how could I update it. Because I didn't remember a Sharepoint feature to update installed apps. And after some time I solved it with the next steps: In order to add the app to your Office 365 tenancy, you will need to add the app. This tutorial will take you through the process of adding the app.In your Office 365 site, click on the Settings icon and click on Add an app. 

If I could fill the title with exclamation points, I would. The lookup() runtime function for Nintex Forms for Office 365 is now available. For those of you that have used Nintex Forms for SharePoint 2010 or 2013, you know how powerful this function is, and for those just new to Nintex Forms, let's take a look at what you will be taking advantage of soon! In this example, I want to build an order form that will include a Lookup control pulling Item Names (Title Column) from an Inventory list. In the order form, I want to have read-only values for the item color and the item number. Let's start building! Here is an overview of the Inventory List. Notice the column names and values:Now that we have built an Inventory List, we need to create a list to contain the order form and open the Nintex Forms Designer. I've replaced the Title single line text box control and added a List Lookup control with the following settings:Next, we are going to use the output of our List Lookup control ("Ite

In Nintex 2010, 2013 and 2016 for SharePoint (Standard version even) on-premise of course, there was a possibility to use excel services to query and work with the xlsx and xls files' data. However, insharepoint online there is no such powerful mechanism. Moreover Nintex products for SharePoint Online (neither nwc‌ nor nintex for office 365) don't have any "ootb" actions that would fill that gap. So in the end, there is no straightforward way to achieve it. The most common workaround is to convert the XLSX file into a plain, csv file and then to work with the data from the file using collections (I will write about it in second post). Recently I have realized, that there is a set of excel‌ actions in microsoft flow‌! All of us, who has SharePoint Online, has also a free version of Flow available.  Just be aware, that in the free version Flow does not triggers itself once an event occurs. It just repeatedly checks whether an action occurs and in case it's "check" does not happen in the

You can use the NWAdmin PowerShell snap-in available through the SharePoint 2013 Management Shell on your SharePoint 2013 server with Nintex Workflow installed. You can use NWAdmin and the ExportWorkflow and DeployWorkflow commands to export and deploy a Nintex workflows using a script. You can use the command in migration scripts to move your Nintex solution, in scripts to move your workflows from a development to production environment, or any other situation where programatic access to the workflow will make your work easier. In this post we will walk through how to access the NWAdmin PowerShell tool on a SharePoint server with Nintex Workflow installed, and then export the workflow, and then deploy the workflow to a new list. Contents Export a workflowYou can use PowerShell to export a workflow from SharePoint as a workflow file.To export a list workflow you will need to have the following pieces of info:Source site URL Workflow name Filename and path where you would like to save t

If you observed that below Nintex Timer Jobs not running on your Nintex 2016 farm  follow the below steps:Nintex Connector Subscription Synchronization Nintex Connector Workflow Manager Nintex Connector Workflow Synchronization Nintex Peak Usage SynchronizationMake Sure that you have Central Admin Site running on Application Server, If not follow below steps:Moved Central Admin site to Application Server Stop and Start all Nintex Services on all server Restart SharePoint Timer Service on all server Activated Nintex for all web application Deactivated External Settings from Nintex Administration Activated External Settings from Nintex Administration Turned on all Nintex actions IISRESET on all SharePoint Server.Now you will see all Nintex Timer jobs are running. Support‌Nintex for SharePoint‌ #Nintex2016

To have external connection working, Follow below steps:Turn on External Settings from Nintex Administration Turn on all Nintex Actions Perform IISRESET for immediate availability of actions in workflow. Make sure that you have root site collection created in web application Now you are able to have DocuSign Connection Support‌Nintex for SharePoint‌

We've had a couple of people request the ability to pull back information on the workflows in their farm. This script will return the results of all workflows found inside of the Nintex databases associated with your farm. There are a couple of things to note: Workflows that have been designed, but never run will not show in the results (no record of them in the Nintex DBs) If you have performed a recent purge on the Nintex databases, the workflows may not show up. If you receive errors when running the script, please allow it to run to completion. The script uses what It finds in the Nintex DB and resolves certain information (SiteID > Site collection URL, Etc.) and may error if a Site Collection/Site/List and/or workflow is not found. This will not affect the results of the workflows that are found.  PowerShell ##########################################################################################                             #                                         ### N

Nintex Workflow Cloud Release 54 comes with very good news for those of you using Nintex for BOX.Now, the actions in the BOX connector accept the File or Folder ID as parameters to identify and work with files and folders. And, as you can see in the examples below, the new feature has been added to the actions, it’s not replacing the previous option of the action working with the objects paths. So, if you were already using BOX actions in your workflow with paths don’t panic, you won’t have to change anything. This new feature comes as a response to the feedback we’ve received during the last months from customers and partners asking for a way to interact with BOX objects using the file and folder ID. From here I’d like to thank my product team at Nintex, for the great job they’ve done here and the quick reaction to the BOX and Nintex user's request (myself included ).  Why is this Important? You might be wondering why some of us were asking for this feature, why do we need the File an

 Nintex is pleased to announce the acquisition of Promapp, a business process management software company which provides partners and customers new tools to better optimize business processes through a market leading visual process mapping solution.  The full press release is available at https://news.nintex.com/2018-07-31-Nintex-Acquires-Process-Management-Leader-Promapp . Further details are available at  https://www.nintex.com/workflow-automation/process-mapping/. 

A sandwich PDF is a scanned document that contains an invisible text layer exactly over the image text. Text layer is produced by OCR (optical character recognition) using open source software tesseract. So PDF ist searchable for text and text can copied and pasted in another document. prerequisitesPowerShell workflow action (I use dataone PowerActivity, it should also be possible to other actions like NTX PowerShell Action - Stable Release from Aaron Labiosa ) tesseract (GitHub - tesseract-ocr/tesseract: Tesseract Open Source OCR Engine (main repository) ,  windows installer from Mannheim University Library ) sharepoint listsdocument library named e.g. tesseract for uploading (scanned) images in tiff format list named tesseract-lang to select text language in list lookup control on start formlist workflow tif2pdfstartformworkflowload up an image in tiff format and start item workflow for it. By powershell script text is recognized by tesseract from image and converted to a searchable

Hello! The requirement for doing this was as follows. I have a few lists across various sites that have near to 20,000 items in them. Absences and training registrations for example. When staff leave the company, I wanted to move their relevant items out of the main list into an archive list. I built a site workflow for each of these lists (they reside in different sites ) that allowed me to enter the users logon and items matching the logon would be copied to the archive and deleted. Hence the reason for this post. I wanted to build a parent site workflow, which would allow me to choose the logon as normal and then pass that logon to each of my site workflows and run them, rather than me running each one individually. So I'd not done this myself before so I'm sharing my findings after using the following resource...https://community.nintex.com/docs/DOC-1048 In this example I have 3 site workflows that I'm looking to run and pass a parameter into. Training, Absences and Documents to re

This update is to comment on the document: Manually Update O365 Apps But since I couldn't add any comments to the document I wanted to blog the quick second step needed with modern site. You will not see update link like the following in modern site modeBut you will see it like this in modern sitesSo in modern sites, you cannot update the app as easily. The best way is to use the link in the bottom left corner of the site page to "Switch to classic mode". Then you can easily click the Update link and follow the steps from the original document. Summary:The O365 App will sometimes require the update to be manually applied for Forms or Workflow. You will notified of this requirement when accessing the designer.Product:All Office 365 ProductsSymptom:“Please update to the current version of Nintex Forms for Office365” // “Please update to the current version of Nintex Workflow for Office365”Cause:An update has not automatically applied to your tenancy.Answer/Solution:Navigate to the affect

Hello All! So I have come across some questions and discussions around the out-of-the-box web parts that Nintex provides for reporting and I wanted to dive.Before we go on this adventure, but sure to check out Enable Reports on your Nintex Workflows​ by Emily Billing​, it will help provide some background!Also, these web parts are a part of the Enterprise Edition. Turning On Your ReportsSeems silly, but make sure it is plugged in...At a minimum you will need to turn on Nintex Workflow and Nintex Workflow Reporting Web Parts at the Site Collection level.You may want to turn on Nintex Workflow Enterprise Reporting at the Site level so that you can leverage those reports, but for this I will be covering reports that you can show off to users and paint a picture of what they are doing. Adding Reports To A PageOnce we have everything turned on, we can begin to start using them! I created a page and just started throwing web parts on it!I recommend that you use something to structure the lay

Products: Nintex Workflow 2016, Nintex Workflow 2013, Nintex Workflow 2010 A common cause of workflow failure is size. Additionally, large workflows can cause widespread performance issues in your SharePoint farm. This article provides instructions on how to locate large workflows. Run the below (attached as well as a *.txt file for your convenience) PowerShell script (PowerShell ISE works well) from a SharePoint Server: PowerShell Script Add-PSSnapin Microsoft.SharePoint.Powershell -ErrorAction SilentlyContinue   #Workflows that are larger (in Kb) than threshold will be returned. [int]$threshold = 500   function Get-WorkflowFolders { PARAM ( [Parameter(ValueFromPipeline=$true)] [Microsoft.SharePoint.SPWeb] $SPWeb ) BEGIN {   } END { } PROCESS {   $SPWeb.GetFolder("Workflows").SubFolders   $SPList = $null   [GC]::Collect() } }   function Get-WorkflowData{ PARAM ( [Parameter(ValueFromPipeline=$true)] [Microsoft.SharePoint.SPFolder] $SP