cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Marie-emma
New Member

Filter

Voici mon erreur : " The execution of Template action 'Filtrer_un_tableau' failed: The evaluation of 'query' action 'where' expression '@and(greaterOrEquals(formatDateTime(item()?['Date'], 'dd/MM/ yyyy'), formatDateTime(addDays(utcNow(), -7), 'dd/MM/yyyy')))' a échoué : 'La fonction de langage de modèle 'formatDateTime' attend que son premier paramètre soit de type chaîne. La valeur fournie est de type 'Null'. Veuillez consulter https://aka.ms/logicexpressions#formatdatetime pour les détails d'utilisation.'." 

 

j'ai juste essayé d'envoyer un mail automatique lorsqu'une liste a été modifiée et j'ai utilisé un filtre juste pour avoir 3 informations sur mon email. 

J'ai vérifié le format de la date. 

 

Est-ce que quelqu'un a déjà eu ce problème ? 

1 ACCEPTED SOLUTION

Accepted Solutions
Hardesh15
Super User
Super User

@Marie-emma  Pls try to post your query/issue in English so that other person can also see and help you.

One of the Date value is null that is why you are getting such error. Use condition to filter out blank dates value.

Please 'Thumbs Up' the posts that helped you and 'Accept as Solution' if my post answered your question.

@Hardesh /Gopenly.in

View solution in original post

2 REPLIES 2
Hardesh15
Super User
Super User

@Marie-emma  Pls try to post your query/issue in English so that other person can also see and help you.

One of the Date value is null that is why you are getting such error. Use condition to filter out blank dates value.

Please 'Thumbs Up' the posts that helped you and 'Accept as Solution' if my post answered your question.

@Hardesh /Gopenly.in

thank's to your answer ! I will try and see if it works ! 

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (6,112)