Does PWA meet our needs?

%3CLINGO-SUB%20id%3D%22lingo-sub-2634119%22%20slang%3D%22en-US%22%3EDoes%20PWA%20meet%20our%20needs%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2634119%22%20slang%3D%22en-US%22%3E%3CP%3EWe%20are%20evaluating%20a%20number%20of%20MS%20solutions%20to%20see%20if%20we%20can%20find%20one%20solution%20that%20meets%20our%20needs%2C%20and%20have%20been%20extremely%20frustrated%20by%20MS%20offerings%20by%20their%20lack%20of%20integration%20and%20basic%20lack%20of%20functionality.%26nbsp%3B%20We%20cannot%20imagine%20our%20needs%20are%20unlike%20others.%26nbsp%3B%20To%20date%20we%20have%20evaluated%20the%20following%20MS%20tools...%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CUL%3E%3CLI%3ESharepoint%20lists%2C%20tasks%2C%20and%20calendar'%3C%2FLI%3E%3CLI%3EMS%20Planner%3C%2FLI%3E%3CLI%3EMS%20Project%20Online%2FEssentials%3C%2FLI%3E%3C%2FUL%3E%3CP%3EWe%20not%20evaluated%20PWA%20and%20before%20doing%20wanted%20to%20ask%20those%20in%20the%20forum%20if%20anyone%20can%20provide%20their%20opinion%20as%20to%20whether%20this%20tool%20will%20meet%20our%20needs.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EQ%3A%26nbsp%3B%20Will%20PWA%20meet%20our%20needs%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere%20are%20our%20must%20requirements%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CUL%20class%3D%22lia-list-style-type-circle%22%3E%3CLI%3ECan%20create%20lookup%20fields%20accessing%20data%20from%20a%20SharePoint%20list%20(we%20have%20SharePoint%20lists%20with%20100%2B%20rows%20of%20data%20that%20serve%20as%20fields%3C%2FLI%3E%3CLI%3ECan%20add%20and%20customize%20columns%20(test%2C%20number%2C%20choice%2C%20multiple%20choice)%3C%2FLI%3E%3CLI%3ECalendar%20%2F%20Gantt%20%2F%20List%20views%3C%2FLI%3E%3CLI%3EPredecessor%20relationships%3C%2FLI%3E%3CLI%3ECalendar%20and%20Gantt%20can%20be%20viewed%20either%20through%20SharePoint%20or%20Power%20BI%2C%20and%20can%20be%20merged%20with%20other%20calendars%20on%20Sharepoint%20as%20an%20integrated%20calendar%20to%20show%20all%20daily%20activities%3C%2FLI%3E%3CLI%3EThe%20ability%20to%20filter%20calendar%20views%20(our%20projects%20are%20organized%20by%20department%20and%20work%20required%20-%20we'd%20like%20to%20see%20an%20integrated%20calendar%20with%20conditional%20formatting%20based%20on%20the%20department%2Fwork%2C%20and%20separate%20calendars%20for%20each)%3C%2FLI%3E%3CLI%3EResource%20management%20from%20O365%20members%3C%2FLI%3E%3CLI%3EAutomation%20-%20emails%20triggered%20by%20changes%20to%20the%20project%20for%20the%20resources%20associated%20with%20the%20project%3C%2FLI%3E%3C%2FUL%3E%3CP%3EThank%20you.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2635019%22%20slang%3D%22en-US%22%3ERe%3A%20Does%20PWA%20meet%20our%20needs%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2635019%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F180092%22%20target%3D%22_blank%22%3E%40Sniffer%3C%2FA%3E%2C%3C%2FP%3E%0A%3CP%3EAfter%20a%20quick%20scan%20of%20your%20list%20of%20requirements%20and%20I%20would%20say%20that%20PWA%20is%20definitely%20worth%20evaluating.%20Project%20Online%20custom%20fields%20accessing%20SharePoint%20list%20data%20is%20not%20out%20of%20the%20box%2C%20that%20would%20be%20custom%20dev%2C%20but%20is%20possible.%3C%2FP%3E%0A%3CP%3EGet%20a%20free%20trial%20and%20review.%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fwww.microsoft.com%2Fen-gb%2Fmicrosoft-365%2Fproject%2Fproject-plan-3%3Factivetab%3Dpivot%253aoverviewtab%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.microsoft.com%2Fen-gb%2Fmicrosoft-365%2Fproject%2Fproject-plan-3%3Factivetab%3Dpivot%253aoverviewtab%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EPaul%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

We are evaluating a number of MS solutions to see if we can find one solution that meets our needs, and have been extremely frustrated by MS offerings by their lack of integration and basic lack of functionality.  We cannot imagine our needs are unlike others.  To date we have evaluated the following MS tools... 

 

  • Sharepoint lists, tasks, and calendar'
  • MS Planner
  • MS Project Online/Essentials

We not evaluated PWA and before doing wanted to ask those in the forum if anyone can provide their opinion as to whether this tool will meet our needs. 

 

Q:  Will PWA meet our needs?

 

Here are our must requirements:

 

  • Can create lookup fields accessing data from a SharePoint list (we have SharePoint lists with 100+ rows of data that serve as fields
  • Can add and customize columns (test, number, choice, multiple choice)
  • Calendar / Gantt / List views
  • Predecessor relationships
  • Calendar and Gantt can be viewed either through SharePoint or Power BI, and can be merged with other calendars on Sharepoint as an integrated calendar to show all daily activities
  • The ability to filter calendar views (our projects are organized by department and work required - we'd like to see an integrated calendar with conditional formatting based on the department/work, and separate calendars for each)
  • Resource management from O365 members
  • Automation - emails triggered by changes to the project for the resources associated with the project

Thank you.

2 Replies

Hello @Sniffer,

After a quick scan of your list of requirements and I would say that PWA is definitely worth evaluating. Project Online custom fields accessing SharePoint list data is not out of the box, that would be custom dev, but is possible.

Get a free trial and review. https://www.microsoft.com/en-gb/microsoft-365/project/project-plan-3?activetab=pivot%3aoverviewtab 

Paul

Sniffer --

In addition to the excellent reply from my colleague, Paul, I would say that all of your requirements can be met using either Project Online or Microsoft Project Server. However, if you are intended to implement either of these tools for your organization, I would kindly recommended that you enlist the services of a qualified Project Partner to assist your organization. Doing so will save you time, money, and frustration; and doing so will help you to get your system configured exactly per your requirements. My company, Projility, is one of many who could assist you (shameful advertisement). Hope this extra helps.