Skip to main content
Community site session details

Community site session details

Session Id : MOqf768fejxj3lfU0hoV5y
Power Automate - Building Flows
Answered

Filter Excel in OneDrive

Like (0) ShareShare
ReportReport
Posted on 24 Jan 2023 22:18:47 by 5,079 Super User 2025 Season 2

I am receiving and Excel spreadsheet from an email a few times per month.

The sheet looks similar the below.

Everything in 'grey' I've identified as Table1.

Will I be able to get at this table, its column headings, and data, even with the top four rows populated by information I have no interest in - as shown in the red circle?

 

Phineas_0-1674598499625.png

 

  • Verified answer
    wskinnermctc Profile Picture
    6,517 Moderator on 24 Jan 2023 at 23:41:33
    Re: Filter Excel in OneDrive

    I don't know a whole lot about Power Apps especially without a screenshot. I've only used Power Apps with a SharePoint list, but it is similar. Seems like you aren't far off from getting the data in there.

    You might need the column name to be in quotes like ThisItem.'Full Name' and sometimes it needs to be ThisItem.FullName.Value if it is like a choice column.

     

    Check the color of the text and size, maybe it is in there but you can't see it.

     

    This guy has a whole video about dealing with power apps gallery and excel tables and it would probably get you what you need.

    https://www.youtube.com/watch?v=5O5XQrHQMec 

     

    Since the initial question was about excel and power automate, can you do me a favor and mark the post as solved/solution to my initial post that way it will be closed? I'll still respond to questions if you have one, but I might not know the best answer.

  • Verified answer
    Phineas Profile Picture
    5,079 Super User 2025 Season 2 on 24 Jan 2023 at 23:12:48
    Re: Filter Excel in OneDrive

    Great!

    Now, how about from Power Apps?

    I created a Gallery.

    I have the connection back to OneDrive, the Excel file and the specific Table.

    I can choose the Table columns from a list and have the 'ThisItem' choice presented to me - for instance ThisItem.FullName.

    However, nothing populates in the Text Fields.

    The Gallery Items has - 'TextReportJan2_13_2023Tbl', which is the name of the Excel table I need to retrieve the data from - but no data appears.


  • wskinnermctc Profile Picture
    6,517 Moderator on 24 Jan 2023 at 22:34:29
    Re: Filter Excel in OneDrive

    Are you saying the excel file is sent to you and then you save the attachment in a folder, and then you want to know if you can get the info from the table?

    Or are you asking if you can get the info from the table directly from the email attachment?

     

    If the excel file is saved in a folder, you can get the info from the table IF IT IS A TABLE. You have to have the table format which would then be a named table. You can use the power automate action "List rows present in a table" to call the table.

    It will call the table by name in the workbook so it doesn't matter how many headings or where it is located.

     

    Excel TableExcel TableList Rows Present In a TableList Rows Present In a Table

     

    Just listing some fields in an excel sheet and saying that it is a table is not the same as a named table. So if your workbook doesn't have the table formatted, you will have to find another way to get the data.

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

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 2

Loading complete