Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Using Connectors
Unanswered

Clarification Needed: Power Automate Workflow for Outlook to Excel Integration

(0) ShareShare
ReportReport
Posted on by 20

Hello everyone,

 

I am currently following a tutorial on exporting Outlook calendar events into Excel using Power Automate. The tutorial I am referring to can be found here: https://www.enjoysharepoint.com/power-automate-get-events-into-excel/

https://www.youtube.com/watch?v=eCDL1Ix3aGY&t=296s

 

During the implementation process, I encountered a few differences in the connectors and some challenges that require clarification:

1. Connector Discrepancy:
I noticed that the tutorial is using "Office 365 Outlook" as the connector, whereas I am using "Outlook.com." Could you advise if using "Office 365 Outlook" is mandatory for this workflow, or can "Outlook.com" suffice?

2. Integration Issue with Excel Online (Business):
I have been integrating Excel Online (Business) into my automated flow. However, it shows the problem as the screenshot.
截圖 2024-02-16 19.04.35.png
Initially, I suspected that the absence of files might be causing the connector to fail in locating the location. However, when I attempted to open Excel Online, I received an error message stating: "You cannot access this application because it has been misconfigured. Contact your IT department and include the following information."

Therefore, I seek clarification on whether the flow exclusively supports "business" Excel, which would necessitate purchasing a license.

Additionally, I attempted to import the package (the zip file) for the flow but encountered difficulties with the process. Is there anything I can do with the screenshots?

18.58 2024-2-16的影像 (1).jpg

18.58 2024-2-16的影像.jpg

Thank you for your attention to this matter!!

 

 

 

Categories:
  • snowflake_ Profile Picture
    20 on at
    Re: Clarification Needed: Power Automate Workflow for Outlook to Excel Integration

    Hello @jp_conessa ,


    Thank you for reaching out!

    I'm logging into Power Automate using my personal account, which I've licensed for this purpose. However, my calendar is associated with another personal account where my meeting information is stored.

    Regarding Excel options in Power Automate, I only see two choices: Excel Online for Business and Excel Online (Business). There's no option for Excel Online (OneDrive). If you think it would be easier to manage with a business account for both Office 365 Outlook and Excel, I'm willing to purchase those too. 😊

  • jp_conessa Profile Picture
    11 on at
    Re: Clarification Needed: Power Automate Workflow for Outlook to Excel Integration

    Hi, @snowflake_!

    The account you're using with the connection is a corporate/student account or is it a personal account?

     

    For corporate and student accounts you should use "Office 365 Outlook" and "Excel Online (Business)", but if you're using a personal account you should use "Outlook.com" and "Excel Online (OneDrive)".

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

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 1

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 1

Featured topics