Transcrito

Microsoft Power Fx - Simply Explained

3 de ago. de 2026 · 17m 52s
Microsoft Power Fx - Simply Explained
Descripción

Many Excel users want to build apps but think they first need to learn a programming language. This Simply Explained episode shows beginners and citizen developers how Power Fx brings...

mostra más
Many Excel users want to build apps but think they first need to learn a programming language. This Simply Explained episode shows beginners and citizen developers how Power Fx brings the familiar formula mindset into Power Apps, from properties and button actions to data, variables and reusable rules.

In this episode
  • 00:00 – What Power Fx is
  • 01:50 – From spreadsheet cells to app properties
  • 04:52 – Properties turn formulas into app behavior
  • 07:37 – Working with business data
  • 11:03 – Variables, collections and reusable rules
  • 14:46 – One formula system in an expense app
  • 16:57 – Getting started and limits of low-code

Key takeaways
  • Power Fx is the Excel-like formula language of Power Platform, where formulas live in control properties instead of cells and update automatically.
  • Property formulas describe what a control should show, while OnSelect formulas run actions such as Notify or Navigate, and Filter, Sort and LookUp work with business data.
  • Variables and collections hold short-term context, reusable functions keep rules consistent, and lasting records belong in a proper data source such as SharePoint or Dataverse.

Worth quoting

“PowerFX is Microsoft's formula language for the Power Platform. It brings a familiar spreadsheet way of thinking into app building” – Mirko Peters (00:28)

“A text, visible, or color formula describes what something should be, while an on select formula runs because a person clicked or tapped.” – Mirko Peters (06:58)

Explore more on M365.FM
  • Episode page: the full episode with chapters, quotes and a short FAQ on Power Fx
  • Power Fx – the formula language explained here, from property formulas and OnSelect actions to reusable functions
  • Power Apps – where Power Fx formulas sit in control properties such as Text, Visible and OnSelect
  • Microsoft Excel – the familiar starting point, since Power Fx carries the spreadsheet formula mindset into app building
  • Power Platform – the wider family of tools where Power Fx serves as the shared formula language
  • Related episode: Power Apps Component Framework - Simply Explained

Follow and rate M365.FM in your podcast app, and join the free M365 community at m365con.net.

Become a supporter of this podcast: https://www.spreaker.com/podcast/m365-fm-microsoft-365-azure-cloud-power-platform-ai--6704921/support.
mostra menos
Información
Autor Mirko Peters M365, Azure & AI
Organización m365 FM
Página web www.m365.fm
Etiquetas

Parece que no tienes ningún episodio activo

Echa un ojo al catálogo de Spreaker para descubrir nuevos contenidos.

Actual

Portada del podcast

Parece que no tienes ningún episodio en cola

Echa un ojo al catálogo de Spreaker para descubrir nuevos contenidos.

Siguiente

Portada del episodio Portada del episodio

Cuánto silencio hay aquí...

¡Es hora de descubrir nuevos episodios!

Descubre
Tu librería
Busca