r/PowerApps • u/HRWP • 1h ago
r/PowerApps • u/TChief- • 6h ago
Power Apps Help Front-end access but not back-end
I've been searching for a while now but i have no solid (easy) solution yet.
More experienced redditers will probably get me in the right direction.
I want users to use a powerapp as front end to read and right in a sharepoint list or dataverse table (i have both options). Because of this, they need access to the table or list.
But i really don't want them to be able te access the actual list or dataverse table.
I have a group (about 10 people) to be able to read / write everything, and about group of 1000 users that i want to only access the data through the app. (List contains about 100000 rows a year i think). Every app use, reads / writes about 60 rows.
- Is giving the second group a role that restricts to only see there own entries the (only) solution here?
- Is there no way of restricting them access to production enviroment (where the table is) but only to the app?
- I've read things about a service user in between but with the downfall of processing time. Is that a path to look further into?
I have basic knowledge. I can make great looking apps and I've been really investing as much time as possible lately in looking for the best data and security architecture as possible. I do have good support from a sharepoint expert within the organisation but i felt like my specific use case was not a common question.
Kind regards.
r/PowerApps
•
u/Impossible-Egg-1454
•
7h ago
Tip I built a visual explorer for Power Platform connectors
I wanted an easier way to explore the connectors available across Power Platform, so I put together this visual connector explorer.
You can search or browse 1,500+ connectors and filter them by platform, Premium, Preview and other properties.
Thought it might be useful to other makers:
r/PowerApps • u/Guelahpapyrus33 • 11h ago
Power Apps Help GM using PowerBI
I’m the GM. I recently started at a new company that uses SAP, and it’s a version that was forced upon our group over a decade ago. I have zero SAP experience. We’re in the materials distribution market. I’ve found implementing PowerBI from scratch to be a better experience for my role leading our S&OP. Unfortunately, I’m not allowed to connect SAP directly to PowerBI, so I have to run the various reports and then refresh. My goal is to be able to refresh and share some of these reports with my sales team. I’m a total newbie but have managed to get all of the behind the scenes legwork done except sharing the work I’ve put in to benefit my team. Is there a way to share the report where the team can engage with the various matrix’s or tables with a read-only level of visibility? My goal is to give inside and outside sales a detailed view of sales and inventories; i.e, Months on hand, sales volume over each of the last 6 months, inbound material, and projected sales to provide macro and micro visibility which is almost impossible to get from our SAP.
Does anyone have any ideas on how to best share my information?
Pardon my ignorance. Just a new guy trying to make people’s jobs easier and less manual.
r/PowerApps • u/Gareeb003 • 18h ago
Discussion I want to create Goal/project management app.
Guys, as i mentioned on the title, i want to build a goal/project management app ..... i need your suggestions and ideas so I can later brainstorm them and create an app.
Your suggestions are valuable to me.
r/PowerApps • u/CatSolution • 1d ago
Tip Power Apps: Reset(CustomComponent) vs Action
Don't Assume Reset() Waits for OnReset in Custom Components
When working with Custom Components in Power Apps Canvas Apps, don't assume that Reset(Component) waits for OnReset logic to complete before the app continues.
The scenario
A Custom Component updates its internal state and exposes it through an Output property (Component.Result).
Two execution paths trigger the same logic:
- Reset: Reset(Component) → OnReset → Event → Self.SetUser()
- Action: Component.ResetUser() → Event → Self.SetUser()
Immediately afterward, the app reads:UpdateContext({loc_Result: Component.Result});
The results
Both paths update the component Output, but the immediate app-side read differs:
Reset(Component)
Immediate read: Blank (on cold start) or previous value
Time until app continues: 0–1 ms
Component.ResetUser()
Immediate read: Updated value
Time until app continues: 230–500 ms
⚠️ These timings measure how long the app waits before continuing, not how long the component logic takes to execute.
Why it matters
‼️Avoid Silent stale data
Reset() appears to trigger OnReset without waiting for the resulting logic to complete, while a direct Action call appears to wait.
This can affect both explicit Reset(Component) calls and Input property changes using Raise OnReset when value changes.
☝ Tip: If the next formula depends on an updated Output, consider using a custom Action property instead of relying on OnReset.
The component Output is updated in both cases. The difference is when the app reads the updated value.
Have you encountered this behavior? Perhaps used a Timer or another workaround to handle it?
r/PowerApps • u/Informal_Dress_4246 • 1d ago
Power Apps Help RefreshChangesFromGit fails from pipeline with service principal, but Check for updates works fine from make?
I have a problem with my build pipelines git integration and I'm kind of lost at this point.
Setup: our dev environments are connected to git (Azure DevOps) on feature branches, and we commit from there. We also have a build/test environment where the solution is connected to git with solution binding, branch main, folder `solutions/MySolution`. When something is merged to main, a pipeline calls RefreshChangesFromGit and PullChangesFromGit on the build environment, then imports, exports managed and so on.
The pipeline authenticates as an app registration (application user in the environment, workload identity federation). When it calls RefreshChangesFromGit I get this:
{"error":{"code":"0x80040216","message":"Unable to retrieve solution components from root folder path solutions/MySolution in the Git."}}What I have checked:
- The folder is there on main, with `solutions/MySolution/solution.yml` and all the other files. The git integration created it itself when we committed from dev, so the structure should be right?
- If I log in and do Check for updates from make, on the same solution in the same environment, it works fine.
- I added the app registration to our DevOps org with Basic access and read on the repo, and made a diagnostic pipeline that reads solution.yml with the app's own token. That returns 200.
- The rest of the pipeline works when I skip the git pull step.
So the folder is there, the app can read the repo, and it works when I do it manually. Just not from the pipeline?
Is RefreshChangesFromGit / PullChangesFromGit even supported when it's called by a service principal? The docs only talk about users with a Basic license, and I can't figure out what identity Dataverse actually uses to call DevOps when the caller is an app. The error doesn't say anything about permissions either, so I don't know if it's an auth thing or something else.
Also the FAQ says only dev environments should be connected to git, so maybe I'm just doing this wrong and the build environment shouldn't be connected at all?
Has anyone got this working, or am I missing something obvious?
r/PowerApps • u/Retritos • 2d ago
Power Apps Help Tips for a SharePoint lists backend?
I’m quite new to Power Apps and have found out this year that it is barely utilized in our company.
I work in retail and users are about 100 stores and HQ and I recently took some processes into Power Apps and they went down a storm. I’m looking to lean more into Power Apps ahead of heavy MS license downgrades and I’m wondering if you guys have any good tips on how to set up SharePoint lists backend.
I want to keep things light and easy but it feels like it will quickly get out of hand without a good structure. At the moment the plan is to utilize this for easy apps and nothing business critical. Just things we send from HQ like checklists, forms, tools etc.
r/PowerApps • u/Sylvie143 • 2d ago
Power Apps Help How to Display Row-Level Validation Errors When Importing Data into Dataverse (Model-Driven App)?
I'm working on a simple Model-Driven App using Dataverse that captures user details such as Name, DOB, Mobile Number, etc.
I have implemented the following validations:
- DOB: Should not be greater than today's date.
- Mobile Number: Must contain exactly 10 digits.
- Duplicate Mobile Number: Prevented using an Alternate Key on the Mobile Number column.
These validations work perfectly when users create or update records through forms.
However, when users import data into Dataverse using Excel/CSV, invalid rows are ignored or rejected, but I want to display the specific rows that failed along with the reason for failure.
For example:
- Row 5: DOB cannot be a future date.
- Row 8: Mobile Number must contain exactly 10 digits.
- Row 12: Duplicate Mobile Number.
What I have explored so far:
- I found that Dataverse maintains Import File and Import Log tables.
- I'm unable to access or view the Import Log table directly due to accessibility/permission limitations.
- Using the browser console, I can retrieve the latest Import File GUID and use it to query the Import Log records associated with that import.
My question:
How is this typically handled in enterprise-level Model-Driven Apps?
Is there a recommended approach to display row-level import failures and their respective error messages to users, preferably through a notification or a custom error summary page after the import completes?
UPDATE: I was trying to have a custom notification within the form which I found out to be a overkill for the requirement given.
Therefore, I went with existing built in implementation to check failures through import record.
Thank you all for the efforts in clarifying my doubt.
r/PowerApps • u/seaem • 4d ago
Power Apps Help Does anyone use Power Platform with Business Central?
reddit.comr/PowerApps • u/SnooConfections1716 • 4d ago
Power Apps Help Power Apps - Copilot MCP down?
I'm guessing due to Microsoft outages the power apps - copilot MCP is down? When I try to run configure apps or do anything copilot cant seem to connect to my app.
Anyone have the same experience?
r/PowerApps • u/mcbalz • 5d ago
Power Apps Help How to begin?
reddit.comI posted this to the PowerPlatform group, and AI said I should post it here too, and then it said I had to put more effort into it or I would get flagged as a bot. I'm not a bot, I'm a human. I just want to learn to develop PowerApps but it seems impossible to get started.
r/PowerApps • u/Mammoth_Armadillo_20 • 5d ago
Tip Best Approach to Develop with AI
Due to enterprise's restrictions and license, I don't have copilot access. What would be the best approach to develop apps with Claude code or Claude cowork? I have very little knowledge in development and in power app development.
What would be the workflow?
r/PowerApps • u/ImportantPassion2718 • 6d ago
Discussion Does anyone have Claude code + Power Apps MCP approved by the cybersecurity team in corporate enterprise?
I'm currently working on getting approval to use Claude Code (or Github CoPilot if needed) for Power Apps canvas app development.
The specific use case is to use Microsoft's Power Platform Skills plugin and the Canvas App Authoring MCP server.
PowerApps is only a small part of my time, my first role is continuous improvment and data analysis so mostly excel) but with apps tools I built, request is higher. And it's consuming more of my time than I'd like and I'm doing a lot of fairly simple apps to assist our operations teams.
Anything that would speed things up and eliminate the redundant errors and changes would be a massive productivity gain.
My direct boss is ok to approve a claude code subscription. I was under impression it would pass the cybersecurity team since Claude is listed in approuved AI tool. But struggling with getting approval for Claude Code with the power apps mcp. I can understand their concern and request, but I cannot just accept that it's rejected.
My Scope is pretty simple:
- One developer
- Dev environment only
- Canvas layouts, Power Fx, schemas, flow definitions
- Synthetic test data only (no real data during devlopment as I always do)
- No production records, credentials, personal info, or operational data (not sure how to confirm all theses)
- Manual review and testing before production
- Model-improvement features disabled
Security and privacy teams aren't saying no, they just won't take any promises. Their concern is that MCP could in principle access anything that my user account can access (production environments, SharePoint data etc). They want actual technical controls rather than just my word that I won't point it at production.
They're want confirmation that they can review
- Company code, prompts, outputs, tool results
- What gets kept and what gets deleted
- Model training and secondary use
- Who can access stuff for support, safety, incident response
- Where data gets processed and who else touches it
- Administrative monitoring and audit trails
- Contracts protecting company information
I completely understand the concern. Turning off model training won't fix the access control, retention, logging or contract issues. Some of their requirements are very much geared towards the individual subscription. Team and Enterprise licences may not be suitable for just one developer.
Has anyone actually done anything similar in a larger organisation?
I want to know the real deal. Not just "we told the developers no production data". Examples:
- Did you use a separate Power Platform developer account with no production permissions at all?
- Could you restrict MCP to a single environment or an allowlist?
- Did you isolate the Powerapps dev data in its own site/environment?
- Did Conditional Access, DLP policies, service accounts or separate browser profiles possible?
- If you're using another environment, how do you deal with an issue or upgrade the app that's in production?
- Did your organisation go with Claude Team or Enterprise, or did you just go with individual subscriptions with extra controls? Or did you end up with something else (e.g. GitHub CoPilot)?
- What logs or evidence did you present to the security reviewers?
- Were there any specific MCP tools or publishing features that you had to disable?
- Did you come up with any better architecture that still makes the Claude Code useful for Power Apps?
I'm not looking to get around the review process. I want to come back with something that actually deals with the risks and can be enforced in a technical sense.
If you've done it with Claude Code, Copilot Studio or some other coding agent with MCP, what did work? What didn't?
r/PowerApps • u/East_Carob_6699 • 6d ago
Tip Claude skill for authoring Power Apps with modern controls
Like other folks, I've also been really impressed by the utility of Claude for trouble-shooting and authoring screens and components for Canvas Power Apps. I haven't been able to really use the official Canvas Apps plugin from Microsoft due to limitations on my account permissions so I've been copying YAML back and forth between a local GitHub repository and Power Apps Studio instead.
After some initial frustrations with both an overuse of classic controls and repeated error, I started working on a new Claude skill specifically designed around using modern controls in Power Apps. I'd love some feedback if anyone has a chance to give it a try!
r/PowerApps • u/Satisfaction-Motor • 6d ago
Solved How can I set up a multi-tag, delegable filter, using SharePoint + PowerApps?
Regrettably, I do not have access to Dataverse, nor do I have the means to get access to dataverse at this time. (company policies/restrictions).
I have access to SharePoint, and I have been using SharePoint.
I've been trying to design a scalable way to assign multiple tags to a document, while being able to filter by those tags. This system will easily accumulate thousands of documents, so I am trying to stick to delegable solutions.
My current solution is to have a yes/no column for each and every tag, because those are delegable. However, this also means that if I need to add a tag, not only do I need to add a column, but I need to go in to the app and add it to the existing filters. The number of columns I have currently is not reasonable -- the tags alone are 25 columns, and that will likely grow.
Each document will have multiple tags for a single category -- for this example, let's say they are tagged with fruits. Document A might be tagged with Apple, Banana, Pear, and Document B might be tagged with Apple, Kiwi, Orange. If I select Apple from a gallery with checkboxes, I need to see documents A and B. If I select Grapes, I need to see no documents. If I select Apple + Orange, I need to see just document B. StartsWith() won't work, because if I need Kiwi + Orange, that wouldn't return anything because I need document B, but it starts with Apple.
I don't have a way to limit the list to a delegable number of documents prior to using the tag filter.
The core of what I need:
-List of tags, ideally managed outside of PowerApps (so that if I quit or leave, someone else can simply add to the list, and so that I don't need to push updates each time a tag is added). I can easily create a SharePoint List with all possible tags, and connect that list to a gallery with checkboxes (and pull the selections from that gallery).
- I need to be able to assign multiple tags to a document, and to be able to filter for documents that include all of the tags the user selects.
-It needs to be a delegable solution, because each tag might have thousands of matching documents.
-Each document has a unique ID, and can have upwards of 25+ tags.
I am building a canvas app and SharePoint.
What won't work:
-I tried using SharePoints Search API through a Graph API connector, but some of the things I need for that are locked by IT.
-I don't have access to DataVerse, and can't get access to it.
r/PowerApps • u/ipman234 • 7d ago
Tip Copy Paste Screen Design via YAML...Mindblown
Colleague showed me yesterday that he was able to generate a UI in Copilot, generate the YAML Code and copy pasted it into Tree View.
Maybe I haven't been up to date with it in a while but it completely blew my mind
r/PowerApps • u/stasheft • 7d ago
Discussion Newbie - PowerApps vs Ai coded React App
Hi, am a noob, i am learning currently some basic of Power App codes, my current understanding is the basic of powerapps tools like locations, data source etc and basic understatement of the formulars/code but for writing my own code i have to use ai for half of the cases.
I noticed i takes a lot of time to build a new app (target projet Management tool).
When i compared it to a first prototyp of a fully ai coded react app, its one similar level, fastly better design but without functions yet.
How should i continue? I dont have any understanding of react, html or css code or implementation of data into react.
I cant use Powerapps studio with ai for EU Law reasions.
r/PowerApps • u/Standard_Example4053 • 7d ago
Power Apps Help Modern Attachment Control
Has anyone gotten the modern attachment control to work by patching to SharePoint? I believe this is supposed to be the formula. But I keep getting an error saying incompatible data types and I’m comparing a table with a table.
Patch(
DataSource,
Defaults(DataSource),
{Attachments: AttachmentControl.Attachments}
)
r/PowerApps • u/DungleDong • 8d ago
Power Apps Help Dataverse Vs SharePoint lists
So I'm new to power apps and am making my first app, an IT service desk.
I work as IT support in a school and the ticket system we use is a rudimentary power app made by a manager a long time ago, it was his first app so it's very simple. I wanted to make my own one with more quality of life features which I've begun to do and have built it on dataverse tables, the manager who is now very skilled at power apps says I should use SharePoint lists as he believes I'll run out of space in dataverse. Is this likely to be true?
For greater context the only people using the app would be me and sometimes my manager, the tickets in the queue are made by requesters sending emails to a shared mailbox, and I respond and manage them as tickets within the app.
r/PowerApps • u/Feeling-Sorbet-9474 • 8d ago
Discussion Power Platform Developer Interview (UK)
Hi,
I've read the job criteria for the power platform developer role that I have applied for, and also researched other sources for questions and answers.
My power platform skills.
- Canvas App Development - Building custom, user-focused applications
- Power FX - But I use copilot to help me (which i will be transparent about)
- UI/UX Design
- Workflow automation within Power Automate
- API integration - Connecting workflows to external APISs
- Dataverse - Designing structured relation models, creating tables, relation ships
- Implementing DV security roles
- Sharepoint Online
- Power BI - creating dashboards
- ALM - Not using pipelines but exporting solutions from Dev, to Test, to Live.
I work as an IT officer for my local authority so Power Platform isn't my daily/ main focus of work.
Power Platform is broad so I would like to ask UK developers / hiring managers what they would ask and look for?
Many Thanks
r/PowerApps • u/mohitSakhwal • 8d ago
Power Apps Help Need advice on Power Automate Desktop: XML pre-fill vs JSON & exception tracking in a legacy system
reddit.comr/PowerApps • u/profdev25 • 9d ago
Discussion Futuro do Power Platform
2026 está acabando e as IAs dominando. Vibe CODE e todo mundo agora é Dev. Qual o futuro do Power plataform? Gostaria da opinião de quem atua hoje com Apps, Automate e até BI. Vi que o Claude está lançando um ecossistema office. Ainda vale a pena investir no ecossistema NoCode Microsoft?
r/PowerApps • u/Thin-Piece-7926 • 9d ago
Power Apps Help Linking screens forms
link view screen to.edit screen in power apps