Power Platform Community Forum Thread Details

I am having a hard time understanding how Collections work. I have a list from SharePoint that has over 5000 items byt from those Items I only want to pull active items from that list which is roughly over 200. So I created a collection for that list called MyListCollection, so I'm trying to filter it to just show active items. To know which items are active is when the column "Completed is equal to 0" and items are located in the contract column. I have a contract dropdown box (this is where selected items will be stored) in the form, so how would I get that to work and pull just active items.

Categories:

Building Power Apps

@Anonymous

Collections are a complex topic in Power Apps so it is understandable that you feel this way. I had the same difficulties when I was learning. I've put together a huge list of all the most used techniques in what I call the 'Collections Cookbook' if you are interested! (https://matthewdevaney.com/powerapps-collections-cookbook/)

If you would like to only show the Active results here's how to do it. Use this code in the Items property of the dropdown.

["Active","Inactive"]

Then use this code in the Items property of the gallery to FILTER which records are being shown.

If(Dropdown_Status="Active", Filter(your_datasource_name, StatusColumnName = 0))

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."