Filter Gallery by created time most recent only

(0) Share

Report

Posted on by DuncanKlysh

I am trying to make a Gallery that only displays the most recent entries for a dataset.

The project is recording for the same "Zone" multiple times a day, and documenting Pass / Fail for that zone.

I have multiple zones to track and I want the gallery to only show me the most recent record for each unique zone.

I have the fill filters set (If done withing 6 hours green, if with in 12 red, else white) I want to see if they missed a zone which is why I want only the most recent entry per zone)

Basically

Sort by zone, pull only most recent created records.

I have most everything else figures out on this but am having issues with the making it only show the most recent entries.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sienna 1,532 on at

Like (0)

Report

I'm not sure if I undesrstand your question correctly. If you want to filter most recent datasource entry and you have column which record the timestamp when the record was created then use this

Filter(DatasourceName, TimeColumnName>DateAdd(Now(),-12, Hours))

This will filter your datasource with date created in last 12 hours.
Is this what you want?

Was this reply helpful? Yes No
DuncanKlysh 11 on at

Like (0)

Report

That helps with another problem I was having, let me try and explain better

I have this data set

Zone Time
A 1/29/2018
B 1/29/2018
C 1/29/2018
D 1/29/2018
A 2/2/2018
B 2/2/2018
C 2/2/2018
A 2/3/2018
B 2/3/2018

From that I only want to see this
Zone Time
D 1/29/2018
C 2/2/2018
A 2/3/2018
B 2/3/2018

Chronologically the last occurance of the station.
If need I can do with out the Gallery it's self, I just need this data to appear this way.

Was this reply helpful? Yes No
Verified answer

Sienna 1,532 on at

Like (1)

Report
I got it now... I believe you need something like this

Sort(AddColumns(
GroupBy(Table1, "Zone", "TimeColumn"),
"MaxVal",Max(TimeColumn,TimeColumn)),
MaxVal,Ascending)

Was this reply helpful? Yes No
DuncanKlysh 11 on at

Like (0)

Report

Thanks that fixed part of the problem, trying to now merge that with another formula.

Sort(AddColumns(
GroupBy(Table1, "Zone", "Created"),
"MaxVal",Max(Created,Created)),
MaxVal,Ascending)

and

SortByColumns(Filter('Table1', Location = DashDropdown.Selected.Value),"Area",Descending)

Your formula provides what I need for the most recent of each Zone, I have the existing filter for Location which filters from a dropdown.
Can these be merged?

Was this reply helpful? Yes No
Sienna 1,532 on at

Like (0)

Report

Hi @DuncanKlysh
try this

SortByColumns(
Sort(AddColumns(
GroupBy(Filter('Table1', Location = DashDropdown.Selected.Value), "Zone", "Created"),
"MaxVal",Max(Created,Created)),
MaxVal,Ascending),
"Area", Descending)

I'm not sure if this will work.. you just have to play with it to get required result

Was this reply helpful? Yes No