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 / Select date to display...
Power Apps
Answered

Select date to display data

(0) ShareShare
ReportReport
Posted on by

hello everybody plz help me to : If I select a date, I must display all the data for that selected date.1.png

I have the same question (0)
  • timl Profile Picture
    37,137 Super User 2026 Season 1 on at

    Hi @Mustapha_Ait123 


    It sounds as though you want to filter and display the records in a table that match the value in your date picker control.

    The way to do this would be to add a gallery control to your screen, and to set the Items property to the return value of the Filter function.

    There are more details about this function in the documentation here:

    https://docs.microsoft.com/en-gb/powerapps/maker/canvas-apps/functions/function-filter-lookup

     

  • Verified answer
    v-albai-msft Profile Picture
    Microsoft Employee on at

    Hi @Mustapha_Ait123 ,         

    From your screenshot, I know that you are connecting to a SP list named “Bordereau”, but why you use “dataToExport” in your Lable2? Could you tell me what “dataToExport” is?

    You mentioned that you want to “display all the data”, do you want to display all the related list records based on a selected date? Or just want to return a specified column value of the records(for example, return the “Title” value of all records that match the selected date)?

    I assume you want to display all related records form SP list based on a selected date. The point is to use a gallery control/table control. The label control can only show data value, it cannot show record. I've made a test for your reference:

    1. My SP list named “Upload”, in this list, there is a “Date and time” column named “date”.
    2. Add a “Date picker” control named “Datepicker1”.
    3. Add a “Gallery” or a “Table” to display records(Choose one of these two controls depending on your needs).
    4. Set the Gallery’s Items property(Replace with your own list name and column name):

    Items= Filter(Upload,date=DatePicker1.SelectedDate) 

         5. (optional) Set the Table’s Items property(Replace with your own list name and column name):

    Items= Filter(Upload,date=DatePicker1.SelectedDate)

         6. Run the app to check the results.

    v-albai-msft_0-1610504646203.png

    You can see that in my SP list, only one record meets the selected date:

    v-albai-msft_1-1610504646205.png

    Best Regards,

    Allen

  • Ye1 Profile Picture
    5 on at

    Unable to solve the issue. pls educate me thanks.

    Filter(Table3,Date=DatePicker1.SelectedDate)

    Error : incompatible type for comparison galary1 

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