Announcements
HelloI have a requirement that when a new email arrives, I have to extract some things from it such as "From", "Email Date and Time" and Subject line".Also, I have to add a Subject filter.
Can anyone help me with this?
Thank you.
Try watching this YouTube video, maybe it could help: https://www.youtube.com/watch?v=JKGB3Ymf8MEBuyMyStuff - Generate Promo Codes (youtube.com)
Hi @jay_mangukia ,
The logic seems easy. Please refer to the flow I create:
Best regards,
I don't this time and date format. Can we change it to classic DD-MM-YYYY hh:mm AM/PM format?
They are in UTC format, you can change the display format in Excel column settings.
I tried, but its not working.
Which format did you try?
BR,
custom format -> dd/mm/yyyy hh:mm AM/PM
OK, then in your flow, change the input in the Add a row action use expression and dynamic content:
formatDateTime(triggerOutputs()?['body/receivedDateTime'],'dd/MM/yyyy hh:mm tt','en-US')
The time and Date format changed but it is UTC. How can I convert it to IST?
Add a convert time zone action, set it as below and use its outcome to populate the excel column:
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Mohsin Ali 414
11manish 335 Super User 2026 Season 2
M Bilal Khan 274
