[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

All responses (8)

Answers (1)

Sort by

Agnius Bartninkas Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

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.
GreguS 173 on at

Like
a
(0)

Report
Copy link

Link copied!

@Agnius

When i try to use this function, i have all time the same error : date and time to convert need to be "datetime"
Agnius Bartninkas Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

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.
GreguS 173 on at

Like
a
(0)

Report
Copy link

Link copied!

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
Agnius Bartninkas Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
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.
GreguS 173 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

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

thank for your help
Verified answer

Agnius Bartninkas Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
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.
GreguS 173 on at

Like
a
(1)

Report
Copy link

Link copied!

you are awesome