Hi Community,
I want to webscrape a table. Unfortunately, the UI isn't as clean as desired.
So basically column 1-4 are in one table (variable LeftTable) and columns 5-15 are in another table (variable RightTable). Also the headers for the right table are separated, hence a third variable RightTableHeaders.
The goal is to:
- Get the column ID of the column with the title XYZ from RightTableHeaders
- Use this column ID, to retrieve the value from RightTable.
In the best case scenario, it would be easy to combine all to one table but I haven't found a good way to work with datatables yet in power automate desktop (why is that?)
Thanks a lot!