How Can i Select lowest price based on the filters - 'Price and Before noon' i selected

Help Studio
, ,
1

Hello,

Can someone guide me how can i select a lowest price say “Wanna get away” and click on it based on the filters i selected which are “Price” and “Before noon”.
Please do not tell me about LINQ queries . I want a regular activity and do this.
PFA.

image
image1058×740 53.6 KB

2

Hey @S_G1 ,

Can you send us the link of that website so that we can get more information about it by using ui activities

Also i have a solution
Scrape The get away Information by Using the “Data Scraping” wizard to extract the necessary information from the website. This will create a data table with the required details.
And then use the “For Each Row” activity to iterate through the data table and find the row with the lowest price.
To click on the product with the lowest price, use the “Click” activity and indicate the product using a selector and make it dynamic

Hope this helps you out!

3

I did data scrapping but i am getting the data in csv file not in excel to read and get it.

image

4

@S_G1

image
image804×777 50.5 KB

Check this out
Testing.zip (3.2 KB)

5

Thank you @Vikas_M . Will try as you said.

6

@Vikas_M

I tried as you said. I am getting blank message in box.

image
image763×678 50.1 KB

7

@S_G1

use output datatable activty like i have used in the above xaml

Basically , It takes a DataTable as input and produces the data in the form of a string that can be easily displayed

below attached screenshot might help you better

image
image1199×352 24.7 KB

8

@Vikas_M Thank you. It worked for me now.

Can I get the data which is in the message box into excel? or shall i iterate from the datatable it self?

9

@S_G1

Output data table activity was just to confirm output, That’s it.Other than that its of no use in your use case scenario
You have to iterate through the extracted data table only

10

Thank you so much for the confirmation. If possible I would like to talk to you over phone if you are ok please share your number or some where we can message in private.

Need to ask you more about RPA

11

Hey @S_G1
I will be happy to help you
This UiPath forum has a private message option,You can use it to text me for any further queries
Also, I will share my LinkedIn profile in the private message option…If you have any doubts, you can contact me over there too

And As of this thread, if u have any other queries do not hesitate to ask them here
If not kindly mark me as a solution such that it will help the community

The below link points out the steps to mark a post as a solution

Happy automation :smile:

12

Sent you message. please check And i will ask questions here also as you said.

13

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.