Answered

Help with Filtering a gallery based on multiple variables

(1) Share

Report

Posted on by CodyO

391

Greetings! I have a gallery connected to an SP list. I have three buttons that filter based on date. I have been messing around with this for about an hour and can't get it to work.

My goal is if someone clicks the button listed as "Today" it will show info for today. If they click "Yesterday" it will show the previous days info, and Daily would be all the info!

Here is my code that is in the item property of my gallery!

If(
    VarToday = true,
    Filter(
        TimeTracker,
        UpdatedActivityDateTime = Today(),
        Title = EmployeeName.Selected.Value
    )
) Or If(
    VarYesterday = true,
    Filter(
        TimeTracker,
        UpdatedActivityDateTime = Today() - 1,
        Title = EmployeeName.Selected.Value
    )
) Or If(
    VarDaily = true,
    Filter(
        TimeTracker,
        Title = EmployeeName.Selected.Value
    )
)

TIA for any assistance!

best,

CodyO

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Michael E. Gernaey 53,963 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

Hi

You did not explain what isn't working, or details on the Fields that are holding the data.

Also I dont see the data (the actual data, so I can see what it looks like)

Also you image has all errors. Those type of Errors usually mean those fields do not exist in the Items that are being returned, But if you are filtering on a table, it doesn't care if there are zero, simply that it understands the Schema and those errors tell me it doesnt.

Also, if you are trying to compare Today to a Date Time field, that would be impossible (or nearly) to match, because you will be off ine Hours, minutes or seconds

Instead you should check the Date Part of the Value, against the DatePart of Today (or Now()) versus the entire string
which I believe is the actual issue

Please share the above, the data, your Items property, the errors etc and we can help you quickly

Was this reply helpful? Yes No
Verified answer

Chris Ludwig 34 on at

Like
a
(2)

Report
Copy link

Link copied!

Hello,
I would generally recommend filtering via a date field - this gives the user more options. To increase usability, I would also recommend the buttons shown in the screenshot and using these buttons to edit the value of the date field.

To solve the error in your code, however, I would recommend creating a variable that contains a date. You can fill this variable with the buttons (e.g. if you click on the button ‘today’ you set the variable to the value ‘today()’ and so on...). Then you don't have to react to the different button clicks in your filter, but only have one variable. It is important here that you also empty the variable again (if it is not possible to set a filter in your example) and also take into account in the filter that your variable can be empty. However, as you might have a problem here because you are comparing a DateField with an empty variable, I would recommend the approach with the date field, as already mentioned

Was this reply helpful? Yes No
CodyO 391 on at

Like
a
(2)

Report
Copy link

Link copied!

@Chris Ludwig,
I ended up going with your recommendation of using a date field. I was over complicating it by trying to use buttons to set the variables and the date field seems to just be an easier approach. Thank you for the suggestion and help!

Was this reply helpful? Yes No