Formatting date only

[Anonymous]

Hi,

I have an expiry dat that returns as 2021-01-25T08:00:00Z and I want to compose an email stating what is the expiry date in this format: 25 Jan 2021. I tried using 

formatDateTime(triggerBody()?['Expiry Date'],'dd/MM/yyyy')

but it doesn't work. it gives me this error 

InvalidTemplate. Unable to process template language expressions in action 'Send_an_email_notification_(V3)' inputs at line '1' and column '14342': 'The template language function 'formatDateTime' expects its first parameter to be of type string. The provided value is of type 'Null'. Please see https://aka.ms/logicexpressions#formatdatetime for usage details.'.

Please help me. Thank you in advance

[DamoBird365]

Hi @Anonymous 

You need to check that triggerBody()?['Expiry Date'] is actually returning what you expect.

Try it in a compose first.  When you use a ? in an array expression it will return NULL if it cannot be evaluated.  Remove the ? and the expression will fail.  So I guess there is a typo in there somewhere.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Cheers,
Damien

P.S. take a look at my new blog here

[ViditGholam · Accepted solution]

Hi @Anonymous you can do it as shown below

Put your expire date in a string variable and use that variable in your date formatter

Output - 

Hope this helps !

Let me know in case any issues 

If this solves your problem please mark this post as answered and hit me a thumps up.

Thanks and Regards,

Vidit 

[Anonymous]

Hello @ViditGholam !

I am trying to convert to string but I face this issue (in pic). I am unable to put anything under the name portion. 

Able to advice me on how I should do this?

[ViditGholam · Accepted solution]

@Anonymous you will have to initialize a variable some where up in your flow and then set that variable for example look at this flow 

connectors - 

it is just like how we define variables in a code and then use or set them as and when needed.

[ViditGholam]

also try what @DamoBird365  said even I feel there is a typo in there try removing triggerBody()"?"['Expiry Date']

"?" from your previous expression.

[DamoBird365]

Hi @Anonymous 

I think you are over complicating.  Personally I would strip back the 2nd apply to each and if you are new to Power Automate create the following flow actions:

This would return the following:

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Cheers,
Damien

P.S. take a look at my new blog here

[Anonymous]

It works! Thank you @ViditGholam 😄

[Anonymous]

Hello @ViditGholam 

Can I check with you regarding another question?

As seen in the picture, the output is 1 and the condition I set is as follows

May I know why is the expression result false?

[ViditGholam]

@Anonymous try it out this way 

[Edinaa]

@ViditGholam its the same Edina here. 

I tried 

string('Due')

and the output is "Due".

The data in Due is Yes/No or 1/0. How can I write an expression that gets the data instead of the word "Due"?

[ViditGholam]

Hi, @Edinaa so if the data in that "Due" is Yes or no which means true/false just use this instead and check if it works

[Edinaa]

@ViditGholam I have tried this

But I got this

That was why I set the condition as equal to 1 yet it still did not work even if its 1.

[ViditGholam]

@Edinaa  go in the Dynamic contents -> Expression section -> type true and use that instead and check

[Edinaa]

@ViditGholam 

For the condition, I tried Due or WFIDue is equal to the expression true, condition is still false.

[ViditGholam]

@Edinaa make sure this Variable is initialized as a Boolean and not a string also I am checking on how to get the value instead 

[Edinaa]

When I initialize the variable as Boolean, this error comes up: 

[ViditGholam]

@Edinaa I see also try without using a variable 

Put Due directly in your condition 

[Edinaa]

@ViditGholam I have tried that as well and it comes out false as well 😞 

I'm not sure what's wrong

[ViditGholam]

give me some time I will check and let you know