Skip to main content
Microsoft logo
Power Apps
    • AI Builder
    • Automate processes
    • Azure + Power Apps
    • Build apps
    • Connect data
    • Portals
  • Pricing
    • Overview
    • Become a Partner
    • Find a Partner
    • Find consulting services
    • Blog
    • Customer stories
    • Documentation
    • Roadmap
    • Self-paced learning
    • Webinars
    • Overview
    • Issues
    • Give feedback
    • Overview
    • Forums
    • Galleries
    • Submit ideas
    • Register
    • ·
    • Sign In
    • ·
    • Help
    Go To
    • Power Apps Community
    • Get Help with Power Apps
    • Building Power Apps
    • Microsoft Dataverse
    • AI Builder
    • Power Apps Governance and Administering
    • Power Apps Pro Dev & ISV
    • Power Apps Portals
    • Power Platform Integration - Better Together!
    • Power Platform Integrations
    • Power Platform and Dynamics 365 Integrations
    • Community Blog & News
    • News & Announcements
    • Power Apps Community Demo Extravaganza 2020
    • Galleries
    • Community App Samples
    • Webinars and Video Gallery
    • Canvas Apps Components Samples
    • Kid Zone
    • Business Value Webinars and Video Gallery
    • Emergency Response Gallery
    • 2019 Microsoft Business Applications Summit Recordings (Archived)
    • Microsoft Business Applications Summit 2020 Session Recordings
    • Ideas
    • Power Apps Ideas
    • Community Support
    • Community Accounts & Registration
    • Using the Community
    • Community Feedback
    cancel
    Turn on suggestions
    Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
    Showing results for 
    Search instead for 
    Did you mean: 
    • Power Apps Community
    • Galleries
    • Community App Samples
    • Power Apps Formula Reference

    Power Apps Formula Reference

    08-06-2020 08:27 AM - last edited 09-17-2020 08:34 AM

    Super User II PowerAddict
    Super User II
    7813 Views
    LinkedIn LinkedIn Facebook Facebook Twitter Twitter
    PowerAddict
    Super User II PowerAddict
    Super User II
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    Power Apps Formula Reference

    ‎08-06-2020 08:27 AM

    Announcing the Power Apps Formula Reference!

    I am very excited to announce the release of an app that I have been working on for a few months now! Use it if you are looking for a one stop shop for all Power Apps formulas to use as a reference. Or simply share it with someone who is getting started on this beautiful journey! It provides an interactive illustration for each formula. As a result, users not only see the syntax, but also enter their own data and see what the formula does! So enter text/numbers, pick a date, or choose a value from a dropdown and see the magic unfold!

    Story

    This all started with a Lunch & Learn session at Hitachi Solutions. It was an introductory session where we introduced formulas and showed a couple of examples! As a result, I thought about how awesome it would be to have that experience for all formulas. That realization, in turn, resulted in the creation of this app! This was a fun project. However, the biggest challenge was to to come up with working/interactive examples for each formula without adding any datasource.

    Features

    • 150+ interactive illustrations covering (almost) all Power Apps formulas
    • Instructions to guide users through the illustrations
    • Search through the list using formula name or keywords
    • Self contained data and no external data sources
    • Videos for formulas that require a datasource for illustration
    • Supports both online and offline usage
    • A simple illustration of offline capabilities
    • Links to official Microsoft Docs pages for detailed explanations
    • Provide feedback (better illustration ideas, corrections etc.) with one click

    What this is not

    • This supplements Microsoft Docs, not replace them. Therefore, use the docs for detailed explanations of each formula
    • This does not illustrate how formulas can be used with each other to solve more complex problems

    To summarize, if you want to have fun with Power Apps formulas, go ahead and download this app!

    Power Apps Formula Reference.msapp
    Labels:
    • Labels:
    • Featured
    • Formulas and controls
    Message 1 of 13
    7,813 Views
    28 Kudos
    Reply
    • All posts
    • Previous Topic
    • Next Topic
    • « Previous
      • 1
      • 2
    • Next »
    maviso
    maviso
    New Member
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    ‎08-06-2020 02:18 PM
    Hello. I'm not able to download. Can you check what's going on? Thank you
    Message 2 of 13
    7,411 Views
    4 Kudos
    Reply
    PowerAddict
    Super User II PowerAddict
    Super User II
    In response to maviso
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    ‎08-06-2020 02:56 PM

    Hi @maviso , 

     

    The download only works on the icon next to the file name: 

     

    Capture.PNG

     

    Can you please confirm that you are able to download when you click on the download icon? 

     

    Please let me know if you are still facing issues with either the download or import, and I will be more than happy to call/chat or do whatever it takes to ensure you get your hands on this app!

     

    Awaiting your reply. 

     

    Thanks,

    Hardit

    Message 3 of 13
    7,386 Views
    0 Kudos
    Reply
    FranciscoMoro
    FranciscoMoro
    New Member
    In response to PowerAddict
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    ‎08-07-2020 12:20 AM

    Due above posts , ust to confirm I did download it and it works fine. 

    Message 4 of 13
    7,059 Views
    2 Kudos
    Reply
    KrishnaV
    Super User III KrishnaV
    Super User III
    In response to PowerAddict
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    ‎08-07-2020 09:59 AM

    It is working thank you a ton for all your efforts.


    I hope this resolved your issue if you see any challenge/need further help please let me know I am always happy to do it for my community.

    Proud to be a Super User!

    Regards,
    KrishnaV
    Business Applications MVP
    Twitter | Linkedin | YouTube | GitHub
    If this post helps you give a 👍 and if it solved your issue consider Accept it as the solution to help the other members / new members of the community.
    Message 5 of 13
    6,607 Views
    2 Kudos
    Reply
    hkhurshid
    hkhurshid
    Regular Visitor
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    ‎08-08-2020 03:19 AM

    hi i am unable to import please help me on this

    regards,

    Hassan

    Message 6 of 13
    6,210 Views
    2 Kudos
    Reply
    hkhurshid
    hkhurshid
    Regular Visitor
    In response to hkhurshid
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    ‎08-08-2020 03:33 AM

    its done thanks

    Message 7 of 13
    6,202 Views
    2 Kudos
    Reply
    Morten_CC
    Morten_CC
    New Member
    In response to hkhurshid
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    ‎08-09-2020 12:25 AM

    Hi all
    I may be doing it wrong, but I struggle to import the donwload as a .zip folder into PowerApps.

    Can anyone assist?

     

    Thanks

    Message 8 of 13
    5,960 Views
    2 Kudos
    Reply
    hkhurshid
    hkhurshid
    Regular Visitor
    In response to Morten_CC
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    ‎08-09-2020 12:41 AM

    Hi,

    1: download normal (Power Apps Formula Reference.msapp)
    2: sign in power apps

    3: click on Apps button

    4: click new app
    5: click on open
    6: click on browse file (mention path where downloaded file reside)

    regards,

    Hassan

    Message 9 of 13
    5,953 Views
    4 Kudos
    Reply
    FranciscoMoro
    FranciscoMoro
    New Member
    In response to hkhurshid
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    ‎08-09-2020 07:59 AM

    Note that download porviddes is .msapp extension file, thats means you only can upload from fileopctin in Powwer Apps client for example in Windows 10, which has file import powoption in Power Apps Wen Client.

     

    From  Power Apps administration console you ony can import solution in zip file format.

     

    Once you can upload you can share with your collegues and export again.

     

    FranciscoMoro_0-1596984934856.png

    please follow ths link for reference

    https://powerusers.microsoft.com/t5/Building-Power-Apps/How-To-Open-MSApp-Files/m-p/184972#M60743

     
     

     

     

     

     

     

    • te e
    Message 10 of 13
    5,687 Views
    2 Kudos
    Reply
    • « Previous
      • 1
      • 2
    • Next »

    Power Platform

    • Overview
    • Power BI
    • Power Apps
    • Power Automate
    • Power Virtual Agents

    Power Apps

    • Sign in
    • Sign up

    Browse

    • Sample apps
    • Services

    Downloads

    • Studio
    • iOS
    • Android

    Learn

    • Documentation
    • Support
    • Community
    • Give feedback
    • Blog
    • Partners

    • © 2021 Microsoft
    • Follow Power Apps
    • Privacy & cookies
    • Manage cookies
    • Terms of use
    • Trademarks