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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Clarification Needed: ...
Power Automate
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:
I have the same question (0)
  • jp_conessa Profile Picture
    11 on at

    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)".

  • snowflake_ Profile Picture
    20 on at

    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. 😊

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

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Vish WR Profile Picture

Vish WR 376

#2
Valantis Profile Picture

Valantis 361

#3
David_MA Profile Picture

David_MA 294 Super User 2026 Season 1

Last 30 days Overall leaderboard