Unanswered

Get the Dates Only

(0) Share

Report

Posted on by dr3n09

I'm creating a power automate workflow that will automatically get the list of people that has a vacation leaves in a week from a sharepoint calendar and it will send that list to me via email. I was able to get that output, but the date includes the time. I only want the time so I tried to fixed it using the initialize variable but I am getting an error. "InvalidTemplate. Unable to process template language expressions in action 'Initialize_variable' inputs at line '0' and column '0': 'The template language function 'formatDateTime' expects its first parameter to be of type string. The provided value is of type 'Null'."

I tried this expression

if( empty(item()?['EventDate']), null, formatDateTime(utcnow()[item()?['EventDate']], 'MMM-dd-yyyy') )

and the workflow run with no error, but the output only gives me the EndDate. The StartDate is blank or no dates on StartDate.

Any suggestions?

See my current workflow.

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (0)

anandm08 1,936 Super User 2024 Season 2 on at

Like (0)

Report
Copy link

Link copied!
hi @dr3n09 ,
try this
if(empty(item()?['EventDate']), null, formatDateTime(item()?['EventDate'], 'MMM-dd-yyyy'))

Was this reply helpful? Yes No
dr3n09 12 on at

Like (0)

Report
Copy link

Link copied!

Thank you @anandm08, I tried your suggestion. The workflow run without an error but the output only shows the Headers( Name, StartDate,EndDate and EventType) but no value.

Was this reply helpful? Yes No
anandm08 1,936 Super User 2024 Season 2 on at

Like (0)

Report
Copy link

Link copied!
if(empty(item()?['EventDate']), null, formatDateTime(item()?['EventDate'], 'MM-dd-yyyy'))
@dr3n09 try this

Was this reply helpful? Yes No
dr3n09 12 on at

Like (0)

Report
Copy link

Link copied!

Hi @anandm08 I tried the updated expression and it gives me the same result. Only headers but no values.

Was this reply helpful? Yes No