i have inserted Label in Gallery as Name: Aging and in text properties i added below code :
If(ThisItem.Status.Value<>"Completed",DateDiff(ThisItem.'Received Date',Today(),Days)) and results showing no of days : 5,6,10,12..etc
now i want to add slider outside of screen ,by dragging it i need to filter gallery by days of the task
That is up to you.
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
i need to add any thing in slider min & max value
Free-typing code in Notepad . . . corrected in post as well
SortByColumns(
Filter(
'Tracker',
'Assigned Designer'.Email = User().Email &&
(
(IsBlank(vartask) || vartask="All") ||
'Task Type'.Value=vartask
) &&
'Received Date'>=DateAdd(
Today(),
-Slider3.Value,
Days
)
),
"ID",
Descending
)
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
showing invalid arguments, expecting date time value instead in gallery Item:
SortByColumns(
Filter(
'Tracker',
'Assigned Designer'.Email = User().Email,
'Task Type'.Value=vartask||IsBlank(vartask)||vartask="All",
'Received Date'>=DateDiff(Today(),Slider3.Value,Days)
),
"ID",
Descending
)
Hi @Ungarala1 ,
Something like this
Filter(
GalleryDataSource,
'Received Date'>=
DateAdd(
Today(),
-Slider1.Value,
Days
)
)
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
WarrenBelz
791
Most Valuable Professional
MS.Ragavendar
410
Super User 2025 Season 2
mmbr1606
275
Super User 2025 Season 2