Pragmatic Works Nerd News

Power Apps: Ideas Feature For Canvas Apps No Formulas Required

Written by Manuel Quintana | Oct 17, 2026

In this blog, Manuel Quintana introduces the Ideas feature

What is the Ideas Feature?

The Ideas feature is built into the Canvas App design studio and allows users to provide natural language instructions for sorting, filtering, and formatting data. Power Apps then generates the necessary formula automatically, making it ideal for:

  • Beginners unfamiliar with formula syntax
  • Experienced users looking for faster solutions

Key Benefits

  • No formulas required: Simply describe what you want in plain language.
  • Time-saving: Quickly apply changes without writing complex expressions.
  • Learning opportunity: See the generated formula and learn syntax over time.

How It Works

Manuel demonstrates the Ideas feature using a teacher tenure application. Here’s how it works:

  1. Select the gallery or control you want to modify.
  2. Navigate to the Ideas
  3. Enter a natural language command (e.g., “Sort records by newest first”).
  4. Click Get Ideas and review suggestions.
  5. Apply the desired option—Power Apps updates the formula automatically.

Practical Examples

Here are some real-world scenarios Manuel covers:

  • Sorting Data: Sort achievement logs by date in ascending or descending order.
  • Formatting Dates: Change date display to include month abbreviations and commas.
  • Custom Text Formatting: Transform numeric values into descriptive text like “75.0 points earned.”

Advanced Feature: Train with Examples

The Ideas panel includes a Train with Examples

  • Input examples like “75.0 points earned” or “200.0 points earned.”
  • Click Get Ideas—Power Apps generates the formula for consistent formatting.

Why Use Ideas?

This feature is perfect for anyone who wants to:

  • Accelerate app development without memorizing formulas.
  • Experiment with formatting and sorting quickly.
  • Learn Power Apps syntax by observing generated expressions.

Final Thoughts

The Ideas feature continues to evolve with new updates, making Power Apps more accessible than ever. Whether you’re building your first Canvas App or optimizing an existing one, this tool can streamline your workflow and boost efficiency.

Tip: Don’t forget to like, subscribe, and explore Pragmatic Works for more training resources, hackathons, and on-demand learning opportunities.

Don't forget to check out the Pragmatic Works' on-demand learning platform for more insightful content and training sessions on Power Apps  and other Microsoft applications. Be sure to subscribe to the Pragmatic Works YouTube channel to stay up-to-date on the latest tips and tricks.