web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Need to retrieve multi...

Power Automate

Suggested Answer

Need to retrieve multiple substrings from the email subject

(1) Share

Report

Report

Posted on by Iantaylor2050

601

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:

Connector development

Power Automate Desktop

Power Automate Mobile App

Translation quality feedback

Using connectors

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

Valantis 4,347 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 1,851 on at

Like (0)

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

Join the conversation