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:
- My SP list named “Upload”, in this list, there is a “Date and time” column named “date”.
- Add a “Date picker” control named “Datepicker1”.
- Add a “Gallery” or a “Table” to display records(Choose one of these two controls depending on your needs).
- 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.
You can see that in my SP list, only one record meets the selected date:
Best Regards,
Allen
