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,
I assume that you haven't followed
If you need a HTML new-line, replace decodeUriComponent('%0A') with '<br>'
Of course you can also add a comma
join(
body('Filter_array'),
',<br>'
)
@Chriddle is there any way to add break line when posting to the teams message
still getting output as below
GHYWI_YWHD_NAT_68901_0","YUPLE_HU_MJU_561803uh_0","UTWNJ_UGW_6820_Y
would be easier if i got message output in teams message
like below
GHYWI_YWHD_NAT_68901_0",
"YUPLE_HU_MJU_561803uh_0",
"UTWNJ_UGW_6820_Y
tried couple of things like apply each action doesn’t seems to be working
thanks in advance
Here are 2 options:
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')
)
Requirement is to paste a every result as anew line delimiting “ , “
I don't get it.
Your proposed output looks strange.
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"]
Even simpler:
From
split(
replace(
outputs('Compose'),
decodeUriComponent('%0A'),
' '
),
' '
)
Filter
@contains(item(), '_')
Select From:
split(
replace(
outputs('Compose'),
decodeUriComponent('%0A'),
' '
),
' '
)
Map:
if(
contains(item(), '_'),
item(),
''
)
Filter:
@greater(length(item()), 0)
Michael E. Gernaey
497
Super User 2025 Season 1
David_MA
436
Super User 2025 Season 1
Riyaz_riz11
244
Super User 2025 Season 1