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 / Array filter and selec...
Power Automate
Unanswered

Array filter and select action

(0) ShareShare
ReportReport
Posted on by 7

Hi, new to this but I want to get it right!

 

I'm trying to accept a form response, take the next item in an excel table, and send that item in an HTML table to the email address provided in the form.

 

Unfortunately, I'm unable to filter and select the way I want. I can populate the HTML table with either all of the rows in the table or none, but not the top row only. My hunch is that the select action is selecting from 'value' which hasn't been filtered and there should be a variable created for the filtered item.

 

arrayarrayflowflow

 

 

I'm taking this one step at a time but I will be adding an action to delete the top row as the key will not be useful to anyone else and move the next key up to the first row.

 

Any help would be appreciated!

Categories:
I have the same question (0)
  • ScottShearer Profile Picture
    25,290 Most Valuable Professional on at

    @parnellijones 

    Let me suggest an alternate approach.  Note in the Get rows action I have set top count to 1 so that only 1 row is returned.

    Excel.jpgExcel1.jpg

     

  • parnellijones Profile Picture
    7 on at

    It worked!

     

    I can't believe I didn't recognize the 'Top Count' field - thanks for the reference.

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 604

#2
Valantis Profile Picture

Valantis 502

#3
Vish WR Profile Picture

Vish WR 417

Last 30 days Overall leaderboard