Once we have brought the Inbox information into Power Query, check out these categories across the top of the table.
These headings allow us to sort and filter the table to include only the needed items.
Useful columns for filtering include:
- Recipients names & email addresses
- Date and time the email was sent
- Date and time the email was received
- Message importance/priority level
- Attachment indicator and attachment filenames
- Message read/unread status
An interesting column is the “Body” column. This contains two versions of the email message: a plain text version and an HTML version of the message.
I want to filter the “Folder Path” column to only include messages from the “Action Required” subfolder.
You can also filter using pre-build text filters for items that begin, end, include, or don’t include specific text.
Other columns, like the “Subject” column display all the email subject lines. The “Sender” column contains nested information about the name and email address of the sender.
If we want to include the “Sender” information in the output table, we can click the Expand Table button at the top of the “Sender” column and click OK to extract the names and email addresses as additional columns in the current table.