My full flow is this.
I’m not sure I am doing well, having little experience.
TestSNv0.xaml (87,8 KB)
Description:
Open Site 1, “page 1” and collect ID’s (extract-data-table)
For each Row, of the Site1, go into detail and collect some specific data.
Then,
Go to Site2: (servicenow), and from the list, search Site ID collect in Site1,
and compare if the data is equal.
ExtractData.xlsx (26,8 KB)
In this excel i write all data.
Sheet1: Page1 , site1
Sheet2: Page2 site1
Sheet3: table scraping on ServiceNow.
I have to look in the list of sheet3,
Porder collected on Page1, site1,
and verify that:
PO_Line, and Price are equal.
If they match, I have to perform other operations, not yet present.
I don’t know exactly if the flow is correct.
Maybe there is a better method.
And then, the problem is the formatting of the price…
ex: my ID Number in list is: 0410008151

In sheet2, i get: PoLine value (1)
and Sub.Amt (3,500.00)

then, I have to check if in sheet3,
amounts and lines, match.

Writing takes place on two lines.
One is the total, for POrder who have multiple lines.
The second line indicates the amount for each line.
It is too complicated for me.
And a first obstacle, it is certainly the formatting of the price.
Can anyone help me?