Flow

(0) Share

Report

Posted on by KNAR

I need a help to extract texts which contains _ from email

sample email :

Hello

Billing date is due for this month. Please find the servies below

GYO_PL6801_HD_YTO

KY_YO_HHS_GY_9610

Thanks,

Categories:

Building flows

I have the same question (0)

All responses (12)

Answers (2)

v-mengmli-msft on at

Like (1)

Report
Hi @KNAR ,

If this is a fixed-format email sent to a customer, then you can use the following method to get the text containing '_'.

1/My test email.

2/Flow.

first(split(last(split(outputs('Html_to_text')?['body'],outputs('Compose_2'))),'Thanks'))

3/Result of test.

The above method results in the text containing '_' by cutting the line break in the body and 'Thanks'.

——————————————————————————————————————————————

If my answer helps you solve the problem, please accept it as a solution.

Best regards,

Rimmon

Was this reply helpful? Yes No
KNAR 17 on at

Like (0)

Report

@v-mengmli-msft @Unfortunately its not a fixed format we do have separate format for other emails but services has fixed text containing _
so is it possible to extract the text which contains _
And services 1 - 50 which may vary based on the email, so if its extracting based on the _ will be useful

thanks

Was this reply helpful? Yes No
KNAR 17 on at

Like (1)

Report

@jibbs @abm

Was this reply helpful? Yes No
Verified answer

Chriddle 8,436 Super User 2025 Season 2 on at

Like (0)

Report
Select From:

split( replace( outputs('Compose'), decodeUriComponent('%0A'), ' ' ), ' ' )

Map:

if( contains(item(), '_'), item(), '' )

Filter:

@greater(length(item()), 0)

Was this reply helpful? Yes No
jibbs 84 on at

Like (0)

Report

Hi @KNAR , give @Chriddle's solution a try. If you still face any issues, you could try the AI Builder action to extract the text, but keep in mind that that solution requires premium PA license with limitations on AI Builder action credits.

Was this reply helpful? Yes No
Verified answer

Chriddle 8,436 Super User 2025 Season 2 on at

Like (0)

Report
Even simpler:

From

split( replace( outputs('Compose'), decodeUriComponent('%0A'), ' ' ), ' ' )

Filter

@contains(item(), '_')

Was this reply helpful? Yes No
KNAR 17 on at

Like (0)

Report

hey @Chriddle thanks above solutions works could you please help me with the solution for the below
As im trying to post this result in the group chat
while i am getting ouput as the below

["GHYWI_YWHD_NAT_68901_0","YUPLE_HU_MJU_561803uh_0","UTWNJ_UGW_6820_Y"]

BUT Need a output like the below

"GHYWI_YWHD_NAT_68901_0",
"YUPLE_HU_MJU_561803uh_0",
"UTWNJ_UGW_6820_Y"]

Was this reply helpful? Yes No
Chriddle 8,436 Super User 2025 Season 2 on at

Like (0)

Report

I don't get it.

Your proposed output looks strange.

Was this reply helpful? Yes No
KNAR 17 on at

Like (0)

Report

Requirement is to paste a every result as anew line delimiting “ , “

Was this reply helpful? Yes No
Chriddle 8,436 Super User 2025 Season 2 on at

Like (0)

Report
Here are 2 options:

If you want to keep it as JSON, stringify the array and add new-lines

If you just want to list the values, join the array

If you need a HTML new-line, replace decodeUriComponent('%0A') with '<br>'

replace( string(body('Filter_array')), ',', concat(',', decodeUriComponent('%0A')) )
join( body('Filter_array'), decodeUriComponent('%0A') )

Was this reply helpful? Yes No