Solved

Extracting delimited name values for multiple names ( List Lookup)


Badge +9

Hi

 

 

I wouldn't  mind some thoughts on my approach

 

On my form I have captured multiple selected names from lookup lists

 

 

5;#John Does;#6;Jane Doe

 

If I use the regex operation in my workflow

Regex config.PNG

will this work so I can output to a collection var colNames - I want to be write each to the Workflow history

 

Do I sill need the For Each loop & Extract Value from Collection to pick say the first name or can I can I simply use Extract Item Collection Action

 

If I use For Each can I store each in a separate var for use in Send Mail?

 

 

 

Daniel

icon

Best answer by westerdaled 31 May 2016, 16:18

View original

3 replies

Badge +9

Regex config for names.PNG

I have got a but further ... just the trailing ";"  to match so I can extract my names....

Badge +9

As for this: Collection(Edm.String)"},"results":["House","Flat","Maisonette"]}   which is the output from a Check boxes. Any hints on how I get those building strings split out?

Badge +9

All

With a little help from a friend: Simon Doy, Yorkshire suguk, we got the regex expression sorted - I can easily extract my first name.

(?<=#)([A-z|s]*)

Daniel

Reply