Filling web table with excel data.

[waytokabir]

Hi!

I am very new to power automate desktop. Trying learn it from Youtube videos. I am creating a flow where web form will be filled up with excel data. The problem is there are so many items in the table of web page. I need to search for an and populate text of various columns within that row. i could not do it. my flow can search for the item but it can not fill data from excel in the desired columns. Could you please advice me on that.

Thanks.

[Deenuji]

@waytokabir 

Could you please share some screenshot of your power automate desktop flow along with your web page?

It will helps us to understand your issue in details and guide you appropriately.

Thanks,
Deenuji Loganathan 👩‍💻
Automation Evangelist 🤖
Follow me on LinkedIn 👥

-------------------------------------------------------------------------------------------------------------
If I've helped solve your query, kindly mark my response as the solution ✔ and give it a thumbs up!👍 Your feedback supports future seekers 🚀 

[waytokabir]

Yes, certainly. Please have a look and find me a solution.

  

[VishnuReddy1997]

Hi @waytokabir ,

Is not at all Poupulating or Populating partially like it need to polulate rate but its populating as ra.

If it is the above scenario just disable Populate text using Physical Strokes as shown in below image.

If its not all Populating you need to work on the selctors.

(Note:- if you got your solution you can mark as solution and gives kudos)

Thanks & Regards

Vishnu Reddy

[Deenuji]

@waytokabir 

What is the error you are getting during the populate text action execution? 

Are you captured your UI element properly? You can check that by opening UI elements tab and you debug on your selectors.

Thanks,
Deenuji Loganathan 👩‍💻
Automation Evangelist 🤖
Follow me on LinkedIn 👥

-------------------------------------------------------------------------------------------------------------
If I've helped solve your query, kindly mark my response as the solution ✔ and give it a thumbs up!👍 Your feedback supports future seekers 🚀

[waytokabir]

You could see the web data table has numerous rows with a search box. My flow can search for the result using populating text and then pressing an enter key. But it can not go to the specific columns of that very row to populate the text. I know nothing about debugging selectors. It would be nice for me if I could find a video regarding this issue.

[VishnuReddy1997]

Hi @waytokabir ,

Please find the link for video about UI elements and selectors.

Link: https://youtu.be/7jqD9YucPSA?si=kxiDk16CL52bzfDy 

(Note:- if you got your solution you can mark as solution and gives kudos)

Thanks & Regards

Vishnu Reddy

[Deenuji]

@waytokabir 

Yeah got it. Just apply some filter values and apply filter to your table and show how results looks like?

And also share your web app hmtl code like below(press F12 to get the code)

Thanks,
Deenuji Loganathan 👩‍💻
Automation Evangelist 🤖
Follow me on LinkedIn 👥

-------------------------------------------------------------------------------------------------------------
If I've helped solve your query, kindly mark my response as the solution ✔ and give it a thumbs up!👍 Your feedback supports future seekers 🚀