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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / get row returns 1 value
Power Automate
Unanswered

get row returns 1 value

(0) ShareShare
ReportReport
Posted on by 11

Hi All, 

There are multiple rows for 1 value in excel and flow returns only the first value.. Input from the bot triggers the flow and this is the flow structure ;

 

byrmque_0-1604499068661.png

 

Example: 

 

Column AColumn B
1Apple
2Seattle
3John
3Rick
3Tim
3Gigi
3Sam
4Banana

 

Key Column : Column A and Key Value : and flow result is : John

 

How can i get all the values (John, Rick, Tim, Gigi, Sam) returned for one key value please ?

 

Thank you for your responses. 

 

B.

Categories:
I have the same question (0)
  • Verified answer
    byrmque Profile Picture
    11 on at

    I got this sorted out by using list rows + array variable.. thank you.

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 522 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 364 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard