Skip to main content

Notifications

Community site session details

Community site session details

Session Id : UM8OEtuSJyvCazCCUf5XRP
Power Apps - Building Power Apps
Unanswered

Create a daily report from mailbox Outlook

Like (0) ShareShare
ReportReport
Posted on 25 Jan 2024 21:31:27 by 24

Hello Experts,

 

As a beginner user - I'm looking to create a flow with the below request:

 

Create an end of day powerbi or excel report from outlook -mailboxes and have it sent it to individuals.

 

How can I achieve this?

  • geeklarokcmie Profile Picture
    24 on 26 Jan 2024 at 15:56:50
    Re: Create a daily report from mailbox Outlook

    Could you please share me a sample flow to understand the expressions and the details that follow?

  • Bartelli Profile Picture
    75 on 26 Jan 2024 at 15:45:58
    Re: Create a daily report from mailbox Outlook

    The trick with getting this information is access. If you don't have access to the email, you won't be able to pull this information.

     

    I would start with the trigger, Office 365 Outlook: when a new email arrives(v3), get the email(v2) step, then either create an excel workbook to log the email or have the email logged to a SharePoint list. That way you can get a count and create a dashboard from any of those applications or using PowerBI.

     

    Let me know if this helps, thanks!

  • geeklarokcmie Profile Picture
    24 on 26 Jan 2024 at 15:25:04
    Re: Create a daily report from mailbox Outlook

    Appreciate your response, Bartelli.

    Below are my needs for reporting on a daily basis -

    1) number of emails received to three different mailboxes per day to certain users (ex: johndoe@microsoft.com, janedoe@microsoft.com)

    2) total number of users and their email addresses sending requests to three different mailboxes

    Thank you. 

  • Bartelli Profile Picture
    75 on 25 Jan 2024 at 22:40:57
    Re: Create a daily report from mailbox Outlook

    What would you be reporting? 

    -the number of emails with attachments?

    - a list of all emails sitting in the inbox?

    Give me an idea of what the report would consist of - power automate may be the answer.

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

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Apps - Building Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 89 Most Valuable Professional

#2
MS.Ragavendar Profile Picture

MS.Ragavendar 60

#3
stampcoin Profile Picture

stampcoin 48

Overall leaderboard