I am new to Power Automate Desktop and trying to determine whether I can use it to enter data into a webform from an Excel spreadsheet. The use case is that I am trying to automate the entry of an invoice into a web based point of sale product. To add a line item to the invoice, I must paste a barcode number from the Excel spreadsheet into a field on one form and if it is found, I must click on a "suggestion" that pops up to get to the form where I enter the rest of the information on the item then save it. I can get Power Automate to do almost all of this except click on the "suggestion" link that pops up.
When I run the capture on the manual process, the U/I element preview is "div[Id="suggestion-box"] > ul > li > a > span[Text="L&M RED BOX 100"]" (this is a pack of cigarettes). In this forum it is suggested that I could be less specific so that I won't need to provide the text of the suggestion name, but don't I still have to indicate that this is a "span"? That suggestion name can have thousands of different names so it would be impossible to populate the name needed. The good news is that there is only one link that will appear on the page if the barcode number entered on the first form is successfully retrieved. I am new at this and don't have much development background so I am getting the feeling that I am way over my head on this one. Screenshot of the u/i element description attached. Any suggestions on where I can get some help on this one or should I just hire someone to do this?
