Nintex Workflow - How To Set a DateTime field to Current Date AND Time

-
What: Surprisingly had some trouble with this simple task, so here's how you can avoid wasting 20 minutes of your life.  If you have a list column that is of type Date AND Time, it can be difficult to set it to the current date and time inside a workflow.

Why:  You might like to do this if you were logging changes to items to a separate list for reporting on later.

How (quick): Create a string variable called 'CurrentDateTime', set the string variable to equal 'CurrentDate[space]CurrentTime'.  Set your DateTime list column to equal the workflow variable CurrentDateTime.

 How (detailed):
  • Create a Workflow Variable called 'CurrentDateTime' of type 'Single line of text'
  • Create a 'Set Variable' step and set CurrentDateTime to equal value: Current Date[space]Current Time
    (these two values can be found under common variables tab).



  • Update the field on the list item to equal the Workflow variable you just set.  In my case, I was updating my DateTime field called End Time to equal CurrentDateTime variable.

Comments

  1. Unknown21 March 2016 at 20:29

    this is not working

    ReplyDelete
    Replies
    1. The Baretta21 March 2016 at 21:39

      Gday Sherly, what seems to be the problem?

      If nintex error messages aren't helpful, sometimes it helps to create a 'log history' step after setting variables so you can make sure the variable is formatted correctly.

      Happy to help further if you're still stuck.

      Cheers,
      Brett

      Delete
  2. Unknown14 January 2017 at 22:50

    Maybe Sherly issue is due to simple text writing: Baretta maybe missed to say that you need to select "CurrentDate" and "CurrentTime" using the "insert reference" icon of Nintex, unless this references are not recognized.

    Hope this help, and thank you Baretta for this useful suggestion

    Cheers
    Michele

    ReplyDelete
  3. Ynedis14 April 2018 at 00:16

    You can use the Action "Calculate date" and check "Use date when action is executed" and check "Include time".

    ReplyDelete

Post a Comment

Popular posts from this blog

How to Copy/Duplicate a Table and Columns in a Dataverse Environment

-
Image
What If you need to do either of these things, then this article is for you: Create a copy of a table in the same environment as the original table Create a copy of a table but want a different prefix against custom column names Why In most circumstances, if you need to duplicate a dataverse table, I would suggest to bundle it inside a solution, and migrate the solution to another environment.   However, in the scenario where you need the duplicate table to be inside the same environment, here's a quick method that requires no manual creation of columns! How Short answer : Install  XRMToolBox , inside XRMToolBox, install and utilise the Clone Field Definitions Plugin  from the Tool Library. Pre-Tasks In order to clone a table with a new PREFIX value for the columns you first need to do the following: Create a new PUBLISHER with the new prefix you would like Create a new TABLE where you will be cloning all the fields. Tasks Download & Install  XRMToolBox On t...
Read more

Export Group Membership From Active Directory Using Power Query

-
Image
If you need to export a list of staff from an Active Directory Group, follow these steps.  Allows you to gather all the names & usernames of staff in a particular group and save the information into Excel. Step By Step How To: Open up Excel > Power Query Tab Click From Other Sources > From Active Directory: (In Excel 2016 this is found under: Data Tab > New Query > From Other Sources > From Active Directory) screenshots from Excel 2016 on left, Excel 2010 w/ Power Query Add-on right A popup will ask you to enter your domain name.  It should already be populated with the correct information but if not, input your companies domain name & Click OK: In the Navigator that opens up, expand your domain tree and double click group: You should now see a list of all groups in Active Directory in the Power Query Editor: In order to find & filter for a specific Group, Click the Down-Arrow for the 'distinguishedName' column > ...
Read more

Microsoft Flow - Apply To Each Limitation (5000 items)

-
Image
What Had a situation where I was pulling back 70,000 items in an array from a REST API call.  I wanted to create a SharePoint item for each of the items in an array, however the 'Apply To Each' action kept giving me the following error: ActionFailed . An action failed. No dependent actions succeeded. Why This was due to a Microsoft Flow limitation. When you are using the Free Version of MS Flow you are limited to 5,000 items in a loop .  Explained here:  https://docs.microsoft.com/en-us/flow/limits-and-config Workaround I tried my best to come up with a workaround, tried splitting up the array into batches of 5,000.  All to no avail.  in the end, gave up, and saved the array of items to a CSV and saved the CSV in a SharePoint Library instead. body('Parse_JSON')?['applist']?['apps'] The only other alternative I could come up with is to grab the 'first 4999 items' from the array, which does work with an expression like this: ...
Read more