Teams Copilot Oracle Order Lookup

I want a streamlined way for anyone in Order Management, COPS, Finance/AR, or Logistics to pull key Oracle order details directly inside Microsoft Teams by simply chatting with Copilot. When I ask, “What’s the waybill for order 5015****?”, Copilot should respond instantly by reading the most recent values—Schedule Ship Date, Scheduled Arrival Date, Waybill Number, Delivery Number, and any future columns we add—from a continuously refreshed Excel file stored in SharePoint.

Current landscape
• Oracle order data already lives in a cloud repository (not Oracle Cloud, AWS, or Azure).
• Our preferred integration path is file-based: an automated export dumps the latest dataset as CSV/Excel, which SharePoint syncs to Teams.
• No one should have to log in to Oracle manually after this goes live.

Your work
1. Build or refine the automated job that pulls the data from our cloud Oracle instance and overwrites—or delta-updates—the SharePoint-based Excel file on a reliable schedule.
2. Create the custom Copilot agent within Microsoft Teams so it can:
– Read the Excel file in real time (without requiring additional user permissions).
– Parse natural-language questions and map them to the right columns.
– Return concise answers or, when asked, the entire order row.
3. Handle security and access control so only authorised Teams users can query the data.
4. Document the setup clearly and provide a hand-off session so my admin team can maintain or tweak schedules later.

Acceptance criteria
• Asking for any of the four specified fields by order number retrieves the correct value in ≤3 seconds.
• The Excel file reflects Oracle changes at least every hour without manual touches.
• Role-based access follows our existing Teams groups.
• No direct database credentials are exposed anywhere in the solution.

Tech stack suggestions are welcome—Power Automate, Graph API, Adaptive Cards, Python or PowerShell scripts, etc.—as long as the above goals are met. Let me know your approach and timeline, and feel free to flag any dependencies you foresee.