2 New & 2 Improved Power Apps Functions
ฝัง
- เผยแพร่เมื่อ 1 ส.ค. 2024
- Dive into the exciting world of Power Apps with our latest video, where we explore the newest features and improvements that will revolutionize how you work with Power Apps! From enhanced table functionalities to simplifying JSON operations, encoding HTML, and leveraging Unicode characters, this video is your go-to guide for mastering these updates. Whether you're looking to merge tables effortlessly, flatten JSON for better data handling, or add a touch of creativity with Unicode characters, we've got you covered. Don't miss out on these powerful tips and tricks that will elevate your Power Apps experience!
What You'll Learn:
Table Function Improvements: Learn how to seamlessly merge tables, add records, and work more efficiently with your data.
JSON Made Simple: Discover how the updated JSON functionalities can help you simplify your data structure, making it easier to manage and interpret.
HTML Encoding: Understand the significance of encoding HTML in Power Apps and how it can enhance your app's compatibility with various platforms and services.
Unleashing Unicode Characters: Add flair to your apps with Unicode characters. We'll show you how to use them creatively within your Power Apps projects.
Perfect For:
Power Apps Developers looking to stay up-to-date with the latest features.
IT Professionals seeking to enhance their app development process.
Anyone interested in making their Power Apps projects more dynamic and efficient.
Up your Power Apps Skills Today!
www.powerapps911.com/up-your-...
0:00 Four New Power Apps functions
0:47 Merge Collections in Power Apps
3:43 Combining tables in a gallery
6:52 Add items to distinct dropdown
10:18 EncodeHTML Power Apps function
12:20 JSON FlattenValuesTable
14:27 UniChar, Char, Hex2Dec functions
Do you need some help with something that you are working on, contact us!
www.powerapps911.com/contact
UniChar www.vertex42.com/ExcelTips/un...
PowerApps911
www.powerapps911.com/
Let's connect on social!
Twitter: / shanescows
Facebook: / powerapps911
Instagram: / shaneyoung911
LinkedIn: / cincyshane
Join this channel to get access to perks:
/ @shanescows
#powerapps #PowerPlatform #CanvasApps - วิทยาศาสตร์และเทคโนโลยี
The table function update is a simple but MASSIVE change. Thanks a lot for the video Shane
I agree. Happy to help.
The table part looks like a way to join small tables on the front end instead of the backend. That can come in pretty handy. That’s not the only I like, but that’s a big deal!
Thanks for sharing Shane!
You are welcome. I think your explanation is spot on and it is very helpful.
"Jason...like that killer movie thing..."😆 Great intro to the new Table function, Shane!
I was in a weird mood with all of my random comments. 🤣
I've got so many apps running "ALL" lists, with complicated filters on reporting and various process steps... Huge win!
I agree, I got super excited when I realized that was the big win with that function.
Hi Shane, as usual great video ;-), for HTML encoding as you mention it's really handy for the API where you need to pass information, here's a scenario where I'm using it to generate a QR code for a business card using the office365 connector and you probably know that a VCF card as a lot of information and it needs to be encoded to be usable by the API
I am most excited about the Table function and being able to quickly spin up an "All" option for my drop downs.
That does seem to be the big slam dunk for everyone. 😀
Brilliant! The table function update is amazing, the ability to add items to drop down lists or choices - could even use an add record as a type of header. so many options now available. Thank you for highlighting this Shane
Happy to help. Have a great day. 🐶
Thank you Shane. The table function update is my favorite
Mine too, opens a lot of doors.
Thanks for sharing.
You are welcome 🤩
I needed this video last week 😭 but thank you so much for sharing this info!
Sorry I am slow. 🤩
Thanks a million for making us aware of these changes. Wow! the Table one is really good to know but the JSON and the others are also good to be aware of. Appreciated
My pleasure!
Nice with the table function. Thanks for the update 😊😊
You bet Frank!
Thanks Shane! Now I am busy making dropdown items more sleek and performant!
Perfect! Love it 🤩
NOOICE! 😀😀👍👍 ...also, FIRST!!
You will always be 🥇 for me
Very timely. One of my students was working on this last night and got stuck using the collections approach. Shared this with him this morning.
Glad it was helpful!
Yup. Great video Shane. ❤ Thank yo.
Happy to help, have a great day!
There's 1 life changing event today, and it's this video, not the eclipse.
Do you come out and fight crime during the eclipse since it will be dark? 🤣
Thanks Shane
Happy to help! Have a great day!
Thanks
I appreciate the support Paul! 🤩🐶
Great news, I've tried this table marge stuff several times but I was never happy with the results.
Thanks for sharing!
Happy to help. Have a great day. 🐶
What are we supposed to do with all the loops we have had to jump through to add "ALL" to combo boxes?
Donate them to charity for the tax write off before they expire? 🤣
Great video shane!! encode base64 would be more useful then encode html LoL
Breed : Cat got me good :D
😹
Hey legend... Thank God you post videos like this... Keep it up buddy... I open my testing app and type Table('Sharepoint_List1', 'Sharepoint_List2') but they weren't merged. The output is giving me a table with 2 table records when it should give me a merged table... Any idea Shane?
It doesn't merge the rows of data. Just puts all of the rows from both tables into one table. Is that maybe the confusion?
@@ShanesCows nevermind Shane haha... I had the data row limit at 1 to make sure I don't have delegation issues so it was only giving me 1 record for each table 😅😅😅😅😅😅 so the Table() function has delegation limitation... Many thanks legend...
Hey Shane, I could not make the Table() function to merge my tables, mind to give me a hand? any documentation where I can understand the function
Here is the Microsoft documentation. learn.microsoft.com/en-us/power-platform/power-fx/reference/function-table Hopefully it helps.
Hi Shane, suddenly the images stored in sharepoint list is not showing in PowerApps using Absolute url... do we need to make change using encode url to fix this. your thoughts on this will be very helpful
I just did a test and they are working for me. Maybe spin up a new app and test, see if you can find your issue.
If we use table function and combine two different datasources, then how to perform other operations on gallery items like filter, search or pagination?
Did you ever get this answered??
Hello Shane. I’ve been trying to do that with a ComboBox, so that an additional record with All is displayed. But it’s not working. What do I need to do differently than with a dropdown?”
i encounter delegation warning on table function.. any tips to avoid that?
Nope, the function is not delegable. Sorry
they need to introduce "for" loop in powerapps...
I would love that. In the meantime I have our special way we do it th-cam.com/video/YhUzkrWOfro/w-d-xo.html
Yeah we need a lambda kind thing
The code is not working anymore it was working before, then all of a sudden it stop displaying my data
Which code? I just checked the Table function and it worked for me to combine 2 tables.
Its giving me delegation warning
Also im using dataverse
@@ShanesCowstable(table1,table2,table3) dont work for me
….and now we have a CB penguin 🐧 in our app.
I love this! One of my kids love penguins so they always me smile.
Wow. The most awaited, Table function and the All. That's All I wanted 😉. Thanks Shane 🪟. ❤
You are welcome. It was a pretty awesome surprise.