Skip to main content

Hello,

I created a Nintex Data source using the SharePoint Online connection and 'Query a list’ operation.  

The SharePoint list contains three text columns and one calculated column in which the output is also text. The formula is just = CONCATENATE(NCol1]CCol2]CCol3]). Only alpha characters are being concatenated, no commas or other special characters. I have a single item right now in my list.

If I add this calculated column in the Columns section of the NAC Data source, and then attempt to use the column on a NAC Form with the Data lookup or Choice - Single (dropdown view) controls  I get a data load error.

If I remove the calculated column from the Columns section of the NAC Data source, I am able to load data in the NAC form controls.

Is what I am trying to do possible in a NAC Form? If not, can I use formulas in the NAC Form to present a drop down list of the three columns as a single concatenated list item?

Thanks,

Adam

Hey @acl76 , I can’t see a problem with using Calculated columns.

Is your ucol1], ]col2] and ncol3] just single line text columns?

I did a quick test and seems to work, also used  CONCATENATE:

 

Thank you for the reply. I was able to see the field in the NAC Form options config as you included in your screenshot. However, when i tried to submit the form I ran into the data load failure. Were you able to use the form? It fail to load for me in both Preview and post publish.

 

Setup in SharePoint Online
Able to pull the value into the NAC Form design mode
Unable to load the list in a real time submission attempt.

Thanks,

 

Adam

I second @Deon  - no issues here either.

You might have better luck using “=Column1]&" "&aColumn2]...” instead of “=CONCATENATE(AColumn1], " ", ]Column2]...).

@Deon & @Sampcyn - I tried the alternat text method provided by Sampcyn but am still getting the same result. I can access a calculated column in NAC Form design mode, but when I publish the workflow and try a submit I get the data failed to load.

To add, I have a second control on the same NAC form that is pointing to another SharePoint Online list, via the NAC Data sources, but not accessing any calculated columns and it is able to load without errors.

I will keep researching, I must have something configured wrong.

Thanks,

Adam

One of my team members helped me figure this out. When I created the NAC Data source, I add both columns and the sort column in the configuration.

Data source configuration options

Apparently the NAC form Data lookup and Choice - single controls do not like this configuration to be present in the Data source. I removed all configuration and instead set the Columns and sort order column in the NAC form control at design time.

Set column in NAC form control

The drop down loads correctly with my calculated field.

I should add that this was only an issue with calculated columns, I am able to set configuration in the NAC Data source for simple data types like single line of text.

Thanks for the suggestions!

Adam

 

Reply


View our Community Site Map

Nintex Community Sitemap
Terms & ConditionsCookie settings