Skip to main content

Notifications

Power Platform Community / Gallery / Copilot Cookbook / New Advent Calendar for 202...

New Advent Calendar for 2023: 25 Days of Copilots

Audrie101 Profile Picture Posted by Audrie101

Welcome to the 2023 Advent Calendar: 25 Days of Copilots

This page will contain all the assets for the 25-day series on Microsoft Copilots, with a strong focus on value-added for the Power Platform. This video series is best for makers who are comfortable working in Microsoft 365, and who are familiar with Power Apps. There is no other prerequisite, so we all can see how copilots will enable every person at home or at work. Bookmark this page using aka.ms/25DaysofCopilots.

Highly recommended context video with Bill Gates:
https://www.youtube.com/watch?v=bHb_eG46v2c


Survey: https://aka.ms/CopilotsSurvey


**BOOKMARK the PLAYLIST** because I have added at least 1 supplemental video per day as a resource recommendation to watch and learn more (doubling the fun)! https://www.youtube.com/playlist?list=PLnFZgEkUYL025DXnMaevLkwULDejAE9Hf 

Daniel's YouTube Channel: https://www.youtube.com/@DanielChristian19

April's YouTube Channel: https://www.youtube.com/@AprilDunnam

Eric's YouTube Channel: https://www.youtube.com/@ericentsie4015

 

Previous advent calendars:
25 Days of Dataverse: https://aka.ms/DataverseAdventCalendar 
25 Days of Flows: https://aka.ms/25DaysofFlows 

During the 25-day period this page will be updated with links to all the videos, resources will be provided, and solutions made available for upload where applicable as well. Therefore, it would be wise to bookmark this page.

****************************************************DAY BY DAY**********************************

***Day 1: Introduction to the 25 Days of Copilot
Enable everyone at work or home to be more successful with Microsoft Copilot features and services. This 25 day series will focus on value-added within the Power Platform, and will highlight scenarios and solutions which you can customize further for your own purposes. The overall goal is to show the 'art of the possible' in a short span of time, but to inspire new ideas for usage. This first video also covers technical pre-requisites for the Power Platform Copilots and AI Builder's GPT-powered opportunities. We look forward to sharing great tips from this panel of experts: April Dunnam, Eric Entsie, Daniel Christian, and yours truly!

Day 1 Resources
Copilot Studio: https://www.microsoft.com/copilot/microsoft-copilot-studio

Copilot for Power Apps: https://learn.microsoft.com/power-apps/maker/canvas-apps/ai-overview

Copilot for Power Automate: https://learn.microsoft.com/power-automate/faqs-copilot

Copilot for Power Pages: https://learn.microsoft.com/power-pages/getting-started/create-page-copilot
Copilot for Power BI: https://learn.microsoft.com/power-bi/create-reports/copilot-introduction

Pre-requisites: https://learn.microsoft.com/power-platform/admin/geographical-availability-copilot

 

***Day 2: Optimizing Work with Copilot in Edge

In this second day of the series I'd like to share a few tips related to the Copilot, previously Bing Chat for Enterprise, found in Edge. In this video I'll also highlight the reasons you might want to use it over just browsing to public ChatGPT services and apps.


IMPORTANT: More detail on the privacy & security advantages: https://www.youtube.com/watch?v=wOSxyQX7Nu4 

Shared tips on to optimize Copilot for work:
1.Summarizing, extracting points, and analyzing browser tabs & pages
2.Composing new content within Microsoft Office Online documentation
3.Analysizing images - in this demo for a Microsoft Excel table which is a bit of a hack
4.Creating images for docs and slides

 

Day 2 Resources:

Sidebar....Copilot Overview: https://www.microsoft.com/edge/features/copilot

Copilot FAQ: https://learn.microsoft.com/copilot/faq

Understanding the superior value of Microsoft 365 Copilot: https://www.youtube.com/watch?v=S7xTBa93TX8

GREAT TIPS to improve AI art results: https://create.microsoft.com/learn/articles/how-to-image-prompts-dall-e-ai

Audrie's favorite copilots for productivity and collaboration applications (shhh, don't tell anyone I have favs):
Copilot for Microsoft Excel: https://www.youtube.com/watch?v=I-waFp6rLc0

Copilot for Microsoft Teams: https://www.youtube.com/watch?v=rLC2frnUasw

Suggested prompts to try out:
--Summarize this PDF (in the browser tab) or web page

--Extract action items from this document or web page

--Write a detailed blog outline with h2, h3, subheadings, and bullet points about [insert topic]

--What are the most common questions asked about [insert topic]. Include acceptable answers.

--Shorten this text [insert email that is too wordy] to under 200 characters

--Ask how to calculate the square root of 144 (or other mathematical expression for details on HOW to calculate the answer)
--Provide tips on improving my LinkedIn profile [or resume]

--Draft 10 interview questions for a person applying for [role]

--Draft a 30, 60, 90 plan for a social media champaign on [product or initiative] in under 500 words

--Create a pencil sketch of a brownstone in Brooklyn, NY with fall colors

--Let's play [topic] trivia!

 

***Day 3: Power Apps Copilot Time Savers for Beginners and Advanced Makers!
Today we're going to discuss copilot as a helpful tool, not only for beginners, but also for intermediate and advanced makers, saving them both time and energy - and adding a bit of fun to their day!

Common Shortcuts for :
1.Planning and Table Design
2.Table and Column Creation
3.Both Model Driven and Canvas App Shortcuts
4.Easily Add Relationships

Day 3 Resources:
Clay and Phil show off the first run experience for brand new users - they make it so fun! https://www.youtube.com/watch?v=f9wPTl-xKyU

 

Overview of Copilot for Power Apps:
https://learn.microsoft.com/power-apps/maker/canvas-apps/ai-conversations-create-app 

 

Prerequisites for AI features in Power Apps:
https://learn.microsoft.com/power-apps/maker/canvas-apps/ai-overview

 

Managed Environments App Descriptions:
https://powerapps.microsoft.com/blog/copilot-now-powers-all-app-descriptions

 

Prompts used for Car Inspections:
1. What columns can I add to improve this table specifically for the inspection of cars at an automobile garage? Please leverage the internet to get typical table columns and formats.
2. Add a column to indicate any payment due.
3. Add a choice column for the selection of follow-up category: Replacement Part Required, Recall, Paint Job, Accident Repair

 

***Day 4: Overview of Power Apps Copilot Options for Apps

In Day 4 of the 25 Days of Copilots we take a closer look at the key opportunities for delightful experiences in our Power Apps applications. A lot this is a quick first-lock, we will have have additional days during this series where we will double-click on each of these later on in the series.

 

A. Copilot for Building Apps (see the two video posts in this playlist for Day 3)
B. Copilot to Edit Apps
C. Optimize Copilot Bots for Apps (and other platforms)
D. Leveraging AI Builder GPT Prompts

 

Day 4 Resources:
General Overview and Pre-requisites: https://learn.microsoft.com/power-apps/maker/canvas-apps/ai-overview

Apps from Conversation: https://learn.microsoft.com/power-apps/maker/canvas-apps/ai-conversations-create-app

AI Builder Text Generation: https://learn.microsoft.com/training/modules/ai-builder-text-generation/

AI Builder Governance White Paper: https://www.microsoft.com/download/details.aspx?id=103317

Editing your app from the Copilot panel:

https://learn.microsoft.com/power-apps/maker/canvas-apps/ai-edit-app

Optimizing bots from Copilot Studio:

https://www.microsoft.com/microsoft-copilot/microsoft-copilot-studio

Daniel's Video on SharePoint Security (Copilot Studio):
https://www.youtube.com/watch?v=F-XHn6RZ6Eg

 

 

***Day 5: Tough Stuff Gets Easy with Power Automate's Copilot!
Today I'm sharing the different things I've enjoyed testing using the Power Automate Copilot! Working at the same booth with MVP Scott Shearer at Ignite, I was inspired by his many insights and demos which I'm sharing with you today too! It's important for us all to keep testing our prompts and provide feedback for orchestration improvements in the community ideas forums so that the copilots will evolve!

If you'd like a live meet-and-greet during the weekend, let me know and we can try to arrange that before the month ends too!

Day 5 Resources:
Getting started with Power Automate Copilot - https://learn.microsoft.com/power-automate/get-started-with-copilot

Full overview videos by Microsoft:

https://www.youtube.com/watch?v=dMrZ96UNsXo
https://www.youtube.com/watch?v=Xu-d3CuhCoc


Add your ideas for improvements:
Power Automate Ideas · Community
Power Apps Ideas · Community

***Day 6: Creating Modern Canvas Apps with Copilot and Power Apps by Daniel Christian
"This video focuses on creating modern canvas apps with Copilot and Power Apps. One of my favorite hobbies is setting up musical holiday lights and that involves several props. I need a way to keep track of all my props. Hence I decided to build me a canvas app using copilot."-Daniel

AudrieMSFT_0-1701873306332.png

 








Day 6 Resources:

Modern controls:
https://learn.microsoft.com/power-apps/maker/canvas-apps/controls/modern-controls/modern-controls-reference

Christian Family Lights YouTube channel (added one of the recent videos to the playlist - SOOOO BEAUTIFUL):
https://www.youtube.com/channel/UCLdNQNNEvidbmaQFkliNisQ

Subscribe to Daniel's YouTube channel to get access to great tutorials and perks. Thank you Daniel for being such a good friend and partner in this amazing Copilot journey!
https://www.youtube.com/@DanielChristian19



***Day 7: Expediting Solutions with Copilot in Model Driven App by Eric Entsie

Embark on a journey to supercharge your model-driven Apps with Copilot! In this must-watch video, we'll guide you through key aspects that revolve around leveraging Copilot for swift and efficient app development.
Eric Entsie MVPEric Entsie MVP

 

 

 

 

 

 

 

 


🔧 Explore the Essentials:

Environment Settings for Copilot: Uncover the foundational steps in configuring your environment for Copilot. Learn how to optimize settings to seamlessly integrate this powerful tool into your development workflow.

Dataverse Table Settings for Copilot: Dive deep into the intricacies of Dataverse Table settings tailored for Copilot. Discover how these configurations pave the way for enhanced data management and app functionality.

Interactions with Copilot: Witness the magic unfold as we demonstrate real-world interactions with Copilot. From generating code snippets to expediting complex processes, Copilot becomes your coding companion.

📋 Detailed Insights: This video isn't just a tutorial; it's a comprehensive guide to harnessing the full potential of Copilot in Model Driven Apps. Whether you're a seasoned developer or just starting, these insights will elevate your app development game.

 

Day 7 Resources:

Using Copilot in Model Driven Apps:

https://learn.microsoft.com/power-apps/maker/model-driven-apps/add-ai-copilot

Model Driven App Components: https://learn.microsoft.com/power-apps/maker/model-driven-apps/add-ai-copilot

Model Driven App FAQs: https://learn.microsoft.com/power-apps/maker/model-driven-apps/model-app-faq

 

Subscribe to Eric's YouTube channel to learn even more! Thank you Eric for helping with this series and sharing your expertise!

https://www.youtube.com/@ericentsie4015

 

***Day 8: The Power of GPT3 in Power Apps by Eric Entsie

Discover the limitless possibilities of integrating GPT-3, the powerful language model, into your Power Apps creations! In this exciting video, we delve into the core concepts that harness the synergy between Power Apps and GPT-3.

🔍 Explore Topics:
Power Apps Idea Icon:
Uncover the significance of the Power Apps Idea Icon and how it enhances collaborative ideation within your applications.

Describe to Show:
Learn the art of describing to show! We explore the intuitive features that enable you to visually represent your ideas within Power Apps effortlessly.

Programming by Example:
Dive into the revolutionary concept of Programming by Example. See how Power Apps leverages GPT-3 to understand and replicate your actions, making app development more intuitive than ever. Train the Model: Witness the magic of training models within Power Apps. Unleash the potential of machine learning to enhance your applications, from image recognition to predictive analytics.

🎓 Educational Insights:
This video is not just a tutorial; it's a journey into the creative possibilities that emerge when the Power of GPT-3 meets the innovative world of Power Apps. Whether you're a seasoned developer or a curious enthusiast, there's something for everyone! 👩‍💻

Hands-On Demonstration:
Follow along as we provide a hands-on demonstration, showcasing how GPT-3 seamlessly integrates with Power Apps to bring your ideas to life.

🚀 Empower your Apps, and elevate Ideas! Don't miss out on unleashing the full potential of GPT-3 within Power Apps!

Day 8 Resources:
Original blog on Power Apps Ideas: 
https://powerapps.microsoft.com/blog/introducing-power-apps-ideas-ai-powered-assistance-now-helps-anyone-create-apps-using-natural-language/ 
Documentation: https://learn.microsoft.com/power-apps/maker/canvas-apps/power-apps-ideas 
Related Video: Let Power Apps Write the Power Fx For You! - Power CAT Live - YouTube

Subscribe to Eric's YouTube channel to learn even more! Thank you Eric for helping with this series and sharing your expertise!

https://www.youtube.com/@ericentsie4015

 
***Day 9: Targeted Data Access for Copilot for Power Apps

Dive into the world of advanced data access control with Copilot! In this enlightening video, we unravel the intricacies of managing and restricting data access, ensuring your Model Driven Apps are not just powerful but also secure.


🔍 Key Highlights:

Why Manage Access to Data in Tables or Datasources:

Understand the critical importance of data access management in your applications. Learn why it's not just about functionality but also about safeguarding sensitive information.

 

Restricting Access Based on Backend:

Explore powerful techniques to control access at the backend. We'll guide you through strategies that empower you to dictate who can interact with your data sources and when.

 

Row Level Access Control:

Delve into the specifics of row-level access control. Witness how Copilot enables you to finely tune access, ensuring users only see the data they are authorized to view.

 

Column Access Restrictions:

Uncover the nuances of column access restrictions. Fine-tune your data visibility by controlling which columns are accessible to different user roles, enhancing data security and compliance.

 

🛡️ Empower Your Data Security Strategy:

This video isn't just about features; it's a comprehensive guide to fortifying your applications. Whether you're building enterprise solutions or personal projects, understanding and implementing these strategies is crucial.

 

👩‍💻 Live Demos:

Join us for practical demonstrations showcasing the step-by-step implementation of these data access control techniques. See how Copilot seamlessly integrates into your security workflow.

 

Day 9 Resources:
Canvas App Copilot Control: https://learn.microsoft.com/power-apps/maker/canvas-apps/add-ai-copilot
Model Driven Copilot Control: https://learn.microsoft.com/power-apps/maker/model-driven-apps/add-ai-copilot

Creating Views in Dataverse: https://learn.microsoft.com/power-pages/configure/data-workspace-views 


IMPORTANT: How to Configure Tables to use Copilot: https://learn.microsoft.com/power-apps/maker/data-platform/table-settings-for-copilot

 

 

***Day 10: Getting your creative juices flowing with AI Builder GPT Models

In today's video we will take a closer look at using AI Builder Models which are powered by GPT in our Power Apps applications. It's super easy to set up, and the expressions are very consistent, making this easy to learn and to do yourself,  no matter how new you might be to Power Apps!

 

Day 10 Resources:

Documentation for AI Builder in Power Apps: https://learn.microsoft.com/ai-builder/azure-openai-model-papp 
Documentation for AI Builder in Power Automate: https://learn.microsoft.com/ai-builder/use-in-flow-overview 
Documentation for AI Builder with SharePoint: https://learn.microsoft.com/ai-builder/sharepoint-overview 
Documentation for AI Builder in Teams: https://learn.microsoft.com/ai-builder/teams-templates 

Managing credits for AI Builder: https://powerusers.microsoft.com/t5/AI-Builder/HOW-TO-Track-model-credit-consumption-with-Power-BI/m-p/2508734#M3716 

RECENT ANNOUCEMENT: Approval Step No Longer Required! (As of 12/19/2023):

https://powerautomate.microsoft.com/blog/ai-builder-gpt-prompts-are-generally-available/

 

***Day 11: Customizing AI Builder GPT GPT Models

Today's video will introduce you to customizing prompts in AI Builder for use in Power Apps. You will learn about designing prompts and adding your own dynamic values (essentially a custom GPT for work). You'll also get a few ideas of usage in your Power Apps solutions!

 

Day 11 Resources:
Documentation: https://learn.microsoft.com/ai-builder/azure-openai-textgen#open-the-prompt-engineering-interface

RECENT ANNOUCEMENT: Approval Step No Longer Required! (As of 12/19/2023):
https://powerautomate.microsoft.com/blog/ai-builder-gpt-prompts-are-generally-available/

 

***Day 12: Keeping the 'co' in Copilot Viable!

Today's short video focuses on a relatively new feature in Power Automate which is intended to facilitate Responsible AI with human-in-the-loop approvals which are targeted to validating GPT generated responses before the processing of them is completed. Take a look at this short presentation of 'why' this is important, and please share your ideas in the Power Apps community. We want to hear your thoughts on whether this is helpful in your company. FYI: Product engineering reviews ideas posted there regularly so rest assured your thoughts will be read!

 

Day 12 Resources:

Documentation:

https://learn.microsoft.com/ai-builder/use-a-custom-prompt-in-flow


Managing credits for AI Builder: https://powerusers.microsoft.com/t5/AI-Builder/HOW-TO-Track-model-credit-consumption-with-Power-BI/m-p/2508734#M3716 

 

Power Apps Ideas Forum (add new, or upvote existing, feedback):

https://ideas.powerapps.com/d365community/forum/f1458c72-ae29-ed11-9db2-000d3a8c451e

 

Reza's video:

https://powerusers.microsoft.com/t5/Webinars-and-Video-Gallery/How-to-use-NEW-Approval-of-Text-action-in-Power-Automate/td-p/2272955 

 

 

***Day 13: Copilot Knowledge Repositories (Internal/External Audiences)
Today's video discuss a common business problem which is to find information in an ocean of information. Whether it's in support of the employee workforce, or for the customer-facing website, either way we reduce the need for the trial and error related to simple 'keyword search' and constant 'context switching'. I'm using a very well designed website as an example (so it's not hard to find stuff there), but it does help to demonstrate how generated answers from a copilot conversation differs from keywoard, menu, or filter based searches.

 

Key takeaways:

  • Configuration 4:00
  • Asking human-like questions that show off the value of GPT powered copilots 14:15
  • Troubleshooting conversation triggers and topics  15:00

 

The prompts we used (test it out on your own too):

  • Good morning I would like to buy a pen for my daughter but I'd like to spend less than $50. Please suggest 5 pens in that category for a new user.
  • Is the TWSBI 580 difficult to clean?

 

Day 13 Resources:
Documentation: https://learn.microsoft.com/microsoft-copilot-studio/nlu-boost-conversations 
Copilot Studio value opportunities: https://www.youtube.com/watch?v=_NICbozG0i0 

 

***Day 14: Amazing Picture Opportunities with Copilot in Edge!

In today's video we will take a closer look at how Copilot in Edge helps us create visuals in support of messaging a concept or company, for clarity in PowerPoint presentations, as well as to create fun and inspiring training images with memorable lessons to be learned!  

 

Key takeaways :  Think out of the box and forget any limitations you've had in the past for:

-Logos

-Banners

-App Icons

-Comics

-Presentation Visuals

-AI Generated Photography ("photo-realistic" is a good prompt style to remember, but you can also do 'watercolor', 'pencil sketch', and many others!)  

 

Prompts used for images:

-Create a simple vector style logo for a new company named "Coffee Friends" using only 2 colors with very high contrast.

-Create an artistic but vector styled logo focused on the letter A, and highlighting they predict the weather in a fun way. 

-Create a comic strip image in the style of Charlie Brown that makes a funny joke about rainy days.

-Create a poster in the style of the movie Mission Impossible for a geeky men's magazine cover.

-Create a banner for my YouTube channel. My channel focuses on reviewing modern kitchen gadgets.

-Create a photo realistic title slide image for a presentation about climate change (tips in video on aspect ratio).

 

Documentation: https://www.microsoft.com/en-us/edge/features/copilot?form=MA13FJ

 

Make your own holiday masterpiece:

https://www.youtube.com/watch?v=KYqu359oY6o

 

Image Creator:
https://www.bing.com/images/create 

 

Dall-e Documentation (built into Microsoft 365 Office Copilots and Copilot for Edge/Bing.com):

https://openai.com/research/dall-e

 

EXTRA Microsoft videos for each day can be found in the YouTube playlist here:

https://www.youtube.com/&list=PLnFZgEkUYL025DXnMaevLkwULDejAE9Hf

 

 

***Day 15: Creating Low Code Chatbots with Copilot Studio by Daniel Christian

In today's video Daniel Christian focuses on creating low-code chatbots with Copilot Studio. This demonstration shows exactly how easy it can be to create a custom copilot for managing product selection across preferred suppliers!  

 

Introduction 00:00
Create Copilot using websites 00:40
Create Copilot using description 04:17
Conclusion 08:00 

 

Day 15 Resources:
Copilot Studio: Generative answers - Microsoft Copilot Studio | Microsoft Learn

FAQs: FAQ for generative answers - Microsoft Copilot Studio | Microsoft Learn
Creating Modern Canvas Apps with Copilot and Power Apps - https://www.youtube.com/watch?v=o9icwWiMCoA   (inventory app)

Creating Bot Icons: Image Creator (microsoft.com)

 

Supplier links:

Boscoyo Studios – boscoyostudio.com
Wally's Lights LLC – wallyslights.com

 

Additional references:
Jingle Bells 7 by Kevin MacLeod is licensed under a Creative Commons Attribution 4.0 license. 
Artist: http://incompetech.com/

 

***Day 16: Create an entire website with Copilot for Power Pages!

Today's video shows how simple it is to build an entire website just working with Copilot and tweeking the results with a few simple point and click operations! Website building has never been easier!

 

Day 16 Resources:

Documentation - https://learn.microsoft.com/power-pages/getting-started/create-page-copilot
Create a Developer Environment: https://aka.ms/DeveloperPlan 

Related Microsoft Video - https://www.youtube.com/watch?v=wf3ONsQENt0

 

Full 25 Days playlist with extra video content:
New Advent Calendar! 25 Days of Copilots (youtube.com)

 

***Day 17: Building Forms over Data with Copilot for Power Pages!

Today's video shows how simple it is to build forms over data using Power Pages Copilot. We will create a form, iterate through the needed fields, add an attachment field and permission it anonymously.

 

Day 17 Resources:

Documentation:
https://learn.microsoft.com/power-pages/getting-started/add-form
https://learn.microsoft.com/power-pages/getting-started/multistep-forms
https://learn.microsoft.com/power-pages/security/table-permissions
https://learn.microsoft.com/power-pages/

 

Create a Developer Environment:
https://aka.ms/DeveloperPlan

 

Related Microsoft Video:
https://www.youtube.com/watch?v=wf3ONsQENt0

 

***Day 18: GPT Powered Models on your Smart Watch!

In today's video we will be talking about GPT powered content notifications that show up firstly on your own Smart Watch, but ultimately can be pushed to anywhere such as email, Teams, or even other applications. This is a fun one where I focused on my own Growth Mindset and Wellness, and then thought about how this might be used to draft content for family, friends, and even work colleagues. I've been working to overcome a bit of phone addiction, by replacing many simple needs with concise notifications and widgets on my watch. I have actually managed to leave my phone at home! Have you tried this? I bet you can come up with even more scenarios and ideas for refinements!
 

Day 18 Resources:

 

AI Builder GPT Models:
https://learn.microsoft.com/ai-builder/azure-openai-model-papp 

Azure OpenAI Options:
https://learn.microsoft.com/azure/ai-services/openai/overview 

 

Power Apps Example:
https://techcommunity.microsoft.com/t5/ai-machine-learning-blog/azure-open-ai-gpt-with-power-apps-build-a-power-app-to-create/ba-p/3730864 


Configuring Apple Watch Notifications

 

 

***Day 19: Use Excel in Copilot Studio by April Dunnam

Copilot Studio makes it easier than ever to create your own AI-powered Copilots. In this video, April Dunnam will demonstrate a use case for creating a Copilot to help you with holiday gift ideas. You'll see how to use data from Excel in your Copilot and how to pull data from public websites so that the generative AI can answer questions about your data.

 

April DunnamApril Dunnam

 

Day 19 Resources:
Try a demo of Copilot Studio: https://web.powerva.microsoft.com/tryit 
Read the Documentation: https://aka.ms/april/copilotstudio 

Follow April's Copilot Chronicles series here.

 

***Day 20: What's a Prompt Catalog and how do you build one? by April Dunnam

The more that you use generative AI, the more it becomes important to have a central place to store and manage your AI prompts across all the tools you're using (ChatGPT, Microsoft Copilot, Midjourney, Power Automate Copilot, M365 Copilot, etc).

In this video, April Dunnam explains the importance of having a prompt catalog and goes over ways that you can create one yourself!

April also gives us the gift of a pre-built Power Apps template, which is available as a free download from the Power Platform Sample Library here: https://aka.ms/promptmanager!

 

Day 20 Resources:

https://aka.ms/PowerPlatformPrompts 

https://aka.ms/promptmanager 

 

 

***Day 21: Recent Announcements on AI Builder GPT Models

Today we'll share the two most recent announcements related to the AI Builder GPT Models (also see Days 9 and 10).

 

Day 21 Resources:

Announcement Blog - https://powerautomate.microsoft.com/blog/ai-builder-gpt-prompts-are-generally-available/

 

Documentation:
Try Prompt Builder: https://aka.ms/tryprompts 
Prompt Engineering Guide: https://aka.ms/promptguide 
Documentation: https://learn.microsoft.com/power-automate/use-ai-builder 

Previous 25 Days Video on Customizing GPT Models:
https://www.youtube.com/watch?v=DmIE8s_6tUw 

Side point relatfed to Power BI Copilot (originally planned for Days 21 and 22):

Find more on Power BI Copilots coming later in the new year. Here is a helpful video in the meantime:
https://www.youtube.com/watch?v=wr__6tM5U6I 

 

 

***Day 22: The Power of the chatbot control in Power Apps (tips and reminders)

Today we'll talk about the reasons you may choose to insert the copilots you have made in Copilot Studio directly into your Power Apps applications. We want to understand the differences between the App copilot control, the Maker copilot control, and the Chatbot control so that we can select the right control for our purposes. These will evolve, so do expect this to become more and more awesome!

 

Day 22 Resources:
Adding a chatbot to Power Apps:

https://learn.microsoft.com/power-apps/maker/canvas-apps/add-ai-chatbot

 

Copilot Studio Documentation:

https://learn.microsoft.com/microsoft-copilot-studio/

 

Copilot Authentication for SharePoint Documentation:

https://learn.microsoft.com/microsoft-copilot-studio/configuration-end-user-authentication

 

Daniel's Video on SharePoint Security (in Copilot Studio):
https://www.youtube.com/watch?v=F-XHn6RZ6Eg

 

Copilot Studio Community:

https://powerusers.microsoft.com/t5/Copilot-Studio-Community/ct-p/PVACommunity 

 


***Day 23: The Microsoft Copilot Studio Implementation Guide

Appropriately as we approach the end of the advent calendar for Copilots, we'd like to annouce the Copilot Studio Implementation Guide. During this series you were able to see small snippets of the high value of Copilot in Power Platform scenarios. So, by popular demand, we have released a guidebook in the form of a workshop which you can deliver in your own environments to optimize for wins with your own copilots! In it you'll find valuable lessons learned, best practices, and architectural guidance. We are convinced that this will be high value to many looking for the productivity, efficiencies, and engagement advantages typical to copilots today! Please share your feedback at the aka.ms link below!

 

Day 23 Resources
Annoucement Blog:

https://microsoftcopilotstudio.microsoft.com/blog/new-microsoft-copilot-studio-implementation-guide/ 


The Downloadable Guide:

https://aka.ms/CopilotStudioImplementationReview 

 

Share your feedback:

https://aka.msCopilotStudioImplementationGuideFeedback 

 

 

***Day 24: Understand Copilot Scopes, Skills, and Mitigation Layers
In today's video we'll bring it all together in a way that can help you understand the variance in responses you get when you work in ChatGPT or Bing Chat, versus using a PowerPoint or Power Apps Copilot, versus a chatbot from Copilot Studio, or AI Builder. What makes the difference? What protective measures are implemented? Most importantly - what are the factors that help YOU decide what to use and when to make your own copilot!?

Side Note: Correction: The term "GPT powered" really refers to the ability to generate responses from natural language (available in all cases)....but that's not about the data sources they access (which you may think from the way I say that in the video). However, you'll see that the 'internet' is not a data source for most product copilots - as they are scoped to the task at hand and instead use Microsoft Graph rather than internet data (aka: Teams, PowerPoint, Excel, Power Apps built-in Copilots). However, in Copilot Studio you can mash up approaches to extend M365 Copilots, leverage other data sources, and further filter or constrain reponses coming from the internet.

Concept question: Where do you see copilots going in the next 5 years? next 10 years? Where do you want to see it go? Post your answers below by clicking the "Reply" button!

Full video playlist includes EVERYONE's videos plus extra Microsoft Videos:
https://www.youtube.com/playlist?list=PLnFZgEkUYL025DXnMaevLkwULDejAE9Hf 


***Day 25: Overview of Advent Calendar Resources


Solution downloads will progressively be added this folder for your convenience.

Please download the Copilot Studio Implementation Guide: https://aka.ms/CopilotStudioImplementationReview 

 

The AI Art Challenge: use hashtag #AIArtMemory and #PowerAddictsAI
(I plan to create a raffle from everyone's submissions since I have a final gift to give out to Power Addicts!)
(1) Audrie Gordon on X: "Wishing your day is fabulous and you are surrounded by friends, family, and plenty of love! Try creating a family memory with AI, it's fun! I created mine remembering the Macy's displays in NY. MS Video: https://t.co/4z0OwZz04b… via @YouTube #AIArtMemory #PowerAddictsAI https://t.co/zkm6t5ydXv" / X (twitter.com)

 

Enjoy your holiday season, and wishing you all the best for the new year!
Your ArtsyPowerApper!

Audrie

 

Categories:

Canvas Apps Featured

Comments

*This post is locked for comments

  • Laxman Profile Picture Laxman 2
    Posted at
    New Advent Calendar for 2023: 25 Days of Copilots

    Dear All,  Copilot Authentication for SharePoint :  I am exploring options to limit and reduce security by restricting API permissions scope to particular sites(Site. Selected) instead of granting complete tenant-level access. Have you come across any leads on this approach? https://techcommunity.microsoft.com/t5/microsoft-sharepoint-blog/develop-applications-that-use-sites-selected-permissions-for-spo/ba-p/3790476 

  • dbmamaz Profile Picture dbmamaz 19
    Posted at
    New Advent Calendar for 2023: 25 Days of Copilots

    Just want to say I've been watching this video series (but putting off starting to study for the PL-100) and I really love it! It give a really broad understanding of the possibilities here.  This kind of overview will stick with me so if I ever get a chance to use these copilots, I will at least know what to look for, know what to consider.