Taking only specific values ​​from the gallery

[Piter_D]

Hi, I have a question because in the gallery it filters a certain number of dates for a given item, and unfortunately for some items there are dates in the form of 01/01/1900. Unfortunately, I cannot restrict the display of these dates by the condition of type date <> date (1900.01.01). the question is if I can write some type condition if subtitle1 = 01/01/1900 then take the next value in the table and let it work as a loop.

@Pstork1 @timl @WarrenBelz 

[rubin_boer]

hi @Piter_D , what is it you are trying to achieve when you say "take the next value", do you wish to summarize values etc?

[Piter_D]

I want to take the earliest date from this gallery except 01/01/1900. that is, the one marked with a bird from the photo.

[Piter_D]

or maybe i can filter this gallery on another gallery and then write condition where subtitle1 <> 01/01/1900?

[rubin_boer · Accepted solution]

@Piter_D using the gallery as a source, try adding a label to the app and set the

I assume this

"Earliest date for dates without 01/01/1900" text = 

Text(
    Min(
        Filter(
            YourGallery.AllItems,
            yourDateColumn> DateValue("01/01/1900", "en-US")
        ),
        date
    ),
    "mm/dd/yy"
)

Hope it helps 

R

[Piter_D]

Text(
    Min(
        Filter(
            Gallery1.AllItems,
            Subtitle8.text > DateValue("01/01/1900", "en-US")
        ),
        date
    ),
    "mm/dd/yy"
)

i have a error in "Min" function.

[rubin_boer]

Replace Subtitle8.text is of type text and the date is type date, hence the error. you can use the column name or DateValue(Subtitle8.text, "en-US")

[Piter_D]

still get error in Min() and what is "date" in this formula? is not recognized.

[rubin_boer]

yourDateColumn

[Piter_D]

okay, its work thank you 😄