Archive: Nintex for Office 365 Forum

HiI'm trying to do a post request with an Access Token in the header using the "call HTTP web service" action.when i'm doing this with a wrong token I get a message saying that the token is wrong or out of date.But when I'm doing this with the correct token.. The workflow stops and I get this error message:RequestorId: ac318ca8-573d-7bfb-0000-000000000000. Details: An unhandled exception occurred during the execution of the workflow instance. Exception details: System.ArgumentException: JsonWebToken.Issuer != clientId@realm at Microsoft.Activities.Messaging.SendHttpRequest.OnReceiveResponse(NativeActivityContext context, Bookmark bookmark, Object value) at System.Activities.Runtime.BookmarkWorkItem.Execute(ActivityExecutor executor, BookmarkManager bookmarkManager) Exception from activity SendHttpRequest HttpPost Switch<String> Sequence Microsoft.SharePoint.WorkflowServices.Activities.CallHTTPWebService Sequence Flowchart testwebrequest.WorkflowXaml_b4be1f9f_26da_4b45_9a77_9c1359

Hey there,We have a scenario from a client that is for an inspection to retrieve data previous inspection data into the form to compare values from current to the last submission.Is there a way to dynamically look up the last submission in real time so the new form can prefill the previously filled data for specific fields?The example below is from their paper-based form but would fill the Previous Leakage information automatically for them and that way, they only need to fill the current leakage field.  

Hi, I have a form the is used as a handover. This form is open for a 12 hour period and then gets submitted at the end of the 12 hour shift. The form currently times out after some time and errors when trying to save.  Does anyone know how to set up an auto save and continue rule or function to run every 20 mins to stop this timeout? OR does anyone else have any kind of work around for this? Thanks,Kyle 

Hi,   I would like to set up a rule so if a calculated value is >0 then the text colour changes to green and if the value is <0 then it changes to red.    Thanks, Kyle 

Hi,I have a Nintex Workflow based using Nintex Forms (classic) as task forms, my task forms are showing the drop-down for Task Outcome field instead of the usual radio buttons. I have tried deleting the control and reapplying, yet this is behaving similarly in all three forms of this workflow. (working fine in other workflow though). is there anyone who faced this and have the solution? otherwise please suggest what can I do.Thanks

Hey all! Need a little help here with an O365 workflow build. We are using "Start a Task Process" in the hopes of setting up an approval that needs ALL THREE of the approves to OK the item before moving on to the next stage. Problem is the workflow is APPROVING regardless if someone rejected. I've played around with state machine a bit, but am still getting an approval regardless if one person rejects. I thought about setting up a query, but am not sure if there's an easier way to do it (and not 100% sure of how to set up the query). I'm learning Nintex for O365 as I go, so any help would be incredible!!! Thank you!!!

I'm facing a weird issue with the Nintex Form. Have anyone else faced it and solved somehow?This is what I did: I have created a calendar-type list in SPO; I have added the "Item" content type to the list and I'be made it the default (Nintex Forms is not working on "Event" content type); I have then added one "Number" field and one "Lookup" field to the content type. I have then went to a Nintex Forms and published "untouched" form. Now, when I'm trying to save the form I'm receiving the error:Please address the following:Invalid URL value. A URL field contains invalid data. Please check the value and try again. I looked into "Controls in use" tab but there is no "Hyperlink" field... There is also nothing in settings? What can possibly be wrong?  Regards,Tomasz P.S.I have attached the exported form. I also have tried to just create a form on a default list, with a lookup column and... there is the same error. Anybody? Help

The Date/Time Control in the New Responsive Designer is a calendar control that defaults the date as "LongDate" (October 21, 2020). Can I change the default format to "ShortDate" (10/21/2020)?

I have a travel request workflow in O365, which locks the permissions down after the form is submitted. It gives read rights to the user who created the request, then sets edit permissions for the managers who will approve it. If an amendment is required, the permissions are updated to allow the creator to edit the record again. After locking down the record for read rights, I use the Office 365 update items action to set metadata using an elevated account. However, there is no such equivalent for the Set Workflow Status action, so this action causes the access denied issue. Workflows will create a Hyperlink field with the name of the workflow. I am not sure whether or not there is still a supported way to update the workflow field using this Office 365 update items action.

Hi all,  I can't be the only one wondering how to recreate the classic approval and collect feedback workflows in modern nintex? My issue is I can't figure out that task screen where the requestor can choose an approver/reviewer for their document. Am I missing something simple?

Using Office 365 Query list can we fetch multiple column's ? Say i have the following query to fetch "FirstName","MiddleName",LastName" <Query><Where><Eq><FieldRef Name='Title' /><Value Type='Text'>001</Value></Eq></Where></Query><ViewFields><FieldRef Name='FirstName' /><FieldRef Name='MiddleName' /><FieldRef Name='LastName' /></ViewFields> By using O365 Query list action we can fetch the First column (here it is "FirstName") which we defined in the <ViewFields/>. So how is it possible to get the other columns like "MiddleName","LastName" and so on...My query is how to fetch the complete row column values returning from the query output? Since "Add Fields" is available, i am assuming that there should be some mechanism which i am missing to fetch the other column values. Appreciate your assistance in advance. 

Scenario - Site workflow on the top level site collection that has two lists on it. The workflow should run daily and loop through all subsites under the site collection and O365 Query list on each subsite to get items that have been changed in the last 24 hours. It should then take those items that have changed and update the specific list on the top level site with the fields gathered in the O365 Query List. I have the entire workflow running as expected but I am running into a problem. A few of the fields I am returning from the O365 Query list can be empty. When those fields are empty, they simply do not exist in the collection that I am running a For-Each loop on to update the list on the top level site. This throws off the index in the For-Each loop since what would normally be at index 3 isn't there, so now index 4 is now index 3 for that particular item. This then gives "Index property is greater than the number of items in the collection." Any ideas on how whenever the O365 Qu

I like to use Nintex forms because I really love how the cascading dropdowns work.  I was wondering, is it possible to connect to an external API (google api's with two-factor authentication) and pull the data to a list and use that list to create a Nintex form with cascading dropdowns and I get fresh data from the API whenever I use the form. Is this possible?  If so, are there any resources that I can read and research?

Hello Team, I am new to Nintex workflow. My requirement is to add a column in the sharepoint list which will have a constant and ID value together as  a string everytime a new item is created. Example: for first item ID will be 1 and new column will have value A1 and will be A2 , A3 etc for 2nd and 3rd item respectively.  I tried creating a workflow by 1. Quering the list and do descending sort based on ID column and assigning ID values to a variable as output2. use get Item from Collection method and get the first value using index = 0 and assign to a variable3. create a workflow variable and assign it a constant , in our example "A"4. Use build string to concatenate variables from step 2 and step 3 using {var1}{var2} and assigning it  to output5. use Set Field in current item to add the value from step 4 to the new column  It is not working. I am using Nintex workflow for O365. Can you please guide me ? Regards,Sandeep

There is no option to validate file names with special characters in attachment control.I need to restrict submission if any file name contains any of this:  [ ~ # % & * {} > < ; ? / + | "" ]How do I do this in Nintex forms for O365?

Possible error: Links in a multi-line rich text field are not active and also disappear after editing the item. I am using the New Responsive Forms Editor.Simple test:I defined a new list in SPO with one additional field named Info as a multi-line field. Set the definition to rich text (with all bells and whistles): Created a form on the list using the New Responsive Designer. No changes, just published it.   Entered a new item with something like this:I entered two links besides some basic formatting. Save & Close (the links still show but are not active) and Edit the item again. The links still seem to be there (though not active). But once the field is clicked it shows like this:Links are gone and after saving the item all basic formatting remains but no hyperlinks.I have checked the Current Limitations (is this the latest version?) but that tells me it should work.Question:  Did I miss something or did I hit a bug?

I am pretty new to using nintex and I am having a hard time figuring this one out. I am trying to create tables within my email workflow notifications based on fields used within the form. Here are two examples of what we are trying to get:Fields: Date expense incurred, Business Purpose, Miles, Travel, etc Fields: Cost Center, Company, Amount, GL Account, Account#, etc thank you in advanced! 

Hello, I have inherited a form with fields, which are not connected to List columns, BUT still get saved into the list. I spent a lot of time trying to find what might be the reason of that - and can't see any possible way of it working, but it still is. Details: there are 3 dropdwon fields on the form - Availability1, Availability2, Availability3. They are all not connected to the list columns. there is a textarea in the list called Availability. It fully corresponds with the data in the dropdowns. If we change the dropdowns and save - the data will be saved in the Avalability text area. If we open the form after saving changes - dropdowns will display the changes made.  there is NO javascript on the form - checked form settings in both 'Custom Javascript' and 'Advanced' none of the fields have field name stored in a variable, i.e. 'Store Client ID in JavaScript variable' is always set to No checked site masterpage for custom javascripts as well - nothing. checked site content for any

I am using the file upload action to copy a file from an approval site to a storage site. Sometimes the storage site does not exist in our office 365 tenant. The action has the ability to write to a variable if the upload is not successful, but the workflow suspends if the site does not exist. Interestingly, it is not trivial to test whether the site exists in O365 - I saw some posts where they use call web service, but this returns unauthorized because it does not pass credential tokens to the web service automatically. The destination is in another site collection.   Any idea how I can test for the existence of the site prior to the file upload, or how is the success variable in this action supposed to work?

Hi, I'm starting out in Office 365 Nintex Forms and am automating a Word document that historically was printed (and subsequently partially automated with SharePoint 2010). Workflow will be driven from this form, with a source list  storing some data from the form itself. The form itself has multiple pages of fields to fill in, with some repeating sections and also employee selection.Not all fields are at all relevant to the subsequent workflow. What I'd like to know is if there is any recommendation around what to store bound in the source list vs what to leave stored within the form itself. How fragile are these forms ? I'm guessing that the repeating data will need to stay in the form. I'm also moving from an InfoPath <shudder> background and am a developer which in itself is both  good and bad thing. Regards Andrew

I have a few fields in my form that I want to only be filled out by a certain user. Is there a way to set the Read-only field to be Yes unless the current user is the correct one? I was trying this but couldn't get it to work: ifElse([Context].[Current user display name] == "username", "No", "Yes")

Hi, I need to count the number of attachments a list item has. I just need to be able to send an email with the attachments as well as the number of attachments in the body of the email. I've seen some similar questions here, but nothing matching exactly. Any help would be great. Thanks.

I inadvertantly deleted Office 365 new responsive designer form. Is there any way to restore it?  @EuanGamble any help would be highly appreciated.

I have list which has an approval workflow which runs when in a new item is created. The data in this list is being accessed by another service, so if an item needs to be cancelled - rather than delete it - I need to flag it in a Status column as "Cancelled", so that the other service can filter out cancelled items (whereas if the item was deleted, it would remain as an active item in the other service). If an item is cancelled I also need to terminate that workflow. Right now I have a hyperlink in a column called "Delete Item", and if that link is selected a form opens where the user can enter the item ID, and then when submitted a small workflow updates the Status column as "Cancelled" and the running workflow for that line item is terminated.Is there a better way to do this, or is there a way so that when the link is clicked the form is pre-populated with the item ID of the line item in which the link was clicked?

Ive created a new responsive form in my O365 environment and now I want to move it to a new site collection in 365 however when exporting it exports as a JSON file extension and when I try to import into the list in the other site collection theres no option for a JSON file import. Ive been searching for a while and haven't found any resources on this.  Could someone please give me some advice on this or point me to another post/info as I'm stuck. Ive also tried migrating it with the latest version of ShareGate and it doesn't seem to bring it across.