Unanswered

Need Assistance with Power Automate Desktop - Filling Web Form from Excel Data

(0) Share

Report

Posted on by shad-yx

Dear Power Automate Community,

I hope this message finds you well. I am currently working on a project using Power Automate Desktop, and I'm facing an issue with filling a web form from Excel data. Basically, I have an Excel sheet with a bunch of materials with their respective ProductID's and Prices.

Here's a brief overview of my situation:

I need to automate the process of filling in corresponding text fields on a web form with the respective prices.
I have successfully read the Excel data using the "Excel" action in Power Automate Desktop.
I can navigate to the web form but I had to add all the text fields in which I want the price to be written automatically manually using the UI Element Feature and I do not want to do that since there's 32 of these Products on Average and I need them to be identified and added automatically.
The problem arises when I try to fill the prices into the correct text fields on the webpage. Since I had to add the text fields manually I only added 2 just for running a demo and the prices from the Excel sheet are being stored in a single input field (when I only had ane text field added in my canvas) and when I added another, it was adding the prices to the field in a weird way while switching between both fields rather than being associated with the respective product IDs. (Product 1 Price was 12, Product 2 price was 34 but it was added as 13 and 24 in the actual site.)

I have tried using variables and conditionals, but I'm not sure how to ensure that each price is written against the data field of the corresponding product on the webpage.

Could you kindly assist me in resolving this issue? I would greatly appreciate any guidance or suggestions you can provide to help me achieve the desired automation.

Thank you in advance for your time and support. MY FLOW MY FLOWTHE SITE

Categories:

Power Automate Desktop

I have the same question (0)

All responses (2)

Answers (0)

MichaelAnnis 5,727 Moderator on at

Like (0)

Report

You could have it loop through the product name elements using Get Own Text, and when it finds the matching name elements, it applies the price to the corresponding price element.

this may be slow, but should work if you do not get to determine which product names appear in which order. In order to do this, you will need to map out which product name element matches to each price element, so you can tell it where to write the price based on that lookup after it finds the right text.

also look to see if the program itself has any kind of import feature. For instance, I had a similar UI to enter stock prices, but we could also import prices using a custom tool from the software maker.

best of luck!

Was this reply helpful? Yes No
shad-yx 2 on at

Like (0)

Report

hey thanks for the response!

I dont see any action called "get own text" or "get text", the only option I see there that's close to what you mentioned is "get text from terminal session"

Also the place where I'm trying to input the price is a website on Chrome, not an application.

Is there any other alternate method to achieve this that you could help me with?

Was this reply helpful? Yes No