Showing results for 
Search instead for 
Did you mean: 
Helper I
Helper I

Need help with writing the flow expressions in Power automation.

Hi All,


Need help with writing the flow expressions for the below-mentioned requirement.


For the received Mail subjects,

FW: RING HEAL CRQ000001144185 - C10/287014 - TDD27564 - 15/07/22 19:00GMT - 16/07/22 05:00 GMT for the DCS Site closure Project.
RE: CRQ000001144186, TDD 27564, TDD 27565, TDD 27566, C10-287015, C10-287016 - 21/7/22 20:00-22:59 GMT CDP Site closure Project.

Expecting an Excel Autoupdate Output like the Below mentioned Sample,




Supporting Notes:-
CRQ Ref no always will be in 15 Length characters,
TDD Ref No -  5 Length No's,

C10 Ref - 6 Lenght No's
Outage week No - Start date's Week of the Month
Project manager name - Mail Sender Name,
Project name - Site Closure Project (along with Site Names like CDP, and DCS)

Thought to get flow Expression to get CRQ REF alone, then to follow the same to columns, if there any other simple way to write the expression also please share.

Thanks in advance.

Advocate II
Advocate II

Hi @RameshKumarE 


This video might help you

Community Champion
Community Champion

Please show your flow.

Contact me if you are interested in custom Power Automate development.

Sure will have a look. Thanks for sharing with me

Yes, I'm looking for some solution, the challenges now I'm facing are ( / )'s, ( - )'s after the C10s and commas after the C10-reference no, space/nospace scenarios after TDDs, and commas to be avoided, Picking the first Date as starting date and if next date provided that need to be considered as End Date, and if no second date provided same first date to be considered as the second date, time also need to be copied Excel cells from email subject.

Sometimes my email will have only C10 ref or TDD ref, but sure it will have CRQ ref

My Current flow follows now,





concat('CRQ',trim(split(split(triggerBody()?['subject'],'CRQ')[1],' ')[0]))

Thanks in advance.

Helpful resources

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

MPA Licensing.jpg

Ask your licensing questions at the Power Automate AMA!

Join Priya Kodukula and the licensing team, super users and MVPs to find answers to your questions on Power Automate licensing.

Users online (3,690)