Skip to main content

Notifications

Announcements

Welcome to the Power Platform Communities - Lets Get Started!
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps - GCC, GCCH, DoD - Federal App Maker... / SharePoint Delegation ...
Power Apps - GCC, GCCH, DoD - Federal App Maker...
Answered

SharePoint Delegation and Filters with DateTime Columns

(0) ShareShare
ReportReport
Posted on by CU22051816-0 8
Hello Y'all,
 
Newbie here. I'm trying to use a formula to filter by the Date/Time column I have called 'Status'. I got it to work but not without delegation errors of course. Is there a way to make this formula without StartsWith? At least that is what I think is causing the error. Formula in Items for the Gallery;
 
SortByColumns(Filter([@'Paid Time Off (PTO)'], StartsWith(Start,TextSearchBox1.Text)), "Start", If(SortDescending1, SortOrder.Descending, SortOrder.Ascending))
 
Also, would it be possible to add on a filter using the datetime columns with datepicker to filter a range of items between those dates? I've searched YouTube and the web with no luck on this. At least not without Delegation or Boolean errors so nothing to work off of there I can provide besides the date picker names:
 
dpStartDate
dpEndDate
 
Any enlightenment would be greatly appreciated!
Categories:
PubSec
  • CU22051816-0 Profile Picture
    CU22051816-0 8 on at
    SharePoint Delegation and Filters with DateTime Columns
     
    That is exactly how I was wanting to do it, search by a certain date format. That did it! I just had to "reconnect" the data source for the items to show when selected for some reason.
     
    Thanks for your help!!
  • Verified answer
    WarrenBelz Profile Picture
    WarrenBelz 147,594 Most Valuable Professional on at
    SharePoint Delegation and Filters with DateTime Columns
    Sorry, still a bit lost here - if Start is a Date/Time column how exactly are you wanting to search on it other than between the two date pickers ? Are you wanting to search on another field or if you wanted to search on a particular date format 
    With(
   {
      _Data:
      Filter(
         [@'Paid Time Off (PTO)'], 
         DateFieldName >= StartDatePicker.SelectedDate &&
         DateFieldName <= EndDatePicker.SelectedDate
      )
   },
   SortByColumns(
      Search(
         AddColumns(
            _Data,
            DateText,
            Text(Start, "ddd d mmm yyyy")
         ),			
         TextSearchBox1.Text,
         DateText
      ),
      "Start",
      If(
         SortDescending1, 
         SortOrder.Descending, 
         SortOrder.Ascending
      )
   )
)
     
    Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.
    MVP (Business Applications)    Visit my blog Practical Power Apps    LinkedIn    Buy me a coffee
  • CU22051816-0 Profile Picture
    CU22051816-0 8 on at
    SharePoint Delegation and Filters with DateTime Columns
     
    It is a Date and Time Column in SharePoint. End state would be for it to filter by the current user (Office365 Users Connected) with a checkbox to where they can see all items. If they know the start date of their request they could search by the date or search between a range. I dont know if that is the best way but that was the vision.
     
     
     
     
     
  • WarrenBelz Profile Picture
    WarrenBelz 147,594 Most Valuable Professional on at
    SharePoint Delegation and Filters with DateTime Columns
    I was expecting it to be of Text type as well as you used StartsWith() in your post. What type is it and how exactly are you expecting it to filter ?
  • CU22051816-0 Profile Picture
    CU22051816-0 8 on at
    SharePoint Delegation and Filters with DateTime Columns
    Good morning @WarrenBelz
     
    Hope your coffee is strong this morning and problems are few!
     
    I am getting an invalid argument error at search. It is excepting the column "Start" to be a text type.
     
    With(
       {
          _Data:
          Filter(
             [@'Paid Time Off (PTO)'],
             Start >= dpStartDate.SelectedDate &&
             End <= dpEndDate.SelectedDate
          )
       },
       SortByColumns(
          Search(
             _Data,
             TextSearchBox1.Text,
             Start
          ),
          "Start",
          If(
             SortDescending1,
             SortOrder.Descending,
             SortOrder.Ascending
          )
       )
    )
  • WarrenBelz Profile Picture
    WarrenBelz 147,594 Most Valuable Professional on at
    SharePoint Delegation and Filters with DateTime Columns
    Something like this should do it - note that the top filter (between the dates) needs to return record numbers (the list can be of any size) less than your Data Row Limit for full results to be returned. 
    With(
   {
      _Data:
      Filter(
         [@'Paid Time Off (PTO)'], 
         DateFieldName >= StartDatePicker.SelectedDate &&
         DateFieldName <= EndDatePicker.SelectedDate
      )
   },
   SortByColumns(
      Search(
         _Data, 
         TextSearchBox1.Text,
         Start
      ),
      "Start",
      If(
         SortDescending1, 
         SortOrder.Descending, 
         SortOrder.Ascending
      )
   )
)
     
    Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.
    MVP (Business Applications)    Visit my blog Practical Power Apps    LinkedIn        Buy me a coffee

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

News and Announcements

Welcome to the Power Platform Communities - Lets Get Started!

Quick Links

Michael Gernaey – Community Spotlight

We are honored to recognize Michael Gernaey as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard >

Last month Overall leaderboard

Featured topics

Product updates

Microsoft Power Platform Community release plans