Do you connect to Exchange Online or Exchange? You can then use the transformative power of Power Query for filter based on all necessary fields, and expand attachments into a structured table. Sharee: Get shared, custom calendar or its events from sharee's mailbox. To inform Exchange that we want to create a Shared mailbox type, we use the parameter -Shared. Power Query Shared mailbox Reply Topic Options BoRaun Frequent Visitor Shared mailbox 05-17-2018 03:06 AM Hi I'm connecting to a shared mailbox. For more information, see Correcting Shared Mailbox provisioning and sizing. Jeff, Is there a way to extract the contact folder of a shared mailbox. I am on Office 365 Business Premium To simplify this table and filter out unnecessary columns for our analysis, we can remove all columns in the table except for the Subject and Date Received columns, and change the Load Settings at the bottom of the Query Settings pane so we load the resulting data directly into the Data Model and not to the worksheet. Note that even if you dont have custom rules and a folder structure to organize your mail, you can also achieve the goal of filtering down to only include emails with a certain recipient in the To line by expanding the ToRecipients column in this table and filtering by email address. I edited the json to remove the metadata and it worked fine. OK, and tell me what credentials you have tried to connect to the shared mailbox: Also, are you populating the UPN in each case with the corresponding UPN for the account you are logging in with? Thank you for the help, Hey there, As per your mentioned description about "Shared mailbox issue-some users not getting emails in the shared inbox". If you use the last version with Office 2013, you can enter the shared mailbox's mail address to Email address field, your UPN (probably your own email address) to the UPN field, and your password to Password field. Note that cross-geo mailbox auditing is not supported. When a group user replies to messages sent to a shared mailbox, the email appears to be from the shared address, not from the individual user. - last edited on Do one of the following: In the Power Platform admin center, select an environment. Contact FAQ Privacy Policy Code of Conduct. Is the mailbox in Exchange on-premise? Go to Solution. There is no fool proof way of distinguishing shared mailboxes from normal users as of now. My account has access to the shared mailbox. - edited Hello, I have an Excel Workbook with which I query an Echange Online shared mailbox. If you want to display a set of mailboxes based on a setting and can't filter on that setting in the Microsoft 365 admin center, do these steps: Find the mailbox property that corresponds to the setting you're interested in by running the command Get-Mailbox -Identity "
Get in Touch: 866.836.8918