Showing results for 
Search instead for 
Did you mean: 
Level: Power Up

Powerapp Canvas - Show Columns selecting Date from Picker

Hi all,


have a powerapp which is linked to a sharepoint list, first column is date, on the canvas I have a date picker and the gallery displays data from the sharepoint list - all working ok.


the bit I am trying to get working is currently it shows all data in the sharepoint list - ideally I want to use the date picker to show only the data with the selected date - deriving this from the date column.


the ability to move between dates as data is entered will show historic information however all the methods I have tried dont seem to link or make a diference.


completly new to powerapps so any help appreciated.






Level 8

Re: Powerapp Canvas - Show Columns selecting Date from Picker

@Sqdv ,


On screen visible property Create a collection as below:

ClearCollect(colGalleryItems,Filter(datasource,DateColumnName = datetime.text))

On visible when we collected the List information. On change Property of Datetime field in the form use same formulae as above. so on every change of the date it filters the data.


Finally Items property of Gallery just place colGalleryItems.



If this answers your question mark it as verified and give a thumbsup


Pavan Kumar Garlapati

Helpful resources


Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!


Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020


Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors (Last 30 Days)
Users online (6,902)