Dynamic cell refence for UI element

[saimond]

Hi 

Good day.

I am new to power automate desktop.

I have a flow click ui element in window.

but i want to loop it that it will click the cell B2, B3,B4 and so on until it will finish in the last row.

Does anyone know how to make the ui element dynamic?that the reference cell will change in the loop.

[eetuRobo]

Use Set Variable -action to have a variable to use for the cell.
In you UI element change the cell that it refers to for example B2(or what ever cell you picked when creating the UI element) to refer to the variable you created for the dynamic cell.

Sometimes you need to change the UI element to be in Text editor mode for it to work with variables. Not always though. I think usually when you use integer and not string.

[saimond]

Hi @eetuRobo  I already did this set the variable.

set the variable to B2.

but how do i increment this that it will change to b3,b4 and so on inside the loop.

[eetuRobo · Accepted solution]

You can make ColumnIndex variable which is just number and then increase that by every loop.

UI element you can have the hardcoded B and then after that the ColumnIndex which is just the integer variable which you increase every loop: B%ColumnIndex%

Then of course you can also have the B to be ColumnLetter -variable which you can change if you want to change column when the columnIndex is for example last row in that table. So If ColumnIndex = 5 then Set ColumnIndex  to 1 and ColumnLetter to C.
Or you can build switch case. Quick example:
If ColumnVar is B2 change it to B3 and use that in the UI element.

Many different ways to do this.

[saimond]

@eetuRobo  thanks you.now working.

It helps a lot.