Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Apps - Building Power Apps
Unanswered

Disable date picker based on a date range using sharepoint columns

(0) ShareShare
ReportReport
Posted on by 212

Do you know how I can disable dates in a datepicker control in powerapps based on a date range.

I have a SharePoint list to specify the date ranges that will be disabled. For example, Block1 record dates between StartDate and EndDate  will be disabled.

 

mthiru_0023_1-1689176325342.png

 

 

  • AhmedSalih Profile Picture
    6,678 Super User 2025 Season 1 on at
    Re: Disable date picker based on a date range using sharepoint columns

    @mthiru_0023, actually @RezaDorrani approach would be the only way you can do that as the Date picker doesn't support your requirement. 

  • mthiru_0023 Profile Picture
    212 on at
    Re: Disable date picker based on a date range using sharepoint columns

    Hi @AhmedSalih, I am looking for a simple solution to disable dates from selection or color code it black/grey so that the user is aware this date is not available for selection based on the date range in SharePoint.  I am happy to hear any suggestion that can utilized here. Basically, there will be date ranges every year (which change) and reflected on a SharePoint list that are not available for selection. Also, previous date and weekend dates are not available for selection. 

     

    I am also reading this video from @Reza may help me.

    (220) Build CALENDAR Control in POWER APPS in Minutes | Connect to SharePoint List - YouTube

  • AhmedSalih Profile Picture
    6,678 Super User 2025 Season 1 on at
    Re: Disable date picker based on a date range using sharepoint columns

    @mthiru_0023, one more question, are looking to disable the dates inside the date picker, or disable the date picker control all together?

     

  • mthiru_0023 Profile Picture
    212 on at
    Re: Disable date picker based on a date range using sharepoint columns

    @AhmedSalih,  I have a vertical gallery on the left of the screen.  I am still working on the UI but the datepicker control is inside an edit form on the right side of the vertical gallery.

     

    mthiru_0023_0-1689181885654.png

     

  • AhmedSalih Profile Picture
    6,678 Super User 2025 Season 1 on at
    Re: Disable date picker based on a date range using sharepoint columns

    @mthiru_0023, is the Date Picker control inside a Gallery that has the table records including the start and end date? Can you share screenshots?

     

     

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

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,645 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,997 Most Valuable Professional

Leaderboard