Skip to main content
Community site session details

Community site session details

Session Id : yyYTsqt6mezgf/MxSLHBwM
Power Apps - Microsoft Dataverse
Answered

Select date to display data

Like (0) ShareShare
ReportReport
Posted on 5 Jan 2021 13:51:37 by

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

  • Ye1 Profile Picture
    5 on 27 Jun 2023 at 06:25:04
    Re: Select date to display data

    Unable to solve the issue. pls educate me thanks.

    Filter(Table3,Date=DatePicker1.SelectedDate)

    Error : incompatible type for comparison galary1 

  • Verified answer
    v-albai-msft Profile Picture
    on 13 Jan 2021 at 02:26:27
    Re: Select date to display data

    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

  • timl Profile Picture
    35,242 Super User 2025 Season 2 on 05 Jan 2021 at 15:44:37
    Re: Select date to display data

    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

     

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

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 791 Most Valuable Professional

#2
MS.Ragavendar Profile Picture

MS.Ragavendar 410 Super User 2025 Season 2

#3
mmbr1606 Profile Picture

mmbr1606 275 Super User 2025 Season 2

Featured topics

Loading complete