Answered

How to get string before a character appearing multiple times in power automate

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I have this string and I need to get the first character before my date value start. so for example if I have name as ZXDER_20201209220430Z I need ZXDER, if I have ZXDDFR_IUT_23_20201209220430Z I need ZXDDFR_IUT_23. How do I do this once in Power automate. My value after last underscore will always be date value.

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Gopala_Krishna 1,495 on at

Like (0)

Report
Copy link

Link copied!
@Anonymous

You can achieve this using below expression in power automate

substring(outputs('Compose'),0,lastIndexOf(outputs('Compose'),'_'))

Replace the outputs('Compose') to the action from where you are fetching the data.

For my example I have taken the sentence how_are_you and stored it in compose action.

----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

if the information shared helps you, please consider giving a thumbs up and mark solution as resolved

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

@Gopala_Krishna great!!! and what if we need the date part, i.e. the value after last "_"

Was this reply helpful? Yes No
Verified answer

Gopala_Krishna 1,495 on at

Like (0)

Report
Copy link

Link copied!
@Anonymous

You can use below expression for that

substring(outputs('Compose'),lastIndexOf(outputs('Compose'),'_'),length(outputs('Compose')))

----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

if the information shared helps you, please consider giving a thumbs up and mark solution as resolved

Was this reply helpful? Yes No