Power Apps Formula Reference 08-06-2020 08:27 AM - last edited 05-06-2021 14:37 PM

[PowerAddict]

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!

[Anonymous]

Hello. I'm not able to download. Can you check what's going on? Thank you

[PowerAddict]

Hi @Anonymous , 

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

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

[Anonymous]

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

[KrishnaV]

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

[hkhurshid]

hi i am unable to import please help me on this

regards,

Hassan

[hkhurshid]

its done thanks

[Morten_CC]

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

[hkhurshid]

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

[Anonymous]

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.

please follow ths link for reference

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