Dates from sharepoint

(0) Share

Report

Posted on by Teja1234

Hi All,

I have a list with dates.

Date:

04/04/2020

04/11/2020

04/18/2020

05/12/2020

Now i wish to perform certain actions only if the selected date is the last date or greater date in that month. For example, if selected date is 04/18/2020 and since there is no date after 18th in April, it should do the subsequent steps.

Any easiest way to do it?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

mdevaney 29,991 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
@Teja1234
I am unclear what context this is being used in so here's a general answer.

If(SelectedDate >= Max(ListName, DateColumn), true_condition_code, false_condition_code )

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
Teja1234 9 on at

Like
a
(0)

Report
Copy link

Link copied!

@mdevaney
How would i do it if i wish to see if the selected date is max in the month. i.e., if i select 04/18/2020 then it should see in april if it is the maximum we have in april. like wise if we select 05/18/2020, then see if it is the maximum in the month of may an so on.

Was this reply helpful? Yes No
Verified answer

v-yutliu-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Teja1234 ,

Do you want to compare date with the max date of every month?

If so, you need to firstly group your data based on month.

Try this formula:

AddColumns(GroupBy(AddColumns(test,"month",Month(Date)),"month","dates"),"maxdate",Last(SortByColumns(dates,"Date")).Date)

//test is my collection name, you could replace with yours

Then you will get a table like this:

The month column is the date's month, maxdate column is the max date of this month.

You could use formula like this to justify whether this action perform:

If(SelectedDate>=LookUp( AddColumns( GroupBy( AddColumns(test,"month",Month(Date)), "month","dates" //group based on month ), "maxdate", Last(SortByColumns(dates,"Date")).Date ),//add a column with the max date of the month Month(SelectedDate)=month,maxdate ),//look up the max date based on selecteddate's month true_condition_code, false_condition_code ）

Best regards,

Was this reply helpful? Yes No