web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Welcome to the Power Platform Communities
Season of Giving Solutions is Here!
Explore Copilot Studio Forums, Blogs & Galleries!
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Gallery / Power Apps - Webinars and Video Gallery / Galleries - No Default Sele...

Galleries - No Default Selected Item/Multiple Selections/Multiple Filters

Views (3420)
BenFetters Profile Picture Posted by BenFetters

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))

bandicam 2019-03-...

Categories:

Comments

  • CapstoneAdmin Profile Picture CapstoneAdmin 125
    Posted at
    Galleries - No Default Selected Item/Multiple Selections/Multiple Filters

    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.

  • BenFetters Profile Picture BenFetters
    Posted at
    Galleries - No Default Selected Item/Multiple Selections/Multiple Filters

    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/

  • dthueringer Profile Picture dthueringer
    Posted at
    Galleries - No Default Selected Item/Multiple Selections/Multiple Filters

    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.