Others

How to Extract Text After a Specific Word in Power Automate

Nimra Malik Sep 30, 2026 868 views

Question details

The user needs to learn how to extract specific text from a string, such as copying content after a targeted word until the next blank line, using a Compose action.

How to Extract Text After a Specific Word in Power Automate

Product: Microsoft Power Automate
Device & OS: not provided
Scenario: Automating workflows that require parsing strings and extracting specific substrings from text data blocks.
Observed behavior: Requires the correct Power Automate expression or workflow logic to isolate text appearing immediately after a reference word.

Before you start

Ensure you have access to your Power Automate flow and identify the exact reference word and the delimiter (like a blank line) you want to use for extraction.

Solution 1Recommended

Seek Help in the Microsoft Power Automate Community

Because text extraction expressions can be highly specific to your document's format, the official community is the best place to get tailored workflow solutions.

String manipulation in Power Automate often requires complex nested expressions. If standard functions aren't working for your specific text block, community specialists can provide exact formulas.

Visit the Community

Open your web browser and navigate to the official Microsoft Power Automate Community forums.

Search Existing Solutions

Use the search bar to look for 'extract text after a word' to see if a similar Compose-action question has already been solved.

Post Your Specific Scenario

If you cannot find a match, create a new post detailing your text structure (e.g., needing text after 'Nodes' until a blank line) and share screenshots of your current flow.

Seek Help in the Microsoft Power Automate Community

Include examples: When posting in the community, always provide a sample of the raw text and the exact output you expect. This helps specialists give you a working expression immediately.

Solution 2

Use Split Expressions in a Compose Action

Use a combination of split() expressions to divide the text and isolate the string you need.

Free Microsoft Office alternative

Analyze Your Extracted Data with WPS Office

While Power Automate handles your background workflow automations, you need a reliable suite to view, edit, and analyze the resulting data. WPS Office provides a free, highly compatible alternative to Microsoft Office for all your spreadsheet and document needs.

1. Download the Installer: Visit the official WPS Office website and click the free download button for your operating system.
2. Install the Software: Run the downloaded installer and follow the quick on-screen instructions to set up the suite.
3. Open Your Data Files: Launch WPS Spreadsheet or Writer to instantly open and analyze the CSV, Excel, or Word files generated by your automated flows.

Fully compatible with Microsoft Word, Excel, and PowerPoint file formats.Includes powerful Spreadsheet functions like MID, FIND, and SEARCH for easy text extraction.Lightweight installation with a familiar, easy-to-use tabbed interface.Free to use for everyday document creation and data processing.

Frequently Asked Questions

Can I extract text between two specific words in Power Automate?

Yes. You can achieve this by nesting two split() functions in a Compose action. First, split the string by the starting word and select the second part of the array. Then, split that result by the ending word and select the first part of the new array.

What is a Compose action in Power Automate?

A Compose action is a built-in Data Operation that allows you to construct, format, or manipulate data (such as strings, arrays, or objects) using expressions before passing that data to subsequent steps in your workflow.

Are there easier tools to extract text from a dataset?

Yes. If your data is in a spreadsheet format, tools like WPS Spreadsheet offer straightforward text functions (like MID, LEFT, RIGHT, and SEARCH) that easily extract specific cell data without the need to write complex workflow expressions.

Office Quick Solutions