r/PowerPlatform

▲ 1 r/PowerPlatform+1 crossposts

Claude Code + MCP Might Seriously Change the Way We Build Power Apps

Over the past few weeks, I’ve been experimenting with Claude Code + MCP (Model Context Protocol) while working on Power Apps Canvas Apps, and honestly… it feels different from the usual “AI assistant” hype.

For the first time, it feels like AI is starting to understand the actual context of a solution — not just isolated formulas or snippets of code.

And if you’ve worked on large Canvas Apps before, you already know how messy things can get after a while:

• Tons of screens
• Repeated Power Fx formulas everywhere
• Components depending on other components
• SharePoint / Dataverse integrations
• Multiple flows running in the background
• Security and role logic spread across the app

At some point, maintaining the app becomes harder than building it.

That’s why MCP caught my attention.

Instead of asking AI one small question at a time, the model can start understanding the broader structure of the project — relationships between screens, formulas, flows, APIs, components, and overall architecture.

And honestly, even in its current state, the potential is huge.

I’ve already seen scenarios where it can help:

✔ Understand large apps faster
✔ Detect repeated logic patterns
✔ Assist with troubleshooting
✔ Speed up refactoring
✔ Generate cleaner documentation
✔ Reduce time spent navigating complex solutions

Now to be fair — this still needs a lot of improvement before it becomes truly reliable for enterprise Power Platform development.

There’s still a long way to go when it comes to:

• Deep Power Fx understanding
• Delegation awareness
• Connector limitations
• Architecture decisions
• Environment strategy
• Enterprise-scale best practices

But even with all of that, I genuinely think this kind of workflow can already reduce development and troubleshooting time by 50% or more in many scenarios.

Not because AI replaces developers.

But because it removes a huge amount of repetitive effort and helps developers understand complex solutions much faster.

Personally, I don’t see AI replacing good Power Platform developers anytime soon.

If anything, I think strong architecture and problem-solving skills will become even more important.

The developers who understand performance, delegation, data modeling, and scalable design will probably benefit from these tools the most.

Feels like we’re still very early in this shift… but it’s becoming really interesting to watch.

Curious if other Power Platform developers have started experimenting with MCP or AI-assisted Canvas App workflows yet.

reddit.com
u/sam_ibrahim — 3 hours ago
▲ 12 r/PowerPlatform+3 crossposts

Learning Power Platform? Check This Out 👀

Hey everyone 👋

I recently started a YouTube channel focused on real-world Power Platform content.

I’m currently doing a “100 Days, 100 Problems” series where I solve actual problems from r/PowerApps and turn them into working solutions.

YouTube: connectedbytech

If you’re new to Power Apps, start with Understanding Power Apps Studio

Recently I built a Seat Booking App in Power Apps

Would love feedback and suggestions from the community 🙌

u/apurva96 — 9 hours ago
▲ 19 r/PowerPlatform+1 crossposts

How do you plan a Power Apps project before building?

How do you plan a Power Apps project before building?

I have been working on improving how I plan Power Apps projects before jumping straight into Power Apps Studio.

One thing I have learned is that it is really easy to start building screens too early.

At first, the app seems simple. Then later you realize you need approvals, user roles, notifications, admin screens, reports, permissions, and a better data structure.

So now I try to slow down and answer a few basic questions first.

My simple Power Apps planning checklist

  • What problem is this app solving?
  • Who will use the app?
  • What does each user role need to do?
  • What does the current process look like?
  • What should the future process look like?
  • What data needs to be stored?
  • Should the data live in SharePoint or Dataverse?
  • What Power Automate flows are needed?
  • Who can view, edit, or delete records?
  • How will the app be tested?
  • Who will support the app after launch?

Example

For an equipment request app, I might plan:

Users: employees, managers, admins

Data: requests, departments, request types, approval history

Screens: home, new request, my requests, manager approvals, admin view

Flows: new request email, manager approval, status update, reminder flow

Permissions: employees see their own requests, managers see assigned requests, admins see everything

Helpful Microsoft resources

Power Apps project planning module:
https://learn.microsoft.com/en-us/training/modules/plan-app-project/

Power Apps documentation:
https://learn.microsoft.com/en-us/power-apps/

Power Apps Plan Designer:
https://learn.microsoft.com/en-us/power-apps/maker/plan-designer/plan-designer

Power Platform ALM:
https://learn.microsoft.com/en-us/power-platform/alm/

I am curious how others handle this.

Do you use a planning template, a checklist, a diagram, Planner, Lists, Excel, or do you mostly build as you go?

u/matt-hummel — 20 hours ago

Want to really really learn how to build large scale application with the help of power apps

So I have joined a company as a powerapps dev and they have given me basic training and then just handed over 2-3 projects and I am handling in between them.

When I am at work I am working on one project and at home working on another as deadlines are there I am a little overwhelmed for now (scared too).

I am heavily dependent on claude/gpt but I have no idea what it is doing.

Please can some one help me I want to learn how the things are build, how the data is moving, SharePoint is mapped in the application.

Is anyone here in a similar situation too?

reddit.com
u/onSlaught001 — 1 day ago
▲ 6 r/PowerPlatform+1 crossposts

Schema-Driven CRUD Form Dialog | Downloadable Example App | Quick Guide

Why I Built This Component

After building multiple CRUD apps, repetitive form maintenance became painful:

  • duplicated controls
  • Patch logic all over the place
  • layout inconsistencies
  • hardcoded validation everywhere

Wanted to explore a more configurable + maintainable approach for Canvas Apps at scale.

Downloadable here: https://github.com/KiMi5555/PowerApp_Schema-Driven_CRUD_Dialog

Core Idea

Instead of manually creating forms for every table/entity:

  • define a FormSchema
  • render fields dynamically through a gallery
  • collect standardized FormData
  • Patch normally afterwards

The goal is to make forms:

  • reusable
  • configurable
  • easier to maintain
  • less tied to specific data sources (Source-Agnostic, even Excel)

Current Features

  • Dynamic field rendering
  • Text / Dropdown field support
  • Schema-driven labels
  • Structured FormData output
  • User Defined Form CRUD flow/logic
  • Reusable dialog component

Still WIP:

  • validation system
  • more field types
  • cleaner schema DX

Component Quick Usage Guide

Setup Video Available Here: https://www.reddit.com/r/PowerApps/s/grbYPd2a02

1. Prerequisite (Initial Setup)

In your Own App, ensure:

  • Component is Imported and Inserted (MyComponent)
  • Reorder MyComponent to the FRONT.
  • Gallery of your Data Source (MyGallery)
  • App.OnStart( ) = Set(gbl_IsDialogOpen, false); Set(gbl_DialogMode, "New");
  • MyComponent.Width = Parent.Width
  • MyComponent.Height = Parent.Height
  • MyComponent.Visibile = gbl_IsDialogOpen
  • MyComponent.DialogMode = gbl_DialogMode
  • MyComponent.SelectedRecord = MyGallery.Selected
  • MyComponent.OnEdit = Set(gbl_DialogMode, "Edit")
  • MyComponent.OnDialogClose = Set(gbl_IsDialogOpen, false)

2. Define Your Form Schema

In App.Formulas, define your Form Schema

Example:

MyFormSchema = Table(
    {
        Type: "text",
        Label: "Title",
        Required: true,
        SelectedValue: MyGallery.Selected.Title
    },
    {
        Type: "dropdown",
        Label: "Department",
        Required: false,
        SelectedValue: MyGallery.Selected.DeptCode
        Items: AddColumns( 
                MyDepartmentSource,
                ItemLabel,
                ThisRecord.DepartmentName,
                ItemValue,
                ThisRecord.DepartmentCode,
    }
)

Refer to the Table below to customize your Form Fields.

Param Input Type Explanation
Type "text" // "dropdown" Defines the Field Type. For now, only text & dropdowns are supported. More will be added later on.
Label Text A Unique Identifier for your Field Label/Header. This is also used for LookUp() when using FormData
Required Boolean Whether the Field can be left blank. As of now, is broken and may not work properly. TBC :3
SelectedValue Selected Gallery Item's Property The Data Referred to when Dialog is in Edit Mode.
Items AddColumn( DropDownData, ItemLabel, ThisRecord.<ColA>, ItemValue, ThisRecord.<ColB> ItemLabel = Dropdown Options to Render, ItemValue = Value each Option Holds

3. Pass Schema Into Dialog

The dialog dynamically renders fields based on the schema configuration.

MyComponent.FormSchema = MyFormSchema

4. Custom Form Logic + Centralised FormData

The Form Events OnCreate() / OnSave()/ OnDelete() can be customized to cater to your business needs and requirements.

The FormData can be accessed using LookUp(Self.FormData, Label = "MyLabel").Value

// Sample Code for OnCreate() / OnDelete()/ OnSave()

// OnCreate
Patch(
  MyDataSource, 
  Defaults(MyDataSource), 
  {
    ID: GUID(),
    Title: LookUp(Self.FormData, Label = "Title").Value,
    Department: LookUp(Self.FormData, Label = "Department").Value
  }
);

// OnDelete()
Remove(MyDataSource, MyGallery.Selected);

// OnCreate
Patch(
  MyDataSource, 
  Defaults(MyDataSource), 
  {
    Title: LookUp(Self.FormData, Label = "Title").Value,
    Department: LookUp(Self.FormData, Label = "Department").Value
  }
);

Feedback Please ❤️

Would love feedback / ideas from others experimenting with similar patterns.

u/FreeFoodILike — 1 day ago

Managing AI for end-users

Hi all, for enterprises on E5, from an administration and governance perspective:
- how do you allow end-users to use Copilot Studio, Power Platform, Power Automate with AI Builder, AI Models, and use of models from OpenAI or Anthropic?
- How do you manage the credits, allowing only specific users to certain features?
- Where do we find the “do-not-train-on-my-data-policy” if we select openai or anthropic models? Can we assume that data stays in our tenant? I don’t find it clearly written anywhere.

Edit: I’m very familiar with the OpenAI APIs. However Microsoft is inserting it all over its products, and introducing lots of abstractions with overlapping or ambiguous product and feature names, it is so hard to administer and also prescribe to internal users which features to use. In fact, it is somewhat easier to teach some users how to directly use the openai APIs — at least the token accounting and logging is clear.

Thanks for your help!

reddit.com
u/kayhai — 3 days ago
▲ 2 r/PowerPlatform+1 crossposts

Connection failed: connection not configured for this service

Pretty new to Power Apps but have been enjoying building my first small business app, however I could do with some help if anyone is able to assist.

The app connects to a single in premise SQL server database, reading from a couple of stored procedures and writing to one table (connection via SQL Server Authentication and installed Power Apps Gateway). There are no flows involved.

My tested App is in a dev environment (non default env) within a solution and has been tested on a tablet (android) already and functionality-wise is ready to be used in the business. I need to finalise the deployment side of things but have been struggling to find clear guides on what I need to do.

I've created a production environment, and the app will connect with different databases in dev and production instances. I have 5 per plan licenses already allocated to the prod environment.

I've been struggling with the process for a few days re exporting from dev and importing into prod environment as managed solution and getting the connection references etc working. I've done a lot of googling and used chat GPT but haven't got to a working process yet.

I've got to the point time-wise where I decided, as an interim measure to buy me time to work out the proper ALM process, to import the app into the prod and push live as an unmanaged solution. Once in the prod env then manually removed all the dev database connections from the app and replaced with connections to the prod database.

All works now under my login (premium Power Apps license) in prod environment on desktop, but for the user acct I've shared the app with (tablet based) it's asking to Allow the SQL Server connection each time opening it, and when open it's showing 'CONNECTION DETAILS failed: connection not configured for this service.' when trying to read from a SQL stored procedure, so simply not connecting.

I figure this is the most critical thing for me to resolve currently - I've tried below, but most posts for this error seem to relate to flows which I'm not using:

  • In power platform admin center, granted app users security roles of 'App Opener' & 'Basic User' (diagnostic shows as "User Status: Enabled").
  • Clearing storage and cache of Power Apps app on tablet, re-signing in - numerous times.

I'm almost definitely missing something here so any pointers on what to check/change would be massively appreciated.

reddit.com
u/Confident-Economy432 — 4 days ago
▲ 8 r/PowerPlatform+1 crossposts

Agent Flows Credits

I’m currently testing different approaches in Microsoft Copilot Studio / Power Automate for an email-processing use case (email received → AI extraction → Dataverse record creation).

One thing I noticed is that an Agent Flow seems to consume Copilot Credits even when the logic itself is relatively simple. In my case, the flow includes:

  • AI Builder actions (OCR + prompt)
  • Copilot agent actions
  • Dataverse actions

From what I understand, AI Builder and agent runtime both consume billable Copilot Credits.

My question is:
If I rebuild the exact same process using a standard Power Automate cloud flow instead of an Agent Flow while still keeping the same AI Builder actions would the Copilot Credit consumption be lower?

In other words:

  • Does Agent Flow itself add additional Copilot runtime costs?
  • Or would the billing remain almost identical because the expensive part is mainly the AI Builder / LLM actions?
  • Is it considered best practice today to keep orchestration in standard Power Automate and only use AI Builder / Copilot actions where strictly needed, to minimize Copilot Credit consumption?

For context, my tests showed that calling a Copilot agent from an Agent Flow seems to add extra runtime consumption on top of the AI actions already executed.

Curious to know how others are architecting these solutions in production and how you optimize Copilot Credit costs.

reddit.com
u/PowerPlatformRookie — 4 days ago
▲ 5 r/PowerPlatform+2 crossposts

How can I extract user security role BU and email address

Hi guys, I just want to extract the user name, e-mail, business unit, and security roles. Can I know which xrm toolbox plugin can give me all the details? And please share any YouTube video explaining the process. It will be helpful for me. Thank you

reddit.com
u/villu0777 — 5 days ago

My first end-to-end solution

Hi, everyone!

I hope this type of post is okay.

I have an HR background but am heavily pursuing MS Power Platform. I noticed I felt more energized with this type of work.

Here is a link to my first end-to-end solution... well, a demo of it.. it's a Workplace Investigations Case Management solution: https://www.linkedin.com/posts/forrestmcarthur_microsoftpowerplatform-powerapps-hrdigitaltransformation-ugcPost-7461184041786970112-rVqa?utm_source=share&utm_medium=member_desktop&rcm=ACoAACSZf10BoJeKBW1hmisHcBedC72hArX-RDY

I don't go into all the behind-the-scene details because it is LinkedIn.

However, I would love any initial feedback or if someone wants to discuss the architecture/design decisions.

Kicking myself for not noticing the font editor displaying but I just couldn't get as good of a run as I did on the one with it. :( sad day.

I'm really excited to start my next project, and I am sitting for the PL-200 this upcoming Monday!

reddit.com
u/LiteratureisMyVice — 7 days ago
▲ 3 r/PowerPlatform+1 crossposts

Power BI on MacBook

Hi everyone,

I’m currently doing my master’s in Supply Chain Management, and during this block we’ll be using Power BI. I’ve heard it’s a very useful tool to learn.

However, I’m a MacBook user, and I was wondering how I can install or use Power BI on macOS. Is there a way to download it directly, or do I need to use another method?

Thank you in advance!

#PowerBI #MacBook #SCM

reddit.com
u/Sufficient_Ostrich14 — 8 days ago

Power Platform consultant Big4

Hi all,

After working with power platform for about 6 months where I build a customized Canvas CRM app for my organization I was invited for an interview with KPMG.

Is there anyone with experience in a similar role and enterprise scale Power Platform development and or consultancy? How do you experience this? Would you recommend to go on this career path and where can I grow towards?

Thanks in advance! :)

reddit.com
u/Groovy-Moovy — 9 days ago
▲ 2 r/PowerPlatform+1 crossposts

Power Platform Interview

Hi everyone,

I have an upcoming interview for the power platform developer role with 3+ years of experience next week.

Please let me know if anyone is willing to do a mock interview or share their experience/ resources/ most asked power apps and power automate questions.

Interview is majorly focused on power apps and automate.

I truly appreciate your responses.

reddit.com
u/PurpleProgress7398 — 8 days ago
▲ 10 r/PowerPlatform+1 crossposts

Dataverse plugins suddenly returning Schema Name instead of Logical Name?

Hi everyone,

Is anyone else experiencing strange issues with Dataverse / Dataverse plugins since this morning?

Specifically, it looks like Dataverse may be returning or expecting the Schema Name instead of the Logical Name for some attributes inside plugins. This is breaking late-bound logic that expects column logical names.

Example:

var value = entity.GetAttributeValue<string>("new_customfield");

where new_customfield is the logical name. Since this morning, in some scenarios, it looks like something like new_CustomField — or the schema name equivalent — is being returned/required instead, causing null values, missing attributes, or unexpected plugin behavior.

This seems odd because, according to Microsoft’s Dataverse SDK documentation, late-bound code works with logical names. For example, Entity.LogicalName, AttributeCollection, GetAttributeValue<T>(), IOrganizationService.Retrieve, and metadata properties such as LogicalName are all based on logical names rather than schema names.

Context:

  • Dataverse plugins in C#
  • late-bound entities using Entity, Attributes, and GetAttributeValue<T>()
  • attribute names no longer seem to match what the plugin expects
  • no code changes on our side
  • behavior appears to have changed suddenly this morning

Has anyone else seen this today?

Does anyone know whether Microsoft has rolled out an update, regression, or undocumented breaking change affecting Dataverse / Power Platform plugins?

Any workaround or confirmation would be appreciated.

Thanks!

reddit.com
u/PoetExpert855 — 10 days ago
▲ 17 r/PowerPlatform+1 crossposts

Rolling out Agent Builder before Copilot Studio: how are you gating access without breaking your Citizen Dev environment?

We want Agent Builder broadly available but Copilot Studio limited to a smaller, trained cohort (possibly long-term). The catch is an existing Citizen Development program running in its own default environment that we don't want to disturb.

Has anyone done this cleanly and consistently? Security groups, environment routing, DLP, licensing. What's worked?

Background: when we gave end users the full PP experience out of the gate, adoption and support became a real burden. Trying not to repeat that.

reddit.com
u/DevelopmentVast819 — 11 days ago
▲ 10 r/PowerPlatform+1 crossposts

Power Apps Code Apps + Graph API — Are You Using Them in Production Yet?

Are you using Power Apps code apps in your organization? What’s your experience been like with integrating the Graph API? Interested to hear your thoughts, challenges, and best practices.

reddit.com
u/Independent-Hunt-370 — 10 days ago

Why Nintex Migrations Fail It’s Not the Migration.

Most Nintex migrations become difficult not because of the platform itself, but because old workflows often contain years of layered fixes and undocumented logic.

The smartest teams usually treat migration as an opportunity to simplify and clean up workflows first, then migrate what still delivers real business value.

Once the unnecessary complexity is removed, the actual transition becomes far more predictable and easier to manage.

reddit.com
u/crowcanyonsoftware — 10 days ago
▲ 4 r/PowerPlatform+1 crossposts

Use existing solution as basis for a new solution

I'm lost trying something that i thought would not be so difficult and after Copilot wasn't much help maybe someone here had an idea.

I have a working solution with two power apps, several flows, environmental variables (too distinguish between SharePoint list for DEV and PROD). The solution is undamaged in the DEV and managed in PROD. The solution was developed for Site A and now I want to use it as basis for a new solution for Site B (it will be slightly different but more than 80% will remain the same so i dunt want to build it from scratch).

I wanted to export the solution as unmanaged to the new Site B DEV environment, but Copilot clearly says this is not a good idea and can lead to issues as it sounds like it is not really a completely new instance.

It suggested to export the two apps separately as .msapp files and recreate all flows and tables manually.

Woke i find this ridiculous i have done that but run into issues with missing env variables v(there are solution dependent and I didn't export a solution and also deleted them as data source from the apps but without success).

So my question what is the correct or workable approach to achieve this?

Thanks a lot

reddit.com
u/Florida712 — 10 days ago
▲ 19 r/PowerPlatform+1 crossposts

getting a little fed up and worried

In my company, and in many others, low-code solutions are spreading rapidly. Despite the growing demand, I feel that the company doesn’t take low-code development seriously. They see it only as something “extra,” almost like a part-time responsibility. Having to work on this in my “free time” is really frustrating because I’m never 100% focused on the solutions and architectures, and I end up losing track of some aspects of the work.

Furthermore, nowadays it seems like everyone is a citizen developer. With new tools like Copilot and vibe coding, everyone is creating solutions, which makes me wonder: “Is my development work still necessary?”

At times, I feel like I could be fully dedicated to low-code development and focus entirely on building solutions, but I increasingly find myself questioning the future of low-code development.

Between this and being a technician who works with SQL, Java, MES.. I don't know which would be better for the future.

reddit.com
u/TheWorldIsLost — 14 days ago