🚀 Build Your Own “Copilot Prompt Hub” with SharePoint + Power Apps
🚀 Build Your Own “Copilot Prompt Hub” with SharePoint + Power Apps
Tired of keeping your Outlook Copilot prompts in scattered notes or emails?
Here’s a simple way to store, share, and copy prompts across your team using just SharePoint Online + Power Apps.
This no-code solution takes less than an hour to set up and gives your team a central hub for all their best prompts.
🗂 Step 1 – Create a SharePoint List for Prompts
We’ll use SharePoint as our prompt library.
-
Go to your SharePoint site → New → List → Blank list.
-
Name it: CopilotPrompts.
-
Add these columns:
-
Title → Single line of text (prompt name).
-
PromptText → Multiple lines of text (plain text).
-
Category → Choice (Email, Meeting, Follow-Up, Action).
-
👉 Now you’ve got a central place to store all prompts.
📱 Step 2 – Build a Power Apps “Prompt Hub”
Let’s turn this list into a user-friendly app your team can use on desktop, Teams, or mobile.
-
Go to make.powerapps.com → Apps → New app → Canvas app → Blank (Phone).
-
Add a data connection → choose your site → select the CopilotPrompts list.
-
Insert a Vertical Gallery → set Items to:
CopilotPrompts -
Inside the gallery, show:
-
ThisItem.Title -
ThisItem.PromptText
-
📋 Step 3 – Add the Copy Button in Power Apps
-
Insert a Button inside the gallery item.
-
Set Text to:
"📋 Copy" -
Set OnSelect to:
If( !IsBlank(ThisItem.PromptText), If( Copy(ThisItem.PromptText), Notify("Prompt copied!", NotificationType.Success), Notify("Copy blocked by browser/device policy", NotificationType.Warning) ) )
✅ Now, with one tap, users can copy any prompt and paste it directly into Outlook Copilot (or any app).
✍️ Step 4 – Add New Prompts Easily
-
Insert an Edit Form → set DataSource to
CopilotPrompts. -
Add fields: Title, PromptText, Category.
-
Add a Submit button:
SubmitForm(Form1); Refresh(CopilotPrompts)
Now anyone can contribute new prompts to the hub.
🎉 The Result
-
A central SharePoint Prompt Library.
-
A Power Apps Prompt Hub where users browse, search, and copy prompts.
-
One-click 📋 Copy buttons inside Power Apps.
🌟 Why This Rocks
-
Beginner-friendly → no coding required.
-
Shareable → publish the app to Teams or mobile.
-
Scalable → start with a few prompts, grow into hundreds.
Your team now has a Copilot Prompt Hub that makes using AI easier, faster, and more consistent.
👉 Next Level:
-
Add search & filter in Power Apps.
-
Use Power Automate to send a “Prompt of the Day” in Teams.
-
Upgrade to Copilot Studio later for enterprise-scale prompt management.
✍️ engaging when you post it on your automation blog?

Comments
Post a Comment