Need to retrieve multiple substrings from the email subject

(1) Share

Report

Posted on by Iantaylor2050

603

I have the below email subject. I need to retrieve the substring site address and postal code from the below subject. I have already retrieved the RBL number successfully.

May i know how to achieve this using Power automate?

Site address should be St Patricks Gardens and St Columbas Close, Gravesend

Postal code should be DA12 4AJ

Email Subject

RBL2113 - St Patricks Gardens and St Columbas Close, Gravesend, DA12 4AJ

Code to retrieve RBL Number

substring(item()?['Subject'], indexOf(item()?['Subject'], 'RBL'), 7)

Categories:

AI Builder

Building flows

Connector development

Power Automate Desktop

Power Automate Mobile App

Process mining

Translation quality feedback

Using flows

Using connectors

General topics

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Valantis 6,526 on at

Like (1)

Report
Copy link

Link copied!

Hi @Iantaylor2050,

just need to tell Power Automate where each piece starts and how long it is.

For the site address, paste this into a Compose or whatever field you're using:

substring(item()?['Subject'], add(indexOf(item()?['Subject'], ' - '), 3), sub(sub(length(item()?['Subject']), 10), add(indexOf(item()?['Subject'], ' - '), 3)))
It finds the ' - ' in the subject, jumps 3 characters past it (that's where the address starts), then works out the length by stripping off ', DA12 4AJ' from the end.

For the postal code:
substring(item()?['Subject'], sub(length(item()?['Subject']), 8), 8)
This just grabs the last 8 characters. DA12 4AJ is 8, so it works cleanly.
if you ever get subjects with a shorter postcode (some UK postcodes are 7 or 6 characters) you'd need to change that 8. For your current format you're fine.

Best regards,

Valantis

✅ If this helped solve your issue, please Accept as Solution so others can find it quickly.

❤️ If it didn’t fully solve it but was still useful, please click “Yes” on “Was this reply helpful?” or leave a Like :).

🏷️ For follow-ups @Valantis.

📝 https://valantisond365.com/

Was this reply helpful? Yes No
Suggested answer

11manish 3,038 on at

Like (1)

Report
Copy link

Link copied!
Since your subject has a consistent pattern, you can extract each part using string functions in Microsoft Power Automate.

Given Subject
RBL2113 - St Patricks Gardens and St Columbas Close, Gravesend, DA12 4AJ

Structure:

[RBL] - [Site Address], [Postal Code]

1. Extract Site Address

Logic:

Starts after " - "

Ends before last comma (postal code part)

Expression

trim(
substring(
item()?['Subject'],
add(indexOf(item()?['Subject'], ' - '), 3),
sub(
lastIndexOf(item()?['Subject'], ','),
add(indexOf(item()?['Subject'], ' - '), 3)
)
)
)

Output

St Patricks Gardens and St Columbas Close, Gravesend

2. Extract Postal Code

Logic:

Everything after the last comma

Expression

trim(
substring(
item()?['Subject'],
add(lastIndexOf(item()?['Subject'], ','), 1),
sub(
length(item()?['Subject']),
add(lastIndexOf(item()?['Subject'], ','), 1)
)
)
)

Output

DA12 4AJ

Thanks
Manish

Visit my blog : https://powerappbuilder.blogspot.com/

Was this reply helpful? Yes No
Valantis 6,526 on at

Like (1)

Report
Copy link

Link copied!

Hi @Iantaylor2050,

Just wanted to check in and see if everything is working now. If you still need any help, feel free to let me know.

Also, if the issue is resolved, it would be great if you could mark the answer as solved so others with the same question can find it easily.

Thanks and have a great day!

Was this reply helpful? Yes No