Skip to main content
Nintex Community Menu Bar

Find index of an item in a collection

  • April 26, 2016
  • 11 replies
  • 87 views

Forum|alt.badge.img+11

Hi,

Is there a way, without the use of a ForEach action, to query a collection variable by a value and get its index inside the collection?

I'm using Nintex Workflow 2013 on-premises

Giacomo

11 replies

Forum|alt.badge.img+17
  • Nintex Partner
  • April 26, 2016

No (Original Post)

Edit: From the help documentation, Exists returns a yes or no boolean that the value exists and not an index. But see Mike M​'s response, Exist does return an index.


Forum|alt.badge.img+17
  • Nintex Partner
  • April 26, 2016

HA, Sorry. I just wanted to post my shortest response ever. I can't find any way. There are no Collection operations that do this

Add

Remove

Count

Get

Exists

Sort

Pop

Join

Clear

Remove duplicates

Remove by value

And if you use Join, put into a string variable, there are no inline functions that can operate on the string to find an index

fn-Replace

fn-Remove

fn-Length

fn-Insert

fn-SubString


Forum|alt.badge.img+17
  • Nintex Partner
  • April 26, 2016

I didn't find anything using SharePoint calculated field formulas either

Calculated Field Formulas


Forum|alt.badge.img+17
  • Nintex Partner
  • April 26, 2016

So if this truly is the case, what are you trying to do with the collection?


Forum|alt.badge.img+7
  • April 26, 2016

laugh.png


Forum|alt.badge.img+12
  • April 26, 2016

That made me laugh grin.png


Forum|alt.badge.img+12
  • April 27, 2016

Hey all,

Actually you can do this with the Collection Operation action using Exists... but its not Andrews fault for not knowing because the Nintex documentation under the help menu is wrong.

.       You can use the "Exists" method of the Collection Operation to do exactly what you want.   Exists actually returns a numeric - the index of the 0 based collection.    You can log to history to see that this is true as I did below when I use Exists on the value Buffalo.  

Collection:

Index of Buffalo:

Cleveland;Columbus;Detroit;Buffalo;NYC;
3

Thanks,
Mike


Forum|alt.badge.img+17
  • Nintex Partner
  • April 27, 2016

Perfect Mike, thanks for checking it out for real! I should edit my response to not scare future readers away. (but it was so fun).

I'll get the help documentation updated to reflect this! Go Team!


Forum|alt.badge.img+11
  • Author
  • Nintex Partner
  • April 27, 2016

Hi Mike M​,

thank you very much for your clue!! and also thank you Andrew Glasser​ for all the reply you have posted here happy.png, especially the first one!

Thanks again, I was not so confident that there is a solution but, as always, this community is great!

Giacomo


Forum|alt.badge.img+7
  • Nintex Partner
  • November 9, 2018

Is there more information on this? If I try to save the results of an "Exists" test into anything other than a boolean variable I'm getting a coercion error. 


Forum|alt.badge.img+11
  • Author
  • Nintex Partner
  • November 9, 2018

Hi Jeff,

With a number (or integer, I don't remember exactly which one is ok) variable you should be fine