Filter the table automatically for current month

[mariaschm]

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? 

[dpoggemann]

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.  

Thanks,

Drew