PowerFX was only announced officially this year, still feel its too fresh to say one is a "PowerFx developer" proper. And even then, Microsoft is only beginning to roll it out to their other platforms outside of powerapps.
Powerapps, especially when you run through Microsofts official certifications, is definitely touted as just one part of the whole Power Platform, including Power Automate, Power BI and Power Virtual Agents.
From a business/career perspective this also makes sense, in that one shouldn't just be using Powerapps alone in a developer/programming context - it's a suite of products and a tech stack to analyze and solve business problems in a way that is proposed to be quicker than even traditional DevOps. See the vision for Fusion Teams/Fusion development approach.
These are business users (not necessarily developers proper) that know the business "on-the-floor" in other technical capacities but using the tools of the power platform to work alongside pro dev that would put together the APIs, the pipelines, etc.
Knowing other languages is just another part of the Power Platform developer toolset to solve business problems.
Do you use a registered Microsoft license reseller?
If so ask them about bundles, if not go direct to Microsoft and work a deal. At 2k+- users, Microsoft would be more than happy to make a deal. I have 2500 in my org and Microsoft made a nice deal.
Also the pricing cut in half. Now $20 per user per month for premium: https://powerapps.microsoft.com/en-us/pricing/
We have this setup with a Powerapp (https://powerapps.microsoft.com/en-us/).
It makes a webhook call to fetch status upon load, and allows the user to turn on/off the VM. The buttons are dynamic depending on the status returned on the first call.
WH calls are received by an Azure function. It spits back the data and the powerapp parses the JSON.
>Is there any technical skill which I need to learn to incorporate in PowerApps?
Power FX.
Link to Microsoft Power FX page
Without spending a lot of cash, forms in SPO are super lacking. There is nothing, from Microsoft, to fill the void of InfoPath. I would work on moving away from it as you can already tell Microsoft forgot about it :)
There is a glimmer of hope that PowerApps will be the replacement. Still no official statement about that though :(
I just created a solution where the sharepoint data source environment variables worked like expected.
You need to follow the steps described in this blog post.
Mi sembra una situazione per cui qualcosa come Power Apps potrebbe invece essere la cosa più semplice, soprattutto perché poi c’è meno cose da gestire nel tempo. Singola app scritta “senza codice” (o con poco codice) e via… per desktop e mobile. https://powerapps.microsoft.com/ (disclaimer: lavoro per MS)
Microsoft is getting rid of Dynamics 365 for Outlook (also referred to as Outlook COM Add-in) October 1, 2020.
You need to transition to the new Dynamics 365 App for Outlook before the deadline.
This is actually a pretty complicated aspect of the service, but there are some documents out there about how to set yourself up.
I believe the short answer is that, yes, you will need a license to "run" a PowerApp, even if you aren't the one that built it. Whether that's the trial (as alluded to by /u/kwagenknight) or a paid P1, P2, or another SKU.
The PowerApps pricing page has some stuff about this depending on your scenario.
This licensing overview also talks about things through the lens of O365 trials.
1) I do have experience.
2) It isn't that hard. I used a platform from Microsoft called PowerApps. I bet if you spent a few days learning about it, you could build apps, also. I'm using an Azure SQL DB to store the data, which is a little more difficult to use. You can use PowerApps with an Excel spreadsheet and get similar results.
More info on PowerApps: https://powerapps.microsoft.com/en-us/
If that's your only need for local installation, consider PowerApps (which is included in O365 - https://powerapps.microsoft.com/en-us/) as replacement and use RDS as interim. You can run with cheaper O365 licenses and wouldn't need any kind of Azure infrastructure.
Currently, PowerApps can only be shared within an organization and PowerApp apps aren't published to any public app stores. Instead, users must first install the PowerApp app, sign in with their Office 365 credentials, and then load their custom apps from there. When they install PowerApps app on their device, they'll need to sign in with their Office 365 credentials. They could then share the app with individuals inside the organization or share the app with the entire organization.
You can disable PowerApps by removing the user license, though users can individually sign up for a trial of PowerApps. If you have DLP policies in place, though, you can prevent them from accessing company data. https://powerapps.microsoft.com/en-us/tutorials/signup-question-and-answer/#administration-of-powerapps
If you have an Office365 tenant for e-mail, consider using Powerapps. Specifically the model-driven ones, that allow you to very quickly build custom applications on the basis of a simple CRM. With the per-user plan costing only $20/user/month, you can very rapidly innovate and bring your product to the market.
You might want to use a combo of SharePoint and PowerApps. There is an Onboarding Template you can start with. https://powerapps.microsoft.com/en-us/blog/office-template-onboarding-tasks-now-available/
There are two types of connectors: standard and premium. Connectors help you connect with the data source. Standard connectors include excel, onedrive, sharepoint etc. Meanwhile premium ones include SQL Server, oracle and many others. With E3 license you could use powerapps with standard connectors but not premium ones. There are two license: per app and per user.
Let's say you want to use SQL server as your data source to store and load the data. In that case you will require a license model for evey user who uses the app, either per app or per user (depends on your requirement).
This, as for your app each user you share it with will require an additional Premium licence, where as for Cloud flows, only 1 user will require a licence which may work out cheaper
Also this method you can have it send an email to let you know it has ran or even add in approval from you before it runs
Look at this though https://powerapps.microsoft.com/en-us/developerplan/
;)
It's microsoft but it doesn't say it in the address so people don't pretend to be them either https://powerapps.microsoft.com/en-us/blog/introducing-powerapps-portals-powerful-low-code-websites-for-external-users/
It should have been possible to use a NSW health domain though https://docs.microsoft.com/en-us/powerapps/maker/portals/admin/add-custom-domain
You can ‘cheat’ by using the Power Apps community plan/environment for production use. It allows for custom connectors, but they can technically only be triggered by you and only for development purposes.
However, you could also ‘develop’ an Flow that listens for new SharePoint List items as trigger for your flow if you want to automize.
While this is from 2017 it could help you with your goal:
https://powerapps.microsoft.com/en-us/blog/office-template-onboarding-tasks-now-available/
Here is a link that is more recent that also covers what you are trying to do. Plus it has an physical example you could look at.
https://www.knutrelbemoe.com/post/hr-onboarding-powerapps-sample
While I applaud your script sharing.
Maybe put your code in a free github repository and paste the link here?
It's a long scroll down to the comments for now :).
As for tips:
You could look into creating a power app with a portal and use a service principal/service account to run your script.
https://powerapps.microsoft.com/en-us/portals/
Maybe later on you could add additional tasks.
This would avoid sharing sensitive information.
Have a look at powerapps for 365. I used the onboarding template and customized it quite a bit to redirect and show different tasks and kick off power automate workflows for various items.
https://powerapps.microsoft.com/en-us/blog/office-template-onboarding-tasks-now-available/
Edit: you can also use sharepoint lists as a data source to store/pull data from
😂🤣😂🤣😂🤣😂
Para React Native minimo necesitas saber JS y HTML, ademas de varias cosas de servidores. Osea en una semana ni de chiste.
Para drag and drop que es lo que veo que quieres esta MS Power Apps, la haces desde una interfaz gráfica, ademas de que te puedes conectar a “Exceles” para una base de datos. Super util si no le sabes a la programacion!
Take a look into Common Data Service
The transition parameter was required, but the requirement was removed last month - see https://powerapps.microsoft.com/en-us/blog/more-small-steps/ for the announcement.
You could try using the "Book a Room" PowerApps template. You can always modify it to meet your exact needs. https://powerapps.microsoft.com/en-us/blog/office-template-book-a-room-now-available/
Hi,
Dynamics 365 is not required for CDS or Model-driven apps.
If your client is migrating to Office 365, PowerApps and Flow are included in that O365 subscription at no additional cost. Likewise, if your client has a Dynamics 365 subscription, PowerApps and Flow are included in that. It is just one more way to get access included.
If your client is interested in using CDS or building model-driven apps, they would require a P1 or P2 subscription. Here's a blog post with more information on which plan is right for your needs:
https://powerapps.microsoft.com/en-us/blog/business-model-may/
Let me know if that helps.
Brian
Not exactly open source, but if you want to stay within the Microsoft stack look at Azure PowerApps. Use the connector software to connect an Azure PowerApp to on-premises SQL Server (connector supports many data sources.)
The Microsoft alternative is PowerApps. There is an on premises version of the product. It is not only a replacement for Infopath, but will allow you to develop all types of browser/mobile applications to interface with SharePoint. The simplest version of which is a form that will fill out a list in a SharePoint library. It features a lot of drag and drop features as well as automatic population of fields from your custom list. You can learn more about it at https://powerapps.microsoft.com/en-us/
SharePoint Vagabond - Microsoft Premier Field Engineer
i may consider this, spotted this
then i wondered..can that tablet run android apps ie: snapchat,etc i suppose it's possible.
Wir haben damals hiernach aufgesetzt https://powerapps.microsoft.com/en-us/blog/introducing-the-sap-erp-connector/. Mittlerweile gibts aber auch einen OData Adapter, leider nur auf GIT. Damit kommt man aber um das doofe .NET SDK der SAP herum. https://github.com/microsoft/PowerPlatformConnectors/tree/master/custom-connectors/SAP-ODATA-Demo
Dataverse for Teams is free, might have to look up the limitations compared to "real" Dataverse thou.
I already built apps within DV4T, but it's not really as nice an experience as working with the native PA designer.
If you have 15 people working with the data, you need to consider the cost for 15 premium licenses:
https://powerapps.microsoft.com/en-us/pricing/
Working with 15k items in SPO would not be the big deal, it all comes down to how you filter the data. Delegation is depending on funkctions, f.e. Search is delegated using SPO, not with Dataverse.
Filter is fine with both sources. So if you manage to filter down your data to a result below 2k, you are fine.
Why not stop with front-end coding as well and do low-code/no-code solutions? 😅
https://powerapps.microsoft.com/ https://www.outsystems.com/ https://www.mendix.com/
I don't believe in 'one size, fit's all' solutions though but for some situations these could work :).
If I move apps from one place to another, I use the VS Code extension to edit the .msapp file directly.
https://powerapps.microsoft.com/en-us/blog/power-platform-extension-for-vs-code/
This helped me a ton lately and saved hundreds of hours, maybe it can do the trick for you.
First, never use Excel as a data source. The Flow connectors for Excel have file lockouts of 6-12 minutes. Use a SharePoint list or a Dataverse table.
Second, Microsoft actually has a Leave Request Power App template - https://powerapps.microsoft.com/en-us/blog/create-and-manage-leave-requests-with-ease
You could then use the data source, to create a basic Power BI dashboard for the managers to view - https://appsource.microsoft.com/en-us/marketplace/apps?product=power-bi-visuals&page=1&src=office&search=calendar
The main benefit is to have source control also outside of Power Apps. It also uses the canvas source code tool Microsoft announced a while back. Which means you will be able to read all the formulas you write in the source code system without having to open Power Apps (https://powerapps.microsoft.com/en-us/blog/canvas-source-code-tool-integrated-with-power-platform-cli/)
If you have a Power Apps license, then you don't have any additional cost unless you hit the max size for your tenant. Your max size depends on what type of license you have: https://powerapps.microsoft.com/en-us/pricing/ For the full version of Power Apps you can pay to get additional storage as well.
A good starting point for anything involving programming Access is the Northwind Database sample database. It's a good starting point to identify the functionality that you might want and then opening that up that section in Design View and/or the Module Editor to see how it's been done.
Instructions on getting it can be found here:
https://docs.microsoft.com/en-us/dotnet/framework/data/adonet/sql/linq/downloading-sample-databases
It should be said that Access is getting on a bit and isn't really future-proof, Microsoft has been trying to wean people off that and onto Powerapps.
Glad to see! Are you interested in making this app distributable/collaborative to others in your organization? One possibility could be using Power Apps (https://powerapps.microsoft.com/en-us/) -- DM me if you are interested in something like that as well.
Best I can really suggest is one of Microsoft's app in a day classes. I did mine on site but there seems to be some online ones you can do on-demand https://powerapps.microsoft.com/en-us/blog/free-app-in-a-day-powerapps-training-and-more-from-pragmatic-works/
The app we built was a Computer purchasing canvas app, with a model driven app and business process flow as the backend.
Aside from that.... not sure if you've got access, but the D365 Sales suite has in built business process flows to facilitate the sales processes
The price is listed here and dependent on your own currency.
You can purchase from that site, directly from your M365 admin portal, or your CSP (if you have one).
Have you heard of Project Oakdale? It lets you create an relational database (Dataverse) and graphical interface within Teams. It is a siloed data environment per team, but you can edit data tables in Excel as well. There are loads of resources online to help with development such as video series and online documentation by Microsoft.
With the ‘free’ version you need to stick to Teams, but you can upgrade down the road to a full Dataverse environment with more capacity and premium connections.
If you want others to use your database via Web, you need to get somebody to develop a Web app that connects to it. Another option is to re-do the database in something like PowerApps or Zoho Creator.
If it's OK that the others use MS Access (or MS Access Runtime, which is free) to connect to your database, you can use SQL Server Migration Assistant (https://www.microsoft.com/en-us/download/details.aspx?id=54255) to migrate your database to a SQL Server somewhere on the Internet, and then adjust your Access file so that others may connect to it. You'd need to create user logins in SQL Server for the people that need access.
Could a Portal work in this instance?
Either way that's Power Apps, it can do cascading dropdowns like described here:
https://powerapps.microsoft.com/en-us/blog/configure-easy-dependent-drop-downs-in-powerapps/
And you can easily set values based on other fields by just hooking into the OnChange property of the field which controls the other.
This further article provides some abstract examples of this method https://powerapps.microsoft.com/en-us/blog/bulk-update-using-forall-and-patch/
I've implemented this kind of approach by using a collection that exactly matches the column names of the data source Im updating. It took me a while to get it all working (can't remember why as I probably subconsciously try to forget these sort of annoying issues with power apps).
Some more practical examples in this blog post: https://matthewdevaney.com/patch-multiple-records-in-power-apps-10x-faster/
Have you done a through discovery on the use cases? Perhaps something like this could be helpful if you use Microsoft tools. https://powerapps.microsoft.com/en-us/blog/powerappsbot/
Power apps bots allowed me to setup time cards and tracking for contractors. As well as manage requests for sign off on time cards. The data was then fed into power bi where time could be viewed and tracked.
As for utilization you can also track what kind of questions were being asked (capture the input) and also set up a small survey after to get feedback on how the user felt the bot helped them solve their need.
AAAND as soon as I said this, MS published a blog introducing a new connector. Now you can get alerts when a dataflow completes using connectors.
​
Take a look at the documentation for the recently upgraded Container control:
Seems like it's basically flexbox under the hood.
It's a little tough to visualize without the data set but you could also explore some sort of PowerApps/PowerBI integration.
I'm not sure if you would be looking for the entered values to store or anything but either way maybe this article (https://powerapps.microsoft.com/en-us/blog/creating-updateable-power-bi-reports-with-powerapps-by-ike-ellis/) is a decent read?
PowerBI really isn't a great platform for doing work unfortunately; so there's limited options when it comes to user interaction and everything.
Hope this at least helps a little.
Have you tried setting up a free personal aka developer powerapps environment? Its comes with cds just has a size limitation but perfectly functional. Only caveat is that you can't share apps with others but perfect for using it yourself and developing apps to export to other sandbox or production environments. Its called the powerapps community plan see here to sign up: https://powerapps.microsoft.com/en-us/communityplan/
If you are also using Microsoft Team, do a YouTube search on "Project Oakdale" - it's a preview release of building PowerApps within Teams and uses a "light" version of Common Data Services.
https://powerapps.microsoft.com/en-us/blog/introducing-project-oakdale-a-new-low-code-data-platform-for-microsoft-teams/
There is a way to do this, but I’m not somewhere that I can open my Powerapps to get at how I have it set up. Hopefully this article helps:
https://powerapps.microsoft.com/es-es/blog/separate-custom-forms/
CDS internally requires a licence yes. Minimum is the per app / per user licence. It costs about $10 per user per month. It gives access to 2 apps and 1 portal and power automate flows (included premium features) which are connected to the apps.
Portals is an add on.
Closest I can think of would be MS PowerApps which is targeted towards mobile devices. It's not 100% identical to VBA, but it's decently flexible enough to do all sorts of things.
This is entirely possible and is a great use case for Power Apps.
There is a fantastic blog post with learning resources for Power Platform at https://powerapps.microsoft.com/ro-ro/blog/microsoft-powerapps-learning-resources/
>But I found out I can use it on phone now. So I'm just doing to transfer all my information to excel now. I'm talking Calendar, plans, expenses, tracking food I eat, exercises.
Look into Microsoft PowerApps. It's a platform where you can build mobile apps. You can set up the apps to read from and write to Excel files stored on OneDrive. Get the Community Edition to build apps for free.
Don't forget, you get 2! apps for the $10/user/month. Once you get to 5 apps, it's cheaper to run the unlimited $40plan.
https://powerapps.microsoft.com/en-us/pricing/
My poor vacation request plan was going to cost $60k/year to implement. A consultant dev and 2 months time cost $20k with $5k for infrastructure AND we don't have to pay that again the next year, or the next, or the next. My ROI was 5 months, so it was an easy sell to the bean counters. Even if we have to bring someone back in for updates, etc, we come out way ahead for building a few apps here and there.
For 100 users, the ROI would just be over 2 years with a similar cost which may make the buy/hire/papp it decision a bit harder to sell. Month 26 it's free though. :)
Not sure if I’m understanding completely but here is my ¢2.
If you’re using distinct() directly against the SharePoint list, I’m not sure this delegatable. Here is a list of the delegatable formulas. https://powerapps.microsoft.com/en-us/blog/sharepoint-delegation-improvements/
Alternatively you can use Filter(), which is limited to 5k until you index the SharePoint List columns. IDK what the actual list item limit is for SPO but for SP13 it was 30,000,000. https://docs.microsoft.com/en-us/sharepoint/install/software-boundaries-and-limits
Then perform the distinct() locally against the collection. Currently, I have multiple Power Apps with over 8k SharePoint items. https://powerapps.microsoft.com/lv-lv/blog/powerapps-now-supports-working-with-more-than-256-items-in-sharepoint-lists/
However, it is true that if you do plan to have an immense data set, SP is not best data repository.
As I understand you correctly you are looking for something like SSMS with a little logic on top and minimal programming. Probably SQL server/MS based right? What about power apps? https://powerapps.microsoft.com/de-de/. In terms of RAD you might want to look into Apache Isis https://isis.apache.org/ or its Net equivalent https://github.com/NakedObjectsGroup/NakedObjectsFramework
You can pretty much do the same thing, but it is a little different with powerapps. You add the parameter at the end of the URL, but you need to add some code and a timer to the PowerApp. You set the time to autostart, and at the end of the timer run you set some code to check for the parameter in the url and if the parameter exists it will run a Navigate() function to navigate to the screen you want. If the parameter does not exist then nothing happens. It's a little clunky, but so far its the only way I found to do it. Here's the link to some info on the MS site with more details:
​
https://powerapps.microsoft.com/en-us/blog/powerapps-deep-linking/
I think the answer to that is definitely yes. The power suite can and will take over the roll which access filled for self developed business solutions. Check out this article from Microsoft to get a feeling of what can be done: Account Planning App. It is all about the CRM system which is used internally at Microsoft by their global sales team, something like 5k users. It is totally built from the power platform!
Is the rest of your team using Microsoft (Outlook etc.) or are they all in Google? This sounds like it should be a mini application. Unfortunately Google App Maker is almost gone, but they have a paid service called App Sheet.
If your team uses Microsoft then Power Apps is specifically built for this kind of stuff (I always think of it as a system designed to approve expense reports).
Building this in Google Sheets would require quite a bit of Scripting to get it to work more than is normally sufficient for a solution.
You can try exporting as Zip file, you have to fix broken connections after the import but other than that it should work.
Here is a reference:
https://powerapps.microsoft.com/en-us/blog/powerapps-packaging/
> Most of my large clients are using teams expiration policies in place of trying to control the creation of teams.
Can confirm. We've had two security and governance engagements with Microsoft and Enabling Technologies, and have talked to several PFEs - and they all echo this same sentiment.
This is the same thing with the Power Platform. Creating self-service portals is the future, where you have expirations, approvals and audit log trails is the new norm.
That's the entire point of many of these services. IT can't possibly meet the needs of every user, so you are empowering your users to do it themselves, and only engage with IT if they have issues.
Office 365 and Azure provide more than enough tools to be proactive, the Center of Excellence Starterkit is a perfect example. While it isn't specific to Teams, the same methodology is recommended across the entire Microsoft Cloud.
Well you already have Power Apps and Power Automate licenses for O365 as part of your E1. That should cover all standard connectors. Are you working with premium connectors that require premium licensing?
Here's a cost guide for premium. https://powerapps.microsoft.com/en-us/pricing/
No there isn‘t a way to license just an app for everybody in your organization as apps are run in the context of each individual user (different from Power Automate).
You have to license each user at least for the „Power Apps per app plan“ as the seeded O365 license doesn‘t include premium connectors. However the seeded Dynamics 365 plans are sufficient if you happen to have them for your users.
The „per app plan“ will give each licensed user the ability to run the maximum amount of two apps that are using premium connectors - cancas apps that use standard connectors are still unlimited as long as your users have the seeded O365 Power Apps license assigned to them. If more apps with premium connectors are required you need to assign them the „per user plan“ which grants them an unlimited amount of these apps to run. More information about the pricing and capabilities can be found here.
...but maybe you have the ability to „outsource“ the required functionality into an automation in Power Automate (depends on the scenario / use case and amount of executions). Then you would just need to license a technical user (Power Automate per user plan) that is authenticated in this specific automation - but only works with up to 15‘000 API requests (connection calls) per day if I remember correctly.
Microsoft has provided a PowerApp that you can deploy into a SharePoint site, manage communications and information to the organization: https://powerapps.microsoft.com/en-us/blog/crisis-communication-a-power-platform-template/
These articles should help you out! A few different approaches to the results you are looking for.
https://powerapps.microsoft.com/en-us/blog/custom-api-for-image-upload/
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-patch
https://blogs.perficient.com/2018/10/08/store-powerapp-camera-photos-in-sharepoint-or-onedrive/
However you can setup a flow to notify the users about the rules, best practices, training videos... if the user didn’t accept the rules the same flow can delete the recent created app. I would like to recommend reading this blog post about CoE Kit: https://powerapps.microsoft.com/en-us/blog/update-to-the-power-platform-center-of-excellence-starter-kit/
And also this one: https://powerapps.microsoft.com/en-us/blog/establishing-an-environment-strategy-for-microsoft-power-platform/ about the environment strategy. For new environments you can control who has right to create apps.
MS has a whitepaper for governance and deployment: https://powerapps.microsoft.com/en-us/blog/powerapps-enterprise-deployment-whitepaper/
They are correct, sort of. The 50mb for plan 1 is the amount allocated per license. Storage is pooled at the tenant level. So if you have 10 plan 1 licenses, thats 500mb. There is a comparison of both plans here https://powerapps.microsoft.com/en-us/pricing/
If you just want to input data easily into a database or file with a simple interface, PowerBI isn't a solution. PowerBI isn't really designed to add new data items on the fly, they are usually imported from elsewhere and PowerBI is used to visualize them.
I haven't tried it yet, but you might be able to use Power Apps to create an app to add new items.
I believe they have updated choice fields to be delegatable, so this should work the way you've described.
I believe the syntax would be filter('helpdesk', status.value="WIP")
https://powerapps.microsoft.com/en-us/blog/sharepoint-delegation-improvements/
The office side of the app is definitely possible, but PowerApps currently can’t be shared externally from your environment. :(
The new PowerApps Portals will likely do what you need but it’s still very much in preview and lacks basic features. https://powerapps.microsoft.com/en-us/blog/introducing-powerapps-portals-powerful-low-code-websites-for-external-users/
When you click on "My Vehicles" and then "See My Vehicles" do you see anything? It's coming up empty for me even though the title shows up when I click the "Check Vehicle Title Status..." link...
And the "Request Distribution" link is under the "My Account" tab, first option on the list.
I think the site is built with this point and click microsoft product: https://powerapps.microsoft.com/en-us/ or something like it... they need to hire actual webdevelopers and a security guy, sorta scary this thing is hooked up to sensitive databases.
PowerApps and Flow are about to make some major changes to their licensing in October. Hopefully this helps to clarify what you are looking for.
E3 and F1 licenses will be able to use standard data con ections within powerapps. Azure SQL is moving from standard to premium.
>Based on the scenario that you mentioned (an canvas app using Azure SQL and SharePoint List as data source), I afraid that you would not be able to develop and distribute Apps. Effective October 1, 2019, the Azure SQL connector will be reclassified from Standard to Premium. If you want to access all Premium, on-premises and custom connectors within your PowerApps, you must purchase a standalone PowerApps or Flow plan license.
https://powerapps.microsoft.com/en-us/blog/new-licensing-options-for-powerapps-and-flow/
Access might not be the best approach for this kind of application. Microsoft have dropped Access' web functionality.
The company is trying to move people over to Microsoft Powerapps for developing online applications.
You can assign security groups to the app. Go into "Share" and set the O365/AD-Group to the permission level you want.
It's an absolute dumpster fire right now. You can't even get notifications of a new app being created or deny people from creating apps. It's absolutely infuriating. Let's not get started on the environment labels for dynamics vs power apps and legacy and 0%)#%)&#)@($)@(&)@%&
You can administer the environment/apps with a power app app app app... several choice words here.
https://docs.microsoft.com/en-us/power-platform/admin/admin-guide
To manage apps and add AD groups: https://powerapps.microsoft.com/en-us/blog/new-connectors-for-powerapps-and-flow-resources/
Then the power platform could be wgat you are looking for. More precisely power apps 😉 https://powerapps.microsoft.com/en-us/blog/introducing-powerapps-portals-powerful-low-code-websites-for-external-users/
Check out the relatively new PowerApps Portals. This may get you what you are looking for.
I'd reccomend looking to the AI Builder for PowerApps.
https://powerapps.microsoft.com/en-us/blog/introducing-ai-builder-for-powerplatform/
PowerApps is for people in your org to create basic, internal apps. It has a number of (templates)[https://powerapps.microsoft.com/de-de/blog/5-new-powerapps-templates-for-the-common-data-service/] you can use.
Dynamics 365 (D365) is a collection of online/SaaS apps that handle a company's ERP, financials, CRM and more. One of the cool things about it is all the D365 apps share the "Common Data Model." So if you create a customer in your CRM, the ERP and financials apps understand and can use that customer. This solves many integration issues a lot of companies have, if for example they are using an ERP and then a different vendor's financials.
Finally, PowerApps can also use the Common Data Model. So if you create a customer in CRM, and then make a PowerApp your customer data is accessible pretty easily.
So really, it's more like you're putting your data into the Common Data Model and now you can hit it from D365, Office 365, PowerApps, Graph API (I believe) and more. We're trying to do this at our company.
We use a combo of PowerApps to serve up the "app" for employees and SharePoint to store data for leave requests and holiday allowances in lists similar to Microsoft's solution here: https://powerapps.microsoft.com/en-us/blog/create-and-manage-leave-requests-with-ease/
It may not be rolled out to your environment yet.
https://powerapps.microsoft.com/en-us/blog/tree-view-has-an-app-item-to-make-app-building-easier/
It sounds like what you're looking for might be a LCDP (Low Code Development Platform). Take a look at Appian and Microsoft PowerApps for some ideas about what these look like.
The save button from the App. If(SharePointFormMode="CreateForm", SubmitForm(CreateItemForm), If(SharePointFormMode="EditForm", SubmitForm(EditItemForm)))
I built this app, roughly a year ago from a similar guide.
https://powerapps.microsoft.com/en-us/blog/separate-custom-forms/
PowerApps is designed to be a web-based tool for what Microsoft calls Power Users (not true developers but savvy enough to do it themselves).
If you've never done SharePoint development, it may be somewhat daunting but give it a shot and you can put something together that gets you close to what you want.
They have a getting started series here: https://powerapps.microsoft.com/en-us/blog/category/getting-started/
I honestly had the same idea on making my own app/software but I am just a programmer. If you are into that idea I would probably take a look at this! Seems as a simple barcode app only take 5-10 minutes to write?
https://powerapps.microsoft.com/en-us/blog/make-barcode-scanning-apps-in-minutes/
If you use PowerApps, you need to make sure you are appropriately licensed to do what you want to do: https://powerapps.microsoft.com/en-us/pricing/
But yes, PowerApps and Microsoft Forms are what you want to look into to replace any kind of forms Excel-based or otherwise.
Hello! We would like to suggest you create a support ticket on the following Power Apps site for assistance:
(https://powerapps.microsoft.com/en-us/support/)
You may also contact our general support at support.microsoft.com or call 800-642-7676.
Cheers!
Here is a few helpful links for you that have great use case samples and videos.
For a list of functions and formulas: https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/formula-reference
For use cases and documentation help, I use: https://powerapps.microsoft.com/en-us/blog/microsoft-powerapps-learning-resources/
For some decent videos I use: https://powerusers.microsoft.com/t5/Video-Webinar-Gallery/bd-p/VideoGallery
That shanescows is actually really good at making videos and would highly recommend him. He does a great job of explaining all things PowerApps.
Documentation is extremely lacking for PowerApps, and is probably one of the most frustrating things about it. I just had an 8-hour training session with Microsoft today on PowerApps and CDS and so many of the participants were complaining of the same issue. During our development, here are a few of the links I have bookmarked that have helped me tremendously.
For a list of functions and formulas: https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/formula-reference
For use cases and documentation help, I use: https://powerapps.microsoft.com/en-us/blog/microsoft-powerapps-learning-resources/
For some decent videos I use: https://powerusers.microsoft.com/t5/Video-Webinar-Gallery/bd-p/VideoGallery
That shanescows is actually really good at making videos and would highly recommend him. He does a great job of explaining all things functions.
What you’ll probably want to do is add the data to a Collection using the Collect function in the OnSelect property of a button.
There is also the LoadData and SaveData functions.
https://powerapps.microsoft.com/en-us/blog/build-offline-apps-with-new-powerapps-capabilities/
Hello! To properly handle this question, we would like to suggest you try and visit the PowerApps support page on the following site where you can post in the PowerApps community:
(https://powerapps.microsoft.com/en-us/support/)
You may also contact our support at support.microsoft.com or call 800-642-7676.
Cheers!
Basically you want a web based MS Access. You could likely whip up something in Azure PowerApps with an Azure SQL backend fairly quickly.
Otherwise there may be an ERP application out there for the industry.
You might give Microsoft Power Apps a shot. It looks like the successor to visual studio light switch. https://powerapps.microsoft.com/en-us/
Never used Power Apps myself but did use lightswitch. IMHO with these RAD frameworks you trade easy maintenance for agility so keep that in mind as you mature your product.
Trying to understand what you mean a little better: You're comparing Access (the desktop tool) with PowerApps? Or are you comparing AWA with PowerApps? Because AWA (the apps that actually existed in Sharepoint, which I realize involved the use of Access desktop to create) also didn't compare well with traditional Access desktop solutions.
I think MS is positioning PowerApps against AWA rather than Access desktop.
Re PowerApps working client-side, what about delegation? https://powerapps.microsoft.com/en-us/blog/powerapps-update-large-sharepoint-lists-startswith-delegation-flexible-height-gallery-validation-ismatch-regular-expressions