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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Powerapp Canvas - Show...
Power Apps
Unanswered

Powerapp Canvas - Show Columns selecting Date from Picker

(0) ShareShare
ReportReport
Posted on by

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.

 

thanks

 

Lee

 

Categories:
I have the same question (0)
  • PavanKumar Profile Picture
    479 on at

    @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

    Regards,

    Pavan Kumar Garlapati

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the April Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
Vish WR Profile Picture

Vish WR 899

#2
Valantis Profile Picture

Valantis 571

#3
11manish Profile Picture

11manish 499

Last 30 days Overall leaderboard