Answered

Date selector from Calendar on https://data.ecb.europa.eu/currency-converter

(0) Share

Report

Posted on by Defacto87

Hi Everyone,

I'm trying to figure out how I can select a particular date, in the date selector on the European Central Bank website: https://data.ecb.europa.eu/currency-converter

(I know that the data can be extracted using other means, but for reasons I wont get into, let just say that my process needs to include the selection of a date, on that webpage). I tried using different methods found in other posts (such as this one: https://powerusers.microsoft.com/t5/Power-Automate-Desktop/Selecting-Date-from-Calendar/td-p/2287711), but this wont work. Plus none of the methods used in this video will work: https://www.youtube.com/watch?v=unByToIU9ss&t=44s

Anyone has an idea? Given this is a fairly wide used website, I was hoping some of you might have found a solution.

Thanks in advance.

Categories:

Power Automate Desktop

I have the same question (0)

All responses (3)

Answers (2)

Sort by

Verified answer

cwischnewski 162 on at

Like
a
(0)

Report
Copy link

Link copied!

You should be able to capture that UI element. I did a little Chrome inspecting and found that the CSS Selector should be "div[class="bx--date-picker-input__wrapper"] > input[type="text"]" if you need to hard edit it. Then you should be able to use the Browser automation / Web data extraction / Get details of element on a web page action.

Was this reply helpful? Yes No
Defacto87 8 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you for the reply! You are absolutely correct that what you suggested will allow me to click on the element, and return the attribute value (in this case today's date). The greater challenge in this case (I think) is to change/select to the appropriate/different date. Generally, other website will allow you to manually input a specific date as an alternative to the date calendar selector, so you would simply click on the element (as you correctly pointed out) then send the input for a date. Here, the user is required to select the date on the calendar. Not sure how I can get there consistently using UI element only. If you or someone else have any thoughts on how this can be achieved that would be great.

Was this reply helpful? Yes No
Verified answer

Agnius Bartninkas Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Once you have opened the date picker, you should be able to send a click by using the value, as the value is the actual day value. So, if you modify the selector, it should work in theory.

The tricky thing is selecting a date in a different month. You'd need to build a functionality that extracts the current month, converts it to a date, and calculates how many times you need to move back to actually navigate to the month you want. Then click the back arrow that many times. The rest should be okay.

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