Disable date picker based on a date range using sharepoint columns

(0) Share

Report

Posted on by mthiru_0023

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.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

AhmedSalih 6,678 Moderator on at

Like (0)

Report

@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?

Was this reply helpful? Yes No
mthiru_0023 212 on at

Like (0)

Report

@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.

Was this reply helpful? Yes No
AhmedSalih 6,678 Moderator on at

Like (0)

Report

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

Was this reply helpful? Yes No
mthiru_0023 212 on at

Like (0)

Report

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

Was this reply helpful? Yes No
AhmedSalih 6,678 Moderator on at

Like (0)

Report

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

Was this reply helpful? Yes No