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 / Retrieve Row ID text v...
Power Automate
Unanswered

Retrieve Row ID text value in on-screen table

(0) ShareShare
ReportReport
Posted on by

Hi, I have a scenario where what looks like a checkbox list is actually a table so it's not immediately straightforward to associate the row label with the corresponding checkbox. I need to get the row number where the text in column one matches the input variable %reason% so I can then pass this to an action to click the corresponding check box. I have the input variable and search part working fine, now I need to undertstand how to retrieve the number of the matching row label.  This is an a desktop app - the image below is a mock up representing the on-screen display. TIA.

Nellodeon_0-1689612049273.png

 

  • Agnius Bartninkas Profile Picture
    Most Valuable Professional on at

    If the check-boxes are in fact stored in table rows, they should have a row number property that you can use. Try capturing several of them as separate elements and see how the selector is different. Then you need to find the row number of the matching text and use that in the selector.

     

    To get the row number of the matching text, you can either use a Loop action to go through the list of Reasons you retrieved from your app, until you find the one you need, and then Exit loop when you find it. Inside the loop, you would increment a variable that indicates the row number. 

     

    Alternatively, if you can extract all of the Reasons in a form of a table, you can also use the Find or replace in data table to find the match. This will return a table of row and column indexes where matches were found. It will be stored into a variable called %DataTableMatches%. You can then get the row index from there as %DataTableMatches[0]['Row']%.

     

    Then to pass that into a selector of the checkbox, you will need to modify the selector. See this article on how to use variables in selectors: https://learn.microsoft.com/en-us/power-automate/desktop-flows/build-custom-selectors#use-variables-in-a-custom-selector

    -------------------------------------------------------------------------
    If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.

    I also provide paid consultancy and development services using Power Automate. If you're interested, DM me and we can discuss it.

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 Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Automate

#1
Mohsin Ali Profile Picture

Mohsin Ali 414

#2
11manish Profile Picture

11manish 331 Super User 2026 Season 2

#3
M Bilal Khan Profile Picture

M Bilal Khan 274

Last 30 days Overall leaderboard