Archive: Nintex for Office 365 Forum

We have created a new list and new nintex form .After saving the nintex form , iam trying to create new item..Iam getting the error  "The Value '1E+24' of the maximumValue property of "cannot be converted to type 'Double'." Please find the attached to see error.can anyone please suggest or help me to resolve this one

We are working some automataion with we have been using nintex forms for the same and we have used Repeated tables into our forms for the same, but we are facing one issue that once the form is been saved is saved for multiple times , the data from repeated tables is getting lost , this is happening for one particular form only , we have several forms for this we are not facing this issue , but only for this particlaur form . can any one help us what will be the issue ??

Hi, I need to create new excel documents on a new item creation in a list. I'm trying to using the "Create Item" action to create an Excel document in document library. The excel template is associated with a custom content type. This content type is specified while configuring the action. However, every time a word document is only created in the document library. Does "Create ITem" only support Word files?

We're getting a warning in our cloud sql database that Nintex is not escaping parameters when it's querying: SELECT Job FROM <table> WHERE Site = '‍{Variable:varDBSite}‍' Errors when a site name with a quote is passed: SELECT Job FROM <table> WHERE Site = 'Rocky's Reward' On-prem offers the option, however it looks like o365 doesn't? Is there a solution?

I am new to nintex workflow. I am using the functionality of document generation in 365 office for a generating excel sheet. I am able to copy Tag from from nintex document Tag but it is not pasting into the cell that I am selecting.

I think I must be missing something.   I was using a regex to replace a character in a text field.   I needed to replace a comma with a semi-colon and a space.   It added the semi-colon but not the space.   Not sure what I am missing here.

Context: I've been tasked to start migrating our workflows over to O365 from 2013 ahead of time to hopefully make the transition smooth. Our environment is based in NZ with a timezone of (UTC +12).I'm having two issues with dates within scheduled workflows and hope they might be caused by the same thing: Our preferred date format is dd/MM/yyyy and logging the variable that contains the date returns it like this. However, when a notification is sent out it gets converted to MM/dd/yyyy and takes off 1 day. E.g. 20/06/2019 becomes 06/19/2019. The notification action comes right after the log action in WF so I wouldn't expect it to be changing. Using query list to filter out items if due date has passed current date is causing workflows to terminate with the following message: "String was not recognized as a valid DateTime". Due date is a sharepoint column as a Date and time Current date is done by using Add time to date action storing result in a Date/Time variable:Regional settings in th

 When binding a workflow variable in Custom Javascript section of Nintex Task Form Settings Window, I couldn't see the last workflow variable which I created and I needed to inspect the element and add overflow-y: scroll to see the last added workflow variable. Please have a look on to the following gif. 

I have a number field that is optional to be updated. Zero is a legitimate value to enter into the field. However, if the field is left empty, it still returns zero. So a test for zero doesn't tell me if that was the original value or the updated value. I'd like the field to return blank if the field wasn't updated by the user to zero. I tried the following script that i found elsewhere, however it doesn't seem to work in o365.  NWF$(document).ready(function() {     var number = NWF$('#'+Number).val();    if(number == 0)    {      NWF$('#'+Number).val('');    } });    

Hello,    I am trying to figure out how to add business days to several tasks assigned in nintex worklfow. I have searched for answers. However, I have not found a solution or a work around. Any help would be greatly appreciated. 

Hey there, apologies if the question has been asked but I searched for a solution without any success.   Has anyone developed a solution where Nintex queries Office 365 profiles, detects profiles that are expiring within 7 days and send an email notification to these users?   The reason I am looking for such a solution is to communicate to staff to update all their other device passwords, especially members out in the field.

When I attempt to delete my Nintex workflow from the Workflow Gallery I receive the prompt to confirm and click OK but then I get the "Deleting Workflow.." image for an infinite period of time and the workflow never deletes.  I've let this run for as long as 30 minutes before with no success and this is occurring across my entire site collection for all Nintex workflows.  The Nintex Knowledge Base has this logged as a known issue but their only solution is to contact Microsoft for support.  I've also reached out to Nintex Support and did some troubleshooting but we were unable to resolve this issue.  I then contacted Microsoft Support and they advised removing SharePoint from our retention policy and then trying to delete the workflows.  I gave that a try but was still unsuccessful at removing the Nintex workflows.  Has anyone had this issue and successfully been able to address it and, if so, how did you do it?

I am recreating a workflow for a SPonline list and Nintex.    In SP2013 using Nintex I was able to copy the value of a multi-value choice column into a variable and paste it into a text field using only 2 actions (Set-Variable and Set-FieldValue) and  and get a nicely formatted string of text that looked like this: Brazil;Ecuador When I try to to the same thing in SharePoint online with Nintex I get this:{"results":[{"Id":36,"Value":"Brazil"},{"id":8,"Value":Ecuador"}]} I am using the same workflow actions: How on earth can I make it work like it used to?  Each item will have a varying number of entries in the variable, so I would need to be able to clean up each one if I have to go that route.  I need to use the cleaned up string in a Powerapp. @vadim_tabakman 

Hi All, hopefully you can help me with this.  For some reason i can't get the cascading lookup to work for this scenario.  Following is an example of the issue:I have an existing list (list1). In list1 there is a 'city' text field (plus a 'city ID' text field). A form lookup control populates these two fields. There is also a free text 'suburb' field in list1. I feel like this field could be the issue, not sure . I have a second list2 (and form) where I want to lookup the suburbs filtered on the city from list1.So i have two lookup controls on a form connected to list2:   I can bring back the cities into a form lookup dropdown - text field and ID field for City.    I can bring back the suburbs into a form lookup dropdown - text field and ID field for Suburb. However when i attempt to filter the suburb on the city control, the drop down is blank.  A note given when setting the 'Filtered by control' field in the List Lookup control of form2 is "The control must be of a type that can post

good afternoon,   I'm encountering an issue which is likely user error, but I am a bit stumped at this point.  In a workflow I am attempting to utlize the Query List action.  The list has been selected, and and I trying to bring back items which match a Text workflow variable.  For some reason, even though the value appears to be an exact match for the specified column and variable I get zero results. if I manaully type in the condition the query returns expected results.  Is there a need to trim the variable or convert it in some way prior to use in a query?

I see that it is possible to create custom form controls for SharePoint 2013 using the Nintex Platform Development Environment. Does a similar thing exist for Nintex for Office 365? I've been creating custom client side controls using Javascript but validation and post back are a bit of an issue when working this way.

Hey Guys, Does any one now how to use the "Update List Item" action to update the "Name" column in a document library. In on premise envriornment we had the Name column directly available to update. But in O365, there is a column "Path and Name".I tried to update this column using below method:{Workflow Context:Current site URL}‍‍{Workflow Context:List Name}‍/‍{Variable:varFileName}‍but it seems, it does not work. Can someone help on this? Regards,Shyam

Hi there! Since a week or two (since the update of Nintex Forms on Office 365(?)), my customers experience a problem while using the Nintex List Forms Online Web Part. When using this Web Part to show a Nintex Form on a page, it keeps showing the 'Loading' icon. When I try to open the form via the List itself, it opens right away. In some cases, after a Form has been opened through the List, the form is also shown via the Nintex List Forms Online Web Part. When I close the browser and I open the page that includes the Nintex List Forms Online Web Part, it keeps 'Loading'. To me, it looks like a caching-thing that is caused by the latest version of the Nintex Forms app. I've tried to add both *.SharePoint.com and O365.Nintex.com in the Trusted Sites, but that had no positive effect. Thanks in advance! - Michel Verwijmeren

Hi there, I'm trying to create an SPList in SharePoint using Nintex Workflow for Office365. As there is no direct Action available in Nintex for Office 365, I've used REST API to do the same. I followed the steps as said in the below article.Using the Office 365 REST API to create lists from your Nintex Workflow.But I ended up with Access denied error as below.Response Content : {"error":{"code":"-2147024891, System.UnauthorizedAccessException","message":{"lang":"en-US","value":"Access denied. You do not have permission to perform this action or access this resource."}}}Response Status Code: ForbiddenCan someone help me to get over this? My requirement is to Create a Sub-Site & few SPLists as requested by End-users(by filling up a form). I'm able to Create a Sub-Site as there is direct action. For creating Lists, I'm using REST API which I could not succeed. Since this a very common requirement, I'm expecting there should be a way of doing it without much difficulty. Thanks in adva

I'm trying to show the open task for the current user on the homepage of the (sub)site.  As this are new sites, they have the modern interface and within the list webpart the task lists are not available.  Is there a nintex webpart available to load these Nintex tasks?

Work flow doesn't send notification to the person that is the result of the query. When I run the query I can see the correct result, but the notification doesn't go to the person.  I think I am missing something, maybe I need to create a different variable for my notification.  I am attaching print screens of workflow, query and variable.  Thank you.

Hi guys,  I cannot find much information on this, but I would expect that when a workflow instance is terminated (manually or by a workflow), all workflow tasks that relate to the instance, are removed as well. I notice in my current O365 environment that this is not the case, can someone confirm this?  So to my understanding I would need to "workaround" this by deleting all workflow tasks by using e.g. a different workflow... Thanks, Glenda

Suddenly a workflow gets "suspended" with this message: The account password has expired, as specified by the account settings.I have checked and updated the Connection Manager entry related to this WF with the proper User and PW.  Republished the workflow itselfAnyone seen this behavior ?ThanksJaap

The company requires all external email to go through our own internal email filtering system. When configuring an email action I can select "External email and attachment" which uses an external email service configured by Nintex. I need to prevent users sending email externally either by preventing the selection of this option or by having our domain  restricted to prevent the external email service. I have tested this and currently our domain is prevented from sending email attachments (which is good). How can I prevent external email?

Hello,    I am in the process of recreating a few forms in Nintex for O365 and am running into an issue. We have multiple SharePoint lists that sit on a separate site collection that will be referenced in multiple forms. However, when I go to use the "List Lookup" control in Nintex, I receive the error "Loading the available lists failed. Please check the URL you have provided is a valid URL within the current site collection." To begin I used a relative link as I did in Nintex On-Premise, but to no avail. Our SharePoint lists that are reference site at a location similar to this: domain.sharepoint.com/sites/NintexTables. In the "Source SharePoint site" field I've tried the following URL's with no luck: /sites/NintexTables, sites/NintexTables, domain.sharepoint.com/sites/NintexTables, and https://domain.sharepoint.com/sites/NintexTables. What am I missing? Is there a setting I need to enable to allow these two site collections to "talk" to one another? Any help is welcome!