11-26-2019 08:16 AM
In this PowerApps Tutorial video I'll be showing how to get around the default select item issue with galleries so that you can have no items selected as well as being able to select multiple items and filter galleries based on multiple filters. Let me know if you have any questions or if you would like me to do a video on a specific subject in PowerApps and I'd be happy to help!
Enjoy!
Functions used:
OnVisible: ClearCollect(colCustomers,AddColumns(ForAll(Customers,{Title:Title}),"Selected",false))
Gallery - OnSelect: Patch(colCustomers,ThisItem,{Selected:!ThisItem.Selected})
Filtered Gallery - Items: If(CountIf(colCustomers,Selected) = 0,Projects,Filter(Projects,LookUp(colCustomers,Title = Customer).Selected))
watch?v=-35hXN9s5kQ
Very nice video! Is there a way to make this delegable? I am using sql server as data source and I have unfiltered way more than 2000 rows.
Thanks in advance.
My initial response would be that you would have to save your sql data into a collection first, and then it would be delegable. But let me look into it more and I will get back to you! In the meantime, these pages might help a little if you haven't looked at them yet -
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/delegation-overview
https://docs.microsoft.com/en-us/connectors/sql/
Hey Ben, what is the items of your gallery set to for the Project owners? I'm trying to reproduce your results but can't get it to work.