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 / Find Matches in Drop D...
Power Automate
Answered

Find Matches in Drop Down List Resulting in System.Data.DataRow But Need Row Index

(0) ShareShare
ReportReport
Posted on by 145

Hello,

I am using the 'Find or replace in data table' action to narrow down all the values on a websites drop down menu that match a variable I set in a data table, it appears to be working fine as far as determining how many record matches there are but it keeps displaying 'System.Data.DataRow' for any match after the first one, instead of the index number (row number.) 

Alanisp22_1-1693443517250.png

I am looping through a data table I setup using 'For Each'. MatchP is the current item on my data table the loop is on and [2] is the column the variable is listed in that I need to find all matches in the drop down for. 

Alanisp22_0-1693443369210.png

Any guidance would be amazing. 

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

    Hi @Alanisp22 

     

    Could you show how the DropDownValues variable value shows in power automate desktop ?

     

    Thanks & Regards,

    Nived N 🚀

    LinkedIn: Nived N's LinkedIn
    YouTube: Nived N's YouTube Channel

    🔍 Found my answer helpful? Please consider marking it as the solution!
    Your appreciation keeps me motivated. Thank you! 🙌

  • Verified answer
    Alanisp22 Profile Picture
    145 on at

    Hi! I ran the flow this morning and the data is there now. I am no longer receiving 'System.Data.DataRow.'. I wonder if the page just had to be refreshed. Not sure if it will happen again. 

    Here are the dropdown values:

    Alanisp22_1-1693501878769.png

     

     

     



    When I ran into that issue, I was looking for all the MatchP[2] variables which would be 'WA'. 

     

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

    Hi @Alanisp22 

     

    So you want all matches where the that column have value which contains WA , like Econ_WA ?

     

    Thanks & Regards,

    Nived N 🚀

    LinkedIn: Nived N's LinkedIn
    YouTube: Nived N's YouTube Channel

    🔍 Found my answer helpful? Please consider marking it as the solution!
    Your appreciation keeps me motivated. Thank you! 🙌

  • Alanisp22 Profile Picture
    145 on at

    Hi, sorry for the delay. I didnt run into that issue anymore so its working as expected. Thank you for helping.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 589

#2
Valantis Profile Picture

Valantis 459

#3
11manish Profile Picture

11manish 382

Last 30 days Overall leaderboard