Power Platform Community Forum Thread Details

Hello everyone,

First time posting here.

I have a perplexing issue and I have asked ChatGPT without good results.

I am creating a flow for a webpage which references my excel spreadsheet. My spreadsheet is holding all of the data I need to have transferred to text boxes on the webpage. My goal is for the flow to click on the correct "Add" button on the webpage which enables the text box and matches with a set of text being referenced from the spreadsheet. I'll give an example below:

	details from spreadsheet which correspond to the answer to text box 1 and require add button 0_0 to be clicked
Add button 0_0	drop down menu	text box 1
	details from spreadsheet which correspond to the answer to text box 2 and require add button 1_0 to be clicked
Add button 1_0	drop down menu	text box 2

The problem I'm having is that the data from the spreadsheet is not laid out in a uniform way and so the "details from spreadsheet which..." box appears in random orders and thus varies the location to click on the Add button. Sometimes Add button 1_0 is the first add button that needs to be clicked and sometimes Add Button 3_0 is the first one that needs to be clicked. Additionally, there are blank cells on the spreadsheet which only require the Add button to be clicked one time on it's respective webpage.

If this makes sense to someone and you know how I can tackle this issue I would love to hear from you.

Thank you!

Categories:

Power Automate Desktop

Without the actual website + data most I can give you is some general tips:

- Text boxes, dropdowns and buttons will all have some attribute to differentiate themselves by, be it class, id and or CSS path that you can use to point PAD in the right direction.

- You can make the selector more generic by shortening its CSS Path

- Extract data from webpage action can you give you a lot of insight into what you're extracting via its advanced settings menu (found in the recorder of elements at the bottom)

- Press F12 and open the web-page developer tools to find out the CSS of each element on the page and how they differ (should be a select element button on top left portion of the developer tools screen)