Need to convert text to date and time format

(0) Share

Report

Posted on by Jawaharprem

272

Hi All,

in dataverse table column named "Creation_on" is Single line of text in that in date and time in text format "28/05/2025 18:05:18" i need to convert to date and time format in other column named "Created on date" i used this flow but iam getting error pls help on same.

thanks

jawahar

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Suggested answer

WarrenBelz 155,283 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @Jawaharprem,

Here is an example using a manual trigger and your text string. The output is UTC, which can be used to directly update your data source in date/time format. - You need
parseDateTime(YourSourceTextHere,'en-GB')

Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.
MVP (Business Applications) Visit my blog Practical Power Apps LinkedIn

Was this reply helpful? Yes No
Jawaharprem 272 on at

Like (0)

Report
Copy link

Link copied!

Hi Sir,

Thanks for your time, but my query is i need to update the correct date and time in "Created_on_date" column in dataverse,

Was this reply helpful? Yes No
WarrenBelz 155,283 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @Jawaharprem,

That is what I thought I provided - you can input your Text string into the Flow and the output of the Compose action at the bottom can be directly patched to your Dataverse Table Date/Time field in the next action. If you are going "the other way" converting date/time to a Text string, you need
formatDateTime(YourDateTimeFieldHere,'dd/MM/yyyy HH:mm:ss')

Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.
MVP (Business Applications) Visit my blog Practical Power Apps LinkedIn

Was this reply helpful? Yes No