Power Platform Community Forum Thread Details

In Power Automate, I have an expression to trim the email and extract the date value, outputting it in MM/DD/YYYY format, and then create a date item in the SharePoint List.

How do I convert this output to MM/DD/YYYY to DD/MM/YYYY?

Example below: if I have an input date of 11/02/2025, it is read as Nov 02 2025. When it creates the item in SharePoint List, it should be read as 11 Feb 2025.

If the input is like 31/01/2025, i will get this error message.

Action 'Create_item' failed: The 'inputs.parameters' of workflow operation 'Create_item' of type 'OpenApiConnection' is not valid. Error details: Input parameter 'item/StartDateofLeave' is required to be of type 'String/date'. The runtime value '"31/01/2025"' to be converted doesn't have the expected format 'String/date'.

Thanks.

Categories:

Using flows

Hi,

Step 1: Convert string to a proper date object

Use formatDateTime() with parseDateTime() if needed.

If your input is a string in MM/DD/YYYY:

This will:

Parse using en-US to correctly interpret MM/DD/YYYY

Output as dd/MM/yyyy (e.g., 11 Feb 2025 → 11/02/2025)

Step 2: Store as a proper date in SharePoint

When inserting into a Date column in SharePoint, do not send a formatted string. Instead, use ISO format (i.e., yyyy-MM-dd), which SharePoint expects for date fields.

Use this expression to convert the original MM/DD/YYYY string into ISO format:

This way, SharePoint stores the correct date (e.g., 2025-02-11), and will display it in the user’s regional format, such as 11/02/2025 for UK or Feb 11, 2025 for US.