Copy information from datatable to multiple fields

Help Activities
1

@ppr Now I have a complicated question and I will try to describe it as much as possible. The function that I am trying to recreate in UiPath is this…
At the current moment there is an excel sheet with a list of vendors. They get the top 25 unique vendors and then they copy those fields from excel and then import from clipboard into a single field in a website. Because they are copied from excel, when they are copied into that first field, they fill in the 25 rows below that field so that they end up with a list of one vendor in each row.
I was able to get this information into a datatable, and then find the top 25 unique vendors. Now I need to copy that information to the clipboard in a way that resembles how they are copied to clipboard in excel so that I can import them from the clipboard into the website and have them flow down to the rows below.
Any suggestions, anyone???

1 Like
2

At this part we would recommend to check the different available entering options. Maybe clipboard is less to prefer compared to type into 25 times into the different fields.

Can you please share a screenshot from where you will enter the vendors? Thanks

3

Hi @karen.c.stewart4.civ ,

Maybe what you are expecting is the data appearing in multiple lines, so we can paste this 25 rows of data directly into the website at once. This has been implemented in SAP fields/Table but not sure if the same logic would work in the website.

Assuming you have the Top 25 Unique Vendor as a list, then we can use String Join to join these values with a New line like below :

str_25VendorList = String.Join(Environment.NewLine,vendorList25)

Here, vendorList25 is a variable of the datatype list or Array of String, containing the 25 Vendors, str_25VendorList is a String type variable which contains the vendors in multiple lines.

You could try performing Paste operation with str_25VendorList and check if the data gets pasted into the website as required.

4

@supermanPunch that is awesome. It worked on the first try! Thank you so much.

Just so I know what we did….we took the array of string and converted it into simple string variable, correct? That is what allowed it to input into each of the fields, correct?

5

@karen.c.stewart4.civ ,

Yes, Along with the addition of a New Line after each value.

6

@supermanPunch thank you so much! You have taught me something new today. It is a great day already….more knowledge in!!!

1 Like
7

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