5 Fancy Functions in Power Apps
ฝัง
- เผยแพร่เมื่อ 1 ส.ค. 2024
- #powerapps #PowerPlatform #CanvasApps #powerfx
In this engaging tutorial, Shane Young dives into five "fancy" Power Apps functions that are essential for Power Apps developers. Despite the casual term "fancy," these functions are practical tools that can significantly enhance your Power Apps experience. Shane not only introduces each function but also demonstrates practical examples of how they can be integrated into your projects. The video is a must-watch for anyone looking to deepen their understanding of Power Apps and streamline their app development process.
Functions Covered:
Coalesce: Learn how to return the first non-blank value in a sequence, a handy tool for managing data inputs.
Sequence and AddColumns: Discover how to generate dynamic tables and shape data effectively using these functions.
Notify: Get insights into creating subtle user notifications within your app, a simpler alternative to modal pop-ups.
With: Explore how to reduce redundancy in your formulas, making your code cleaner and more efficient.
Key Takeaways:
Practical demonstrations of each function.
Tips on integrating these functions into various scenarios.
Insights into making your Power Apps more efficient and user-friendly.
Challenge for Viewers:
Shane encourages viewers to solve a challenge using the Weekday function, adding an interactive learning element to the video.
Up your Power Apps Skills Today!
www.powerapps911.com/up-your-...
0:00 Five Fancy Functions
0:30 Coalesce function
5:07 Sequence function
8:20 AddColumns function
12:03 Notify function
14:45 With function
Do you need some help on something that you are working on, contact us!
www.powerapps911.com/contact
PowerApps911
www.powerapps911.com/
Let's connect on social!
Twitter: / shanescows
Facebook: / powerapps911
Instagram: / shaneyoung911
LinkedIn: / cincyshane - วิทยาศาสตร์และเทคโนโลยี
For anyone looking to learn or refine power platform skills. I highly recommend Shane and his channel, as well as his website as a learning resource. I have been all over Google and TH-cam over the past 120 days or so and time and time again Shane has come through for me. I just signed up for his channel which is very reasonably priced for the content you get access to. But the main reason I feel compelled to recommend him is that he truly cares about his viewers. He has been more responsive to me on a non-paid plan than others that I signed up for in the past. So, Kudos to you, Shane!
This video was made 3 weeks and 4 days ago. Nice!!
I was just jumping in to review the "With" function on TH-cam. You read my mind, Shane!
Love it. Happy to help. Have a great day. 🐶
Nice work Shane! A video comparing "With" and "As" functions would be really great! Thank you for all the good videos
That's the best explanation of "With" that I've seen. Good job, Shane.
Thanks. I love the feature and I hope to get other people to.
Great call out on some of the lesser known/used functions! I've been using With so much more thanks to you. Makes my code so much cleaner and easier to understand! Thank you for all you do.
You are welcome, I love hearing what I do is helping. 🙂
This was really good, Shane. The Coalease is one I do know about but haven't used in any App yet because I never properly understood it but its much much clearer after watching your video. The usecases with the Sequence and With functions deepened my understand as I've used them sparingly. I think I'll start using them more often. Thanks for making it look very simple to understand. 🤣🤣
LOL. I discovered Coalesce in one of your videos recently and fell in love with it.
I taught my 301 live class last week. We must have used Coalesce a dozen times. Such a useful function once you understand it. 🤩
Great video! Something else about sequence is it allows one gallery to have multiple tables. Keeps the app clean when you use galleries instead of dropdowns
Sequence is the best 😎
Nice one... Thanks Shane.... The "with" stuff is really helpful 👍👍💥💥
With might be my favorite function. 😍
Thank you Shane for the tips on With function
Thanks, I appreciate all of the comments.
Nested width just blew my brain. Nice!! =)
Awesome. There is hopefully a lot of gold hidden in this video. 😎
great video with fancy functions!
Glad you liked it! Thanks
The best way I've been using notify is when I run workflows from the app. If you use your run after failure setting effectively, then you can effectively put responses back into powerapps after each scope or action within your flow. That way if that step fails the user can know a little more about what the issue was before they just go straight to support saying the flow keeps failing with a generic message (which often are very hard for a frontline user understand / not in plain text). If you wrap the run code inside notify and the response is text, then .... you get the idea? It doesn't have to be only about failures though, you could have a workflow that 'grades a response' or does 'xyz' and has multiple branching... you can send back different messages to within notify depending on the output of the workflow - so long as each respond to powerapps action has the same variable name.
Awsome. Thanks for sharing!
You mentioned posting a link to a video about how you do pop-ups? Most appreciated
th-cam.com/video/BL7a5PmgZoc/w-d-xo.html Sorry about that.
hey cool i use the sequence in the following setup when i read out some specific gallary element, like Last(FirstN(blabla,thisrecord).value that might be a topic to cover for you.
Very cool! I will add it to my list, thanks for sharing. I actually just made a short on Sequence also for tomorrow. Shhh!
Great video, as always. Any tips on how to avoid delegation on using some of the functions (like add columns).
Nesting functions is about the best I have th-cam.com/video/iG8SjWtX1yM/w-d-xo.html Use something that is delegable inside a non delegable fucntion.
Could the Mod have been included in the first With and the nested With was just a "teaching moment"? Or do they have to be separate functions.
Mod references the With output so it had to be nested in this case. :)
How to upload multiple files to dataverse record and save it to share point doc library.And send notification email to user in that particular dataverse record with multiple documents attached in the email
Does As qualify as a fancy function? Does it work in a way that complements With, or am I associating two things unnecessarily? Any videos on. As? Thank you, @ShaneCows
I think of As as a way to make looping and filtering formulas easier. Watch the video on Forall and you will see As in action. ForAll and other Functions in Power Apps
th-cam.com/video/fmLCnIeYcn4/w-d-xo.html
@@ShanesCows thank you! (from a Chiefs fan) - hope your week/weekend goes well.
Great video as usual Shane! About your challenge , would something like this work?
=AddColumns(Sequence(Value(TextInput1.Text), Weekday(Today(),StartOfWeek.Friday), 7), "myDate", Today() + Value)
Shane you are very good teacher❤
I think this upper formula is correct.
I think this code answers my question, "Can you get this calculation to skip weekends"? However, I don't know where this fits into the With function.