web

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

News and Announcements icon

Power Platform CommunityForums Power Automate Getting Characters bef...

Power Automate

Answered

Getting Characters before some characters

(0) Share

Report

Report

Posted on by Geeks_D

1,169

Hello Folks,
I need help with some compose functions in my flow

I want to get the characters before 2 characters in my string

The characters are either _ or Space

E.g if the String is ABC_ 123_2343 : Extract ABC and if the String is ABC 123_23426 - extract ABC from this string

Thanks for every help and suggestions

Categories:

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (2)

Verified answer

v-jefferni Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @Geeks_D ,

Try below expression:

if(empty(split(YourString,'_')[0]),split(YourString,' ')[0],split(YourString,'_')[0])

Best regards,

Was this reply helpful? Yes No
Geeks_D 1,169 on at

Like (0)

Report
Copy link

Link copied!

Hi @v-jefferni
Thanks for that,
The code extract _ for strings starting with _ but extract all the string for Character that start with space
E.g - ACB_123 works fine
ABC 1233 will extract everything
Once again thanks for your help

Was this reply helpful? Yes No
Verified answer

v-jefferni Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Geeks_D ,

I was thinking there could be _and space together within the string. If it would be either _ or space within the string, try below expression:

split(replace(YourString,' ','_'),'_')[0]

Best regards,

Was this reply helpful? Yes No

Join the conversation