How can I extract an OTP from the body of a text message in Blue Prism after retrieving emails using the Outlook VBO Get Received Items (Basic) action? The extracted email body is stored in a collection—how do I extract the OTP from it?
Additionally, the action retrieves all emails matching the subject, but I only need the most recent one, which is the last row in the collection, since it's an OTP. How can I ensure only the latest email is processed?
