Problem to populate 6 fields on a webpage with data from 2 datatable (extract from excel file)

(0) Share

Report

Posted on by GreguS

173

Hello guys,

i lost hope for my project ... 😰

I need to populate 6 fields on a webpage (the data are extract from a excel file) before click on a button for save the informations for go to next line of my excel data .

My problem is PAD add systematically time to date extract from excel ( i don't understand why, it's stupid seriously...)

@Agnius help me for delete time, but now i have two different datatable from PAD and i don't find how to populate each line correctly from %exceldata% and %exceldata2%.

%Exceldata%

%Exceldata2% for only convert date without time ...

i have two answer :

1-it's not possible to delete time to data extract from excel directly in one Datatable (same another informations for my 6 fields) ? (ExcelData)

2-If it's not possible to delete time directly in the first datatable, how to populate my fields with two different Datatable ? As a reminder i need to populate 6 fields and click to button "save" before go to another line ..

i have try lot of solution, but i don't find how to populate my 6 fields correctly (symmetry date field from ExcelData2 and another informations from the same line to ExcelData).

if someone have a idea for help me

kind regards Grégory

Categories:

Power Automate Desktop

All responses (7)

Answers (1)

Sort by

Agnius Bartninkas Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

If you are processing one line at a time, you don't need to bulk-remove the time from the timestamps. Simply remove it from the current line as you process it inside the loop.

-------------------------------------------------------------------------

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!

Hello @Agnius , for you it's possible to delete timestamps directly when i populate the field ?

i need to create a new variable for this ? i doesn't have search for the moment, it's difficult to find informations / help for PAD on the web

i doesn't see how is possible, i need to use the function convert datetime to text ?
Agnius Bartninkas Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Yes, you should use a Convert date time to text action on the date in the current row within a loop. This will result in a separate variable for the specific date. And you can then use that variable to populate your text field with a date.

-------------------------------------------------------------------------
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 search since 4 hours on google without issue. (seriously)

I doesn't find how to target a speficic column ?

where you find the command line, i found NOTHING about PAD on the web compared to powershell ?

Greg
GreguS 173 on at

Like
a
(0)

Report
Copy link

Link copied!

I'm completely lost in the deep seriously lol

i stop search for today
Verified answer

Agnius Bartninkas Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

Remove the part that formats your entire date column. Then, in your For each loop that iterates through %ExcelData%, use Convert date time to text the way you already do on %ExcelData2%, but instead use %CurrentItem['Date']%. Store the converted date into %FormattedDateTime% and then use %FormattedDateTime% when writing the value in Populate text field in web page.

That's all you need.

-------------------------------------------------------------------------
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!

Hello it's good with ['Date'], i don't understood how to select a column, now i know.

i have try to use ['Date'] yesterday, but i think only with %exceldata%.

it's resolve, thank you @Agnius

i put a screen if people have same problem