Answered

Import Date from excel into date field with calendar

(0) Share

Report

Posted on by Dazza_Aus

Hi,

I have a web field that uses a calendar to select the future date. as part of the activity creation I need to set the date.

I have been able to add to the field with the formatted ate, but it doesn't save the new date.

As I am still learning I would appreciate some help.

Categories:

Power Automate Desktop

I have the same question (0)

All responses (9)

Answers (1)

Sort by

VJR 7,635 on at

Like
a
(0)

Report
Copy link

Link copied!

@Dazza_Aus , can you share what have you done so far in the flow to write the date to the calendar.

Was this reply helpful? Yes No
Dazza_Aus 30 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @VJR ,

Attached is some screen shots.
does this help?

Was this reply helpful? Yes No
VJR 7,635 on at

Like
a
(0)

Report
Copy link

Link copied!

In the action on row no 16, tick "emulated typing" option and check what happens.

Was this reply helpful? Yes No
Dazza_Aus 30 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,
I tried this but no difference. I didn't change from todays date after saving.

Was this reply helpful? Yes No
VJR 7,635 on at

Like
a
(0)

Report
Copy link

Link copied!

After emulated typing you need to also try doing a SendKeys on TAB or Enter key.

Was this reply helpful? Yes No
Dazza_Aus 30 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

Thanks for the suggestion.
This field is not actually a "data entry" window and it relies on the calendar selector.
Th send keys did stop it reverting. I can't actually type in this field.

Was this reply helpful? Yes No
VJR 7,635 on at

Like
a
(0)

Report
Copy link

Link copied!

Using the id of the textbox directly try to write its value using run javascript on webpage. The id is visible in the screenshot of your first post. Also I have added some javascript on webpage examples on this forum. You can take a look.

Was this reply helpful? Yes No
Verified answer

Dazza_Aus 30 on at

Like
a
(0)

Report
Copy link

Link copied!

OK. problem solved. When looking to fix this with the Java script After hunting and trying a couple of time I saw that there was a space between the comma and year. once I had adjusted the SS, it changed the date. YeeHa

Was this reply helpful? Yes No
jon2249 15 on at

Like
a
(0)

Report
Copy link

Link copied!

I am having similar issues -- The date field is not a typeable field. What function did you use to solve the issue? Did you remain using the populate text field on webpage to solve this issue?

Was this reply helpful? Yes No