Unanswered

Formatting date only

(0) Share

Report

Posted on by Community Power Pla...

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

Categories:

General topics

I have the same question (0)

All responses (23)

Answers (2)

DamoBird365 8,942 Microsoft Employee on at

Like (0)

Report

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

Was this reply helpful? Yes No
Verified answer

VIDIT 666 on at

Like (0)

Report

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

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

Like (0)

Report

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?

Was this reply helpful? Yes No
Verified answer

VIDIT 666 on at

Like (0)

Report

@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.

Was this reply helpful? Yes No
VIDIT 666 on at

Like (0)

Report

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

Was this reply helpful? Yes No
DamoBird365 8,942 Microsoft Employee on at

Like (0)

Report

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

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

Like (1)

Report

It works! Thank you @ViditGholam 😄

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

Like (0)

Report

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?

Was this reply helpful? Yes No
VIDIT 666 on at

Like (0)

Report

@Anonymous try it out this way

Was this reply helpful? Yes No
Edinaa 16 on at

Like (0)

Report
@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"?

Was this reply helpful? Yes No