Hi Mahender,
I understod you have promoted the content of an InfoPath list to a SharePoint form library. I assume the information is stored in a field multiple lines of text. If this is the case you can build your solution making use of the following of actions e.g. 'Regular expression', 'Collection Operation' and 'Build dynamic string'.
You could use an action of type 'Regular Expression' with:
- Pattern: '\n'
- Option: Split
- Input text: <Your multiple lines of text field>
- Store result in: 'Your workflow variable <Type:collection>'
=> To split values of each line into a collection variable (EMPID EMPNAME Designation Organization ;1
Mahender SSE A ;2 Lauren
TSE A)
Then you could use an action of type 'Collection Operation' with:
- Target collection: 'Your workflow variable <Type:collection>'
- Option: Pop
- Store result in: 'Your workflow variable <Type: text>'
=> To pop the last value from your collection variable and store it into a text variable. (2 Lauren TSE A)
Doing this repeatedly usind (e.g. using an action of type 'Loop') you can store each line of the collection into text variables until no value remains. Then you can use the variables in the email body of your email.