Zapier OneDrive User Files

Category: Connectors · View source ↗

Runs as: Skill Run it in Super Magic and confirm each write. A Flow can also fire a shared skill through the Run Skill action (beta), though this one is written for a person to run rather than a ticket event. Connectors: Zapier: OneDrive Role: Technician Outcome: Faster Resolution & Response, Time & Cost Savings (Capacity) When to use: “<user> says the Q3 proposal vanished — find it,” “pull the file that won’t open so we can check it,” or “send <user> a link to the recovered file.” Run it: on one ticket.

Prompt

"My file disappeared" is a top-ten ticket, and the answer is usually findable: locate the document
with a OneDrive KQL search, fetch the specific file the ticket is about, and when something must be
shared, create the narrowest link that works. Touch exactly the files the ticket names — a user's
OneDrive is their working life, not a browsing ground.

This runs only if the member has connected Zapier with a Microsoft account whose permissions actually
reach the user's OneDrive (often via admin/delegated access). If the connected account can't see the
drive, say so rather than concluding the file doesn't exist. If Zapier is absent, degrade by giving
the user self-serve search/recycle-bin steps — do not stop. Each Zapier call = 2 Zapier tasks — one
well-formed KQL search beats five vague ones.

1. Anchor to the ticket: the exact file name/description, the user, and why access is needed. No
   ticket-relevant reason, no file access — every access is ticket-justified and noted.
2. Locating ("it's gone"): run a KQL search scoped to the user's drive — filename fragments,
   filetype:, modified-date ranges. Files are usually misplaced, renamed, or auto-saved elsewhere.
   Report candidates as name + path + modified date only — enough for the user to say "that's it"
   without the desk reading anything.
3. Not found in scope → report the searched terms and scope honestly and hand off to the tenant's
   recovery process (recycle bin, retention/restore). This skill searches; it doesn't promise
   restoration, and never concludes "the file never existed" or "it was deleted by <user>".
4. Fetching (troubleshooting): retrieve the named file only when inspecting it is the ticket's actual
   task (corrupt file, version check). Content beyond the ticket's need stays unread and unquoted.
5. Sharing-link hygiene: narrowest scope that works — specific-people link over org-wide, org-wide
   over anyone-with-link; view unless editing is the purpose; expiration where the tenant supports it.
   "Anyone with the link" requires my explicit okay; never widen an existing link's scope to save a
   step.
6. Leave a note (plain text): what was searched/accessed, what was found (name/path, not contents),
   any link created and its scope/audience. The access trail is part of the deliverable.

​Prompt

Prompt