convert date time to string

(1) Share

Report

Posted on by PeggyLang

381

I need to convert a date time format in excel to a string so that I can pass this through to Smartsheet

However, I can't make out the syntax in this AI description

Categories:

Building flows

I have the same question (0)

All responses (10)

Answers (1)

Michael E. Gernaey 53,392 Super User 2025 Season 2 on at

Like (0)

Report

Hi @PeggyLang

Are you getting errors?

Have you made sure that the actions it creates are using ISO 8601 formats for any excel reading actions? (meaning that its turn on in the action when reading data from excel)

You said you cannot get a string, but we need to see the actual agent, the action its trying to do, the input/output and preferably including errors etc.

Was this reply helpful? Yes No
PeggyLang 381 on at

Like (0)

Report

@Michael E. Gernaey

I need help writing that piece of my flow. Below is as far as I was able to get.

Was this reply helpful? Yes No
Ellis Karim 11,691 Super User 2025 Season 2 on at

Like (0)

Report

Hi PeggyLang,

@Michael E. Gernaey is referring to the following setting for the DateTime Format in the List rows present in a table action:

Ellis Karim
Blog | LinkedIn | Bluesky
If this solved your issue, please mark it as ✅ Accepted Answer. If it helped, feel free to give it a 🩷 Like!

Was this reply helpful? Yes No
Yasemin 59 on at

Like (0)

Report

Hi, try using 'yyyy-MM-ddTHH:mm:sszzz' as the format for Smartsheet requires ISO 8601 (Smartsheet documentation: Dates and times ) I assume this requires the target columns data type to be formatted to a date as well, maybe you can check that.

If you're trying to create a new row in Smartsheet for each row in the Excel file, add an action for creating a new row in Smartsheet inside the foreach loop, that iterates through the Excel column.

Use formatDateTime with the correct format that is required by Smartsheet either in the Compose action or use the formatDateTime() function directly in the Smartsheet new row action and the corresponding columns parameter field inside the apply to each loop.

If you're trying to convert something to a string, you can use the function string()

Was this reply helpful? Yes No
PeggyLang 381 on at

Like (0)

Report

Hello Ellis,

I have created a manual test and the flow runs successfully.

Screenshot below of the flow with your guidance.

After I have run this flow I then invoke the Data Shuttle to write all the rows from the excel to my Smartsheet Worksheet.

I'm still only getting the date portion of the column.

Screenshot below is the excel file on Sharepoint site.

Screenshot below is the cell in my Smartsheet worksheet that is only receiving the date portion.

I really need the cell highlighted in Smartsheet worksheet to read;

2025-06-17 05:21:03

I'm not sure what I'm missing here.

Was this reply helpful? Yes No
Ellis Karim 11,691 Super User 2025 Season 2 on at

Like (0)

Report

Hi PeggyLang

I found this:

"Smartsheet currently doesn't allow timestamps except in the system Modified and Created columns. The only way to display the timestamp, as you have found, is as a text column. "

Read more here: How to put a date and time together in a column? — Smartsheet Community

Ellis Karim
Blog | LinkedIn | Bluesky
If this solved your issue, please mark it as ✅ Accepted Answer. If it helped, feel free to give it a 🩷 Like!

Was this reply helpful? Yes No
PeggyLang 381 on at

Like (0)

Report

Correct, but I'm trying to pass a 'text string' from excel to a column in my Smartsheet worksheet.
I'm tring to convert the column in excel that contains the full date/time format to a text string, then write that to Smartsheet via Data Mesh. Text to text. That should work. But i'm having trouble converting the date/time format in excel through power automate to a text string.

Was this reply helpful? Yes No
Verified answer

PeggyLang 381 on at

Like (2)

Report

While walking in the garden, the solution became so clear I can't believe I didn't see it earlier.
I have added a script;

- insert column next to column containing Date /Time

- New column contains =TEXT formula to convert the Date /Time to a text string

Runs perfectly now.

Was this reply helpful? Yes No
Ellis Karim 11,691 Super User 2025 Season 2 on at

Like (0)

Report

Hi

When you use "List Rows present in a table" with the ISO 8601 setting, the date columns are read as text.

Here is an extract of the runtime output of a "List Rows present in a table". Note the "Note Created Time" and "Note Created Date" are read as text:

So, you should be able to send the date time like "2025-06-17 05:21:03" from Excel as is to a Text/Plain Text column in Smartsheet.

What is the error message, or output you see in Smartsheet?

Ellis Karim
Blog | LinkedIn | Bluesky
If this solved your issue, please mark it as ✅ Accepted Answer. If it helped, feel free to give it a 🩷 Like!

Was this reply helpful? Yes No
PeggyLang 381 on at

Like (0)

Report

@Ellis Karim
That is curious 'the date columns are read as text'. But when the data shuttle took the excel data and wrote it to my Smartsheet worksheet ONLY the date portion was written.

AFTER adding the script to insert new column and use the =TEXT formula the output to my smartsheet via Data Shuttle was then the entire Date/Time format.

Curious as well, what are screenshots from that you included in your response below? It appears to be my data somehow.

Was this reply helpful? Yes No