Hi, I need to create a power automate desktop flow, where it extracts the required data from a webpage and adds them into the Excel file.
For example, I have an Input File having a list of Item names. I'll ask the user to upload the input file whoever runs the bot. The bot has to read the input file and opens up the website.
Also it has to create an output file having the column headers mentioned below so that after extracting the data, the values should be pasted accordingly to the output file.
The bot opens the website.
The bot has to type automatically the first item name from the input file in the search bar as shown below.
The required item name opens up. Now the bot should extract the following data as shown below.
Then, the extracted data should be pasted accordingly to the output file. And Veg is pasted if we find Green symbol in the item name.
And for the next item (Eg. Betty's Chestnut Mont Blanc Latte) again it searches, and the following steps should happen until it reaches the end of the row i.e, empty row.
I thought of achieving this creation of Excel file using PowerShell script. I also tried but could not get the result.
Please help me to resolve this issue.
Thanks in advance for your help.
