What programming languages are used in Microsoft Power Platform?

In Microsoft Power Platform, several programming languages and technologies are used, depending on the specific tool within the platform. Here's an overview:

Power Apps:

• Canvas Apps:

  • Power Fx: The primary low-code language used in Canvas Apps. It's a formula-based language similar to Excel functions, allowing users to build logic, interact with data, and create custom user interfaces.

    • Learn Power Fx

  • JavaScript: For more advanced customizations, JavaScript can be used, especially when working with Power Apps components or integrating with other web technologies.

    • Learn JavaScript

• Model-Driven Apps:

  • Power Fx: Used for business logic, data integration, and UI customizations in Model-Driven Apps, often in combination with Microsoft Dataverse for database interactions.

    • Learn Power Fx for Model-Driven Apps

  • JavaScript: Model-Driven Apps often rely on JavaScript for advanced customizations, form controls, and event handling.

    • Learn JavaScript for Power Apps

Power Automate:

• Workflow Automation: Power Automate uses a visual, low-code approach for automating workflows. However, behind the scenes, you can also use expressions and formulas similar to Power Fx.

  • Learn Power Automate

• Azure Logic Apps: For more complex automation, you can extend Power Automate with Azure Logic Apps, which might involve additional coding in languages like C# or JavaScript.

  • Learn Azure Logic Apps

Power BI:

• DAX (Data Analysis Expressions): Power BI uses DAX for defining calculations, measures, and business logic within reports and dashboards.

  • Learn DAX

• M (Power Query Formula Language): For data transformation and shaping, Power BI relies on M, a language used in the Power Query Editor.

  • Learn M Language

• R and Python: For advanced data analytics and visualizations, Power BI allows the integration of R and Python scripts.

  • Learn R in Power BI

  • Learn Python in Power BI

Power Virtual Agents:

• No-Code/Low-Code Interface: Power Virtual Agents primarily uses a visual, no-code interface for building bots. However, for advanced scenarios, you can write JavaScript or use Power Automate to trigger more complex logic.

  • Learn Power Virtual Agents

  • Learn JavaScript for Virtual Agents

In general, Power Platform is designed to be low-code, but it supports using traditional programming languages like JavaScript, C#, R, and Python when more customizations or integrations are needed.