Blog Post

Microsoft 365 Copilot Blog
3 MIN READ

The Great Copilot Journey: Now Available through Power Automate

KristinGinn's avatar
KristinGinn
Icon for Microsoft rankMicrosoft
Jul 02, 2025

Are you responsible for launching Microsoft 365 Copilot within your organization and tasked with ensuring your teams don’t just have access, but actually embrace and benefit from Copilot? As an IT leader or decision maker, you know that rolling out new technology is only half the battle; the real challenge lies in sparking genuine interest and user adoption. 

That’s exactly where the Great Copilot Journey comes in. It’s a guided, interactive program that can help your organization unlock the full potential of Copilot, one prompt at a time. And it’s now available as an open-source solution for Microsoft 365 Copilot and Copilot Chat that’s ready to be used with minimal manual effort. 

How does the Great Copilot Journey work?  

The Great Copilot Journey is an engaging onboarding and skill-building resource you can use to help your team learn how to achieve more with Copilot. Over the course of 30 days, participants receive an easy-to-follow prompt every day, each crafted to introduce and reenforce Copilot’s core capabilities. From saving time and kickstarting work, to improving collaboration and leveraging agents, the experience is structured to inspire users and build confidence step-by-step. A 20-day extension pack is also available to create a 50-day experience.  

By creating small successes with Copilot every day, users not only gain proficiency with Copilot, but also develop new, more productive habits for leveraging AI assistance in real-world scenarios.  

Accelerate Your Copilot Rollout with Power Automate and SharePoint 

Now available as an open-source Power Automate flow, you can deliver the Great Copilot Journey prompts directly to your users via Teams or email with minimal manual effort. It’s a plug-and-play solution built on Power Automate and SharePoint that brings the experience to life in a scalable, trackable and customizable way.  

Execute the Great Copilot Journey with Power Automate 

The new Power Automate flow significantly enhances and facilitates the setup and execution of the Great Copilot Journey. It minimizes manual effort by automatically retrieving and distributing your customizable Copilot prompts from a curated SharePoint list, while ensuring dependable delivery and operational consistency. Key features include: 

  • Effortless Scheduling: The workflow runs automatically every workday at your specified time, defaulting to 9:30 AM CST, with easy customization options. 
  • Seamless Retrieval and Content Generation: This solution collects key variables and prompts from your SharePoint list and automatically generates an adaptive card for Teams and formatted HTML email. 
  • Unwavering Delivery Assurance: Send your daily emails and Teams messages reliably according to your predetermined settings. You can also test your messages prior to launch, and triggered alert emails will notify your admin should any issues arise during information retrieval or delivery. 

With this streamlined process, you can focus less on logistics and more on empowering your teams to make the most of every day with Copilot. 

Scale and Customize your Great Copilot Journey with SharePoint 

Whether you want to leverage the curated prompts of the Great Copilot Journey or customize the daily messages for your team, this new import-driven approach empowers you to tailor the experience to fit your organization’s needs. The Excel file included in this resource is already formatted to align with SharePoint’s import schema to allow for a seamless import and direct connection to the Power Automate flow. SharePoint’s native list features allow you to easily edit, configure or localize the prompts, links, images and metadata of your messages to give your users exactly what they need.  

SharePoint also allows you to collaborate with members of your team while giving you peace of mind with version history and permission controls that allow you to audit or revert changes if needed.  

Start Your Journey Today 

Are you ready to transform the way your team works? Download this automated resource today and set your organization’s Great Copilot Journey in motion! Choose from the experience that best meets your needs: 

  • Download the experience for Microsoft 365 Copilot: If your teams have Microsoft 365 Copilot licenses, this version is for you. It will help guide your users through what’s possible with Copilot across Microsoft 365 apps like Word, Outlook, Teams, PowerPoint and more. 
  • Download the experience for Copilot Chat: This edition is right for you if you want to start your AI transformation using Copilot Chat, the free chat experience for Microsoft 365.  

Start your journey today and help your team make using Copilot a daily habit and experience what’s possible with AI, one prompt at a time. 

Updated Jun 30, 2025
Version 1.0

19 Comments

  • Usmaan's avatar
    Usmaan
    Copper Contributor

    following instructions now, lets see how it goes.

  • Elin_Rabe's avatar
    Elin_Rabe
    Copper Contributor

    Interesting! Is there an easy way to get this in other languages than english? I work with Norwegian companies and user adoption tend to be easier when in their own language. 

  • KamBrzezinski's avatar
    KamBrzezinski
    Copper Contributor

    I've tested the channel adaptive card and it's not formatted properly on my side, for anyone else encountering this issue, you can paste and edit the card easily using https://adaptivecards.microsoft.com/designer

    • AnthonyEscobedo's avatar
      AnthonyEscobedo
      Icon for Microsoft rankMicrosoft

      Thanks for the nudge! Feel free to ping me on the side or on LinkedIn to chat more about this! I haven't had this come up through testing but happy to assist if there's anything you're hung up on

      LinkedIn: Anthony Escobedo | LinkedIn

  • mjackson42's avatar
    mjackson42
    Copper Contributor

    I'm trying to set this up using the instructions in the "Great Copilot Journey - Installation & Configuration" PPTX. The second slide shows an overview of the process, but the pages with expanded instructions skip point 4, Configure, entirely. Thus, there are no guidelines for the "Configure Dates for Journey to run (SharePoint List)" portion from the overview, so if you attempt to run the cloud flow manually to send the daily emails, it does not find anything to run. Is something supposed to configure the run dates in the Sharepoint list for you, or are you supposed to fill in the dates manually?

    • KamBrzezinski's avatar
      KamBrzezinski
      Copper Contributor

      When importing this table to a SharePoint list, define the 'PromptDate' column as a 'Date & time' column type, then set the dates manually. This enables you to choose when to send each prompt (the logic in the flow is IF the date in the column matches today's date, THEN send the prompt). I'd recommend using the 'Config - Test activated' with the 'Default value' set to 'Yes' the first time you run it, just so you can see if the flow is working properly. The guide would be much easier to follow if it was a video, also a lot less work to put it together :)) - I'm not the flow creator, or an MS representative, so please don't chase me after this ;)

      • AnthonyEscobedo's avatar
        AnthonyEscobedo
        Icon for Microsoft rankMicrosoft

        Impressive Kam! Thank you for the great details! 

        We made a video but found it may have been overly complex whereas the ppt kept things simple. 

        I'll take a look at the PPT based on the feedback here and update as necessary! 

        Feel free to ping me on LinkedIn if you get stuck! Anthony Escobedo | LinkedIn

  • bdsimpsn's avatar
    bdsimpsn
    Copper Contributor

    Is there a version of the solution we can import for weekly emails instead of daily? Or instructions on how to modify this to send like the weekly .oft files?

    • KamBrzezinski's avatar
      KamBrzezinski
      Copper Contributor

      set the 'PromptDate' column to dates spread weekly, the flow logic runs every day (this can be changed in the trigger, but not required), and simply looks if the today's date and PromptDate match to send the email/channel message.

      • AnthonyEscobedo's avatar
        AnthonyEscobedo
        Icon for Microsoft rankMicrosoft

        Nailed it! The weekly emails with the summary of prompts are in the original link for the Great Copilot Journey but we did not build this flow to send the weekly emails but specifically for the daily emails. Having said that, it's simple to modify to meet your needs for the weekly emails. I did a quick test and it worked well. Copy the body of each of the emails into the sharepoint list and it should work with minor tweaks! 

        Let me know if you need some hands on time and I could talk you through it!  Ping me on LinkedIn >>> Anthony Escobedo | LinkedIn

  • jeffreynormore's avatar
    jeffreynormore
    Copper Contributor

    If you want to modify a prompt, is there a way to modify the url to also auto-populate that prompt like how it is in the example? I.e. if we change translate this to japanese to french, wanting it so that if you click the url the updated prompt shows instead.

    • KristinGinn's avatar
      KristinGinn
      Icon for Microsoft rankMicrosoft

      Hi jeffreynormore​,

      You can save prompt and share them with people in your company. The easiest way to generate those links is to

      1. Open Copilot Chat
      2. Submit your prompt
      3. Once Copilot gave you a response, hover over your prompt and click the "copy prompt link" on the right
      4. That's the link you can insert in the email

      If you have users outside of your tenant, that link will not work for them and it will only open Copilot Chat without the pre-populated prompt. 

      I hope this helps. 

      • AnthonyEscobedo's avatar
        AnthonyEscobedo
        Icon for Microsoft rankMicrosoft

        Doing something like what you mentioned could be an easy way to repurpose the Great Copilot Journey with custom prompts like you're talking about while still taking advantage of the marketing pieces and templates supplied with the GCJ. I experimented with this but haven't created a program around it yet. Let us know your thoughts! 

  • KamBrzezinski's avatar
    KamBrzezinski
    Copper Contributor

    awesome work, thank you!

    While I know how to import this solution to Power Automate, you might want to write a little guide for less technically skilled adoption managers ;)

      • JenniferAbler's avatar
        JenniferAbler
        Copper Contributor

        Is the guide available yet?  I'd love to have a step-by-step guide!