Answered

Passing date and time to date input type of a child flow

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi,

Hi have an input field of Date type in a child workflow called Email Date.

I am trying to pass the date and time value from the parent workflow into it.

In my parent workflow I have a trigger: 'When a new email arrives in a shared mailbox (V2)'
In the 'Run a child flow' action I have the following expression for the Email Date input:

formatDateTime(triggerBody()?['receivedDateTime'],'yyyy-MM-dd-THH:mm:ssZ')
as I am trying to send over the 'receivedatetime' value from the trigger.

However I receive this error:

The input body for trigger 'manual' of type 'Request' did not match its schema definition. Error details: 'String '2023-08-30-T16:39:18Z' does not validate against format 'date'.'.

I notice that the received date time value' from the trigger is in the format:
receivedDateTime": "2023-08-30T16:39:18+00:00"

If I use expression:

formatDateTime(triggerBody()?['receivedDateTime'],'yyyy-MM-dd')
it works fine.

I'm wondering if the date type input in the child workflow only accepts yyyy-MM-dd and not time, as it shows YYYY-MM-DD in the trigger for it?

Is time allowed in the Email (date type ) input above?

Can some confirm /help with this?

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

JonDoesFlow 1,304 on at

Like (0)

Report
Copy link

Link copied!

Does it need to be a date format in the child flow trigger ?

Could you have Email date as a string, and then format that string as date time in a compose step after the trigger, and then use that date wherever you need it ?

---------------------------------------------------------------------------

If I have helped you with an answer, please accept this post as a solution and thumbs up my reply. Thanks !

Blog - JonDoesFlow
Twitter - JonDoesFlow
YouTube - JonDoesFlow

Was this reply helpful? Yes No
Chriddle 8,672 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Yes, the date input in this trigger only accepts strings in the format "yyyy-MM-dd".

If you need a date/time, just use the text type input.

In PA, a date or datetime is just strings that conform to the appropriate format.

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

Like (1)

Report
Copy link

Link copied!

Just to let you know what I finally did was, take Jondoesflow advice and pass it over as a string to the child workflow.

I then created a string variable and used format date time expression:
formatDateTime(triggerBody()?['text_3'],'dd/MM/yyyy HH:mm') to get the string into this format:
[text3] being whatever your string input is for the input in the child flow trigger. Use peak code to see what it is for the input)
2023-08-31 12:15

Once you have it in the above format, follow the solution in this link /topic below to convert to date time in the same format. I had to do this as I wanted to update a date and time Dataverse field

https://powerusers.microsoft.com/t5/General-Power-Automate/How-to-convert-string-dd-mm-yyyy-hh-mm-to-datetime-with-format/td-p/827289

Was this reply helpful? Yes No