Skip to content
Menu

Free tutorial

String Functions

The majority of Power Automate flows need string manipulation. Here's how to do it.

Anders Jensen Automation & AI Instructor

Intro

The majority of Power Automate flows need string manipulation. Here's how to do it.

Learning Objectives

  • Manipulate Strings

Description

  • Initialize a variable
    • Name: OurTextFirstPart
    • Type: String
    • Value: Mr. and Mrs. Dursley of number four, Privet Drive, were proud to say that they were perfectly normal
  • Initialize another variable
    • Name: OurTextLastPart
    • Type: String
    • Value:  , thank you very much.
  • Use the following functions to manipulate the two strings:
    • concat
    • substring
    • slice
    • replace
    • toUpper (toLower)
    • indexOf
    • nthIndexOf
    • lastIndexOf
    • startsWith (endsWith)
    • Split
      • Use an Apply to each on the result array to print out each element
      • Use an expression to print out a specific element, e.g. the 2nd element
    • Trim

Video Guide

More tutorials

  • Microsoft Power Automate

    Lessons for Microsoft Power Automate (cloud): approval flows, Excel, Outlook, forms, AI Builder, HTTP requests, error handling, and more.

    Read more →
  • Error Handling and Creating a Detailed Log

    Make sure your flows can handle when things don't go as expected: Error Handling and write a Log.

    Read more →
  • Excel

    We need to know a little "code" when working with Excel in Power Automate: WDL (Workflow Definition Language) to create functions JSON to interpret the results

    Read more →