Skip to content

README.md

Latest commit

 

History

History
302 lines (233 loc) · 16.1 KB

README.md

File metadata and controls

302 lines (233 loc) · 16.1 KB

Power Fx Snippets 🏆

The world's most comprehensive collection of Power Fx code snippets for Microsoft Power Platform

GitHub stars GitHub issues GitHub PRs License

🎉 What's New -- v2.0.0 Release

Major repository restructuring complete! The repository has been reorganized with a feature-first architecture for better navigation, discoverability, and developer experience.

📣 Read the full v2.0.0 Announcement | 📋 Release Notes

✅ New Structure (9 Categories)

Category Description Highlights
📱 app-lifecycle/ App initialization & lifecycle Named formulas, OnStart, OnError
🎨 ui-controls/ Control-specific snippets Gallery, buttons, inputs, charts
🎭 ui-patterns/ Reusable UI patterns Dialogs, menus, theming, components
🌈 visual-assets/ Visual resources SVGs, icons, colors, fonts, emojis
📊 data-operations/ Data & transformations Sample data, JSON, geocoding
🔧 functions/ Functions & utilities UDFs, algorithms, string manipulation
🔗 integrations/ External services Office 365, Power Automate connectors
🎓 learning/ Educational content Tutorials, certification, best practices
🧰 utilities/ Tools & templates Validation scripts, templates

🆕 January 2026 Highlights

  • 230+ markdown files with standardized structure
  • YAML frontmatter on all snippets for searchability
  • Table of Contents auto-generated in all files
  • History sections tracking changes in every file
  • GitHub Actions for automated snippet validation and weekly link checking
  • Unit test coverage for all repository tools (validator, index generator, migration helper)
  • Issue & PR templates for consistent contributions
  • PRODUCT-INDEX.md -- Browse snippets by Power Platform product
  • MIGRATION-GUIDE.md -- Find where your old bookmarks moved

📋 View Migration Details | 🔍 Browse by Product

🚀 Quick Start

New to Power Fx? Start here:

Copy-Paste Code Examples

1. Detect if the app is running in Studio (edit) mode:

// Named formula -- place in App.Formulas
fxIsInStudioMode = StartsWith(Host.Version, "PowerApps-Studio");

Source: app-lifecycle/formulas/expressions/boolean-is-in-studio-mode.md

2. Alternating row colors (zebra striping) in a Gallery:

// Set TemplateFill on your Gallery control
If(
    Mod(ThisItem.OrderNumber, 2) = 0,
    Color.White,
    ColorFade(App.Theme.Colors.Lighter80, 50%)
)

Source: ui-controls/gallery/styling/alternating-row-colors.md

3. Convert a Color value to its hex string:

// User-defined function -- place in App.Formulas
fxGetHexFromColor(ColorValue: Color): Text = Left(
    Substitute(
        JSON(ColorValue, JSONFormat.Compact),
        """",
        ""
    ),
    7
);

Source: ui-patterns/theming/Theming.md

4. Random screen transition effect (UDF):

// User-defined function -- place in App.Formulas
fxRandomScreenTransition(): Text =
    With(
        { RandomNumber: RandBetween(1, 5) },
        Switch(
            RandomNumber,
            1, ScreenTransition.Cover,
            2, ScreenTransition.CoverRight,
            3, ScreenTransition.Fade,
            4, ScreenTransition.UnCover,
            5, ScreenTransition.UnCoverRight,
            ScreenTransition.None
        )
    );

Source: app-lifecycle/formulas/user-defined-functions/screen-transition-random.md

5. Parse JSON returned from a Power Automate flow:

UpdateContext(
    {
        locFlowResult: ParseJSON(MyFlow.Run(ThisItem.URL).response).value
    }
);
ClearCollect(
    colParsedData,
    ForAll(
        locFlowResult As MyRecord,
        {
            Name:        Text(MyRecord.Name),
            DisplayName: Text(MyRecord.DisplayName),
            Type:        Text(MyRecord.Type)
        }
    )
);

Source: data-operations/json/parsing-flows-json.md

📖 Table of Contents

🎯 Core Categories

Category Description Quick Access
📱 app-lifecycle/ App initialization & lifecycle Formulas • Error Handling
🎨 ui-controls/ Control-specific snippets Gallery • Buttons
🎭 ui-patterns/ Reusable UI patterns Theming • Components
🌈 visual-assets/ Visual resources Icons • SVGs
📊 data-operations/ Data & transformations Sources • JSON
🔧 functions/ Functions & utilities UDFs • Algorithms
🔗 integrations/ External services & APIs Connectors • Power Automate
🎓 learning/ Educational content Tutorials • Best Practices
🧰 utilities/ Tools & templates Tools • Templates

🛠️ Repository Tools

🔥 Popular Snippets

Quick Wins (5 minutes or less)

Snippet Category Difficulty
Alternating Row Colors ui-controls / gallery Intermediate
Detect Studio Mode app-lifecycle / formulas Beginner
Color to Hex Conversion ui-patterns / theming Intermediate
Random Screen Transition app-lifecycle / formulas Beginner
Error Kinds Collection app-lifecycle / formulas Beginner

Advanced Solutions

Snippet Category Difficulty
Responsive Hero Cards Gallery ui-controls / gallery Intermediate
Get Manager Rollup (Org Hierarchy) integrations / Office 365 Advanced
Parse JSON from Power Automate Flows data-operations / json Intermediate
Proportional Value Calculator (UDF) app-lifecycle / formulas Intermediate
Microsoft Base Themes ui-patterns / theming Beginner

Browse all snippets: By Category | By Product | By Tag

🎯 How to Use This Repository

For Beginners

  1. Start with Getting Started category
  2. Browse by difficulty level (beginner/intermediate/advanced)
  3. Use the search function with keywords like "gallery", "form", or "SharePoint"

For Experienced Developers

  1. Jump directly to specific categories that match your needs
  2. Filter by tags and prerequisites
  3. Check related snippets for comprehensive solutions

For Teams

  1. Use Learning Resources for onboarding
  2. Implement Best Practices across projects
  3. Leverage Advanced Patterns for complex scenarios

🔍 Search & Discovery

By Technology

By Use Case

🤝 Contributing

We welcome contributions! Here's how to get involved:

Ways to Contribute

  • 📝 Add Snippets: Share your Power Fx solutions
  • 🐛 Report Issues: Help improve existing content
  • 💡 Suggest Improvements: Propose new categories or features
  • 📚 Improve Documentation: Enhance guides and navigation

Getting Started

  1. Read our Contribution Guide
  2. Check existing Issues for ideas
  3. Fork the repository and create your branch
  4. Add your snippet with proper metadata
  5. Submit a pull request

Snippet Requirements

  • ✅ Metadata: Complete YAML front matter with title, description, category, tags, difficulty
  • ✅ Documentation: Clear explanation and usage examples
  • ✅ Code Quality: Well-formatted, commented Power Fx code
  • ✅ Testing: Include test scenarios where applicable

📊 Repository Stats

  • 📁 Categories: 9 main categories with 40+ subcategories
  • 📄 Snippets: 230+ code examples and patterns
  • 🏷️ Tags: Searchable tags for filtering
  • ⭐ Stars: Your support helps grow the community!

🏢 About Power Fx

Power Fx is the low-code language that powers Microsoft Power Platform applications. It combines the familiarity of Excel formulas with the power of a programming language, enabling both citizen developers and professional developers to create sophisticated business applications.

Key Features:

  • 📊 Excel-like syntax you already know
  • 🔧 IntelliSense and formula suggestions
  • 🌐 Cross-platform compatibility
  • ⚡ Real-time evaluation and debugging
  • 🔗 Rich integrations with Microsoft 365 and Azure

📞 Support & Community

Get Help

Community Resources

❓ FAQ / Troubleshooting

Where did my old bookmark go? The repository was restructured in v2.0.0 (January 2026). All files were reorganized into 9 feature-based categories. See the Migration Guide for a complete mapping of old paths to new locations.

How do I find snippets by product (Canvas Apps, Model-Driven, Power Automate)? Check the Product Index which groups every snippet by the Power Platform product it applies to.

How do I contribute a snippet? Read the Contributing Guide for instructions on adding snippets, reporting issues, or proposing improvements. Every snippet needs YAML frontmatter, a clear description, and working Power Fx code.

Power Fx is not working the way I expected. Power Fx has important syntax differences from .NET, Excel, and JavaScript. Before debugging further, read the Power Fx Gotchas document -- especially the section on date/time formatting where m/mm is context-sensitive.

How do I validate my snippet before submitting? Run the snippet validator tool: python utilities/tools/snippet-validator.py your-file.md. This checks YAML frontmatter, required fields, and valid category/tag values.

📄 License

This repository is licensed under the MIT License - see the LICENSE file for details.

🙏 Acknowledgments

  • Power Apps Community for inspiration and contributions
  • Microsoft Power Platform team for creating Power Fx
  • All Contributors who share their knowledge and expertise
  • You for being part of this amazing community!

⭐ Found this helpful? Star this repository to show your support!

🤝 Want to contribute? Check out our Contribution Guide to get started!

History

Date Author Changes
2026-02-17 Cleanup Fix stats (230+), update TOC links, fix paths to docs/, correct Reference/ case
2026-01-29 Phase 6 v2.0.0 launch updates: enhanced Quick Start, Popular Snippets, FAQ, What's New
2026-01-27 Migration Initial TOC and history section added