lindi
Canvas Initiate

Regular Expression to Extract Approver Name (Nintex for Office 365)

Using Nintex for Office 365 I cannot get the Approver name from a completed task (using lazy approvals) as the task list shows modified by as ''app@sharepoint''.  For auditing purposes I need to know exactly who approved via lazy approval.  I have read that it is possible to extract the approver name from the approver comments metadata but am not familiar with regular expressions and all of my attempts so far have been unsuccessful.

Approver Comments as below and I want to extract the part shown in bold only i.e. approvers display name and presence (in brackets after the name):

John Smith (Audio Systems Ltd) (Approved) 28/10/2020 1:57:47 PM - 28/10/2020 2:13:05 PM - [This is my comment]

0 Kudos
Reply
3 Replies
SimonMuntz
Nintex Employee
Nintex Employee

Re: Regular Expression to Extract Approver Name (Nintex for Office 365)

Hi.

In the regular expression action use the "Extract" string operation.
The pattern is:
^([a-zA-Z\s\(]*)\)
0 Kudos
Reply
lindi
Canvas Initiate

Re: Regular Expression to Extract Approver Name (Nintex for Office 365)

Hi Simon,

I tried this but got nothing returned []

Not to worry as we've decided to turn off lazy approvals and force users to complete approvals via the task list where I can query who completed the task easily.

Thanks anyway,

Linda

0 Kudos
Reply
SimonMuntz
Nintex Employee
Nintex Employee

Re: Regular Expression to Extract Approver Name (Nintex for Office 365)

Very strange as I tested this before providing the solution.

Sample workflow attached.

0 Kudos
Reply