Dates

(0) Share

Report

Posted on by garthh

138

The subflow DirecrDebitReportDate below calculates the date I need to the variable FormattedDateTime2.

The Action Populate Tex tfield in window populates the Report parameters date field

However the date is not FormatteddateTime2

Where have I gone wrong?

Categories:

Power Automate Desktop

All responses (9)

Answers (0)

Sort by

momlo 1,527 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @garthh
Could it be that your desktop application takes whatever format you give it and transform it as it wish?
I would suggest trying to copy date in the format you want it to be than past from clipboard to the field and see how app handles it
ryule 929 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

I agree with momlo, I bet the application is expecting it to be inputted a specific way and it doesn't like the way the "Populate" action is doing it. You may play with a variety of different options....click and send keys, copy/paste, emulate typing option enabled/disabled, etc....
garthh 138 on at

Like
a
(0)

Report
Copy link

Link copied!

momlo, thank you
The field won't accept a copy and pasted date.
I presume the date has to be typed in so need to see how to do that
garthh 138 on at

Like
a
(0)

Report
Copy link

Link copied!

ryule, thank you
momlo's idea was good
The field won't accept a copy and pasted date.
I presume the date has to be typed in so need to see how to do that
garthh 138 on at

Like
a
(0)

Report
Copy link

Link copied!

ryule, thank you
momlo's idea was good
The field won't accept a copy and pasted date.
I presume the date has to be typed in so need to see how to do that
AS-06081019-0 1,738 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@garthh Use split action to get dd, MM, YYYY to get it into variables. Once you have it, use sendkeys action to pass the variables in respective fields.
Or use sendkeys tab then use populate to pass respective variables in respective fields.

Hope it helps!!

Cheers,
Ankesh
--------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.
garthh 138 on at

Like
a
(0)

Report
Copy link

Link copied!

Ankesh, thank you
I'll try, but you may get more questions!
garthh 138 on at

Like
a
(1)

Report
Copy link

Link copied!

Ankesh
This works!

Thank you
AS-06081019-0 1,738 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@garthh Glad it helped.

Cheers,
Ankesh
--------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.