Answered

Left function with varying lengths

Like (0) Share

Report

Posted on 30 Nov 2022 03:24:41 by Community Power Pla...

I'm trying to replicate the effect of this formula from excel "LEFT(B5,FIND("-",B5)-1)" in Power Automate, where instead of cell B5 I'm referencing the Subject line of an email.

My trigger is every time an email is received from specific senders, I want to salvage only the left hand portion of the subject line, after a specific character, but with the left hand side being varying lengths. For example:

C-Suite _ Monthly Sales report	C-Suite
Northwest Ops _ Volume Report	Northwest Ops

I've tried this, but the expression is invalid

left(triggerBody()?['subject'],find("-",triggerBody()?['subject'])-1)

Any help would be greatly appreciated.

Categories:

Business Process Flows

All responses (2)

Answers (2)

Verified answer

v-bofeng-msft on 30 Nov 2022 at 05:31:32

Like (0)

Report
Re: Left function with varying lengths

Hi @Anonymous ,

The point is that '-' is not a valid operator in flow , please use 'sub' instead.

left(triggerBody()?['subject'],sub(find("-",triggerBody()?['subject']),1))

Best Regards,

Bof
Verified answer

Ajinder31 530 on 30 Nov 2022 at 04:49:28

Like (1)

Report
Re: Left function with varying lengths

Hi @Anonymous , If requirement is to get text before first underscore _ I think below expression will work fine.
split(triggerOutputs()?['body/subject'], '_')[0]

--------------------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.