Copilot Studio Training - Power Automate Online Training
                     What Is Power Fx and How Is It Used in Power Apps?
What Is Power Fx?
• Power Fx is Microsoft’s low-code formula language used in Power Apps.
• It is inspired by familiar Excel-style formulas, making it easier to learn.
• Power Fx is used to create calculations, conditions, and app behavior.
• It helps makers build applications without writing traditional programming code.
• It turns business requirements into simple, readable formulas.
WWW.VISUALPATH.IN +91-7032290546
1
Why Was Power Fx Created?
• Traditional programming can require significant coding knowledge and development 
time.
• Power Fx makes application logic accessible to business users and citizen developers.
• Excel users can apply familiar concepts when moving into app development.
• Formulas can be created directly within app properties and controls.
• It helps teams build and modify business apps more quickly.
WWW.VISUALPATH.IN +91-7032290546
2
Where Is Power Fx Used in Power Apps?
• Buttons: Perform actions such as saving data or navigating between screens.
• Galleries: Filter, search, and sort records dynamically.
• Forms: Validate information and control how data is submitted.
• Labels and controls: Display calculated or changing information.
• Screens: Control visibility and behavior based on user actions or conditions.
WWW.VISUALPATH.IN +91-7032290546
3
Understanding Power Fx Formulas
• Power Fx uses functions such as If, Filter, LookUp, and Sort.
• Operators can be used to compare values and create logical conditions.
• Formulas can work with text, numbers, dates, records, and tables.
• Functions can be combined to solve more complex business requirements.
• Its readable syntax makes formulas easier to understand and maintain.
WWW.VISUALPATH.IN +91-7032290546
4
Power Fx and Data Sources
• Power Fx can interact with data from Dataverse, SharePoint, SQL Server, and other 
connectors.
• Filter can find records that match specific conditions.
• LookUp can retrieve a particular record or value.
• Patch can create or update records in a data source.
• Delegation allows supported operations to be processed by the data source for better 
scalability.
WWW.VISUALPATH.IN +91-7032290546
5
Real-World Power Fx Example
• A sales app can filter customers based on the salesperson selected.
• An approval button can check whether all required information is available.
• A search box can instantly filter a customer or product gallery.
• Patch can save updated customer information directly to a connected data source.
• Conditional formulas can show different messages or controls for different situations.
WWW.VISUALPATH.IN +91-7032290546
6
Best Practices for Using Power Fx
• Keep formulas simple, readable, and focused on one business purpose.
• Use meaningful names for controls, variables, and collections.
• Avoid unnecessary repeated calculations that can affect app performance.
• Check delegation warnings when working with large datasets.
• Test formulas with different inputs, users, and real-world scenarios.
WWW.VISUALPATH.IN +91-7032290546
7
Key Takeaways
• Power Fx brings spreadsheet-style formulas into modern low-code development.
• It allows users to create powerful application logic with less traditional coding.
• Power Fx connects user actions, business rules, calculations, and data.
• Its capabilities become stronger when combined with Power Apps and data connectors.
• Learning Power Fx is an important skill for building efficient and intelligent business 
apps.
WWW.VISUALPATH.IN +91-7032290546
8
 Contact
Microsoft Power Apps
Address:- Flat no: 205, 2nd Floor, Nilgiri Block, Aditya 
Enclave, Ameerpet, Hyderabad-1 
Ph. No: +91-7032290546 
Visit: www.visualpath.in 
E-Mail: [email protected]
WWW.VISUALPATH.IN +91-7032290546
THANK YOU
                                          Visit: www.visualpath.in
Scan me 
WWW.VISUALPATH.IN +91-7032290546