Display an icon in gallery if the newest 'Created date' in a list is greater than 7 days

[JazzyN20]

The idea here is to display an icon/shape/object in a gallery if the newest list items created date is older than 7 days.

I have attempted doing this thus far by using the objects visible property and a gallery.selected.created date which works until the gallery is interacted.

I am guessing there may be a way of simpy looking up the list an not needing to have/use a gallery.

[RandyHayes]

@JazzyN20 

If this is an icon in the gallery, then just set the Visible property to:

  (DateDiff(Today(), ThisItem.Created) > 7)

I hope this is helpful for you.

[JazzyN20]

Hi Randy

the icon is in a gallery where the source is a simple collection. The created date I need to use is on a SharePoint list and has nothing to do with the gallery where the icon is so I cannot use this.item.created date. Need to lookup the list somehow

[v-bofeng-msft · Accepted solution]

Hi @JazzyN20 ,

You could try:

First(Sort(YourSPList,Created,Descending)).Created

Best Regards,

Bof

[RandyHayes]

@JazzyN20 

So what then in the list is it that you want to look up?  You mentioned the newest item.  Is that what you are looking for?