How to create multi-value filtering using a Tag Picker in Power Apps
Vložit
- čas přidán 9. 07. 2024
- In this video, learn how to use the Fluent Picker in canvas apps and model-driven custom pages to perform advanced filtering in a fully delegable way. I also show the new 'in (membership)' operator that can be used to filter using multiple lookup values in dataverse.
This is part of a series of videos on building a canvas app or model-driven custom page that shows a grid of accounts with fully delegable sorting, paging and filtering:
👉aka.ms/creatorkit
✅ Responsive Containers • Responsive containers ...
✅ Responsive Grid with adaptive columns • Dataverse Grid Control...
✅ Dataverse Delegable Paging in Power Apps
• Dataverse Delegable Pa...
✅ Multi-value filtering using a Tag Picker • How to create multi-va...
✅ Command Bar and model-driven navigation in custom pages
• Command Bar and model-...
🔗Information about delegation of 'in' operator: develop1.net/public/post/2022...
#PowerApps #CanvasApps #ModelDriven #CreatorKit
Contents:
00:00 Introduction
00:24 Overview of Filtering
01:29 Creating list of filter values for picker
04:43 Adding the Picker
06:54 Binding suggestions
13:57 Autoheight
15:46 Adding filtering
23:00 Tidy up filtering controls
27:58 Summary - Jak na to + styl
Scott you're a tremendous developer and orator. Thanks for letting us inside your brain every once in a while.
Excelente Muchas gracias !!!, Saludos desde Colombia.
¡Gracias, de nada! 🤗
Loving this series Scott. Making good use of some of these components in some of my own projects thanks to these videos! Looking forward to the next one
As always, greatly appreciated for these great resources that you are putting together, Scott. Keep them coming. :)
Thanks Hameed ☺️ I’ll keep them coming for sure!
thanks, it actually let me through so i could download it.
Looking forward to watching this. This is a wonderful learning resource. Thanks Scott
Thanks Jimbo! Let me know if there is anything you’d like me to expand on when you watch!
Mind blowing 💥Great one Scott. Thanks for sharing.
Thank you Kristof! Thank you for watching! Was there a specific part that your mind was blown by?! 😊
@@ScottDurow Content quality of your channel 👏🏻
Hi Scott, great content!
Is it possible to do this type of multi select filter with tag picker using only text values? I have single line of text fields in my sharepoint list, and I am using collections for setting up my choices in drop downs... not quiet sure how to implement this in my case... thank you in advance for reply!
cool
😎😂
Hi Scott, How to reset Tag Picker ?
The Fluent Picker uses a collection for the items which you maintain yourself by adding/removing from the collection onChange. To reset the tag picker, just clear the collection, i.e. Clear(myPickerCollection)
Set the delegation item limit to 5 or 2 and check whether the IN operator is truly delegatable or not. Greetings. :)
Hi Tom! Thanks for watching. You will need to update your version to the latest preview version at the moment to get the delegation. Check out the monitor trace I show at the end - it seems too good to be true I know 🚀🥳
@@ScottDurow I was playing with this operator last week and got a little scared. Although the yellow triangle did not appear, after setting the item threshold to 5, the query could not return sixth record from the dv table. I will double check with the latest version.
See GUID column for ‘in (membership) (preview)’ at learn.microsoft.com/en-us/power-apps/maker/canvas-apps/connections/connection-common-data-service#power-apps-delegable-functions-and-operations-for-dataverse
I blogged about the new delegation of 'in' here - develop1.net/public/post/2022/10/24/power-fx-delegation-of-in-operator-against-davaverse!
@@ScottDurow Thanks! This is great