Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Filter the table automatically for current month

The columns of our table consist of the months of several years: January 2021, February 2021,..., and we have a form within our power app and for that we only want to display the input field of the current month. Can someone help? 

Super User
Super User

Hi @mariaschm ,


Can you help explain a bit more here... 

  1. Is your Power App Canvas or Model?
  2. You mentioned that the "columns" are the months?   Does your Dataverse table itself have a column named for each month or is there a single column in the table that is identified as "Month" and this contains values like "January 2021", "February 2021", etc.?
  3. On your form are you trying to allow the user to only enter a value for a specific Month column like "October 2021" or are you wanting them to enter the actual Month in the value on the form like "October 2021" in a Month column?


The answers to these questions will help me understand more how to help.  





Hope this helps. Please accept if answers your question or Like if helps in any way.

Helpful resources

Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Users online (4,187)