You’re offline. This is a read only version of the page.
hello everybody plz help me to : If I select a date, I must display all the data for that selected date.
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:
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.
You can see that in my SP list, only one record meets the selected date:
Best Regards,
Allen
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
#1
mmbr1606
22
Super User 2025 Season 1
#2
stampcoin
17
#3
ankit_singhal
11
Super User 2025 Season 1
Share
Report
All responses (
Answers (
