Multiple lookups to dataservice and present the data in a list/Table or Custom List

Hi

The scenario is that the user has multiple orders (the count varies), for each of these orders I would like to present the sales lines on a page, there is no distinct field that can be used across the saleslines. Any good ideas to present such solution?

The sales lines only contains (“salesOrderno”, “quantity”, “price”, “VAT”)

I hoped that the Custom list would be the way to go, but that doesn’t support the use of “Tabs, Tables, lists etc”
The custom list would suit the requirement perfectly.

Custom list

Table query using ThisRow.SalesOrderNo1

Next

Table query using ThisRow.SalesOrderNo2

Next

Table query using ThisRow.SalesOrderNo3

Etc.

Any good ideas to solve this?

Hello Michael

Can you perhaps share an image/file of the input format and desired output?

Regards,
Soren

Hi Søren

I’ll do a graphical representation of the issue, but basically what I’m looking for is a pickinglist of sales lines for a list of sales orders

X Number of sales orders and for each of them a list of sales lines.

Presented in one table.

The sales orders are stored on dataservice with the user email as the link and the saleslines are stored in a different dataservice with the sales order number as the link.

That’s why the custom list with a table in each of the rows would work perfectly

Does it make sense?

Venlig hilsen/Best Regards
Michael Jeppesen

Sendt fra Outlook til Android

Hello Michael

Sorry, but im afraid I still dont quite understand :sweat_smile:

Are the orders in .csv-format, Excel-file, .pdf-files, on a webpage or something else?

And you write that you want to “present sales lines on a page” - again, is this a .pdf-file, webpage, Excel-file or something else?

Regards,
Soren

Hi Søren

Both datasets are stored in the UiPath Dataservice, and should be presented in UiPath Apps.

Im not sure if my image helps anything.

I’m thinking if relationships between the two Dataservices would solve my issue.

Doing a lookup towards to sales order records, and return the sales order lines from the second dataservice entity.