Answered

Regular Expression Match

(0) Share

Report

Posted on by Jevita

i'm creating a flow that takes the photo attachments from a email and puts it into a netwrok share. i have the subject of the email naned "#foldername" i need to remove the '#" from the subject. other than using the Regular Expression Match action is there anothe way?

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

RezaDorrani 12,145 on at

Like (0)

Report
Copy link

Link copied!

Hi @Jevita

Since the format is always #foldername in the subject name
Removing # means removing item at index 0

The following expression will do the trick

substring(subject,1,sub(length(subject),1))
where subject - dynamic content value holding the subject

Regards,
Reza Dorrani

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

Was this reply helpful? Yes No
v-alzhan-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Jevita ,

You could use the Workflow definition language as @Jevita mentioned to achieve your needs
And you could refer to link below to learn more about the workflow definition language:
https://docs.microsoft.com/en-us/azure/logic-apps/workflow-definition-language-functions-reference

Please let me know if your problem could be solved.

Best regards,
Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
maxpower45255 223 on at

Like (2)

Report
Copy link

Link copied!

I can't believe that it's 2023 and Power Automate doesn't have a regular expression action out of the box yet.
This feature is desperately needed and resorting to azure functions as a solution is too cumbersome. There are some premium connectors that can do it, but they're slow in many cases and aren't free either.
Come on Microsoft! we need this!

Was this reply helpful? Yes No