Create apps with PowerApps and Dynamics NAV

Original URL…

Some of you have tried to build apps using PowerApps and the connector for Dynamics NAV. For some, it turned out to be more difficult than expected, and you’ve asked for some guidance from Microsoft. Well, here we go: The Dynamics NAV connector requires ODataV4, and that means Dynamics NAV 2017 or Dynamics NAV 2018. But it’s not that straightforward.

The connector

It exists, allright, but only in preview. However, you can use it to connect to your Dynamics NAV data through a PowerApps canvas app. So why haven’t we talked about it in the docs for Dynamics NAV? After all, we do mention PowerApps in the context of Dynamics 365 Business Central, and you all know that those two brands are actually the same code base, so what’s going on?

We haven’t promoted the Dynamics NAV connector because the current connector hinges on technology that doesn’t work well with the amounts of data that an average customer has. We hope to deliver an updated version, as we wrote in an announcement for using Microsoft Flow earlier this year (it’s technically the same connector). Until then, we recommend caution in the objects that you expose as ODataV4 web services and use in PowerApps.

Get it to work anyway

Yes, you can build an app in PowerApps that connects to Dynamics NAV 2017 or Dynamics NAV 2018. But it requires special circumstances, and, as stated above, you might want to be careful about using the Customer List or similar pages with many lines.

To add Dynamics NAV as a data source in PowerApps

  1. Make sure you have a Dynamics NAV deployment that work with Office 365 Single Sign-On. That can mean using Azure Active Directory, for example.
  2. Expose the objects you need as ODataV4 web services
    1. Think small, as in the User Tasks page rather than the Customer Ledger Entries page
    2. Make sure that the OData V4 endpoint port is exposed through the firewall. The default port is 7047, but it is configurable. This is a general requirement to use web services outside of the internal network.
  3. Get an account for PowerApps. Optionally, get a free trial
  4. Read the steps that are described for Business Central, – but don’t follow them just yet!
    1. Instead, make sure that your web services are ready to consume, and test that you can get to them through the firewall.
    2. If you’re in a multitenant environment, you must the configure the URL in step 6 in the procedure for how to connect to Business Central to have the tenant in the host name and not in the query parameter, as described here.
  5. Now you’re ready to go – follow the steps as described for Business Central, but in step 6 use the right URL.
    1. If multitenant, it’s this format:‘CRONUS-International-Ltd.’)
    2. If not multitenant, it’s this format: http://myserver:7048/DynamicsNAV110/ODataV4/Company(”CRONUS-International-Ltd.’)
    3. Make sure you specify the right names and port, of course.

At the end, you should be able to connect.

But what about the other versions of Dynamics NAV?

Sorry, we haven’t tested if the connector can be persuaded to use web services other than ODataV4. If you have Dynamics NAV 2016 or older, you don’t have ODataV4, and so you probably can’t use PowerApps. But again, maybe you can, but from our point of view the scenario is not supported.

Service announcement

This is just FYI – our blog is targeted by a couple of spam generators these days, and that means that some of your comments might be caught by the spam filter. Due to the volume of incoming spam comments, we can’t easily find your perfectly legitimate comments. So if your comment doesn’t show up, it’s not because we’re neglecting you.


PowerApps Spring Update

Original URL…

Just 18 months ago we announced the general availability of PowerApps, and since then we’ve seen incredible engagement from our customers and partners. People in over 200,000 organizations have built some amazing apps – transforming how they audit retail stores, buy cars at auctions, manage wind farms, teach algebra, and more.

Bringing the power of Dynamics 365 to PowerApps

Today, we’re excited to announce our next big step forward: we’re bringing PowerApps together with the platform that powers Dynamics 365.

With this significant update, we’re advancing what PowerApps can do on several key fronts:

  • The Common Data Service is taking a huge leap forward, adding capabilities ranging from server-side logic and business processes to advanced security and pro developer support
  • We’re introducing a new style of app building: model-driven apps that automatically generate rich user experience based on your data and processes in the Common Data Service
  • PowerApps built on the canvas get new capabilities for working with the Common Data Service as well

The key to delivering these new capabilities is a set of enhancements we’re making to the Common Data Service.  We took the Common Data Service as you know it today, merged its features with the Dynamics 365 platform and renamed it to the Common Data Service for Apps to reflect the new functionality.

Thanks to the Dynamics platform capabilities CDS for Apps gets a huge boost in functionality (see Clay’s blog for more in-depth details), including long requested features like:

  • Server-side logic to enable scenarios from simple validation and defaulting to complex code executing during data updates.
  • Business Process Flows to model business process stages and guide users through them.
  • Sophisticated security model providing row level security and even models hierarchies.
  • Calculated fields to user server side logic to compute values in an entity.
  • Production ready pro developer SDK, based on the proven xRM SDK, allowing CDS for Apps access from any pro-dev application.

This significant update also adds a new type of application that can be created with PowerApps: Model-driven apps. Model driven apps are a more data centric way to build “forms over data” declarative applications.  Model driven apps focus on entities in CDS for Apps, their relationships, associated business logic and forms. Based on that metadata they automatically render a responsive experience across mobile and web clients.  The current style of building apps by designing screens remains a key capability of PowerApps. Moving forward, we call that style of apps canvas apps (I’ll go into more details regarding the differences and when to use which, later in this post).

With these new capabilities, PowerApps and the Common Data Service for Apps now power Dynamics 365 for Sales, Marketing, Customer Service and Talent. PowerApps P2 officially becomes the new platform SKU, moving away from being a admin and maker focused plan to becoming THE plan for users of stand-alone model driven apps.

If you’re already a Dynamics 365 user, this means as soon as your Dynamics 365 apps are upgraded to 9.0, your data will be available in CDS for Apps. Existing Dynamics 365 environments will show up in PowerApps, assuming you have the right access permissions. Dynamics 365 customizers will start using PowerApps to customize Dynamics 365 (no worries: Solution Explorer and other familiar editors remain available), and if you already know how to customize Dynamics 365 then you already know how to build model-driven apps!

It’s also worth noting that all your existing Dynamics 365 apps will continue to work without any modification. The only thing changing for existing Dynamics 365 customers is that the platform you’re already familiar with will get bigger, better and stronger!

Even if you’re not a current Dynamics 365 subscriber you now have a proven, enterprise-class app platform at your disposal that gives you a new approach to solve your biggest app opportunities with.

The new capabilities will be generally available from early May, but if you want to dig in early the public preview starts today. If you already have P2 licenses simply create a new CDS for Apps instance and start building model-driven apps. If you don’t own any P2 licenses you can also sign up for a P2 trial to take a test drive. Manas’ blog shows you the exact steps.

What you should know about model driven apps and canvas apps

Given we’re adding a new app style to PowerApps it’s probably worth explaining the strengths of each style and where we see customers using them.

The PowerApps you know today is focused on high productivity app development starting from the user experience for each screen. Going forward, we’ll call these canvas apps as you’re dropping and configuring controls onto a free-form canvas. This style of building provides pixel-perfect design control over the screens of your app, letting you create rich custom UI in the WYSIWYG studio.

Canvas apps are usually targeted at highly customized role- or task-specific experiences that can pull in and mash up multiple data sources from virtually anywhere. Customized user experiences help making your apps easily approachable so that users can jump right in without needing any/much training. From this release onwards, we are also adding support for server-side logic when building canvas apps with CDS for Apps, more on this later in this blog.

While canvas apps start with user experience, model-driven apps start with your data.

You still get the high productivity app development experience you expect from PowerApps, but with a bottom-up approach: start with data, relationships, business processes and forms. PowerApps then renders the user experience automatically based on the declarative model, creating the appropriate visuals based on device, form factor and even things like the assigned role of the app user. Need to add a new field to your forms? Just modify the entity form and it automatically starts to show up in all apps that use the updated form. Model-driven apps are great for apps with lots of forms and many possible user scenarios through them.

Accessing the new model driven capability is simple, just use the app mode toggle in the PowerApps portal ( to switch to model driven app mode.

Your app users will find both canvas and model driven apps in Initially mobile clients for canvas apps and model driven apps remain separate, but this will change later this year.

Of course we will keep iterating. As always our focus is to get the new capabilities to you, our users, and then evolve them using your feedback. We will work to further enhance the creation experiences and make them more visually coherent.

If you’re familiar with canvas apps and want to get a head start building model driven apps then check out this great blog post on how to get started.

If you’re new to PowerApps we have a host of resources to get you started. Our customer success team has a great blog linking to a wide range of learning resources for different levels, I’d recommend you start there.

Server-side logic in CDS for Apps

Common Data Service for Apps provides several types of server-side logic:

Declarative logic, that does not require writing any code. In this category CDS for Apps provides:

  • Business Process Flows – BPFs are a way to describe business processes as a sequence of stages with specific steps in each stage. Use a business process flow when you want users to move through the same stages and follow the same steps to interact with a customer for example. BPF allows modelling of sophisticated processes through capabilities like enforcing certain conditions are met before advancing to the next stage, or dynamically switching stages depending on input from prior stages.
  • Workflows – CDS for Apps support synchronous (“real-time”) and asynchronous workflows. Custom workflows can be triggered on a wide range of events such as creation of a new record, changes to a record,  deletion, etc. The workflow itself can then take one or multiple actions like modifying fields, creating new records or even preventing the operation that triggered the workflow from completing.
  • Business rules – Ensuring accurate data, regardless of the app that created or edit it is important to maintain data consistency, and ensure apps and analytics continue to operate as expected. Business Rules provide a nice graphical UI for defining these rules and actions that will be executed sychronously when a record is created/updated.
  • Calculated and roll up fields – entities can now include calculations and roll ups of related records to allow you to create Excel like formulas on both number and text-based fields. This enables calculations to be defined once, ensuring a consistent value is used across all your apps.

In addition to the graphical, declarative editors, CDS for Apps now also supports pro-dev extensibility:

  • Code plugins –  Plugins define custom business logic through .NET that can be triggered by a wide range of events in the platform. They provide the ultimate in fine-grain extensibility for pro-devs.
  • Custom Workflow activities – Similar to plugins, these can be written in C# and allow definition of custom activities that can be triggered as part of a workflow to execute custom business logic not easily expressed declaratively.

What do these changes mean for your existing canvas apps and any new canvas apps that you can build on the Common Data Service for Apps?

New canvas apps will continue to be able to use the Common Data Service for Apps as a data source and will also gain some new and much requested capabilities. The most exciting being the ability to use the above mentioned server-side logic in your canvas apps. Business Process Flows are not yet supported in Canvas apps, but all the other types of entity scoped server side logic can be used with Canvas apps. Evan provides details on how to get started using business rules in a canvas apps.

For existing canvas apps currently using the Common Data Service there will be some manual upgrade work required to enable the new functionality for those instances, you will begin receiving notifications starting in April with details. No worries, your existing CDS instances will continue to work, new CDS for Apps instances will already have all the new capabilities enabled.

But wait there’s more…!

While the addition of the Common Data Service for Apps is big step forward for us, expanding the scope of the business problems PowerApps can be used to address, we’ve also continued to invest in our current core feature set. For example, web authoring going to GA today and continued app performance improvements.

If you build apps connected to SharePoint, I’m sure you’ll be very happy to see we are adding support for natively uploading attachments into SharePoint lists, yes, including photos! You can read all about it in Filip’s blog.

We’re continuing the deep PowerApps integration with Microsoft Flow, including Flow support for business process modeling. Business process flows are an extremely powerful approach to business process modeling. Stephen expands on BPF and a lot of great new Flow capabilities in the Flow blog.

Our Admin capability is getting a boost with new PowerShell cmdlets to automate lifecycle management and monitoring for PowerApps and Flow, we’re GDPR compliant, and we’re also starting to combine admin centers into a new unified Business Application Platform Admin center.

Even though this is a fairly long blog post, this is still not mentioning all the new capabilities. If you want to read more, check out the Business Application Platform section of the Spring wave release notes.

While we’re very excited about the updates we’re announcing today it’s just the beginning. We have big plans for the next 12 months as we work to integrate the model-driven world with the canvas world much more tightly, bringing more of the declarative capabilities into canvas apps, and enabling more canvas like functionality into model-driven apps.

What we’re most excited about is seeing what you create with PowerApps and hearing your feedback on what you like and where we need to improve. Your fingerprints are all over the last 18 months of our updates and additions and we want more of them over what we do in the next 18 months, so please keep your feedback coming and go and create a new CDS for Apps environment to try out all the new capabilities!

¿Qué es PowerApps?

Original URL…

¿Qué es PowerApps?What is PowerApps?

PowerApps es una colección de servicios de software y de aplicaciones que funcionan conjuntamente para transformar a nivel fundamental la forma en que se crean y comparten aplicaciones de línea de negocios personalizadas.PowerApps is a collection of software services and apps that work together to fundamentally transform and accelerate how you build and share custom line of business applications.

Introducción animada a PowerApps

PowerApps se conecta a los orígenes de datos y servicios en la nube que ya usa, lo que le permite generar aplicaciones rápidamente que cubren necesidades concretas (basándose en los conocimientos que ya posee).PowerApps connects to the cloud services and data sources you’re already using, giving you the ability to quickly build apps that suit specific needs – building on skills you already have. Puede compartir aplicaciones al instante con sus compañeros de trabajo a través de la Web, de tabletas y de dispositivos móviles.You can share apps instantly with your co-workers across the web, tablets, and mobile devices. PowerApps también se integra con Microsoft Flow, lo que permite desencadenar flujos de trabajo desde las propias aplicaciones.PowerApps also integrates with Microsoft Flow, making it possible to trigger workflows from within apps. PowerApps puede ser rápido y sencillo, capaz de generar una aplicación en minutos que extrae datos de Excel o de un servicio en la nube.PowerApps can be simple and fast – capable of producing an app in minutes that pulls in data from Excel or a cloud service. Pero PowerApps también es estable y orientado a la empresa, y está listo para atender requisitos complejos como el seguimiento de los recursos de una empresa y el enlace a los sistemas back-end.

Microsof Power BI

¿Qué es Power BI?

Power BI es una colección de servicios de software, aplicaciones y conectores que funcionan conjuntamente para convertir orígenes de datos sin relación entre sí en información coherente, interactiva y atractiva visualmente. Tanto si se trata de una sencilla hoja de cálculo de Excel como de una colección de almacenes de datos híbridos locales o basados en la nube, Power BI le permite conectar fácilmente los orígenes de datos, visualizar (o descubrir) lo más importante y compartirlo con quien quiera.

Power BI puede ser sencillo y rápido; capaz de crear información rápida a partir de una hoja de cálculo de Excel o una base de datos local. Sin embargo, Power BI también es estable y tiene una funcionalidad apta para empresas, listo para un modelado exhaustivo y un análisis en tiempo real, así como para un desarrollo personalizado. Por tanto, puede convertirse en su herramienta personal de creación de informes y visualización, así como actuar como el motor de análisis y de decisión que impulsa proyectos en grupo, divisiones o empresas enteras.

Las partes de Power BI

Power BI consta de una aplicación de escritorio de Windows denominada Power BI Desktop, un servicio SaaS (software como servicio) en línea denominado servicio Power BI, y aplicaciones móviles de Power BI disponibles para teléfonos y tabletas Windows, así como para dispositivos iOS y Android.

Estos tres elementos, Desktop, el servicio y el destinado a dispositivos móviles, están diseñados para permitir a los usuarios crear, compartir y utilizar información empresarial de la forma que les resulte más eficaz para su rol. More…