web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Apps
Unanswered

test

(0) ShareShare
ReportReport
Posted on by 6
Categories:
I have the same question (0)
  • Michael E. Gernaey Profile Picture
    53,968 Super User 2026 Season 2 on at

    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

     

     

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    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 Profile Picture
    3,294 Most Valuable Professional on at

    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
     )
     )

     

     

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Thank you for your reply

     

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Thank you

  • Michael E. Gernaey Profile Picture
    53,968 Super User 2026 Season 2 on at

    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

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Thank you for your reply

    Issue resolved

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    How to Delete my Post?

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 392 Most Valuable Professional

#2
11manish Profile Picture

11manish 181 Super User 2026 Season 2

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 112 Super User 2026 Season 2

Last 30 days Overall leaderboard