Share via

In dataverse for planner premium. it seems like there isn't a specific column that finds the actual completeion date

Jackson Lindsey (TEMA) 0 Reputation points
2026-03-10T15:47:23.8166667+00:00

In Dataverse msdyn_finish and msdyn_scheduledend always seem to hold the same values so Im really just wondering what the intended way to get the actual complete date is

Microsoft Teams | Microsoft Teams for business | Tasks | Manage tasks
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Hendrix-C 15,095 Reputation points Microsoft External Staff Moderator
    2026-03-10T21:28:53.59+00:00

    Hi @Jackson Lindsey (TEMA),

    Thank you for posting your question in the Microsoft Q&A forum.

    According to your concern and based on my knowledge on Microsoft Planner, in Planner Premium (which is built on the Project for the web and stores data in Dataverse), the standard task fields like Finish / Scheduled End are schedule dates and typically won’t give you a dedicated “completed on” timestamp. Refer to the information from DaleHowardMVP, Project for the web doesn’t store an Actual Finish / completion datetime out of the box, so there isn’t a dedicated column you can query for “the moment the task hit 100%.” For reference: In P4TW, when a user completes a task, is the date/time captured? : r/MSProject

    (This is a non-Microsoft website. The page appears to be providing accurate, safe information. Watch out for ads on the site that may advertise products frequently classified as a PUP (Potentially Unwanted Products). Thoroughly research any product advertised on the site before you decide to download and install it.)

    The suggested practical approach is to use Dataverse auditing to derive completion timestamp. If auditing is enabled for the table/column, you can query the Audit table for the change event when progress (or the status field you use) first became “complete”:

    • Enable auditing at the environment level > Enable auditing on the task table (e.g. msdyn_projecttask)
    • Track the field that indicates completion (% complete or percentcomplete)
    • Then read the Audit History to see exactly when it changed to 100%

    For you receiving further appropriate assistance and guidance, I recommend posting your scenario in the Microsoft Power Platform Community Forum Thread. This forum is dedicated to Dataverse for Planner Premium/Project for the web and is actively monitored by experienced users, Microsoft partners, and engineers who can provide detailed guidance and share best practices.

    User's image

    Apologies for redirecting you to a different community as I'm a forum moderator, my primary role is to guide users toward the appropriate resources and support channels and the category you initially posted in primarily focuses on Microsoft 365-related topics, therefore I may not have the depth of expertise needed for Dataverse-specific questions.   

    Thank you for your patience and understanding throughout this process. If you have any other questions or concerns in the future, please do not hesitate to reach out again. Not only will I be happy to help you, but also all the moderatos of the Q&A forum will do their best to provide support and assistance.  

    I hope that everything will get sorted out soon. Wishing you a great day ahead.

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".       

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments
  2. Q&A Assist
    2026-03-10T15:47:32.9333333+00:00
    AI generated content. This question contains an answer created with AI from Q&A Assist. Learn more

    In Dataverse there is no dedicated “actual completion date” column for Planner tasks exposed in the PlannerSyncAction table. The available columns include status-related fields like percentcomplete and priority, but no separate timestamp that records when a task actually reached 100% complete.

    Because of this, the intended way to infer completion is to use percentcomplete (when it equals 100) as the indicator that the task is complete, and then rely on Dataverse’s generic auditing/timestamp columns (such as CreatedOn/ModifiedOn on the relevant row) or any solution-specific date columns your environment provides. However, the context only shows percentcomplete and does not define a specific “actual finish” or “completed on” column for Planner sync data.

    So, within the Planner premium Dataverse schema shown here, there is no separate, purpose-built “actual completion date” field analogous to Actual Finish in Microsoft Project; completion must be inferred from percentcomplete combined with general Dataverse timestamps.

    References:

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.