Check if dates are in chronological order in a collection

(1) Share

Report

Posted on by pquateli

Team,

I have a problem and I would like to ask for your help:

I need to check that the dates in a collection are in chronological order (only when STATUS column is COMPLETED) and, if not, set a variable to "false".

My collection has 3 columns, as in the example below:

ORDER	DATE	STATUS
1	01/02/2020	Completed
2	03/02/2020	Completed
3	07/02/2020	Completed
4	05/02/2020	Completed
5	09/02/2020	Completed
6		Awaiting
7		Awaiting

Thank you very much for any help you can give me.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

v-siky-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
@pquateli

What is the data source and what is the type of Status columns?

If the Status is text column, please try this, put the codes to button OnSelect:

Clear(Result);ForAll(Filter('Table',STATUS="Completed"),Collect(Col_LoopNo,1);If(Last(FirstN(Filter('Table',STATUS="Completed"),CountRows(Col_LoopNo))).DATE=Last(FirstN(SortByColumns(Filter('Table',STATUS="Completed"),"DATE1",Ascending),CountRows(Col_LoopNo))).DATE,Collect(Result,true),Collect(Result,false)));If(false in Result.Value, Set(VariableName, false))

If dates in a collection are not in chronological order, it will set false to the variable.
Sik

Was this reply helpful? Yes No
pquateli 9 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks Sik, I'll try.
Original data is in SharePoint list and Status column is text.

Was this reply helpful? Yes No
v-siky-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @pquateli

How about your issue?
Does the workaround above suit for your case?
Sik

Was this reply helpful? Yes No