cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mattlin
Regular Visitor

How to use VB expression in url of power automate?

Hi Community,

I used expression in UiPath as below Previously, but it didn't work in Automate.

"http://xxxx/xxxx/pages/xxxx/xxx.jsp?Type=b&fromDate="&System.DateTime.Today.AddDays(-1).ToString("yyyy/MM/dd")

How to use VB expression in url of power automate when I launch new Internet Explorer ?

 

Thanks.

1 ACCEPTED SOLUTION

Accepted Solutions
amamidwar23
Advocate I
Advocate I

HI ,

 

In PAD, you need to use  following activities and to store date in a variable  and use the resulted variable in your URL .

 

so if time variable is Currendate  then your url will be 

http://xxxx/xxxx/pages/xxxx/xxx.jsp?Type=b&fromDate=%Currendate%

 

amamidwar23_0-1624441786610.png

amamidwar23_1-1624441817523.png

Thanks 
AR

Please consider to Mark my post as a solution! to guide others, if this helps .

View solution in original post

2 REPLIES 2
amamidwar23
Advocate I
Advocate I

HI ,

 

In PAD, you need to use  following activities and to store date in a variable  and use the resulted variable in your URL .

 

so if time variable is Currendate  then your url will be 

http://xxxx/xxxx/pages/xxxx/xxx.jsp?Type=b&fromDate=%Currendate%

 

amamidwar23_0-1624441786610.png

amamidwar23_1-1624441817523.png

Thanks 
AR

Please consider to Mark my post as a solution! to guide others, if this helps .

Thanks, your suggestions have helped me solve the problem.

My flow as below:

Get current date and time → Add to datetime (-1) → Convert datetime to text (Variable produced FormattedDateTime)

→ Launch new Internet Explorer : %'http://xxxx/xxxx/pages/xxxx/xxx.jsp?Type=b&fromDate='%%FormattedDateTime%

 

Helpful resources

Announcements
Register for a Free Workshop.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Top Kudoed Authors
Users online (2,309)