web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate convert date only to d...

Power Automate

Unanswered

convert date only to date with timestamp.

(0) Share

Report

Report

Posted on by Community Power Pla...

I have date only column in dataverse.

I would like to convert date only to date with timestamp.

This is because to use create event(V4).

I have checked following document but cannot find how to covert.

Reference guide for functions in expressions - Azure Logic Apps | Microsoft Docs

Any help would be appreciated!

Categories:

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Verified answer

Expiscornovus 33,189 Most Valuable Professional on at

Like (0)

Report
Hi @Anonymous,

Do you have any requirement for a specific time? You could just hard-code a time value with a formatdatetime function in an expression.

Below is an example which takes a startdate variable date and adds 12:00 timestamp to it.

You can replace that variable by your dataverse date column.

formatDateTime(variables('StartDate'), 'yyyy-MM-ddT12:00:00.0000000Z')

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

Like (0)

Report

@Expiscornovus

Worked !! Thank you so much!!

Was this reply helpful? Yes No

Join the conversation