Answered

Amend format of received time dynamic content

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I'm using power automate to sort incoming emails into a SharePoint file. The created SharePoint file name is "'received time' 'subject'.eml" but the default layout for received time is 'YYYY-MM-DD T h_m_s + 00_00'. I would ideally like this to read 'DD-MM-YYYY T h_m' but I cannot find a way to do this. Any suggestions?

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (1)

v-yetonggu-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Anonymous ,
Do you want to The 'received time' format convert to ''DD-MM-YYYY T h_m'?
If so, I have a test for your reference.
In my scenario:
concat(concat( split(split(outputs('Received_Time'),'-')[2],'T')[0], '-',split(outputs('Received_Time'),'-')[1], '-',split(outputs('Received_Time'),'-')[0] ), ' T ', concat( substring(split(outputs('Received_Time'),'T')[1],0,2), '_', substring(split(outputs('Received_Time'),'T')[1],3,2) ) )

Best Regards,
Sunshine Gu

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @v-yetonggu-msft
Thanks for your reply.
I've tried using your solution but it has flagged the following error:
This is my complete flow, with your solution copied and pasted in, in case the issue is with the way I've formatted it:
(there is a SharePoint address that I have removed for the screenshot).
Can you see anything that is wrong?

Thanks,
George

Was this reply helpful? Yes No
Verified answer

v-yetonggu-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Anonymous ，
Reference the compose control name in your scene.
concat(concat( split(split(outputs('compose'),'-')[2],'T')[0], '-',split(outputs('compose'),'-')[1], '-',split(outputs('compose'),'-')[0] ), ' T ', concat( substring(split(outputs('compose'),'T')[1],0,2), '_', substring(split(outputs('compose'),'T')[1],3,2) ) )
Best Regards,
Sunshine Gu

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Yes that has worked. Thanks @v-yetonggu-msft

Was this reply helpful? Yes No