Answered

Filter Excel in OneDrive

(0) Share

Report

Posted on by Phineas

5,325 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?

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (2)

wskinnermctc 6,519 Moderator on at

Like (0)

Report

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 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.

Was this reply helpful? Yes No
Verified answer

Phineas 5,325 Super User 2025 Season 2 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Verified answer

wskinnermctc 6,519 Moderator on at

Like (0)

Report

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.

Was this reply helpful? Yes No