User Profile
RatanPushp
Brass Contributor
Joined Sep 08, 2022
User Widgets
Recent Discussions
Re: Assignments - inconsistency oData-feed and PWA-GUI?
Hello CuriousProjectUser , Try reversing your approach, first consider Resources table and join it with Assignments table to fetch resources list with assignment eq 0. Moreover, you may also use Power BI report content pack to validate OData of Project Online Assignment, Resources, Projects, etc.. https://github.com/jaduong/Project-Power-BI-Content-Packs/blob/master/Microsoft%20Project%20Online%20Power%20BI%20Content%20Pack.pbit Hope this helps you! Regards, Ratan PushpRe: Creating a Project through Graph API "msdyn_CreateProjectV1"
Hello johnjohn-Peter , Since, the new project is created using API, it cannot appear in Recent list of projects. If the new project is created, then it must be available in "Created by me" list. The Recent list shows project which you recently accessed. Hope this helps you! Regards, Ratan PushpRe: Need Help in Project Operations connection with Project for Web
Hello Navdeep, Try the integration of Dynamics 365 Project Operations with Project Accelerator, eventually the projects will be also visible in Project for the web. Scenario to create a project in Project Accelerator automatically on new project creation in Dynamics 365 project operations, you can use Power Automate for project creation workflow. Create a new flow and select the trigger: When a record is created (Dataverse connector). Configure the trigger to monitor the Project table in Dynamics 365 Project Operations. Add an action: Create a new record (Dataverse connector). Select the Project table in Project Accelerator. Map fields from the Dynamics 365 Project Operations project to the corresponding fields in Project Accelerator (e.g., name, description, start date, etc.). Verify that the project is created in Project Accelerator with the correct details. Hope this helps you! Regards, Ratan PushpRe: Resources mapping using Project (Planner) and MS Power BI template
Hello Sidi, This resource utilization report is developed using Project Online data tables, Resource assignments and capacity. Resource Utilization percentage is calculated by dividing sum of assignment work by sum of resource capacity. To achieve similar report for Project (Planner) additional customization is required as resource capacity not available in existing solution tables. Thanks & Regards, Ratan PushpRe: Project online REST API for Project Manager approval on Task status update
Hello Shruti, The allocated tasks of a project to a team member are part of their assignments. So, you need to refer "EnterpriseResources/Assignments" along with "TimeSheetPeriods/TimeSheet" and related endpoints to find related tasks of a team member. As per the solution design of Project Online, the project task submitted by a team member requires respective Project Manager approval, and Timesheet manager on the timesheet (It depends on the timesheet configuration). Hope you find this information helpful. Best Regards, Ratan PushpRe: Resources mapping using Project (Planner) and MS Power BI template
Hello Sidimm, Resource utilization report is not part of Power BI report pack and require custom development. Assume, you are looking something similar to below report. https://www.linkedin.com/posts/ratan-pushp_powerbi-projectonline-projectmanagement-activity-7295710080505630720-QDEV?utm_source=share&utm_medium=member_desktop&rcm=ACoAAARF1oIBYwYyPfvSAIEhai53QlcZqxpF6uk I hope it is helpful for you! Ratan PushpRe: PDP - Mandatory Custom Fields Issue
Hello Ahmed, Based on the issue details described by you, I believe few Project level custom fields as mandatory are created in PWA site of Project Server 2019. And the same are added into PDP page of 'Project information". Mandatory fields is empty error message pop-up during project creation in PWA site and also while saving project through MS Project desktop. Hope that's the issue you are refering? Could you please provide input on the newly created custom fields as mandatory. Is it not required during new project creation (via pwa)? Only once the project is created, the manadatory fields should be allowed to edit by users? I can help you, if you answer above query on the usage of project creation. Thanks! Regards, Ratan PushpRe: task and timesheet on user not show
Hi, The Task list by default shows tasks which are either Inprogress or in current week period. The new assignments "work 020, work 027, work 029" are future tasks falling in next month week period. Therefore, by using other views or week period the task will be displayed in task grid. Otherwise, by using Add task the user can add other assigned task in the grid. But by now, I am sure tasks would appeared in Task list as week period proceeds. Thanks for tagging me to this issue to me, next time i'll try to respond early!Re: Show Sprints on Gantt Chart
Snouffelaire With the use of Group by "Sprint" option in View tab, the sprint task will be visible in Gantt Chart. Whereas, to highlight sprint week period in Gantt Chart, modify the bar style of "Group by Summary" with Sprint Start and Sprint Finish (in From and To columns) and also select color or pattern as per your preference. I hope this helps you.Re: Agile Sprints not working (Sprints tab shows as blank) in Project Professional O365 2306
Paul_4 You may create custom tab with Sprint options in it. Go to File-->Options and select Custom Ribbon. I'm not sure about the issue of Sprint tab disappearing but with custom tab, at least those options can be loaded back. Also, the Sprint tab is visible by default if the project created as "Sprints Project" and not in "Blank Project" I hope it helps you.Re: Security in Project
daibt Revoke project plan 3 licenses and ensure users do have M365 subscription, this may restrict users to modify project. However, they update progress (% complete) only, if assigned on a task. Please check below link: https://learn.microsoft.com/en-us/office365/servicedescriptions/project-online-service-description/project-web-service-description#feature-availability Try and let me know if it helps you.Re: How to calculate the total delay on the programme
JDbrasileng You could calculate delay duration within a custom field. For reference, date difference formula can help in providing duration - ProjDateDiff([Finish],[Status Date]). In case, you want calculate delay based on planned / forecasted date then use "Baseline Finish" date instead of "Finish" field. Since, Status date is used in the formula, you can change Status date in Project Information section to view delays accordingly. I hope this helps you.Re: can we Bulk copy paste several tasks in Project online?
Hi Nisha, Bulk task copy in a project can be performed either on PWA project schedule or by using MS Project. a. Copy task in PWA project schedule: Open the project schedule in EDIT mode and copy the tasks but remember to adjust task structure (Task indent or outdent). b. Copy task using MS Project: Open project using MS Project Desktop and copy task into the project plan. Any text content from excel, OneNote, word, outlook etc.. can be copied in Task name. Milestone task can be defined with 0d duration or insert a column of Milestone in your project plan and mark required task "Yes" to that task as a Milestone. Project Restore Administrative Backup and Restore is not available in a Project Online environment. If multiple versions of a Project are needed, for any reason, the best option is to identify the project(s) and save the required versions manually. Keep a backup copy stored locally or in any shared document folder of SharePoint. Let me know if you need more helpRe: Enterprise custom fields not showing on PWA view?
Hi BlissL, The created enterprise custom fields doesn't have any issue as it a Task level field and I believe you are able to find view values in it when viewing the schedule. However, the task page shows assignment of an resource (user). So, please add values at assignment level by opening project in desktop app and using Task Usage view. Give similar value against resource name also and then it will be reflected in Task page. Sure, it will work this time. Thanks, RatanPushp
