web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id : 917/HpulrpmXxr5H/KDtso
Power Automate - Using Connectors
Unanswered

Clarification Needed: Power Automate Workflow for Outlook to Excel Integration

Like (0) ShareShare
ReportReport
Posted on 16 Feb 2024 19:11:36 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:
I have the same question (0)
  • snowflake_ Profile Picture
    20 on 26 Feb 2024 at 17:59:48
    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 22 Feb 2024 at 20:45:44
    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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Telen Wang – Community Spotlight

We are honored to recognize Telen Wang as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Tomac Profile Picture

Tomac 786 Moderator

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 724 Super User 2025 Season 2

#3
stampcoin Profile Picture

stampcoin 290 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics