web

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

Power Platform CommunityForums Power Automate store email subject va...

Power Automate

Unanswered

store email subject values into array

(2) Share

Report

Report

Posted on by Veblitz

2,249

i need to store email subject into array values, how to store below compose values in below flow into array .Kindly help me with the expression

Sample incoming email

Subject: Country:Kenya,Customer:client5

Categories:

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (2)

Verified answer

bscarlavai33 738 Super User 2025 Season 2 on at

Like (2)

Report

Re: store email subject values into array

This expression should do it:

split(replace(replace(outputs('Compose'), 'Country:', ''), 'Customer:', ''), ',')

Was this reply helpful? Yes No
Veblitz 2,249 on at

Like (1)

Report

Re: store email subject values into array

Thanks a lot but its should convert upper or lowercase check in the below expression or we need to store in a variable and convert again to upper or lowercase characters or caps

example1: country,customer->lowercase
Subject: country:Kenya,customer:client5
example 2:Country,Customer->Uppercase startswith in both Country,Customer
Subject: Country:Kenya,Customer:client5
example 2:Country,Customer->CAPS
Subject: COUNTRY:KENYA,CUSTOMER:CLIENT5

so above sorts of probabilities too can exist in the subject

Was this reply helpful? Yes No
Verified answer

Dieter Gobeyn 29 on at

Like (2)

Report
Re: store email subject values into array

The trick is to transform everything to lower, and afterwards perform the replacement. This should eliminate the dependency on the capitals:

split(replace(replace(tolower(outputs('Compose')), 'country:', ''), 'customer:', ''), ',')

If I've been helpful, please mark my answer as Resolved/Answered and give it a thumbs up. This will help others too.

Was this reply helpful? Yes No

Join the conversation