I am using lazy approval on a task. I have it set to capture “Comments including task metadata”. This is what it looks like:
Monserrate, Tony (Approved) 2/11/2025 9:25:38 AM - 2/11/2025 9:26:52 AM - A800459]
I need to be able to grab that 800459 and put it in a variable so I can update it to a SharePoint column.
Hi
Welcome to the community.
You can use a regular expression action to extract the comment.
Pattern: (?<=\=)(.*?)(?=\])
The regular expression action will put the output into a collection, so use a get item from collection action to extract the text into a text variable.
Hi
I used this to extract the number between the []. \(.*?)\]
Hi
It's great to hear that you found a solution.
The regular expression you are using matches the square brackets as well: Monserrate, Tony (Approved) 2/11/2025 9:25:38 AM - 2/11/2025 9:26:52 AM - ;800459]
If you use the regular expression that I have provided, it matches just the number: Monserrate, Tony (Approved) 2/11/2025 9:25:38 AM - 2/11/2025 9:26:52 AM - M800459]
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.