COPILOT STUDIO — PROJECT 4🟡 INTERMEDIATE
DataLink-Agent — structured querying across Dataverse and SharePoint via the Dataverse MCP tool. Static reference showing cross-table reasoning and security-scoped results.
Facilities Assistant — signed in as R. Shah (Building 3 technician)
Which assets in Building 3 have open tickets older than 10 days?
Dataverse MCP Tool · cross-table query Found 2 matching assets in your scope:
AssetTicket ageStatus
Chiller-1914 daysOpen
HVAC-Unit-1211 daysOpen
Log a new facilities request — broken AC in Room 214
SharePoint Action · confirm before write I'll create: Location "Room 214", Issue "Broken AC", Urgency "Medium" — confirm to submit?
Type a message…

Data sources

Dataverse — AssetMCP tool
Dataverse — MaintenanceTicketMCP tool
SharePoint — Facilities RequestsList action

Security scope active

Signed in as R. Shah — Dataverse security role restricts results to Building 3 only. A different technician querying the same question would see a different, correctly-scoped result set — enforced at the data layer, not in the prompt.

Credit cost this session

Cross-table MCP query~5 cr
SharePoint write action~5 cr
What this shows: the cross-table question required the planner to reason across two Dataverse tables in one turn via the Dataverse MCP tool, and results are automatically restricted to what this specific user's security role permits — not filtered after the fact, but scoped at the query itself. The write action still waits for confirmation before touching SharePoint.