Unanswered

Dynamic Date Picker

(0) Share

Report

Posted on by lkhall_37203

Somewhat new to PAD and trying to figure out how to dynamically set start and end dates I don't see anyway to update the actual date boxes. When I inspect the underlying elements it shows that the input value is "disabled". In short I need to be able to dynamically set the start date to the Sunday 2 weeks ago and the end date to Saturday. I thought about getting the current date/time using an add to datetime action to set the start dates and end dates. Then parse out the year , month , date separately then pass those to the UI picker but haven't found a way to do that. Any help would be greatly appreciated.

Categories:

Power Automate Desktop

I have the same question (0)

All responses (9)

Answers (0)

Sort by

lkhall_37203 72 on at

Like
a
(0)

Report
Copy link

Link copied!

update to this I was able to get the month and year working by doing what I suggested earlier. Parsing out the year and month from my date calculation then passing each to a select drop-down list value and that part is working fine but now stuck at the date selection part as they all appear to be individual cell data values and not sure how to parse the entire table

Was this reply helpful? Yes No
MichaelAnnis 5,727 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Are you able to type into these boxes?

That would be easiest, using "Populate Text Field"

Was this reply helpful? Yes No
lkhall_37203 72 on at

Like
a
(0)

Report
Copy link

Link copied!

I wish it was that easy but those boxes are not editable and from the second image in my original post it shows the boxes are disabled

Was this reply helpful? Yes No
MelvinOrellana on at

Like
a
(1)

Report
Copy link

Link copied!

I don't know if this is the case, but in some web based systems you can filter the views via URL, because the dates are sent to the server via a GET request after you select them. Sometimes even download links are dynamic and you can download a file just by creating a link with the right parameters. I have done this in a similar case in one of my flows, the flow just logs in and then downloads the report that I want without ever using the web UI.

Was this reply helpful? Yes No
lkhall_37203 72 on at

Like
a
(0)

Report
Copy link

Link copied!

its not a report that I am trying to download I have to filter the UI for specific claims that generate a list of claims that fall in a predefined filter. Once I get the date filter figured out I then have to loop through each row in the data table and check for certain combination of values.

Was this reply helpful? Yes No
lkhall_37203 72 on at

Like
a
(0)

Report
Copy link

Link copied!

the back end system of this doesn't have any API's nor do I have access to the underlying database so my only option for manipulation is straight from the UI.

Was this reply helpful? Yes No
MelvinOrellana on at

Like
a
(0)

Report
Copy link

Link copied!

When you click the 'apply' button what does the system do? Does it send a request to the server or is it all preloaded in the client side?
What I am suggesting is that you emulate what the button does instead of having the flow to interact with the UI.
For example, there is an action to execute javascript code in the web page, I use that in one flow to grab cookie values but I belive it can be used to change the value of the boxes directly. I didn't even had to write the function myself, I found it in stackoverflow, you can do some research o use chatgpt o something similar to help you write the function you need.

Was this reply helpful? Yes No
lkhall_37203 72 on at

Like
a
(1)

Report
Copy link

Link copied!

well you might be onto something I didn't even look at the URL and it shows the date filter in the URL once I hit the apply button so I guess now I just need to figure out how to dynamically build the URL based on my date parameters

Was this reply helpful? Yes No
MelvinOrellana on at

Like
a
(0)

Report
Copy link

Link copied!

Try converting date to text
then create a new text variable with those pieces
I have the base URL in a separate variable because I use it in other parts of the flow and if it ever changes I just have to change it once.

Was this reply helpful? Yes No