Update log── Microsoft Copilot Advanced tips added and revised

September 2026

• September 12, 2026Word × Python · AddedDownload a .docx from OneDrive or SharePoint with Graph and read it in memory
• September 12, 2026Word × Python · AddedDiff two versions by paragraph and write a new Word report
• September 12, 2026Word × Python · AddedWrite style-check findings as Word comments on a copy of the document
• September 12, 2026Word × Python · AddedList core properties and header/footer text for a folder of .docx files
• September 12, 2026Word × Python · AddedExtract a heading outline and flag skipped heading levels
• September 12, 2026Word × Python · AddedExport Word tables to CSV without losing merged or nested cells
• September 12, 2026Word × Python · AddedScan body text and tables in document order with iter_inner_content()
• September 12, 2026Teams × Python · AddedA minimal Agents SDK bot that answers request status by ID
• September 12, 2026Teams × Python · AddedPost the open-request list to a channel through Graph (DRY_RUN by default)
• September 12, 2026Teams × Python · AddedFind channel posts with no replies using $expand=replies
• September 12, 2026Teams × Python · AddedRead channel posts and count them per author and per day
• September 12, 2026Teams × Python · AddedExport your joined teams and their channels to a CSV
• September 12, 2026Teams × Python · AddedSend request-ledger status counts to Workflows as an Adaptive Card
• September 12, 2026Teams × Python · AddedPost a text notice to a Teams Workflows webhook from Python
• September 12, 2026SharePoint / OneDrive × Python · AddedAudit library columns for empty required values and past-due dates
• September 12, 2026SharePoint / OneDrive × Python · AddedFind anyone and organization-wide sharing links on files in a folder
• September 12, 2026SharePoint / OneDrive × Python · AddedConfine an app to assigned sites with Sites.Selected
• September 12, 2026SharePoint / OneDrive × Python · AddedFetch only what changed since the last run with a drive delta query
• September 12, 2026SharePoint / OneDrive × Python · AddedRead list items with column values via expand=fields(select=...)
• September 12, 2026SharePoint / OneDrive × Python · AddedDownload a file's content from a document library
• September 12, 2026SharePoint / OneDrive × Python · AddedList a site's document libraries and the items in one folder
• September 12, 2026SharePoint / OneDrive × Python · AddedResolve a SharePoint site id from its hostname and path
• September 12, 2026Authentication, Permissions and Governance · AddedLog who ran a script, what it did and when, without tokens or personal data
• September 12, 2026Authentication, Permissions and Governance · AddedOn HTTP 429, wait for the Retry-After seconds and then retry
• September 12, 2026Authentication, Permissions and Governance · AddedKeep a per-script ledger of Graph permissions and flag excess ones automatically
• September 12, 2026Authentication, Permissions and Governance · AddedRead external API keys from Key Vault at run time, not from code or config files
• September 12, 2026Authentication, Permissions and Governance · AddedUse a managed identity for code running in Azure so it holds no credentials
• September 12, 2026Authentication, Permissions and Governance · AddedAuthenticate unattended jobs with a certificate instead of a client secret
• September 12, 2026Authentication, Permissions and Governance · AddedPersist the MSAL token cache encrypted and keep it out of the repository
• September 12, 2026Authentication, Permissions and Governance · AddedSign in from a script with the MSAL device code flow
• September 12, 2026Document Search × Python · AddedEnd to end: score each search method with recall@k and MRR on paraphrased questions
• September 12, 2026Document Search × Python · AddedQuery Azure AI Search with keywords and vectors in one request
• September 12, 2026Document Search × Python · AddedGet permission-trimmed extracts with the Copilot Retrieval API
• September 12, 2026Document Search × Python · AddedRerank only the top candidates with a cross-encoder
• September 12, 2026Document Search × Python · AddedHybrid search: fuse BM25 and embedding rankings with RRF
• September 12, 2026Document Search × Python · AddedFind documents by meaning with multilingual embeddings and FAISS
• September 12, 2026Document Search × Python · AddedTF-IDF and BM25 baselines for Japanese using character n-grams
• September 12, 2026Document Search × Python · AddedChunk by headings, or by fixed size with overlap
• September 12, 2026Document Search × Python · AddedExtract PDF text with pypdf, pdfplumber and PyMuPDF, and compare
• September 12, 2026Document Search × Python · AddedRe-index only changed files with delta queries and cTag
• September 12, 2026Workflow Recipes · AddedCheck only the Word documents that changed since the last run
• September 12, 2026Workflow Recipes · AddedCompare document library column values with the ledger
• September 12, 2026Workflow Recipes · AddedMatch request mail against the ledger and list the gaps
• September 12, 2026Workflow Recipes · AddedPick requests needing follow-up from the ledger, one sheet per owner
• September 12, 2026Workflow Recipes · AddedCheck Word and PowerPoint files together and write one Excel workbook
• September 12, 2026From Instructions to Code · AddedScreen generated code with ast before reading it yourself
• September 12, 2026From Instructions to Code · AddedScope instructions to certain folders with .github/instructions/*.instructions.md
• September 12, 2026From Instructions to Code · AddedPut repository-wide rules in .github/copilot-instructions.md
• September 12, 2026From Instructions to Code · AddedSplit a large task into small functions and prompt for them one at a time
• September 12, 2026From Instructions to Code · AddedWrite assert-based tests first, then ask Copilot for a function that passes them
• September 12, 2026From Instructions to Code · AddedWrite the signature and docstring examples first, then let Copilot fill in the body
• September 12, 2026PowerPoint × Python · AddedBuild a new summary deck from the titles and counts of several decks
• September 12, 2026PowerPoint × Python · AddedBatch-check every deck in a folder against a style list into one CSV
• September 12, 2026PowerPoint × Python · AddedExtract slide images, drop duplicates by SHA1, and list them in a CSV
• September 12, 2026PowerPoint × Python · AddedWalk group shapes recursively so text inside groups is not missed
• September 12, 2026PowerPoint × Python · AddedRead speaker notes safely with has_notes_slide and list gaps and flagged terms
• September 12, 2026PowerPoint × Python · AddedExport slide tables to CSV and mark merged and empty cells
• September 12, 2026PowerPoint × Python · AddedTurn a deck into a Markdown outline and find slides without a title
• September 12, 2026Power Automate × Python · AddedDescribe the function in OpenAPI 2.0 and import it as a custom connector
• September 12, 2026Power Automate × Python · AddedOffice Scripts for the workbook, Python for external calls
• September 12, 2026Power Automate × Python · AddedStart a flow from Python through the When an HTTP request is received trigger
• September 12, 2026Power Automate × Python · AddedCall the function from a flow's HTTP action: key header and time limits
• September 12, 2026Power Automate × Python · AddedWrite an HTTP-triggered Azure Function in Python for a cloud flow
• September 12, 2026Power Automate × Python · AddedSummarize a ledger with the Run Python script action in a desktop flow
• September 12, 2026Outlook × Python · AddedMail an unread-mail summary to yourself (DRY_RUN by default)
• September 12, 2026Outlook × Python · AddedPick up only what changed since last run with the messages delta function
• September 12, 2026Outlook × Python · AddedExpand a week with calendarView and total meeting hours per day
• September 12, 2026Outlook × Python · AddedFilter by a receivedDateTime range and count mail per local day
• September 12, 2026Outlook × Python · AddedFollow @odata.nextLink through every page and group mail by request ID
• September 12, 2026Outlook × Python · AddedCount unread Inbox mail per sender with $select and $filter
• September 12, 2026Outlook × Python · AddedSign in with the device code flow and create a Graph client
• September 12, 2026Excel × Python · AddedSummarize a ledger with pandas and write several sheets to a new workbook
• September 12, 2026Excel × Python · AddedRead a ledger with openpyxl read_only and data_only
• September 12, 2026Excel × Python · AddedList the code in Python cells with FORMULATEXT for review
• September 12, 2026Excel × Python · AddedBring outside data in with Power Query and read it by query name with xl()
• September 12, 2026Excel × Python · AddedCheck which libraries the runtime provides and keep imports up front
• September 12, 2026Excel × Python · AddedPlace variables to match the row-major calculation order of Python cells
• September 12, 2026Excel × Python · AddedKeep group labels as a column when returning a summary as Excel values
• September 12, 2026Excel × Python · AddedRead a whole table into a DataFrame with xl() in a =PY cell
• September 12, 2026Choosing Where Code Runs · AddedCheck library versions in the first cell of a Fabric notebook
• September 12, 2026Choosing Where Code Runs · AddedCheck Functions plan time limits and the Python version before deploying
• September 12, 2026Choosing Where Code Runs · AddedRun functions locally with Core Tools and read settings from local.settings.json
• September 12, 2026Choosing Where Code Runs · AddedShow the Python in Excel runtime in a =PY cell and compare it with local Python
• September 12, 2026Choosing Where Code Runs · AddedCompare the versions pinned in requirements.txt with what is installed
• September 12, 2026Choosing Where Code Runs · AddedLog the Python and package versions next to your results
• September 12, 2026Agents × Python · AddedAsk a Copilot Studio agent from Python with the Copilot Studio client library
• September 12, 2026Agents × Python · AddedCall an Azure Functions API from an agent handler and handle timeouts
• September 12, 2026Agents × Python · AddedGenerate an OpenAPI v2 file for a Copilot Studio REST API tool
• September 12, 2026Agents × Python · AddedUnit-test an HTTP function through build().get_user_function()
• September 12, 2026Agents × Python · AddedBuild a lookup API for an agent as an HTTP-triggered Azure Function
• September 12, 2026Agents × Python · AddedRead agent connection settings from environment variables and host them on aiohttp
• September 12, 2026Agents × Python · AddedSplit AgentApplication routes and rank the catch-all with RouteRank.LAST
• September 12, 2026Code Execution in Copilot · AddedList what changed after Copilot writes Python results into a workbook
• September 12, 2026Code Execution in Copilot · AddedRun advanced analysis code locally with a stand-in for xl()
• September 12, 2026Code Execution in Copilot · AddedRecompute Copilot in Excel's answer with pandas and compare the numbers
• September 12, 2026Code Execution in Copilot · AddedSave the executed code, logs, and generated files from a Predict response
• September 12, 2026Code Execution in Copilot · AddedCall a code interpreter prompt through the Predict API and get the executed code
• September 12, 2026Code Execution in Copilot · AddedPre-check file type, size, and count before handing files to code interpreter