
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
H @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