Unanswered

Visible>If Statement based on DateDiff

(0) Share

Report

Posted on by EG-31080115-0

118

I have a Gallery connected to SP List #1 and have added a Label2 to Gallery card that pulls date form SP List #2. I'm trying to set Gallery Item Visible based on If(DateDiff(Label2,Now(),Days)>1,true,false). For some reason this doesn't work (nothing visible even though there are items where DateDiff(Label2,Now(),Days)>1). I can add Label that displays result of DateDiff(Label2,Now(),Days) and it calculates correctly. Ideas?

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@Microbes

Can you explain a little more about what you are trying to make visible or not? You cannot make an entire row of a gallery be visible or not, only the individual controls in the row or the entire gallery.

You mention the Item property - but what control is it with an Item property? The Gallery has an Items property. Perhaps you meant that?

Was this reply helpful? Yes No
EG-31080115-0 118 on at

Like (0)

Report
Copy link

Link copied!

Thanks @RandyHayes , I was in fact trying to hide Gallery row and as you pointed out this isn't possible. What I hoped to accomplish is,
SP List#1 (Area, Frequency, Task, Tools) is reference table which lists details for aforementioned columns.
SP List#2 (Area, Frequency, Task, Tools, Date_Completed, Initials) is log where task completion is recorded.
Gallery would have items that meet a DateDiff criteria [eg DateDiff(Now(), Date_Completed,Days)>1]
What I attempted, unsuccessfully, was to connect Gallery to SP List#1 to display Task, added a Label to Gallery that used lookup latest Date_Completed from SP List#2 then try to use DateDiff(Now(),Date_Completed,Days)>1 to hide Gallery row.

Was this reply helpful? Yes No
EG-31080115-0 118 on at

Like (0)

Report
Copy link

Link copied!

So, I added "Last_Completed" column to my SP List#1 to be able to filter Gallery on date, but now trying to figure out how to incorporate date difference into filter so that only Gallery items that meet date criteria (e.g. Now() - Last_Completed > 1) are included.

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
@Microbes

So yes, this is the way to exclude rows from your Gallery - in the Items property filter!

What you'll need is to use a formula such as this:

Filter(yourList1, Last_Completed < Now() )

If you want a larger range, then you can use a formula such as this:

With({_minDate: DateAdd(Now(), -7, Days)}, // change the 7 to a range you want Filter(yourList1, Last_Completed < _minDate ) )

You could do the dateadd in the filter, but it is always best to put calculations outside of the filter function to avoid delegation issues where the formula editor has a hard time adjusting to a delegable statement.

You could have stayed with the Date_Completed from list #2 and done some similar things, but having a column with the actual value in list #1 is helpful from a performance aspect.

Was this reply helpful? Yes No