Excel - Replace Text

** AVAILABLE NOVEMBER / DECEMBER 2024 **

Overview

The 'Excel - Replace Text' action for Power Automate provides the capability to search for text fragments within Microsoft Excel documents and replaces with alternative text.

Credit Count

This action consumes 1 credit per operation.

Note, different Encodian actions can consume different number credits. Please always check the action specific documentation and read What is an Encodian Action for a full description of how credits are consumed.

Default Options

The default 'Excel - Replace Text' flow action parameters are detailed below:

• File Content: A Base64 encoded representation of the PDF file to be processed.
• Phrases: The collection of text phrases to locate and replace (See below for further details)

Phrases

For each phrase; the 'Search Text' value will be replaced with the 'Replacement Text' value. By default; Text fragments are located by finding matching instances of the 'Search Text' parameter, to use a regular expression search simply set the 'Is Expression' value to 'true' so that the 'Search Text' parameter will be evaluated as a regular expression and not a free text search.

Multiple phrases can be included within a single operation. To add more than one phrase click the 'Add new item' button:

• Phrase
  • Search Text: The text to locate and replace with the 'Replacement Text' value
  • Is Expression: Set whether the 'Search Text' value should be evaluated as a regular expression, the default value is 'false'
  • Replacement Text: The value to replace the 'Search Text' text with
  • Match Entire Cell Contents: Set whether the search should be for all or part of the cell content
  • Case Sensitive: Set if the 'Search Text' value should be evaluated as case sensitive

By default; all of the following options will 'Inherit' the existing properties in the Word document, which is applied to the text value being replaced, use the options below to override this if required:  

• • Font: The name of the font to use for the 'Replacement Text', by default the font used within the cell will be applied
  • Font - Colour: The font colour to be used on the 'Replacement Text', the default setting is 'Inherit'
  • Font - Size: The size of the font to be used for the 'Replacement Text', by default the font size used within the cell will be applied
  • Font - Bold: Set whether the 'Replacement Text' is set to be 'Bold', the default setting is 'Inherit'
  • Font - Italic: Set whether the 'Replacement Text' is set to be 'Italic', the default setting is 'Inherit'
  • Font - Scheme Type: Set the Font Scheme Type to apply to the text, the default is 'None'
  • Style - Strikethrough: Set whether the 'Replacement Text' is 'Struck Through' and its style, the default setting is 'Inherit'
  • Style - Underline Type: Set the style of the underline for the 'Replacement Text', the default setting is 'Inherit'
  • Style - Script Type: Set whether the 'Replacement Text' should be Subscript or Superscript, the default setting is 'Inherit'
  • Theme Colour: Set the colour for the 'Replacement Text' according to theme within the Excel file, the default setting is 'Inherit'

Please refer to the Obtaining the 'File Contents' Parameter article for guidance on how to obtain the 'File Content' parameter ready to provide to an Encodian flow action.

Advanced Parameters

The advanced 'Excel - Replace Text' flow action parameters are detailed below:

• Culture Name: This setting is used to set the culture for processing the request. Please refer to the Culture Names article for a list of supported cultures

Return Parameters

The 'Excel - Replace Text' flow action returns the following data. 

Action Specific Return Values

• File Content - The processed word document (Base64)

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.