Thanks April for throwing more light on this! Wow! This is great! I've been developing Power Automate flows but haven't used some of those complex expressions as yet. So glad the Powerapps expressions will become the defacto coding language for the PowerPlatform
April, thank you so much for sharing your knowledge on Power platform. Your video was recommended to me today and I'm really glad I found your channel! I've already gained valuable information from your videos and I subscribed. I'll keep coming back for more :)
Thanks, April. Great overview. Glad to have a name for the language & glad to see the commitment to unifying it across Power Platform. Good move, Microsoft.
Great question Lucas. I haven't heard any specifics on if this will work across portals so I can't say for certain. Portals are definitely a different beast so my suspicion would be no but if I find out more info I'll let you know.
Absolutely yes. That is the basis for the formula language so not only will it help you with Excel but also Canvas apps and eventually the entire Power Platform.
Thanks April, Nice introduction of Power Fx, My question - Is there a way to separate code blocks like UI, Business layer in Power Fx. Can you please share your thoughts, how to implement the same ? BR
can i use this as a replacement for ms access? I am accountant and i use ms access. i love ms access because it is a program for people who have no programing skills. as long as you know relational databases, you're good.
Hi Peter, Yes, absolutely you can use the Power Platform as a replacement! The Power Platform has the same goal of providing a way for people without programming backgrounds to build apps. To replace the front end of Access you would use Power Apps. To replace the back end you could use a variety of data sources like Dataverse of SharePoint. And Power Fx as shown in this video is the logic layer.
Thank you for the great video. When Power FX comes to power automate, will I need to rewrite all my expressions? Also will this come to Azure Logics Apps (based on power automate).
Good question - we don't know yet what the experience will be like when this reaches Power Automate since it's still awhile out. But we should know more as it gets closer to rolling out. I haven't heard anything about this coming to Logic Apps, I suspect that will remain separate since the audience for that is more code-first developers
@@marthaskjellerup3796 Definitely - this is just the beginning. In the next couple years we will start to see this used throughout the power platform and the uses cases will expand :)
One year after that announcement it would be interesting how far the development has come. We see interesting improvements in Excel formulas and i guess that has to do with Power fx. Can't wait to use Excel formula all over the other tools . Especially Power Automate is terrible.
Not entirely but they are a ton of similar functions like what was shown in the one image since it is based on Excel. There are some functions we can do in Power Apps that aren't in Excel for example.
@@Saif_Ali_Khan_1301 yeah I get that, but now there's yet another language you need to learn if you want to develop in the MS productivity space. I'm sure they have their reasons.
Unfortunately VBA has been pretty much abandoned rather than updated and made more cross platform. VBA could be used to make re-usable functions and supported things like classes and event sinking. Power Fx has none of that, so whereas VBA could support from Citizen Dev (what we used to call a Power User) up to a pro dev, PowerFx is much less... Powerful. It takes much longer for a competent dev to build a canvas Power App than VBA, as the VBA dev will have a tool bag of functions they can use to quickly perform common tasks safe in the knowledge they are already tested. Power Apps has components but they are preview (should not be used for production apps) and are not data-aware so far less flexible.
Valid question and I think others who have replied have touched on a few issues: VBA isn't as accessible non non-traditional devs and it isn't being updated really
So this is just the language that will power the formula building in the products. So Power Fx itself wouldn't have licensing implied. It would just be subject to the licensing requirements of the product you are using it in.
Thanks April for throwing more light on this! Wow! This is great! I've been developing Power Automate flows but haven't used some of those complex expressions as yet. So glad the Powerapps expressions will become the defacto coding language for the PowerPlatform
Yeah I think it will be a game changer for sure - super excited for it. Thanks for watching Douglas!
Thanks April, I saw this announcement earlier, good to understand it more
Thanks for watching Matt!
April, you are awesome! Thank you for all the great info!
Thanks - you're very welcome!
April, what would you recommend to someone like me who has no experience with Excel formulas?
I'm new to Power Apps but I know js very well - can we use js in the formula bar?
April, thank you so much for sharing your knowledge on Power platform. Your video was recommended to me today and I'm really glad I found your channel! I've already gained valuable information from your videos and I subscribed. I'll keep coming back for more :)
I'm glad you found my channel Hamza! Thanks for watching and subscribing 🙂
Thanks, April. Great overview. Glad to have a name for the language & glad to see the commitment to unifying it across Power Platform. Good move, Microsoft.
Thanks Jim!
Excellent explanation of ignite 2021! Power apps is already super intuitive but I can't say the same about power Automate.
Definitely, it will make expressions in Power Automate sooo much easier!
Thanks for this April. Do you know whether the plans for Fx are to also work across Power Apps Portal?
Good question, javascript and liquid at the moment.
Great question Lucas. I haven't heard any specifics on if this will work across portals so I can't say for certain. Portals are definitely a different beast so my suspicion would be no but if I find out more info I'll let you know.
Great summary... thanks April! 👏👏
You're so welcome! Thanks for watching!
April. Subtitles are disabled in this video ☹️
I'm so sorry about this - there's some weird error with this video and it isn't letting me use auto captions and I'm not quite sure how to fix it :(
Merci April. J'aime beaucoup ta présentation...
De rien! Heureux que vous avez apprécié!
@@AprilDunnam, comment ça se fait que vous parlez si bien le français? En outre la bonne presentation, ça ne surprend plus Très bien, choue.
👍 like to see standardise between canvas apps and Power Automate quicker
Me too :)
As a novice, would it make sense to learn MS Excel formulas?
Absolutely yes. That is the basis for the formula language so not only will it help you with Excel but also Canvas apps and eventually the entire Power Platform.
Hello April, will there be a integration of Power BI's DAX language to Power Fx?
I don't believe so. Everything I've heard so far is Power Fx will not affect Power BI's DAX language
Very clever on pointing out the "fx" for "Fx".
Thanks Joe - I'm a nerd like that and love knowing the history of how names came about 🙂
Hello april,
Okay?
Your video does not have the caption option, could you activate it?
Hello,
I'm not familiar with how captions work on UA-cam. I will have to look into it
Thanks April, Nice introduction of Power Fx, My question - Is there a way to separate code blocks like UI, Business layer in Power Fx. Can you please share your thoughts, how to implement the same ? BR
can i use this as a replacement for ms access? I am accountant and i use ms access. i love ms access because it is a program for people who have no programing skills. as long as you know relational databases, you're good.
Hi Peter,
Yes, absolutely you can use the Power Platform as a replacement! The Power Platform has the same goal of providing a way for people without programming backgrounds to build apps. To replace the front end of Access you would use Power Apps. To replace the back end you could use a variety of data sources like Dataverse of SharePoint. And Power Fx as shown in this video is the logic layer.
Great content as always
Glad you enjoyed it - thanks for watching!
April. thanks for the clear explanation!
You are so welcome! Thanks for watching!
Thank you for the great video. When Power FX comes to power automate, will I need to rewrite all my expressions? Also will this come to Azure Logics Apps (based on power automate).
Good question - we don't know yet what the experience will be like when this reaches Power Automate since it's still awhile out. But we should know more as it gets closer to rolling out. I haven't heard anything about this coming to Logic Apps, I suspect that will remain separate since the audience for that is more code-first developers
Ah FX like f(x) - so clever. I am sure this function based language will revolution the way we think and organize business :)
I think it will Martha - very excited to see how it all evolves!
@@AprilDunnam I can imagine that this is only the start. In a very short while, it will grow exponentially (the use cases and the apps)..
@@marthaskjellerup3796 Definitely - this is just the beginning. In the next couple years we will start to see this used throughout the power platform and the uses cases will expand :)
Smash that thumbs up button!
Thanks Rory!
Very well presented
Thank you!
Thank you, very good video and easy to understand
You're welcome Jonas - glad to hear it was helpful!
One year after that announcement it would be interesting how far the development has come. We see interesting improvements in Excel formulas and i guess that has to do with Power fx. Can't wait to use Excel formula all over the other tools . Especially Power Automate is terrible.
Greet summary happy to find your channel
Thanks - I'm happy you found it too!
Interesting. As usual great explanation.
Thanks for watching!
So whatever formula in excel we can use in powerapps?? 😯
Not entirely but they are a ton of similar functions like what was shown in the one image since it is based on Excel. There are some functions we can do in Power Apps that aren't in Excel for example.
Why didn't they just use VBA? It's what Office runs on.
I know right? I thought that as well...
@@Saif_Ali_Khan_1301 yeah I get that, but now there's yet another language you need to learn if you want to develop in the MS productivity space. I'm sure they have their reasons.
Unfortunately VBA has been pretty much abandoned rather than updated and made more cross platform. VBA could be used to make re-usable functions and supported things like classes and event sinking. Power Fx has none of that, so whereas VBA could support from Citizen Dev (what we used to call a Power User) up to a pro dev, PowerFx is much less... Powerful. It takes much longer for a competent dev to build a canvas Power App than VBA, as the VBA dev will have a tool bag of functions they can use to quickly perform common tasks safe in the knowledge they are already tested. Power Apps has components but they are preview (should not be used for production apps) and are not data-aware so far less flexible.
Valid question and I think others who have replied have touched on a few issues: VBA isn't as accessible non non-traditional devs and it isn't being updated really
I wonder if it'll be free in the future as well or a paid product
So this is just the language that will power the formula building in the products. So Power Fx itself wouldn't have licensing implied. It would just be subject to the licensing requirements of the product you are using it in.
Good to know, how much closer the Power Apps to the Excel, better is 😉
Exactly!
adding open source could be interesting. will be interesting if they'll make that free or a premium feature for the open source addons.
I believe it will free
All I want from Microsoft is for them to speak above my head to me so I can actually learn something quickly.
I’m sorry I don’t understand?
Watch 1.5x-2x
🙂