Hi , I have a requirement in which I have rows of data coming from salesforce and I need to convert the column values to a single cell seperated by comma.
For Example: The below data should be populated as Car1, Car2, Car3, Car4, Car5 and so no..
I am using excel as middleware to achieve that and using TextJoin() function which works perfectly in excel but during document generation this formula doen't calculate and give #NAME? as the value.
Can someone help me with right formula that can work in nintex? And is there any limitation on formula that can be used in excel which is used as middleware. As not all the formulaes works with nintex
Do you have an example output with dummy data that you can attach? My suspision is that your formula is breaking when data is replicating into the document.
You may need to modify your formula to be dynamic.