cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
User_NT
Frequent Visitor

Select a specific new record from multiple rows of records

I'm using an application to register multiple records in one database.
Would you please teach me if there is a way to select a newly registered record from multiple records?
This time, if there are multiple records with the same status (application), I want to be able to select a specific new record from them.
(This time, select the record "test1 request for quotation")

User_NT_0-1634086792267.png

 

 

7 REPLIES 7
Anonymous
Not applicable

Hello @User_NT 

 

As far as I can see in your screenshot, there are 3 items in this window, but all of them have the same status and the same date (also group name and user name are the same).

 

How could you determine which item is the one you should select? What are the criteria for identifying the item you would select from other items?

 

Are all items listed in the order in which they were registered? If so, you could select the item at the top (or the bottom).

 

Thank you.

Thank you, Mr. Shindomo.

 

The records are not listed in the order in which they were created.
When you open the record, there is an item called "Quotation NO".
This item is in the format "EST-number".
I want to identify by looking at this item.
I want to select the record of "EST-latest number".
This time, the record "EST-146" is the latest, so I'm wondering if I can select this record.

User_NT_0-1634176488993.png

 

Anonymous
Not applicable

Hello @User_NT 

 

If there is no option to display the "Quotation NO" on the item list screen, unfortunately, it seems that you have to open each item one by one and check it.

 

It may take time to process if there are a large number of registrations on the same date, but I think you can narrow down the target using the date in the list (first screen).

 

I suppose using PAD you can create a flow to do what you want. Is there any specific part you want to know?

 

Thank you.

Thank you, Mr. Shindomo.
Sorry for the late reply.
If "Quotation NO" is displayed on the Item list screen, is it possible to create a flow to select the record with the latest quotation NO?

Anonymous
Not applicable

Hello @User_NT 

 

It depends on the HTML structure of the list page, but I think the following process can be created in PAD flow:

 

  1. Get all the "Quotation NOs" displayed on the list page and store them in a list-type variable.
  2. Sort the list-type variable in descending order. As a result of sorting, the one at the top can be regarded as the latest.
  3. Use the latest "Quotation NO" to identify the UI element of the item displayed on the list page and perform a "select" operation.

I don't know what kind of operation you mean by word "select". If you want to edit the item, you can make PAD to click on the pencil icon button.

 

Good luck.

Thank you, Mr. Shindomo.
Thank you for providing the detailed method.
As you pointed out, "select" is a click operation of the pencil icon button.
I will actually set it.

 

I'm sorry, let me check one more point.
Basically, PAD can "select" and "extract" items that can be seen from the screen, but can't "select" and "extract" items that cannot be seen (not displayed) from the screen?

Anonymous
Not applicable

Hello @User_NT 

 

As a general rule, when performing web automation with RPA tools such as PAD, you are basically processing the HTML elements and attributes that make up the web content.

 

Therefore, even HTML elements that are not displayed on the screen (hidden / invisible) can be considered as possible target for automation.

 

But of course, if the target is not visible, you will not get help from tools such as UI element capture or web recorder, so you will need enough knowledge of HTML and CSS selectors.

 

Well, I think it is safe to say that it is usually impossible (or very difficult) to automate using information that is not displayed on the screen.

 

Thank you and good luck.

Helpful resources

Announcements
MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

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

Power automate tips 768x460 v2.png

Restore a Deleted Flow

Did you know that you could restore a deleted flow? Check out this helpful article.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Users online (2,387)