Hi all, I could really use your help. I have a long list of field/element names and values in an Excel table. Using Power Automate desktop, I'd like to populate a web claims form directly by element name and write the value to the text box. Depending on the number of car parts, there could be 100s of entries, so I'd really like to have an automated way of doing this, where I could loop through the Excel table and then just populate the values straight to the web. I've tried "Run javascript function on web page" option using getElementsByName and it's not working, or I just don't know how to use it correctly. I'm not a java programmer so I can't even debug. I'm, open to other suggestions, but adding UI Elements one at a time just isn't going to work.
Also, as a side note, the element names are valid, as they worked previously in VBA scripting with IE. Thanks in advance.
Fake sample EXCEL TABLE data below. I can also arrange this data in columns as needed. Whatever is the best method to populate the web form above.
| ELEMENT NAME | VALUE |
| | |
| CLAIM_PRODUCT1 | FORD |
| CLAIM_PRODUCT_SN1 | SN123 |
| CLAIM_PRODUCT_COST1 | 100.25 |
| CLAIM_PRODUCT2 | FORD |
| CLAIM_PRODUCT_SN2 | SN2XYZ |
| CLAIM_PRODUCT_COST2 | 300.99 |
| CLAIM_PRODUCT3 | FORD |
| CLAIM_PRODUCT_SN3 | SNBC |
| CLAIM_PRODUCT_COST3 | 555.55 |
| … | |
| CLAIM_PRODUCT999 | FORD |
| CLAIM_PRODUCT_SN999 | SBAB123 |
| CLAIM_PRODUCT_COST999 | 1111.11 |
