[3/20/2026]

• Access control
• full layout
• customizable banner

[2/27/2026]

Next week

• Start on CDD
• Attorney workload - counts at each level
• Hotelling - try attaching .ics to email
• Role-based pages
• LOP - show a manually converted procedure
• Power BI - full width block or popup 

[2/20/2026]

LOP

• Manually convert a couple of procedures and finalize the format & display for procedure display

Supervisor dashboard

• Pretty good. Add attorney name to spreadsheet
• Need to look more into embedded PowerBI - specs and capabilities

Hotelling

• Email access issue; add event
• Show all events at the same time

[2/6/2026]

• LOP
  • Procedure web component prototype done - make sure the steps are loaded from SharePoint list instead of hard-coded in the component
• Supervisor dashboard
  • Attorney workload: Power App mockup backed by a SharePoint list - use SharePoint Framework component instead; better organization of lists
  • Embedded Power BI: next week show some Power BI visual
• Hotelling
  • Update the wireframe design
  • Get input from Luis on whether it should be a top-level component
  • Create a component

AI tools

• Chat: ChatGPT, Claude, Gemini
• If you pay subscriptions, you get coding tools from the AI providers: Claude Code, Antigravity, etc.
• As student, you get free GitHub Copilot - plugins for VS Code, and all JetBrains IDEs (like PyCharm, IntelliJ IDEA, WebStorm) ...

[1/30/2025]

• LOP part: Steven, Jamie, Jio, Jared
• Supervisor dashboard: Jonathan, Huy, Krystal, Alyssa
• Hoteling: Steven, Jonathan, me, Alondra, Krystal, Huy

[11/14/2025]

Next week will be our last weekly meeting for this semester.

• Everyone to set up the SharePoint Framework dev environment, do a Hello-World component, publish it to the site.
• Report any additional progress
• Timeline for documentation & presentation
• Update the project page

[10/31/2025]

Schedule

Custom content based on user & user's group

• Hide/show content block
• Show customized content within a block

SharePoint/Power Apps approach (Attorney site):

• Work on Announcement block to show some announcements made by site admin (other users can only view)
• Check calendar if the calendar can show both SharePoint site events & Outlook calendar events
• Most commonly used forms - just a list is OK for now; ideally the site should keep track of which forms are accessed the most and show them here.
• Attorney assignments - pull from a SharePoint list, filtered by current user
• Witness & Staff directories - Search bar, and also click-to-search dropdown

SharePoint Framework approach (Attorney site):

• Announcements
• Events - check if you can get both site events & Outlook calendar events
• Built up other blocks

Both teams

• Check if you can get user group, and use that to hide/show blocks

[10/17/2025]

SharePoint Framework team and Power App team both work on implementing this site in parallel.

Welcome block: get the current user name

Office information: static block with some information

Announcement block: pull from SharePoint site announcements; show a list of titles of recent announcements; clicking on a title goes to full announcement

Most common forms: static

Upcoming events: probably a Calendar widget

Attorney assignments: pull  assignments from SharePoint list? Preferrably filtered by current user

Manual & handbooks: static

Expert witness directory: create a SharePoint list from Luis's spreadsheet and pull from the SharePoint list

Staff directory: use a SharePoint list for now

[9/26/2025]

subteam 1:

Johnathan & Steven: get the laptop; starting doing some Sharepoint Framework Hello World stuff; contact Xavier at xnavarro@countyofsb.org or call Luis's work number if you have access questions.

James, Alondra, Huy, Jamie: learn Node.js/JavaScript/React

subteam 2:

(1) Audience targeting by group and by user

When a user access a SharePoint site (e.g. https://csula.sharepoint.com/sites/mysite), see if you can automatically redirect the user to a specific page based on the user's AD group (e.g. https://csula.sharepoint.com/sites/mysite/faculty or https://csula.sharepoint.com/sites/mysite/student). Once the user lands on this page, see what can be further customized based on the user. I don't know what AD groups are in the university AD, but you can try faculty, student, and staff.

(2) Code snippet

See what type of code/CSS you can add to a SharePoint site/page through Code Snippet

(3) Future Site

Create a site that looks like this

Create a SharePoint site based on the outline Luis provided today. See what components (like calendar, OneNote, etc.) you can add to the site.

• SharePoint Framework subteam
  • Johnathan
  • Steven
  • James
  • Alondra
  • Huy
  • Jamie
• General SharePoint Support (e.g. meta tags, components, design ...) and Audience Targeting subteam
  • Allyssa
  • Krystal
  • Jared
  • Jovany

[9/19/2025]

Building team sites for different groups of users??

Role vs AD group??

Top Section

- Search bar

- Calendar (personal and/or trainings)

- announcements/blog/messages from Supervisor

- Data analysis (dashboard/card/section)

Training Hub

- Policies

- Standard Operating Procedures

- *file directory (sharepoint directory/box)

Intern Program Hub

- section for attorneys learn about utilizing internships

Legal Research Hub

- tools

- Request a tool

- Book Purchase Request

Onenote Toolkit

- Read only access

Police Manuals

-evergreen links

-download into a directory

Onboarding Section

-training schedule (all depts)

-countywide training requirements

-documents and video resources

-first week assignments

*Executive team dashboard

- data analysis - feed from Power BI charts

- master calendar

- vacations/personal leave schedule

*Office hoteling request

- book a conference room

- book office for the day

7 sections assignments

fie database/metatags

front end architecture

[9/5/2025]

• Overview of the SharePoint Framework
• SharePoint Framework Tutorials on YouTube
• Graph API Explorer
• Wireframe of a site
• Discord channel - https://discord.gg/cTJSQTeG

[9/1/2025]

1. SharePoint

Google Microsoft SharePoint, read some documentation and tutorials, watch some YouTube videos, ask AI ...

SharePoint example and access

• Log in https://mycsula.calstatela.edu
• Go to App Launcher at the upper left corner (the 3x3 dots), select SharePoint, see if you have the "Create site" link.

2. LDAP (Lightweight Directory Access Protocol) and AD (Active Directory)

A "directory" is where the information about an organization is stored. For example:

• User information: username, password, email, phone, first name, last name, office, role, manager/supervisor ...
• Department information: name, personnel, location, office, administrator ...
• facility, equipment, network ...

LDAP is a standard that defines how the information in a directory is organized and accessed. Active Directory is a Microsoft implementation of the LDAP standard with some MS-specific features and optimizations. Both CSULA and SBPD use AD (or the cloud-based Azure AD), but we only have access to CSULA AD as a regular user (probably cannot browse/add/edit directory data).

Do an image search on Google "LDAP Browser" to see what directory data looks like.

We may need to set up our own LDAP server after we get a better idea of the project.

3. Project

Project Description

Create a SharePoint site that shows different pages and/or content to different users (or different types of users, a.k.a. roles).

For example:

(a) Creates a page for each type of user (i.e. role), e.g. a page for attorneys, a page for IT staff, a page for new employee, etc. After a user logs in, based on the role of the user, the site directs the user to the appropriate page.

(b) Create a page with different content blocks, e.g. News, Alerts, Navigation Menu, Recent Documents, etc. After a user logs in, based on the user, show appropriate blocks and appropriate content in the blocks.

How do we do it?

The proposed platform will use SharePoint’s audience targeting and metadata capabilities to deliver tailored content to distinct user groups, ...

• How do we get user information (e.g. name, role, starting date ...) after a user logs in?
  • Audience targeting in SharePoint
  • Use the Microsoft Graph API ?
  • More research needed
• How capable is SharePoint in terms of delivering dynamic page/content?
  • Redirect a user of a certain role to a certain page?
  • Show/hide certain blocks on a page?
  • Dynamically generate content of a block (e.g. Recent Documents)?
  • More search needed
  • Custom development is likely needed

4. Todo

Because experts on SharePoint, particularly audience targeting and site customization. Explore different approaches and pick one to move forward.

[8/29/2025]

SharePoint built-in search?

Workflows & notifications?

Roles in AD -> how to access roles in SharePoint

New employee in AD?

AD schema