Others

How to Create Microsoft Lists Forms and Filtered Displays with Power Apps

Elise Williams Oct 22, 2026 868 views

Question details

The user wants to customize a Microsoft List form to automatically populate default date and time fields and display records dynamically filtered by criteria like date or shift using a single Power App.

How to Create Microsoft Lists Forms and Filtered Displays with Power Apps

Product: Microsoft Power Apps / Microsoft Lists
Device & OS: not provided
Scenario: Building a dynamic application to handle customized form inputs, default timestamps, and filtered data views for a Microsoft List without needing separate apps.
Observed behavior: The goal is to successfully filter list records by the current date and automatically populate date and time fields in edit forms using Power Fx formulas.

Before you start

Ensure you have the necessary Microsoft 365 permissions to edit the target Microsoft List (or SharePoint list) and create custom canvas apps in Power Apps.

Solution 1Recommended

Customize the Microsoft List Form and Set Default Time Values

Connect Power Apps to your list to customize default values for date, hour, and minute fields using simple Power Fx formulas.

By unlocking the data cards in your customized Power Apps form, you can override the standard blank values with dynamic formulas that automatically capture the current date and time.

Access Power Apps Customization

Navigate to your Microsoft List or SharePoint list, click 'Integrate' in the top menu, hover over 'Power Apps', and select 'Customize forms'.

Set the Default Date

In the Power Apps Studio, select the Date control inside your form. Go to the Advanced tab, click 'Unlock to change properties', and set the 'Default' property to the formula: Today()

Set the Default Hour

Select the Hour control for your time field, unlock it, and set the 'Default' property to: Text(Hour(Now()), "00")

Set the Default Minute

Select the Minute control, unlock it, and set the 'Default' property to: Text(Minute(Now()), "00")

Customize the Microsoft List Form and Set Default Time Values

Format Preserved: Using the Text() function with "00" ensures your hours and minutes maintain a standard two-digit format.

Solution 2

Filter Gallery Displays by Date and Shift

Dynamically filter your list views within a single Power App instead of creating separate apps for different list views.

Free Microsoft Office alternative

Looking for a comprehensive Office suite? Try WPS Office

While Power Apps provides advanced list customization for Microsoft users, WPS Office offers a free, lightweight, and highly compatible alternative for your everyday document, spreadsheet, and presentation needs. Enjoy a familiar interface and seamless migration without the hefty subscription fees.

1. Download and Install: Visit the official WPS Office website to download the free, lightweight installer.
2. Open Your Spreadsheets: Launch WPS Spreadsheet to open, view, and edit your existing .xlsx data tracking files with perfect compatibility.
3. Manage Data Smoothly: Use built-in data validation, filtering, and pivot tables in WPS Spreadsheet as a straightforward alternative to complex list management apps.

Fully compatible with Microsoft Excel, Word, and PowerPoint formats (.xlsx, .docx, .pptx).Manage spreadsheets, track lists, and analyze data effortlessly using WPS Spreadsheet.Lightweight installation with a tabbed, all-in-one workspace interface.

microsoft office alternative - wps office

Frequently Asked Questions

Can one Power App handle multiple views for different shifts?

Yes. You do not need to create separate apps or lists for different views. You can use dynamic controls like dropdowns and date pickers to filter the Gallery items based on the user's selection for shifts or specific dates.

How do I unlock a field in Power Apps to change its default value?

Select the specific data card or control within the form, navigate to the Properties pane on the right or the Advanced tab, and click 'Unlock to change properties' to modify its default formulas.

Can I add a search function to a filtered Microsoft List gallery?

Yes. You can wrap your Filter function within a Search function in the gallery's Items property, linking it to a Text Input control to allow users to search through text columns dynamically while keeping the date filters intact.

Office Quick Solutions