Answered

Convert long date format into ISO 8061

(0) Share

Report

Posted on by ValentinOff

Hello everyone,

I would like to convert a date in long format (for example: Wednesday, February 14, 2024) to ISO format in order to create an Outlook event; formatDateTime doesn't work for that. Do you have a solution to suggest, please?

Thanks a lot !

Categories:

General topics

I have the same question (0)

All responses (7)

Answers (1)

Vaish123 136 on at

Like (0)

Report
Copy link

Link copied!

Solved: URGENT - Converting date to ISO 8601 format - Power Platform Community (microsoft.com)
Please have look

Was this reply helpful? Yes No
ValentinOff 15 on at

Like (0)

Report
Copy link

Link copied!

Thank you for your reply but in this topic it's from a short date; here, I have to convert a long date format to a short date (ideally in ISO format). In addition, I'm in France so the date I have is : mercredi 14 février 2024.

Was this reply helpful? Yes No
CFernandes 8,482 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hey @ValentinOff If the Date is return in French, You will need to use a Translator https://learn.microsoft.com/en-us/ai-builder/flow-text-translation if the Date and then pass it to the formatDateTime(' Wednesday, February 14, 2024', 'dd-MM-yyyy')

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

P.S. take a look at my blog here and like & subscribe to my YouTube Channel thanks.

Was this reply helpful? Yes No
S-Venkadesh 1,214 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi @ValentinOff ,
Below are the steps to convert long date format into ISO 8061:

Obtain the Long-Format Date: Begin by retrieving the desired date in long format using the "Compose" action or any suitable method.

Convert to ISO Format: Utilize the "Convert time zone" action to convert the date to ISO format.

Format as ISO-Formatted Date: Apply the "FormatDateTime" function to ensure the date is correctly formatted in ISO format.

I hope this information is helpful. If it is, please consider giving a thumbs up.

Best regards,

Venkadesh Sundaramurthy

Was this reply helpful? Yes No
CFernandes 8,482 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@S-Venkadesh - Can you confirm if it works with French text? "mercredi 14 février 2024"

Was this reply helpful? Yes No
Verified answer

ValentinOff 15 on at

Like (2)

Report
Copy link

Link copied!

Hi,

Thank you all for your feedback.
I finally found an expression that allows me to do what I wanted:
formatDateTime(parseDateTime(varDate, 'fr-FR', 'dddd d MMMM yyyy')) where "varDate" is, for example, "mercredi 14 février 2024". That works perfectly.

Was this reply helpful? Yes No
CFernandes 8,482 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hey @ValentinOff - Thank you for Sharing the solution with the community...

Was this reply helpful? Yes No