I am having trouble with filtering a column in a sharpoint list by todays date.
My datasouce is: CustomerCareLog
The column i want to filter a gallery by is: AppointmentDate
I have tried lots of things, but i either get errors saying that the column types dont match or i get a delegation warning. I would like to achieve this without a delegation warning.
so far i've tried using the Today and IsToday function, they both return the delegation warning
I've tried converting inserting a date picker and setting its default date to today and filtering by that, but i get a red error circle saying the expression 2019-03-16 eq AppointmentDate is not valid
I've tried ensuring the format of the date picker to match my sharepoint list, but that doesnt make a difference
I've tried creating a label with 'Today()' and tried referencing that and i get a warning that the data isnt the same type:
With that in mid i tried to covert the AppointmentDate column to Text but this gives me a delegation warning again...
Any one got the solution, surely there is an easy way to do this without delegation warnings that i'm simply missing?
Go to Solution.
Hi @RandyHayes just finished setting this all up and want to thank you again for all your assistance on this! All works a dream now and no delegation and future proofed!
Keep up to date with current events and community announcements in the Power Apps community.
A great place where you can stay up to date with community calls and interact with the speakers.
Check out the latest Community Blog from the community!