[PAD] convert datetime to another format

(0) Share

Report

Posted on by GreguS

173

Hello guys,

i have another problem with my PAD.

i read all data from a excel file for populate lot of fields in a webpage.

my problem is when PAD read the date value from the excel, he add time to the date ...

CapturePAD01 (1).jpg

from 07/07/2023 to 07/07/2023 00:00:00

How i can keep the format dd/mm/yyyy in PAD ?

It's not possible to add a command to convert the format when i populate my field date in my website ?

When i try to create another %exceldata% variable with only date column for convert the format, i have a error and i don't understand how to add in my field the date from exceldata2

Categories:

Power Automate Desktop

I have the same question (0)

All responses (8)

Answers (1)

Agnius Bartninkas Most Valuable Professional on at

Like (0)

Report

Use the Convert date time to text action and provide the custom format there as dd/MM/yyyy.
-------------------------------------------------------------------------
If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.

I also provide paid consultancy and development services using Power Automate. If you're interested, DM me and we can discuss it.

Was this reply helpful? Yes No
GreguS 173 on at

Like (0)

Report

@Agnius

When i try to use this function, i have all time the same error : date and time to convert need to be "datetime"

Was this reply helpful? Yes No
Agnius Bartninkas Most Valuable Professional on at

Like (0)

Report

You are passing in an entire list of dates. You need to convert them one by one. Do a loop on the list and then convert each value separately.
-------------------------------------------------------------------------
If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.

I also provide paid consultancy and development services using Power Automate. If you're interested, DM me and we can discuss it.

Was this reply helpful? Yes No
GreguS 173 on at

Like (0)

Report

I don’t really understand how to do.

i need to use a second variable excel for isolate this column with date ?

maybe you have a link for undestand

Was this reply helpful? Yes No
Agnius Bartninkas Most Valuable Professional on at

Like (0)

Report
If you want everything in your list converted, you need to loop through the list and convert each value separately like this:
Here's a piece of code that you can copy and paste directly to PAD to have this loop created for you:
LOOP LoopIndex FROM 0 TO ExcelData2.Count - 1 STEP 1 Text.ConvertDateTimeToText.FromCustomDateTime DateTime: ExcelData2[LoopIndex] CustomFormat: $'''dd/MM/yyyy''' Result=> FormattedDateTime SET ExcelData2[LoopIndex] TO FormattedDateTime END
-------------------------------------------------------------------------
If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.
I also provide paid consultancy and development services using Power Automate. If you're interested, DM me and we can discuss it.

Was this reply helpful? Yes No
GreguS 173 on at

Like (0)

Report

Hi,

i have a error : %Exceldata2% doesn't have a count property

thank for your help

Was this reply helpful? Yes No
Verified answer

Agnius Bartninkas Most Valuable Professional on at

Like (0)

Report
Seems like you have a data table there and not really a list. My mistake. Use .RowsCount instead and provide a column index in the Convert actions:
Here's a snippet:
LOOP LoopIndex FROM 0 TO ExcelData2.RowsCount - 1 STEP 1 Text.ConvertDateTimeToText.FromCustomDateTime DateTime: ExcelData2[LoopIndex][0] CustomFormat: $'''dd/MM/yyyy''' Result=> FormattedDateTime SET ExcelData2[LoopIndex][0] TO FormattedDateTime END
-------------------------------------------------------------------------
If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.
I also provide paid consultancy and development services using Power Automate. If you're interested, DM me and we can discuss it.

Was this reply helpful? Yes No
GreguS 173 on at

Like (1)

Report

you are awesome

Was this reply helpful? Yes No