PowerApp form with Calendar Screen template

[mthiru_0023]

I have a powerapps form to submit requests for processing where the submitter can select a date. The default Date picker control is limited as I want to include a criteria for when a date is available for selection so I am replacing the date picker control with the Calendar Screen template in PowerApps.

In the Calendar Screen template, I have added a Vertical Gallery (Gallery4) to the MonthDayGallery. Gallery4 items is a filter on a SharePoint list that populates calendar dates where the Start Date and End date have a date value. Purpose is to identify that's are not available for selection.

Filter(
BlockDays,
DateAdd(
_firstDayInView,
ThisItem.Value,
TimeUnit.Days
) >= StartDate && DateAdd(
_firstDayInView,
ThisItem.Value,
TimeUnit.Days
) <= EndDate
)

How can I disable the selection or add a validationt to a button to check the dateselected to filter in the list to see if those dates are not available for selection throw an error or prevent user from selecting the date.

[KeithAtherton · Accepted solution]

If you need to prevent selection of dates which are blocked (say, in a collection called BlockDays), add the following code to the calendar date OnSelect property to notify the user.

Please note that this code will require some trial-and-error depending on the field names in use.

If(!IsEmpty(Filter(BlockDays, DateValue = ThisItem.DateValue)),
  Notify("This date is blocked and cannot be selected.");
);

---

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Follow me online.

[mthiru_0023]

@KeithAtherton 

I tried with this below expression but it does not do anything.

If(!IsEmpty(Filter(BlockTradingDays, DateValue(ThisItem.Value)=_dateSelected)), Notify("Block"););

[KeithAtherton]

If you select BlockTradingDays and _dateSelected in the formula bar, what values are displayed?

---

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Follow me online.

[mthiru_0023]

BlockTradingDays is Table, but did not find any data (odd). Maybe the Filter is working in that regard since _dateSelected shows as blank. 

_dateSelected = Blank.

I am not sure how to work with the _dateSelected variable here, as per microsoft ref it sets the date of variable of the selected cell.

Title5_1 OnSelect Property has this meaning it's supposed to apply the

Set(_dateSelected, DateAdd(_firstDayInView, ThisItem.Value, TimeUnit.Days));

Property: OnSelect
Value: A Set function that sets the _dateSelected variable to the date of the selected cell:

Reference information about the calendar-screen template for canvas apps - Power Apps | Microsoft Le...

[mthiru_0023]

Alternatively, I can show a block Icon in the MonthDayGallery1_1:

Using the following expression:

CountRows(Filter(BlockTradingDays,
DateValue(Text(StartDate)) <= DateAdd(_firstDayInView,ThisItem.Value,TimeUnit.Days),
DateValue(Text(EndDate)) >= DateAdd(_firstDayInView,ThisItem.Value,TimeUnit.Days)
)) > 0 && !Subcircle1_1.Visible && Title10_1.Visible

If I disable the selection will be added value.

[KeithAtherton]

As you say, looks like _dateSelected is not being set correctly. I would suggest investigating that to start with.

The code in your example looks good. What is the value of _firstDayInView?

---

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Follow me online.