Answered

variable to set latest date and earliest date

(1) Share

Report

Posted on by joel914823

557

I'm trying to set a slider so that I can use that to filter by created date in my data. How can I set a variable to earliest date and latest date in my created date column?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

Mitanshu 1,658 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
Assuming you have a SharePoint List, you can use formula as below:

Min: First(Sort('YourSharePointList',Created,SortOrder.Ascending)).Created Max: First(Sort('YourSharePointList',Created,SortOrder.Descending)).Created

I didn't suggest to use Min() function because it is not delegable in SharePoint.

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 this post or my previous reply was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
joel914823 557 on at

Like
a
(1)

Report
Copy link

Link copied!

@happyume Thanks for your help! I was trying to do a datediff between the two variables, but running into an error - would you happen to know why (I put the datediff in the Max), see screen shot, any help is appreciated.

Was this reply helpful? Yes No
Mitanshu 1,658 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
Earliest_CreatedDate and Latest_CreatedDate_1 are Controls and not a Date. You need to obtain value of the Control and then convert into Date.

Try:

DateValue(Earliest_CreatedDate.Text)

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 this post or my previous reply was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No