test

[FLMike]

Hello,

We need more information than that picture.

What is the data source? When you say grid are you referring to a Canvas App or Model Driven app, with the data Table on it?

Once we know the data source, then we can have you either

a) add it to the app directly (example a Dataverse Table) 

b) access the data via a connector (in the Canvas App) or through Power Automate or other mechanism

and then add the data directly into the data table or to a collection that you can then add to data table and filter based on the column that has the date field and you can use a >= or <= date range filter.

Please provide the additional details and we can help.

Cheers,

-Michael

[Anonymous]

I am creating Data in Canvas app and Connected Data through data verse data table.

I need display data in the grid based on Month like 

January - january data

Feb - Feburay data.

is there any formula, i can filter data

[cwebb365]

See below. You can use the Date() function to set a variable or start and end dates. In this example, it's for current month. But you can use Date(Year,Month,Day) format and use 1 for the 1st of the month and 0 for last day of a month. You can use this to build a Month picker, or you can hand do it like in there set UpdateContext({varFilterStartDate, Date(2023,2,1)) for startdate and UpdateContext({varFilterEndDate,Date(2023,2,0)) for end date, this will give you Feburary and so forth. Then obviously in your filter use the variables in the filter logic.  There are multiple ways to build a Selection out, But this is how you could get a month filter. 

  Set(
        varFilterStartDate,
        Date(
            Year(Now()),
            Month(Now())-1,
            1
        )
    );
    Set(
        varFilterEndDate,
        Date(
            Year(Now()),
            Month(Now()),
            0
        )
    )

[Anonymous]

Thank you for your reply

[Anonymous]

Thank you

[FLMike]

It still depends on where the data is located, which doesn't sound like its in the app.

If its in the database and you want it in the Table then you need to create a filtered query in the Items property or create a collection and then set the Items property to the collection

Making the dates in between, such as @cwebb365 says works but then you need to write the query. Thats why I am asking where is the data actually located, not where you want it to land.

Data Table

Items Property

Filter(MyDataSource, MyDateField >= StartDate && MyDateField <= EndDate)

Where StartDate and EndDate are your Date ranges, such as previously created. 

Cheers
--------------------------------------------------------------------------------
If I had answered your question, please mark your post as Solved
If you like my post please give it a thumbs up
Thanks
Michael
https://gernaeysoftware.com

[Anonymous]

Thank you for your reply

Issue resolved

[Anonymous]

How to Delete my Post?

[Anonymous]

how to delete this post?

https://powerusers.microsoft.com/t5/Building-Power-Apps/How-to-select-monthly-data-to-display-in-the...