Others

Microsoft Lists Item Cannot Be Marked Complete on the Submission Date

Tauseeq Magsi Sep 27, 2026 869 views

Question details

Users are unable to change the status of an issue-tracker item to 'Complete' on the same day it was submitted without manually altering the reported date.

Fix Microsoft Lists Items Unable to Be Marked Complete on Submission Date

Product: Microsoft Lists and Power Apps
Device & OS: not provided
Scenario: Updating item statuses in a custom issue-tracking system built with Microsoft Lists, SharePoint, and Power Apps.
Observed behavior: The system blocks the status change to 'Complete' on the submission date, seemingly requiring the completion date to be strictly later than the submission date.

Before you start

Ensure you have Owner or Edit permissions for the associated SharePoint list and the customized Power Apps form to view and modify formula configurations.

Solution 1Recommended

Review Form Validation and Date Formulas in Power Apps

Check and modify the underlying logic in your custom Power Apps form that may be strictly preventing same-day completion.

When a Microsoft List is customized using Power Apps, custom validation rules or data cards often override default list behaviors. Date formulas or conditions tied to the 'Status' field might have been configured to require the completion date to be strictly greater than the submission date.

Open the Custom Form

Navigate to your list in SharePoint or Microsoft Lists, click on 'Integrate' in the top menu, select 'Power Apps', and then click 'Customize forms'.

Locate the Status Data Card

In the Power Apps Studio tree view on the left, select the data card associated with your 'Status' or 'Completion Date' field.

Inspect the Formula Properties

Check the 'Update', 'Valid', and 'Default' properties in the formula bar for any logic that restricts the date (for example, looking for a rule like CompletionDate > SubmitDate).

Modify and Publish

Change the formula to allow same-day completion by using the greater-than-or-equal-to operator (>=), then save and publish your app.

Review Form Validation and Date Formulas in Power Apps

Solution 2

Consult the Microsoft Power Platform Community

If the formula logic is complex or nested, gathering expert assistance from the Power Platform community is recommended.

Free Microsoft Office alternative

Looking for a Reliable Office Suite? Try WPS Office

While managing custom web applications requires specialized low-code tools, your daily document, spreadsheet, and presentation tasks don't have to be complicated. WPS Office provides a free, lightweight, and highly compatible alternative to Microsoft Office for all your everyday productivity needs.

1. Download WPS Office: Visit the official WPS Office website and download the free installer for your operating system.
2. Open WPS Spreadsheet: Launch the suite and select WPS Spreadsheet to create a new tracking document or open an existing Excel list.
3. Set Up Easy Data Tracking: Use the built-in Data Validation tool under the Data tab to create dropdown menus for status tracking without requiring any complex code.

Fully compatible with Microsoft Excel (.xlsx), Word (.docx), and PowerPoint (.pptx) formats.Built-in robust spreadsheet tools for easy data tracking and simple list management.Lightweight design that runs smoothly on Windows, Mac, Linux, and mobile devices.Familiar, tabbed user interface ensuring zero learning curve for easy migration.

microsoft office alternative - wps office

Frequently Asked Questions

Why does Power Apps change my default Microsoft Lists behavior?

When you customize a SharePoint or Microsoft List form using Power Apps, the list relies entirely on the custom app's logic and formulas rather than default SharePoint settings. Any hidden constraints in the app will override standard list behaviors.

Can I remove the Power Apps customization and revert to the default list form?

Yes. You can go to List Settings in SharePoint, select 'Form settings', choose 'Use the default SharePoint form', and click OK to bypass the Power Apps logic and return to the standard experience.

How do I fix date validation errors for the current day in Power Apps?

Select the date field's data card, unlock it in the advanced properties pane, and adjust the 'Valid' property. Ensure the formula allows for the current date by using operators like <= or >= instead of strictly less than or greater than.

Office Quick Solutions