Utility - Extract Text between Values

Overview

The 'Utility - Extract Text between Values' action for Power Automate returns a string value extracted from two defined points within the string value provided.

If the two defined points are repeated in the string and you want to extract all instances of the text between the two defined points, please use: Utility - Extract Text Instances between Values

Video Guide

Extract text between values with Power Automate

Credit Count

This is a Utility action and therefore consumes only 0.05 credits per operation (except 1 credit on the free plan). For example, 100 operations will consume 5 credits on a trial and all paid plans.

Default Parameters

The default 'Utility - Extract Text between Values' flow action parameters are detailed below:

• Text - The text from which a value is to be extracted
• Start Value - The text value to start the extraction from
  • Leave blank to use the beginning of the text provided as the Start Value
  • Line breaks are supported within Start Value input
• End Value - The text value to end the extraction from
  • Leave blank to use the end of the text provided as the End Value
  • Line breaks are supported within End Value input

Advanced Parameters

The advanced 'Utility - Extract Text between Values' flow action parameters are detailed below:

• Ignore Case - Set whether the text case should be ignored when executing the extraction
• Include Values - Set whether if any or both of the Start Value and End Value should be included within the result
• Trim Result - Set whether white-space should be trimmed from the end and start of the extracted string

Return Parameters

Action Specific Return Values

• Result - The extracted string value

Standard Return Values

• OperationId - The unique ID assigned to this operation.
• HttpStatusCode - The HTTP Status code for the response.
• HttpStatusMessage - The HTTP Status message for the response.
• Errors - An array of error messages should an error occur.
• Operation Status - Indicates whether the operation has been completed, has been queued or has failed.