Transcribed

Microsoft Power Fx - Simply Explained

Aug 3, 2026 · 17m 52s
Microsoft Power Fx - Simply Explained
Description

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...

show more
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.
show less
Information
Author Mirko Peters M365, Azure & AI
Organization m365 FM
Website www.m365.fm
Tags

Looks like you don't have any active episode

Browse Spreaker Catalogue to discover great new content

Current

Podcast Cover

Looks like you don't have any episodes in your queue

Browse Spreaker Catalogue to discover great new content

Next Up

Episode Cover Episode Cover

It's so quiet here...

Time to discover new episodes!

Discover
Your Library
Search