Others

Extract Email Values in Power Automate for Jira Updates

Elise Williams Sep 28, 2026 869 views

Question details

Extract specific deployment values (Snapshot and Environment) from uDeploy email bodies using Power Automate to reliably update Jira issues.

Extract Email Values in Power Automate for Jira Updates

Product: Power Automate
Device & OS: not provided
Scenario: Parsing uDeploy emails to extract specific data fields for Jira integration using Power Automate string expressions.
Observed behavior: Users encounter an indexOf object-versus-string error when attempting to parse the raw email body without converting it to plain text first.

Before you start

Ensure you have established connections to your email provider and Jira in your Power Automate environment, and have a sample uDeploy email ready for testing.

Solution 1Recommended

Convert HTML to Text and Extract Values Using Expressions

Convert the email body to a plain-text string first to prevent object mismatch errors, then extract the required data using string delimiters.

When reading uDeploy emails, the content is usually formatted as an HTML object. Directly applying string functions to this object results in type mismatch errors.

By converting the payload to text, you can safely use indexOf, split, and substring expressions to locate your deployment data.

Add an HTML to text action

In your Power Automate flow, add the 'HTML to text' action and insert the dynamic content representing your raw email body.

Reference plain text output

When configuring your Compose action or string expressions, make sure you reference the output from the 'HTML to text' step, avoiding the original email object.

Apply indexOf and substring

Use expressions to locate delimiters like 'Snapshot:' and 'Environment:'. For example, use the substring function to pull the specific text positioned after the delimiter's starting index.

Trim the extracted string

Wrap your final extraction expression in a trim() function to remove any leading or trailing whitespace before passing the clean values to Jira.

Convert HTML to Text and Extract Values Using Expressions

Community Support: For highly complex string logic or workflow design assistance, consider posting your detailed expression requirements in the Microsoft Power Platform Community.

Free Microsoft Office alternative

Streamline Your Workflow Documentation with WPS Office

While Power Automate handles your complex Jira integrations, managing the resulting data, reports, and workflow documentation requires a robust office suite. WPS Office is a free, lightweight alternative offering excellent productivity tools for your daily tasks.

Free and lightweight Microsoft Office alternativeHigh compatibility with Microsoft Word, Excel, and PowerPoint formatsEasily draft and manage workflow documentation alongside your Jira integrationsFamiliar tabbed interface requiring zero learning curve

microsoft office alternative - wps office

Frequently Asked Questions

Why do I get an indexOf error when parsing email bodies in Power Automate?

This error occurs because the raw email body is passed as an HTML object rather than a plain string. Converting the email body using the HTML to text action formats it correctly for string functions like indexOf.

Can I use split instead of indexOf to extract specific email values?

Yes, using the split function with delimiters like 'Snapshot:' allows you to break the text into an array. You can then retrieve the required index and use the trim function to isolate the value.

How can I test if my string expressions are extracting the right values?

Add a Compose action immediately after your extraction steps to output the result. Run a manual flow test using different uDeploy email formats and check the Compose output to verify accuracy before sending data to Jira.

Office Quick Solutions