Forum Discussion
Tracking Real Time Data from Email send every Friday
Hi damit23183,
Thanks for you reply. Sure here are some official references you can follow for more details:
Role Based Access Control for Applications in Exchange Online | Microsoft Learn
Use Microsoft Viva Insights in Outlook - Microsoft SupportGet Outlook messages in a shared or delegated folder using the Outlook mail API - Microsoft Graph | Microsoft Learn
Quickly grasp key email engagement metrics | Microsoft Learn
Access Shared Mailbox via Graph API - Microsoft Q&A
Thank you.
hello damit23183 ,
you need to use microsoft exchange with an email that has read access on all other emails and get them in a loop in M language.
and you only sign in with the main email that have access to all.
it would look something like this
let
AliceData = Table.AddColumn(
Exchange.Contents("[email protected]"){[Name="Meeting Requests"]}[Data],
"Emails",
each "[email protected]"
),
BobData = Table.AddColumn(
Exchange.Contents("[email protected]"){[Name="Meeting Requests"]}[Data],
"Emails",
each "[email protected]"
),
// Combine only Alice and Bob mailboxes
Combined = Table.Combine({
AliceData,
BobData
})
in
Combined
Thanks for your response.
I tried but didnt work...however one follow up question is without Authirization How would i connect to different email id?
Thanks
Hi damit23183,
Without proper authorization, it’s not possible or permitted. Microsoft 365 and Exchange Online have strong security protocols, so you’d need explicit consent or delegated access to view another user’s mailbox. If you need access to an account like [email protected], you should request your IT or Exchange admin to grant you delegate access or set up a shared mailbox. With the right permissions, you can then use Power BI or Power Query to connect and retrieve the data you need.
For a more scalable solution, consider using the Microsoft Graph API with application-level permissions, which requires an Azure AD app registered by your admin. This is useful for automation and real-time tracking. If your main goal is to track open rates or engagement, it might be better to have management send emails through a platform like Microsoft Viva, Dynamics 365 Marketing, or Mailchimp, as these offer built-in analytics for tracking engagement.
Thank you.Hi damit23183,
We wanted to check if you had a chance to review our last reply. Let us know if it helped or if you need more guidance, we're always happy to help further.
Thank you.Hi damit23183,
As we have not received a response from you yet, I would like to confirm whether you have successfully resolved the issue or if you require further assistance.
Thank you.