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

  • 28 October 2020
  • 3 replies
  • 100 views

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]


3 replies

Userlevel 6
Badge +22
Hi.

In the regular expression action use the "Extract" string operation.
The pattern is:
^([a-zA-Zs(]*))

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

Userlevel 6
Badge +22

Very strange as I tested this before providing the solution.


Sample workflow attached.

Reply