Filter date by slider

(0) Share

Report

Posted on by Ungarala1

184

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

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

WarrenBelz 153,051 Most Valuable Professional on at

Like (0)

Report
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.

Was this reply helpful? Yes No
Ungarala1 184 on at

Like (0)

Report

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
)

Was this reply helpful? Yes No
WarrenBelz 153,051 Most Valuable Professional on at

Like (0)

Report
@Ungarala1 ,

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.

Was this reply helpful? Yes No
Ungarala1 184 on at

Like (0)

Report

i need to add any thing in slider min & max value

Was this reply helpful? Yes No
WarrenBelz 153,051 Most Valuable Professional on at

Like (0)

Report

@Ungarala1 ,

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.

Was this reply helpful? Yes No