Nov 24 2016 10:02 AM
Apologies if this has been addressed, but I haven't been able to find any answers.
I'm not a developer, just a (at one time) fairly sophisticated user -- of SharePoint 2010. I'm now in a SharePoint Online environment.
My question: I used to to be able to define 'joined lists' in SP Designer and then place a Data View Web Part onto a page (using SP Designer Visual Editor) in order to display the joined data. What is the 'modern' equivalent of that (rather simple, IMHO) process? I can still join the lists in SP Designer to create a Linked Data Source, but:
So, question 1: what should a simple user use as a Visual Editor for SharePoint Online? Do I need to get Visual Studio (which I have zero experience with) or is there another tool recommended?
Next I have stumbled through the plethora of 'new' tools which have appeared, and found:
To reiterate:
The objective is a joined view of select data from three SharePoint Online lists, embedded in a SharePoint page, suitable for C-Suite consumption -- ideally refreshed and updated without regular intervention.
Tools I have:
SharePoint Online (Enterprise license); SharePoint Designer; PowerBI Desktop; Excel; Access; PowerApps. Visual Studio (though with no experience or confidence).
I have Site Collection Admin access, but no higher. I cannot deply scripts (Powershell or otherwise), at least not without some clear and detailed (... for Dummies) instruction.
Data:
Three tables: Division, Project and Status
Division: ID, Name, Short Name;
Project: ID, Title, (Division ID) {as lookup to Division}
Status: ID, Title, (Project Title) {as lookup to Project}
Any suggestions on how I can dispay: Project|Title, Division|Name, Status|Title is a single table view?
Nov 24 2016 11:16 AM
SolutionNov 28 2016 06:56 AM
Juan,
Thank yo for your response. I guess I will crack open Power Apps & update my tool kit.
Cheers,
Kevin
Nov 24 2016 11:16 AM
Solution