Answered

Read text between "[" and "]" characters

(1) Share

Report

Posted on by nok

Hello,
I receive an email with the default subject "Price Ind | 04/Oct/2024 | ID [17]"

How can I read the text between the characters "[" and "]" and store it in a variable?

In the example above, Automate should store the value "17" inside a variable.

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

claudiovc 94 on at

Like (2)

Report

HI.

Please try this

split(split(outputs('subject'),'[')[1],']')[0]

I hope it helps!

Was this reply helpful? Yes No
Verified answer

Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (1)

Report

Hi,

Answers provided by @claudiovc is correct, in addition you can try below approaches :)

2 ways you can try :

1. String manipulation.

Expression -

slice(outputs('Compose'),add(indexOf(outputs('Compose'),'['),1),indexOf(outputs('Compose'),']'))

Output you will get :

2nd approach- (quite advanced and using regex)

Here this method is optional and you can use regular expressions to capture the details present b/w []. for this you need to write an office script and run that script using power automate, see below

https://andersjensen.org/how-to-use-regex-in-power-automate/

This article explains how to use regex pattern to get details.

in your case- regex pattern should be: (?<=\[).*(?=\])

Hope it helps !

Thanks & Regards,
Nived N
LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel
Blog: Nived Nambiar's Blogs
Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you!

Was this reply helpful? Yes No