web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Working with variables
Power Automate
Answered

Working with variables

(0) ShareShare
ReportReport
Posted on by 205

Hello.
Faced another problem with variables. I would be grateful if you help me.

 

Task: double click on each row in Excel.

 

Here is the original:

11.png

 

Here's what I changed:

22.png

 

The question is, why didn't it work for me?
What did I do wrong?
How should I write correctly so that my idea works for me?

I have the same question (0)
  • Nived_Nambiar Profile Picture
    18,138 Super User 2026 Season 1 on at

    Hi @absentia8 

     

    so you want to click each row in excel or a particular cell in each row 

     

    It would be helpful if you can share screenshot of excel file as well 

     

    Also please specify what you are trying to acheive here 🙂

     

  • absentia8 Profile Picture
    205 on at

    Hello @Nived_Nambiar . Glad to see you.

    I am trying to click into each cell.
    I took a screenshot where I want to first click on cell 1 and so on.

     

    1z.png

  • Nived_Nambiar Profile Picture
    18,138 Super User 2026 Season 1 on at

    Hi @absentia8 

     

    Have you used test selector option to test selector by change the Id value to S1, S2, S3 etc ?

     

    i have tried below selector to click cells A1, A2, A3 etc under A column like below

     

    Nived_Nambiar_0-1685285989442.png

     

    it is working fine 🙂

     

    could you try the way above i have mentioned 🙂

     

  • absentia8 Profile Picture
    205 on at

    Have you used test selector option to test selector by change the Id value to S1, S2, S3 etc ?

    -Yes

     

    Thanks for the answer @Nived_Nambiar .

    This method you described also works for me.
    But the task is a little different. You are on the right track!

    Please look at my very first screenshot and also at the second screenshot.
    Do you understand what I want to do?

    I'll try to explain in more detail:
    I previously dropped my Excel file here in the Topic. The method that you suggested to me - it works. BUT. Imagine if there are a lot of such cells and FOR EACH cell I need to click the mouse. Then your proposed method no longer works, because each time the PAD will click on the same cell with the mouse. (When I used the test selector option, it only recognizes it as "S2")
    If you look at my second screenshot, I wanted to implement this through a variable. I set the value of the variable "2" and on the next pass to the FALL, this value "2" changed to the value "3", "4", "5" and so on, and this would completely suit me.
    But PAD refuses to understand me and I hope that you will understand me and help me.

    Please ask me if I didn't explain clearly.
    This is a very simple problem, but I don't understand how to solve it.

     

     

  • Verified answer
    Nived_Nambiar Profile Picture
    18,138 Super User 2026 Season 1 on at

    Hi @absentia8 

     

    This works for me perfectly !

     

    Nived_Nambiar_0-1685298155909.png

     

    it is able to click each cell under the A column when iterated through 2,3,4,5 🙂

     

    Try this kind of selector 

     

    hope it helps !

     

  • absentia8 Profile Picture
    205 on at

    Thanks for the answer @Nived_Nambiar .
    Could you send me a more detailed screenshot of your PAD?
    I did everything as you wrote, but I did not understand how I should set up the "LoopIndex" function so that my stream is error-free?

     

    1w.png

  • Nived_Nambiar Profile Picture
    18,138 Super User 2026 Season 1 on at

    Hi @absentia8 

     

    Try like below

     

    Nived_Nambiar_0-1685324995045.png

     

     

    Additionally after clicking on cell, i have used Down hotkey so that next cell becomes visible to click (or you can use down arrow itself to move cell by cell :))

     

     

     

  • absentia8 Profile Picture
    205 on at

    Thanks for the answer @Nived_Nambiar , I almost got my plan, except for one moment.

    I recorded a short video that shows that the PAD does not click on the "Down" button when the text in the cell is on the very last line.

    https://dropmefiles.com/O0hph 
    Instead, it does not go to the next cell below, but immediately to the eleventh (skipping cells 3,4,5,6,7,8,9,10)
    What do I need to do to make my PAD work on EVERY cell?

     

  • Nived_Nambiar Profile Picture
    18,138 Super User 2026 Season 1 on at

    Hi @absentia8 

     

    Somehow i am not able to access the link due to some restrictions, if possible could you share the screenshot of the flow ?

     

     

  • absentia8 Profile Picture
    205 on at

    Expensive @Nived_Nambiar .
    I can't send you a screenshot because the screenshot alone won't tell you the problem.

    Could you please download the file from the video I posted on another resource?
    I will be glad if you use vpn if you can't download it.

    https://drive.google.com/file/d/10PPsugw0FGeEyP4lkJYW4L4SERq654fl/view?usp=sharing 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Valantis Profile Picture

Valantis 389

#2
Vish WR Profile Picture

Vish WR 331

#3
David_MA Profile Picture

David_MA 298 Super User 2026 Season 1

Last 30 days Overall leaderboard