Problem to build a selector

[Anonymous]

Hello,

I need your help to find the good selector for my project.

Context:  I want to automatize the brand configuration for the sellers of a marketplace. For this project I need to give the authorization for each sellers on a list of brand (from a excel spreadsheet)

For example, for a seller ABCD (fake example I create to explain better the problem), I want to give him the authorization for the brand NIKE.   

Problem If I search this seller , it give me two choices (Seller ABCD and seller ABCDEFG) . My goal is to find the good selector in order to click to the correct checkbox (that it to say  the one which contain the exact name of the seller “ABCD”).

Here is the selector to click to the checkbox associated to the first line :

table[Id="shopsAuthorizedToSell"] > tbody > tr > td > div > div > label > div[Class="mui-checkbox-icon"]

Here is the selector to click to the checkbox associated to the second line :

table[Id="shopsAuthorizedToSell"] > tbody > tr > td > div > div[Class="mui-checkbox checkbox"] > label > div:eq(1)

For both selectors, it works also without [Class="mui-checkbox checkbox"] which is apparently optional

Here is the selector where we can see the text associated

table[Id="shopsAuthorizedToSell"] > tbody > tr > td > div > span[Text="ABCD"]

I try this selector (in click link to a webpage ) but it doesn’t work :

table[Id="shopsAuthorizedToSell"] > tbody > tr > td > div > span[Text="ABCD"]~[Class="mui-checkbox-icon"]

Can you help me ?

[Nived_Nambiar]

Hi @Anonymous 

Could you show me the html structure of the checkbox ?

Right click on checkbox  and click inspect element 

[Anonymous]

Hello @Nived_Nambiar 

Thanks for you help. !

Of course, here is the element of the checkbox : 

<div class="mui-checkbox checkbox"><label title=""><input type="checkbox"><div class="mui-checkbox-icon"><span aria-hidden="true" class="fa fa-check mui-fa-primary"></span></div></label></div>

[Anonymous]

Hello,

I have tried this and it partially works : 
#shopsAuthorizedToSell tbody tr:contains('XXXXXX') [Class="mui-checkbox-icon"]

The problem is that if I use the selector mentioned below , it will also click to the seller ABCDEFG
#shopsAuthorizedToSell tbody tr:contains('ABCDEF) [Class="mui-checkbox-icon"]

I want that it contains exactly the same text. So if search "ABCDEF" it shouldn't click to the checkbox associated to seller "ABCDEFG"

If needed here is the element of the text 

<td role="cell" class="mui-datatable-simple-cell mui-datatable-simple-cell-specific mui-datatable-simple-cell mui-datatable-simple-cell-borderless mui-datatable-simple-cell-content-centered mui-datatable-simple-cell-compact" style="width: 100%;"><div class="mui-datatable-simple-cell-content mui-datatable-cell-text mui-datatable-cell-xs"><span class="mui-text">ABCDEFG</span></div></td>

[Nived_Nambiar]

Hi @Anonymous 

could you expand this part and share the screenshot ?

[Anonymous]

Hello @Nived_Nambiar ,

Yes of course ! Thanks for your help.

[Nived_Nambiar · Accepted solution]

Hi @Anonymous 

CSS selectors and Jquery selectors has one limitation, it cannot detect element fully by text, although jquery can do it some extend using contains which won't be applicable in this case. 

To make things work in your case, use the following logic.

1. Scrap the table found after search and store the results in datatable, 

2. Loop through row and check when the first value is equal to ABC 

3. Check its index value, like at start of loop you can set index variable of integer with value =0 and increment it for every iteration, 

4. I hope that the highlighted html component has index attribute whose value increases with every row 

So you can construct the below selector to be used in click action 

tr[index="%index%"]>td:eq(0)

where %index% represent the index of each row which gets incremented during every iteration.

Hope the logic helps !

Mark it as solution if it resolves your query !

[Anonymous]

Hello @Nived_Nambiar ,

Thank you for your help ! I follow your advice and it works.

For those who want to know how I configure it concretely , here is the screenshot

I had difficulties to find a way to have the row number and this post help me a lot !

https://powerusers.microsoft.com/t5/Power-Automate-Desktop/Searching-through-datatable-to-find-value...