Delay until problem in my flow

[GreguS]

Hello,

i don't understand why i have a error with my flow and "Delay until"

i need to send a mail at hire date of user

I use get user profil v2 for populate a sharepoint item with all informations i need (i can't give the hire date automatic for the moment)

My flow

my sharepoint Item with a test account (test3).

In sharepoint i need to write the hire date manually for the moment and i have add a "approve" for give me the time to add the hire date in sharepoint before my flow continue.

i have a error systematically with the flow and le "Delay until" : Unable to process template language expressions in action 'Delay_until_-_Date_d'arrivée_Avocats_Lyon' inputs at line '0' and column '0': 'The string 'T16:30:00Z' was not recognized as a valid DateTime. There is an unknown word starting at index '0'.'.

i don't understand why i can' t put my sharepoint hire date without error, what is the good syntax for "Delay until".

if i check my variable DateTime, i have no value but my "date d'arrivée" is present in sharepoint, but manually adding by me before validate the approval.

need help please

[RobHardy]

Salut GreguS,

I notice that you assign the Date d'arrivée value from SharePoint to a String variable. Is the column type in SharePoint "Single line of text" or "Date and Time"?

If it's "Date and Time", you should be able to use this directly in the "Delay until" action, without assigning it to a variable first.

If it's "Single line of text", then you will either need to request your users to enter the date in yyyy-mm-dd format (e.g. 2023-10-09), or format the string in this way:

Rob.

[GreguS]

Hello @RobHardy 

yes i have change the value in my sharepoint column "Date and time" to date and time

 I need the date and the time for send my mail

same result if i use sharepoint "date time"

Unable to process template language expressions in action 'Delay_until_-_Date_d'arrivée_Avocats_Lyon' inputs at line '0' and column '0': 'The string 'T16:30:00Z' was not recognized as a valid DateTime. There is an unknown word starting at index '0'.'.

i don't understand what's happen 😞

[GreguS]

UP, j'ai trouvé où est mon problème avec un test.

J'ai essayé d'envoyer un mail avec la date/heure de mon sharepoint dans le corps du texte, et le résultat n'est rien !

The result :

The sharepoint list with Date/Time informations

If people have a idea for me, for reminder i put GivenName, SurName, email and DisplayName automaticly and i save the Hire date manually in sharepoint on the "User" ...

[RobHardy · Accepted solution]

Salut,

Je pense que la problème est que la valeur Date d’arrivée n’existe pas dans la version de l’item SharePoint orignalement créé.

Après  l’action “Start and wait for an approval” (et après quelqu’un a rempli cette date), il faut obtenir la version de l’item actuelle, avec un action “Get item”, et utiliser la Date d’arrivée de cette action.  

[GreguS]

hi @RobHardy ,

i hade the same answer, but i don't undertand how to do this, now i have my date in the good format

PERFECT and thank you very much