How to Validate a Power Apps Date Picker Against SharePoint Availability
Question details
The user needs a method to compare a selected date or weekday in a Power Apps Date Picker with an availability schedule stored in a SharePoint list.
- Product
- Power Apps
- Device & OS
- not provided
- Scenario
- Building a scheduling or booking application that requires verifying date availability against external data.
- Observed behavior
- Requires a formula or validation rule to restrict or verify dates based on SharePoint availability records.
Ensure your Power App is successfully connected to the correct SharePoint list as a data source and that you have appropriate read/edit permissions for the list.
Use a LookUp Formula to Validate SharePoint Availability
Connect your SharePoint list to Power Apps and apply a formula to check if the selected date matches available records.
To validate a date in Power Apps, you must compare the Date Picker's selected value with the records in your SharePoint list. This is typically accomplished using the LookUp or Filter functions.
Since data structures vary greatly depending on your SharePoint list columns, adapting formula examples from the Power Apps Community is highly recommended.
Navigate to the Data panel on the left side of Power Apps, click 'Add data', search for SharePoint, and connect your specific availability list.
Add a Date Picker control to your canvas for users to select the date. Add a Text Label beneath it to serve as the validation error message.
In the 'Visible' property of your error Text Label, write a formula that checks for unavailability. For example: `IsBlank(LookUp(SharePointList, DateColumn = DatePicker1.SelectedDate && Status = "Available"))`. This will show the error if no available slot matches the selected date.
If your validation requires checking specific weekdays or complex conditions, visit the official Power Apps Community forums for advanced validation examples tailored to specific data structures.
Manage Your Schedules Seamlessly with WPS Office
While Power Apps and SharePoint require specific Microsoft environments for complex app building, WPS Office provides a lightweight, free alternative for managing schedules, data lists, and spreadsheets offline.
- 1. Download WPS Office: Visit the official WPS website to download and install the free WPS Office suite on your computer or mobile device.
- 2. Open WPS Spreadsheet: Launch the application and create a new workbook or open your existing Microsoft Excel files to manage availability data.
- 3. Use Data Validation: Utilize built-in data validation and conditional formatting features to organize and monitor schedules without complex app formulas.
Frequently Asked Questions
Can I natively disable weekends in a Power Apps Date Picker?
The standard Power Apps Date Picker control does not natively disable specific days on the calendar UI. However, you can use the Weekday function to validate the selected date and display an error message if the user picks a Saturday or Sunday.
Why isn't my SharePoint list availability data updating in Power Apps?
If recent changes in your SharePoint list are not reflecting in your Power Apps validation, try using the Refresh(SharePointListName) function within your app to force an update of the data source connection.
How do I prevent users from submitting the form if the date is unavailable?
You can disable the Submit button by modifying its 'DisplayMode' property. Use an If statement that evaluates the LookUp validation formula; if the date is unavailable, set the mode to DisplayMode.Disabled, otherwise set it to DisplayMode.Edit.
