Forum Discussion
Filter table based on user input
Hello all, I am having difficulty finding an answer to this. I would like to have a table filtered by a date (any date they choose) input by a user. Example:
User inputs a date. Based on that input, filter the table to show all projects with an "End Date" (End Date field already in the table) greater than or equal to the date that the user input. Pretty simple I would think but I cannot seem to figure it out. Thanks
Add the date field from your calendar table to the page as a slicer and choose "after" drop-down option.
You can then remove the slider feature and condense the object to only show the date field the user would be entering into.
12 Replies
You can do that via the Filters panel.
Add the date field from your calendar table to the page as a slicer and choose "after" drop-down option.
You can then remove the slider feature and condense the object to only show the date field the user would be entering into.
Thank you Drew. What calendar table are you referring? Do I need to make it? I have one list (Project Master) which has many columns including "End Date". Just want user to pick a random date (where do I put/store this date for the filter?) and then projects with a greater date than the one input will show.
It is generally best practice to add a calendar table that simply contains a unique value for each date that you would join to your Project Master table by the End Date (you can Google Calendar Table and find plug and play examples). That being said, if you are only using one table, then you should be able to add the End Date to the page as a slicer and follow the same steps. Let me know if this works for you.
