Trascritto

Microsoft Power Fx - Simply Explained

3 ago 2026 · 17 min. 52 sec.
Microsoft Power Fx - Simply Explained
Descrizione

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 di più
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 meno
Informazioni
Autore Mirko Peters M365, Azure & AI
Organizzazione m365 FM
Sito www.m365.fm
Tag

Sembra che non tu non abbia alcun episodio attivo

Sfoglia il catalogo di Spreaker per scoprire nuovi contenuti

Corrente

Copertina del podcast

Sembra che non ci sia nessun episodio nella tua coda

Sfoglia il catalogo di Spreaker per scoprire nuovi contenuti

Successivo

Copertina dell'episodio Copertina dell'episodio

Che silenzio che c’è...

È tempo di scoprire nuovi episodi!

Scopri
La tua Libreria
Cerca