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,
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.
Please show your flow.
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,
Thanks in advance.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Announcing a new way to share your feedback with the Power Automate Team.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Join Priya Kodukula and the licensing team, super users and MVPs to find answers to your questions on Power Automate licensing.