Hi All,
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
Filter(CustomerCareLog,IsToday(AppointmentDate))
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
Filter(CustomerCareLog,DatePicker1.SelectedDate=AppointmentDate)
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:
Filter(CustomerCareLog, AppointmentDate=LabelToday.Text)
With that in mid i tried to covert the AppointmentDate column to Text but this gives me a delegation warning again...
Filter(CustomerCareLog, Text(AppointmentDate,"dd/mm/yyyy")=LabelToday.Text)
Any one got the solution, surely there is an easy way to do this without delegation warnings that i'm simply missing?
Help/Advise appreciated!
Thanks
Solved! 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!
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
User | Count |
---|---|
200 | |
100 | |
62 | |
59 | |
58 |
User | Count |
---|---|
254 | |
164 | |
90 | |
79 | |
70 |