How To get max date from a column using List Records on Dataverse

[Dk4]

Hi all,

Is there a way to filter only the max date in a custom Dataverse table from list records using Flow?

[v-bofeng-msft]

Hi @Dk4 :

Do you want to get the max date in a column in a custom entity?

If so, pleaset try this flow:

I assume you want to get the max date in the'modifyon' column:

The Result:

Best Regards,

Bof

[Dk4]

Hi @v-bofeng-msft thank you for this, but am trying to get the max date of the 'same date' column based on duplicate columns, but different Ids. As ref below.

I have a table in dataverse, that has a date, telephone number, and ID columns as below.

Date	ID	Tel
12/6/2020	abcd	8421678
12/9/2020	abce	8421679
12/13/2020	abcg	8421678

From the table the 1st and 3rd column have the same Tel num, but different dates and ID. What I'm trying to achieve is on the same table in a column called end date, post the last date with regards to the tel num this is basically the 1st date of the date the number switched to a new record based on ID. The table am trying to come up with looks as below

Date	ID	Tel	Date to
12/6/2020	abcd	8421678	12/13/2020
12/9/2020	abce	8421679
12/13/2020	abcg	8421678

What am missing is a step to get the max or latest date of the column that I will append to the date to mapping. 

[v-bofeng-msft · Accepted solution]

Hi @Dk4 :

Your requirement is hard to be achieved with flow, during the test I realized that this flow will be super complicated.I suggest you use powerapps to solve this problem:

1\create a blank canvas app

2\connect to the data source-my cds table(NewTests)

3\Add a button and set it's OnSelelct property to:

ForAll(
    Filter(
        GroupBy(
            RenameColumns(NewTests,"crb5a_tel","TheTel"), /*Rename "crb5a_tel" to "TheTel" to eliminate ambiguity (the result will only be saved in the cache, and will not affect the data source)*/
            "TheTel",
            "NewGroup" /*Grouping: the group name is NewGroup*/
        ),/*Group data according to TheTel column*/
        CountRows(NewGroup) > 1
    ),/*The target group is a record with data greater than or equal to 2 in the group*/
    Patch(
        NewTests,
        LookUp(Sort(NewTests,Date,Ascending),Tel = TheTel),
        {
            'Date to': Max(NewGroup,Date)/*Get the largest date in the group*/
        }
    )
)

4\Click the button 

5\The Result

Best Regards,

Bof