# Guides > For the full documentation index, see https://250highstreet.com/llms.txt > Guides on SharePoint trackers: examples, what they cost, spreadsheets versus lists, SharePoint versus Smartsheet, and approval workflows. [Approvals (16)](#approvals)[Trackers and logs (87)](#trackers)[Reminders, alerts and updates (61)](#alerts)[Compare tools (17)](#compare)[SharePoint basics (66)](#basics) ## Approvals Approval workflows, sign-offs and requests that wait on someone. - [Require every approver to approve in Power Automate](/guides/power-automate-approval-everyone-must-approve/)\ Make a Power Automate approval wait for every approver, not just the first. Pick the right approval type, read each response and show who rejected. - [Set up a sequential approval in Power Automate](/guides/power-automate-sequential-approval/)\ Send a request to the manager first, then to finance, and stop at the first rejection. Two ways to build it in Power Automate, with a SharePoint list. - [Send an approval with attachments from a SharePoint list](/guides/power-automate-approval-with-attachments/)\ Send a Power Automate approval that carries the files attached to a SharePoint list item: get the file, pass its name and content, and link the item. - [Approver never gets the Power Automate approval email](/guides/power-automate-approval-email-not-received/)\ Approver says no approval email came? Check the address, the Outlook folders, guest status and the Approvals page, then add a backup message. Steps inside. - [Power Automate approval fails after 30 days waiting](/guides/power-automate-approval-timeout-30-days/)\ A Power Automate run lasts at most 30 days, so an approval nobody answers times out. Set a shorter timeout, handle it, and tell the requester. - [Teams approvals not showing up or not notifying](/guides/teams-approvals-not-showing-up/)\ Approvers miss requests in Teams. A checklist for app access, notifications, guests and mobile, plus an email backup so no request waits unseen. - [A Power Automate approval workflow in Teams, at a fixed price](/guides/approval-workflow-fixed-price/)\ How a SharePoint and Power Automate approval workflow reaches people in Teams and Outlook, where approvals break, and what it costs to have one built at a fixed price. - [Approvals lost in email: how to stop chasing sign-offs](/guides/approvals-lost-in-email/)\ Why sign-offs get buried in inboxes, and a simple fix: one SharePoint list with Status, Approver and decision date, plus a Power Automate approval flow. - [Teams approvals vs email approvals: which one should your team use?](/guides/teams-approvals-vs-email-approvals/)\ Teams Approvals or email sign-offs? Compare the audit trail, reminders, mobile use, licensing and limits, with a plain "pick this if" for each. - [Invoice approval with Power Automate: a tracker and a flow that record every decision](/guides/invoice-approval-power-automate/)\ Track invoices in a SharePoint list and use a Power Automate approval flow to route each one, record the decision and date, and spot stuck invoices. - [Expense approval with a SharePoint list](/guides/expense-approval-sharepoint/)\ A simple way to run employee expense approval in a SharePoint list: one request per row, a receipt attached, a named manager, a status, and a view for finance. - [Document approval in SharePoint: built-in approval or a flow?](/guides/document-approval-sharepoint/)\ Two ways to get documents approved in SharePoint: the built-in content approval setting, or a Power Automate approval flow. What each does and when to use it. - [Purchase requests stuck waiting for approval: how to see them and move them](/guides/purchase-requests-stuck-waiting-for-approval/)\ Why purchase requests sit waiting for approval, and a simple tracker that shows who asked, the amount, who must approve and how long each request has waited. - [Time-off requests in email: one list, one approver, one calendar](/guides/time-off-requests-in-email/)\ Time-off requests scattered across email and chat cause missed approvals and coverage gaps. Here is a simple list, an approver rule and a team calendar view. - [Approvals stuck when the approver is out](/guides/approval-stuck-approver-out/)\ What happens to a Power Automate approval when the person who must decide is away, and a simple backup plan with a list, a due date and a reminder. - [Keep an audit trail of every approval](/guides/approval-audit-trail/)\ What a good approval record needs, where Power Automate keeps approval history, and how to write each decision back to a SharePoint list you control. ## Trackers and logs Set up one list for a job: assets, vendors, tickets, incidents, training and more. - [Certificate of insurance tracker in SharePoint](/guides/certificate-of-insurance-tracker-sharepoint/)\ Build a certificate of insurance tracker in a SharePoint list: one row per vendor, expiry and warning dates, a file for each certificate, and a reminder. - [Warranty tracker in SharePoint: end dates and receipts in one list](/guides/warranty-tracker-sharepoint/)\ Build a warranty tracker in a SharePoint list: item, purchase date, warranty end, receipt link, and a view of warranties ending soon. Steps included. - [Software license tracker in SharePoint: seats, cost and renewal dates](/guides/software-license-tracker-sharepoint/)\ Build a software license tracker in a SharePoint list: seats bought and used, yearly cost, owner and renewal date, plus a view and a reminder flow. - [A mileage log in SharePoint for a small team](/guides/mileage-log-sharepoint/)\ Build a mileage log in SharePoint: staff log trips from a phone form, and a grouped view totals miles per driver per month. Steps and what to avoid. - [Petty cash log in SharePoint: spends, receipt photos and approvals](/guides/petty-cash-log-sharepoint/)\ Build a petty cash log in a SharePoint list: one row per spend, a receipt photo, an approver and a balance view. Steps, sample rows and what to avoid. - [Meeting room booking in SharePoint: list, room mailbox or Bookings](/guides/meeting-room-booking-sharepoint/)\ Three ways to book meeting rooms in Microsoft 365: a SharePoint list, Exchange room mailboxes, or Bookings. What each does and which fits a small office. - [Chemical inventory log in SharePoint: location, amount, SDS link](/guides/chemical-inventory-log-sharepoint/)\ Build a chemical inventory log in SharePoint: one row per product with location, amount, a link to its safety data sheet and a review date. - [Event registration tracker with Microsoft Forms and SharePoint](/guides/event-registration-tracker-sharepoint/)\ Build an event registration tracker: a Microsoft Form fills a SharePoint list, a view shows the head count, and a flow sends each person a confirmation. - [Overtime request form with approval in SharePoint](/guides/overtime-request-form-sharepoint/)\ Build an overtime request form in a SharePoint list: one row per request, a manager approval in Power Automate, and a monthly hours total by person. - [Uniform inventory tracker in SharePoint](/guides/uniform-inventory-tracker-sharepoint/)\ Build a uniform inventory tracker in SharePoint: stock by size, who was issued what and when, and a reorder view. Two small lists, no new software. - [A rent collection tracker in SharePoint](/guides/rent-collection-tracker-sharepoint/)\ Track units, rent due dates, payments received and late fees in two SharePoint lists, with a view that shows what is unpaid and past due. - [Short-term rental cleaning tracker in SharePoint](/guides/short-term-rental-cleaning-checklist-tracker/)\ Track each turnover clean in SharePoint: the property, checkout date, cleaner, checklist result, photo proof and a done flag, with a view of cleans due. - [Bakery order tracker in SharePoint](/guides/bakery-order-tracker-sharepoint/)\ Track custom cake orders in one SharePoint list: pickup date, deposit, design notes and a view of today's pickups for the counter. - [Florist order tracker in SharePoint](/guides/florist-order-tracker-sharepoint/)\ Keep florist orders in one SharePoint list: delivery date, address, card message and driver, plus a delivery-day view for the van. - [A calibration log in SharePoint](/guides/calibration-log-sharepoint/)\ Keep one row per instrument check: instrument, date, result, certificate file and next due date, in two SharePoint lists with views for what is due. - [PPE issue log: who got which gear, size and date](/guides/ppe-issue-log-sharepoint/)\ Build a PPE issue log in SharePoint: one row per item handed out with person, size, date and sign-off, plus a view that shows what to reorder. - [A membership dues tracker in SharePoint](/guides/membership-dues-tracker-sharepoint/)\ Track members, dues owed, dues paid and renewal dates for a club or association in two SharePoint lists, with a view of who is unpaid and past due. - [Mortgage pipeline tracker in SharePoint](/guides/mortgage-pipeline-tracker-sharepoint/)\ Track each loan file by stage, target closing date and missing documents in one SharePoint list, with saved views and a daily Power Automate reminder. - [Content calendar in SharePoint](/guides/content-calendar-sharepoint/)\ Build a content calendar in a SharePoint list: one row per post with channel, owner, publish date and status, plus a calendar view and a "due now" view. - [Simple applicant tracking in SharePoint](/guides/applicant-tracking-sharepoint/)\ Track candidates in one SharePoint list with a role, a stage and interview dates, and see them on a board view by stage. Steps for a small team. - [Wedding planner client tracker in SharePoint](/guides/wedding-planner-client-tracker-sharepoint/)\ Track each wedding's checklist, due dates and budget in two linked SharePoint lists, with views for overdue tasks and what is due next. - [Food truck inventory tracker in SharePoint](/guides/food-truck-inventory-tracker/)\ Build a food truck inventory tracker in SharePoint: stock counts per shift, par levels and a low stock view you can open on your phone before you shop. - [Tutoring schedule and attendance in SharePoint](/guides/tutoring-schedule-attendance-sharepoint/)\ Replace loose tutoring sheets with two SharePoint lists: students, and sessions with tutor, attendance, make-up status and parent notice. Plain steps. - [Manufacturing defects reported but never closed](/guides/non-conformance-log-sharepoint/)\ Defects get reported and then forgotten. Log each one in a SharePoint list with cause, owner and due date, and see open items past due. - [Warehouse receiving log: what arrived, short or damaged](/guides/warehouse-receiving-log-sharepoint/)\ Build a receiving log in SharePoint: one row per delivery with PO number, counts, damage notes and a photo, plus an email when a delivery arrives short. - [Nobody knows which drawing revision is current](/guides/drawing-revision-register-sharepoint/)\ Keep a SharePoint list that records each sheet, its revision letter, date and who got it, with one current row per sheet. The drawings stay in a library. - [Catering order tracker in SharePoint](/guides/catering-order-tracker-sharepoint/)\ Keep catering orders in one SharePoint list: event date, headcount, menu and deposit status, plus a view of today's events for the kitchen. - [Moving estimates and booked jobs in one SharePoint tracker](/guides/moving-company-estimate-job-tracker-sharepoint/)\ Link each moving estimate to a booked job, a truck and a date in SharePoint lists, with a simple way to catch two jobs booked on the same truck and day. - [A pest control service log in SharePoint](/guides/pest-control-service-log-sharepoint/)\ Keep one row per pest control visit: site, date, area treated, follow-up and next visit date, in two SharePoint lists with views for visits due. - [Home care visit log in SharePoint, with missed-visit view](/guides/home-health-visit-log-sharepoint/)\ Replace paper and texts with two SharePoint lists: clients, and a visit log by caregiver with a missed-visit view and supervisor check. Notes privacy limits. - [Insurance policy renewals missed or found late](/guides/insurance-agency-renewal-tracker-sharepoint/)\ Track policy renewals in a SharePoint list with expiry date, producer and stage, plus 90, 60 and 30 day email reminders from Power Automate. - [Construction bids sent and not followed up](/guides/construction-bid-tracker-sharepoint/)\ Keep every bid in one SharePoint list with a due date, amount, status and follow-up date, so no sent bid goes quiet and you can see won and lost bids. - [Vet clinic case log, drug log and vaccine reminders in SharePoint](/guides/veterinary-clinic-case-log-sharepoint/)\ Keep patients, visits, a drug log and follow-up calls in SharePoint lists, with a daily email for vaccine due dates. Plain steps and privacy limits. - [Lawn care customers and crew schedule in SharePoint](/guides/lawn-care-customer-schedule-sharepoint/)\ Keep lawn care customers, service days and crews in one SharePoint list, add a skipped visits list, and build a weekly view for each crew. - [Cleaning business job tracker in SharePoint](/guides/cleaning-business-job-tracker-sharepoint/)\ Track recurring cleaning jobs, assigned cleaners, supply needs and client complaints in two SharePoint lists instead of scattered spreadsheets. - [Salon appointments and stylist bookings in SharePoint](/guides/salon-appointment-tracker-sharepoint/)\ Build a SharePoint appointment list for a small salon: stylists, a calendar view, no-show flags and a slot key that blocks repeats. With honest limits. - [Employee offboarding checklist that does not miss a step](/guides/employee-offboarding-checklist-sharepoint/)\ Build an employee offboarding checklist in SharePoint: one list of departures, one of tasks with owners and due dates, and a view of what is still open. - [Purchase order tracker for a small team](/guides/purchase-order-tracker-sharepoint/)\ Build a purchase order tracker in a SharePoint list: PO number, vendor, amount, status and dates, with views for open and late orders. No spreadsheet needed. - [A work order tracker in SharePoint, without a spreadsheet](/guides/work-order-tracker-sharepoint/)\ Build a work order tracker in one SharePoint list: order number, type, priority, status, assignee, dates, parts and hours, with three views and an alert. - [Dental office supply inventory with reorder alerts](/guides/dental-office-supply-inventory-sharepoint/)\ Track office supplies with par levels and reorder points in a SharePoint list, and send the office manager one low stock email a week. Supplies only. - [An HOA violation tracker in SharePoint](/guides/hoa-violation-tracker-sharepoint/)\ Keep every HOA violation in one SharePoint list: property, notice stage, dates and a next-step date, with four saved views. A record, not a rulebook. - [Law firm client intake form that feeds a matter list](/guides/law-firm-client-intake-form-sharepoint/)\ Build a Microsoft Forms intake that adds a row to a SharePoint matter list, with a conflict check flag and a task for the assigned attorney. Not legal advice. - [Restaurant prep list and food temperature log on a phone](/guides/restaurant-food-temperature-log-prep-checklist/)\ Replace the paper binder with a SharePoint list: a daily prep list, a temperature log filled in on a phone, and a flow that flags a missed check. - [Nonprofit grant deadline tracker with reminders](/guides/nonprofit-grant-deadline-tracker-sharepoint/)\ Build a grant deadline tracker in SharePoint with funder, amount, stage and due date, plus a daily Power Automate flow that emails the grant lead. - [Property inspection checklist with photos and sign-off](/guides/property-inspection-checklist-sharepoint/)\ Build a room-by-room property inspection checklist in SharePoint: one list of units, one of inspections, one of rooms, with photos and a manager sign-off. - [Event vendor tracker: quotes, deposits and day-of contacts](/guides/event-vendor-tracker-sharepoint/)\ Keep every event vendor, quote, deposit due date and load-in time in two linked SharePoint lists, with a view that shows which deposits are still unpaid. - [A real estate transaction tracker in SharePoint for a small brokerage](/guides/real-estate-transaction-tracker-sharepoint/)\ Track each deal in SharePoint: a numbered stage, the inspection, appraisal, financing and closing dates, a checklist per deal, and a date reminder. - [Daycare attendance and pickup log in SharePoint](/guides/daycare-attendance-tracker-sharepoint/)\ Replace the paper sign-in sheet with two SharePoint lists: children by room, and a daily log of time in, time out and who picked up. Includes privacy limits. - [A safety inspection checklist in SharePoint](/guides/safety-inspection-checklist-sharepoint/)\ Replace paper checklists in a binder with two SharePoint lists: one for inspections and one for follow-ups, with a phone form and an overdue view. - [A property maintenance request tracker in SharePoint](/guides/property-maintenance-request-tracker/)\ Stop losing maintenance requests sent by text and email. Build one SharePoint list with a form, urgency, status, vendor and dates, plus four saved views. - [A food bank inventory tracker in SharePoint](/guides/food-bank-inventory-tracker/)\ Counts on paper and best-by dates missed? Build an Items list, a Movements list and an expiring-soon view in SharePoint, with the honest limit on totals. - [A fleet vehicle maintenance log in SharePoint](/guides/fleet-vehicle-maintenance-log/)\ Replace paper mileage and service sheets with two SharePoint lists, a Due soon view and one daily reminder email for a small fleet. - [A key checkout log in SharePoint](/guides/key-checkout-log-sharepoint/)\ Replace the clipboard sign-out sheet with two SharePoint lists: one for keys, one for who took them. Plain steps, a keys-still-out view, and honest limits. - [A visitor sign-in log in SharePoint](/guides/visitor-log-sign-in-sharepoint/)\ Replace the paper sign-in book at the front desk with a Microsoft Form on a tablet or QR code that fills a SharePoint list. Includes sign-out options. - [A shift swap request tracker in SharePoint](/guides/shift-swap-request-tracker/)\ Stop shift swaps getting lost in texts. Build a SharePoint list for swap requests with a status, a manager decision and views for waiting and upcoming swaps. - [A volunteer schedule for a church or club in SharePoint](/guides/church-volunteer-schedule-sharepoint/)\ Replace signup sheets and group texts with two SharePoint lists and a calendar view. See who is signed up, which slots are open, and how to handle swaps. - [A punch list tracker in SharePoint for a small contractor](/guides/construction-punch-list-sharepoint/)\ Build a punch list in one SharePoint list: item, location, trade, priority, status, owner, due date, photo and sign-off, with three saved views. - [A volunteer hours tracker in SharePoint for a nonprofit](/guides/volunteer-hours-tracker-nonprofit/)\ Volunteer hours stuck in sheets? Build two SharePoint lists, a Microsoft Forms sign-in, a flow and a grouped view that shows monthly totals. - [An equipment maintenance log in SharePoint for a clinic or lab](/guides/equipment-maintenance-log-clinic-lab/)\ Build an equipment maintenance log in SharePoint with two lists and one reminder email, so service dates stop slipping past unnoticed. - [A field trip permission form tracker in SharePoint](/guides/field-trip-permission-forms-tracker/)\ Paper permission slips go missing. Collect parent consent in a Microsoft Form, keep a roster, and see which students still have no answer. - [Microsoft Forms responses missing from the Excel sheet](/guides/microsoft-forms-responses-not-showing-in-excel/)\ New Microsoft Forms answers not showing in your Excel workbook? Find out why the link breaks, how to get the rows back, and a sturdier way to store answers. - [SharePoint project tracker examples, with a live demo](/guides/sharepoint-project-tracker-example/)\ Real SharePoint tracker builds with the columns, status rules and flows each one uses, a live demo you can open, and the list limits to plan for. - [How to set up an asset register in SharePoint](/guides/setup-asset-register-sharepoint/)\ A step-by-step walkthrough for ops leads: create a SharePoint list, add the right columns, build useful views, enter a first row and set simple permissions. - [How to set up a vendor list with renewal dates in SharePoint](/guides/setup-vendor-list-renewal-dates-sharepoint/)\ Click-by-click steps to build a vendor list in SharePoint with renewal and notice dates, a view sorted by soonest, a sample row and simple permissions. - [How to set up a simple CRM for a 20-person team in SharePoint](/guides/setup-simple-crm-sharepoint/)\ A step-by-step way to build a simple CRM from two linked SharePoint lists: companies, contacts, a stage column, an owner and one view per stage. - [How to set up an incident log in SharePoint](/guides/setup-incident-log-sharepoint/)\ A step-by-step way to build an incident log in a SharePoint list: columns, views, a sample row and who can see sensitive entries. For ops leads. - [How to set up a training record in SharePoint](/guides/setup-training-record-sharepoint/)\ A click-by-click way to track who finished which training, when, and when it expires, using two linked SharePoint lists and a view of what expires soonest. - [How to set up a project intake form in SharePoint](/guides/setup-project-intake-form-sharepoint/)\ A step-by-step guide to a project intake form in SharePoint: one list, required fields, status and decision columns, a view for new requests and a sample row. - [Help desk ticket tracker in a SharePoint list](/guides/help-desk-tracker-sharepoint/)\ How to build a simple help desk in a SharePoint list: columns, views for open, mine and oldest tickets, a simple intake form, and when a list is not enough. - [Inventory tracking for a small team without new software](/guides/inventory-tracking-small-team/)\ Track consumables and parts in a SharePoint list: item, location, quantity, reorder level, an in and out log and a low stock view. Includes honest limits. - [Equipment checkout with no record: how to track who has what](/guides/equipment-checkout-no-record/)\ Shared laptops, tools and vehicles go missing when nobody writes down who took them. Build an asset list and a checkout log with due dates and overdue flags. - [Vendor onboarding takes weeks: how to see every stage and speed it up](/guides/vendor-onboarding-takes-weeks/)\ Why vendor onboarding drags on for weeks, and how one tracker with stage, owner and days waiting shows where each vendor is stuck. - [Contract renewal dates missed: how to track them so none slip](/guides/contract-renewal-dates-missed/)\ How to build one renewal tracker with owners, notice dates and early alerts, so contracts do not auto-renew or lapse without a decision. - [Customer complaints fall through the cracks: one log that closes the loop](/guides/customer-complaints-fall-through-cracks/)\ Why complaints get lost when they arrive by phone, email and chat, and how one simple log with an owner, severity, due date and follow-up fixes it. - [Requests lost in a shared inbox: add an owner and a status](/guides/requests-lost-in-shared-inbox/)\ Why requests in a shared inbox get lost, and how to give each one an owner, a status and a due date using a simple tracker. - [New hire onboarding checklist scattered? Build one trackable list](/guides/new-hire-onboarding-checklist-scattered/)\ Onboarding tasks spread over email, chat and documents? Build one checklist with owners and due dates so no step is missed for a new hire. - [SOP version not current: how to find and keep the right one](/guides/sop-version-not-current/)\ Why nobody knows which version of a standard operating procedure is current, and a simple way to keep one approved copy, an owner and a review date. - [Meeting action items forgotten: how to make them stick](/guides/meeting-action-items-forgotten/)\ Why action items from meetings disappear, and a simple way to capture, assign and follow them so each one gets done or dropped on purpose. - [QR code asset tags that open the SharePoint list row](/guides/qr-code-asset-tags-sharepoint-list/)\ Put one QR label on each asset so a phone camera opens that asset's own SharePoint list row. How to make the links, print labels and what it cannot do. - [RAID log in a SharePoint list: risks, actions, issues, decisions](/guides/raid-log-sharepoint-list/)\ Build a RAID log in one SharePoint list: a Type column, owner, priority, status and due date, plus four saved views and an Open high view. Plain steps. - [Change request log in a SharePoint list](/guides/change-request-log-sharepoint/)\ Build a change request log in one SharePoint list: requester, impact, status, approver, decision date, planned date, and views for pending, approved and late. - [RACI chart in Microsoft 365: a simple list version](/guides/raci-chart-microsoft-365/)\ Build a RACI chart as a SharePoint list: one row per task, Person columns for Responsible, Accountable, Consulted and Informed, plus a view for your own tasks. - [How to back up a SharePoint list before someone wrecks it](/guides/back-up-sharepoint-list/)\ Bulk edits and deletes can hit a small team with no safety net. Five ways to protect a SharePoint list, what each one covers, and what none of them do. - [Move closed items to an archive list so the main list stays fast](/guides/archive-closed-items-to-another-list/)\ Old rows slow views and clutter the list. Use a scheduled flow to copy closed items to an archive list, delete them from the live list, and test it first. - [Add Excel rows to a SharePoint list you already have](/guides/import-excel-into-existing-sharepoint-list/)\ Add Excel rows to an existing SharePoint list: grid paste, or a flow that reads an Excel table, plus a checklist for dates, people and the Title column. - [How to show a progress bar in a SharePoint list column](/guides/sharepoint-list-progress-bar-column/)\ Turn a number column into a progress bar with column formatting. Steps, the JSON to paste, and what to check if the bar does not show. - [Turn overdue rows red in a SharePoint list](/guides/highlight-overdue-rows-sharepoint-list/)\ Late items blend in with the rest of a SharePoint list. Use view formatting so any row past its due date turns red on its own, with no flow and no manual step. - [Make the new-item form shorter: sections and show-if rules](/guides/customize-sharepoint-list-form-sections/)\ Make the new-item form shorter: put columns in sections, hide what is not needed and show a field only when a value is picked. No Power Apps needed. ## Reminders, alerts and updates Make late work and status changes visible without chasing people. - [Convert Word to PDF with Power Automate](/guides/power-automate-convert-word-to-pdf/)\ Convert Word to PDF with Power Automate using the OneDrive for Business Convert file action, plus what to check when it says the file cannot be found. - [Stop a flow early with Terminate in Power Automate](/guides/power-automate-terminate-action/)\ Use the Power Automate Terminate action to stop a flow early and set Succeeded, Failed or Cancelled, so run history shows what really happened. - [Run a scheduled flow on weekdays only](/guides/power-automate-recurrence-weekdays-only/)\ Set a Power Automate Recurrence trigger to Week, pick Monday to Friday, add hours, minutes and a time zone, and test it. Plain steps and what to avoid. - [Create a SharePoint list item from an email](/guides/power-automate-create-list-item-from-email/)\ Build a Power Automate flow that turns each email to a shared inbox into a SharePoint list item with sender, subject and attachments. - [Replace the deprecated "When a file is created in a folder" trigger](/guides/power-automate-when-a-file-is-created-in-a-folder-deprecated/)\ Your Power Automate flow uses a trigger marked deprecated. Here is the replacement, which settings carry over, and how to swap it without breaking the flow. - [Get a person's manager in Power Automate](/guides/power-automate-get-manager/)\ Use the Get manager (V2) action to send approvals to a requester's manager, and set a fallback for people who have no manager listed. - [Assign a Planner task to more than one person](/guides/planner-assign-task-to-multiple-people/)\ Planner lets you put several people on one task, but one person finishing it finishes it for all. Here is how to share work and still track each person. - [Move a Planner task to another plan](/guides/planner-move-task-to-another-plan/)\ Use Move task to send a Planner task to another plan, and see what Microsoft says is removed on the way: labels, goals, custom column values and more. - [Add custom fields in Planner](/guides/planner-custom-fields/)\ Planner custom fields need a premium plan. See what Microsoft says, then use labels, task names or a SharePoint list as a stand-in on a basic plan. - [Make a pre-filled Microsoft Forms link](/guides/microsoft-forms-prefilled-link/)\ How to make a Microsoft Forms link with some answers already filled in, such as a site name, so people finish the form faster. Steps, limits and tips. - [Set a closing date on Microsoft Forms](/guides/microsoft-forms-set-end-date/)\ Set a Start date and End date in Microsoft Forms so the form closes on time. Includes the closed message, a time zone check and a test checklist. - [Teams channel files missing: how to get them back](/guides/teams-channel-files-missing/)\ Teams channel files missing? Check the Shared tab, a renamed SharePoint folder, a private channel site and a deleted channel, then fix each one. - [Save email attachments to SharePoint automatically](/guides/power-automate-save-email-attachments-to-sharepoint/)\ Build a Power Automate flow that saves each email attachment to a SharePoint library, skips signature images and gives duplicate file names a new name. - [Make a readable HTML table in a flow email](/guides/power-automate-create-html-table-formatting/)\ Turn SharePoint list rows into a clean table in a Power Automate email: pick the columns, rename the headers, add borders, and fix raw tags. - [Add days or business days to a date in Power Automate](/guides/power-automate-add-business-days-to-date/)\ Add calendar days with addDays in Power Automate, then skip weekends and holidays with a small loop to get a due date in business days. - [Split text into parts in Power Automate](/guides/power-automate-split-string/)\ Use split() in Power Automate to cut text at a comma, dash or new line, then take the first or last part with first() and last(). Plain steps. - [When to use Send an HTTP request to SharePoint](/guides/power-automate-send-http-request-to-sharepoint/)\ When the standard SharePoint actions fall short, Send an HTTP request to SharePoint can fill the gap. Learn what it is, safe examples, and what to avoid. - [Fix "Column does not exist" in Power Automate Get items](/guides/power-automate-column-does-not-exist/)\ Power Automate says a SharePoint column does not exist. Why the filter fails and how to find the internal column name to use in the Filter Query box. - [Fix 401 Unauthorized in Power Automate](/guides/power-automate-401-unauthorized/)\ Power Automate flow failed with 401 Unauthorized? Read the error code, fix the connection, check site access, and add a failure alert. Steps for SharePoint. - [Speed up Apply to each with concurrency control](/guides/power-automate-apply-to-each-concurrency/)\ Turn on concurrency in Power Automate Apply to each to run loop items in parallel. See the 1 to 50 setting, when it helps, and when variables or order break. - [Run a flow only when one column changes](/guides/power-automate-trigger-when-specific-column-changes/)\ Make a SharePoint flow react only when one column changes. Use Get changes for an item, a Condition card, and a trigger condition. Steps and pitfalls. - [Copy a SharePoint file to another site with Power Automate](/guides/power-automate-copy-file-to-another-sharepoint-site/)\ Copy a file from one SharePoint site to another with Power Automate. Set the Copy file action, choose what happens if the name exists, and test it safely. - [Fix the InvalidTemplate error in Power Automate](/guides/power-automate-invalidtemplate-unable-to-process-template-language-expressions/)\ Power Automate says InvalidTemplate or "unable to process template language expressions"? Find the action, read the expression, guard empty values. - [My Power Automate flow run timed out: what it means and how to fix it](/guides/power-automate-flow-run-timed-out/)\ A Power Automate run ends at 30 days, and one action can time out sooner. Find which error you have, then shorten waits, split loops and set a timeout. - [Fix 429 Too Many Requests in Power Automate](/guides/power-automate-429-too-many-requests/)\ Power Automate shows 429 Too Many Requests when a connector hits its request limit. Slow the loop, lower concurrency and set a retry policy. - [Fix the BadGateway error in Power Automate](/guides/power-automate-badgateway-error/)\ Power Automate shows 502 BadGateway? Microsoft calls it a temporary failure. Turn on retry, check Excel read-only mode, slow the calls and add an alert. - [My trigger condition does not work](/guides/power-automate-trigger-condition-not-working/)\ Power Automate trigger condition not working? How to read skipped runs, check the expression, test it in a Compose step, and fix typing slips. - [Fix "Invalid type. Expected String but got Null" in Power Automate](/guides/power-automate-invalid-type-expected-string-but-got-null/)\ Parse JSON fails when an empty field arrives as null but the schema says string. Allow null in the schema, or change the value before the step runs. - [My flow email goes out without the attachment](/guides/power-automate-send-email-with-attachment-not-working/)\ Power Automate email arrives with no attachment or a broken file? Give the email a file name with its extension and the file content, not a link. - [Fix "file is locked for shared use" in Power Automate](/guides/power-automate-file-is-locked-for-shared-use/)\ Power Automate says a file is locked for shared use. See who holds the lock, then retry in a loop, check the check-out status, or run the flow later. - [Fix "The response is not in a JSON format" in Power Automate](/guides/power-automate-response-is-not-in-json-format/)\ A SharePoint step in your flow got a web page or an error back instead of data. How to check the site address, list name, headers and access, step by step. - [How to run a Power Automate flow on one selected SharePoint item](/guides/power-automate-run-flow-on-selected-sharepoint-item/)\ Add a button to a SharePoint list that runs a flow on one selected item. Steps, the one-item limit, and what to check when the flow does not appear. - [Power Automate run-only users missing: where it is and what to check](/guides/power-automate-run-only-users-missing/)\ Run only users missing in Power Automate? It applies to instant flows with a manual trigger, set by an owner. Check the flow type, your role and the page. - [Error: "An action failed. No dependent actions succeeded."](/guides/power-automate-action-failed-no-dependent-actions-succeeded/)\ Power Automate says an action failed and no dependent actions succeeded. Find the first failed step in the run, read its error and fix that step. - [Close a Microsoft Form after a set number of responses](/guides/microsoft-forms-stop-accepting-after-number-of-responses/)\ Microsoft Forms has no response cap. Count responses with Power Automate, get an alert at your number, then turn off Accept responses or set an end date. - [Flow fails because the connection expired: how to fix it](/guides/power-automate-connection-expired-flow-failing/)\ A Power Automate flow stopped with a 401 error? The connection expired. Use Fix connection, resubmit the run, and set up alerts so you hear about it first. - [Scheduled flow did not run at the set time](/guides/power-automate-scheduled-flow-not-running/)\ Power Automate scheduled flow did not run? Check the flow status, start time, time zone and run history, fix the cause, then test the schedule again. - [How to lock a SharePoint list item after approval](/guides/lock-sharepoint-list-item-after-approval/)\ Make a SharePoint list item read-only once it is approved. Use Power Automate to remove edit rights on the item, and how to undo it. - [Power Automate flow keeps running itself over and over](/guides/power-automate-flow-triggers-itself-infinite-loop/)\ Why a Power Automate flow on "When an item is created or modified" starts itself again, and how to stop the loop with a trigger condition and a status column. - [Power Automate Get items filter query returns nothing: how to fix it](/guides/power-automate-get-items-filter-query-not-working/)\ Why a SharePoint Get items filter query returns no rows or an error: wrong column name, choice text, quotes, not equal, lookup, person and date columns. - [Power Automate condition to check if a field is empty](/guides/power-automate-condition-field-empty/)\ How to test for an empty SharePoint field in a Power Automate condition. Text, person and choice columns each need a slightly different check. - [Email the files attached to a SharePoint list item](/guides/power-automate-email-list-item-attachments/)\ How to send the files attached to a SharePoint list item in one email with Power Automate: get the attachments, build one array, send once. With limits. - [Remind an approver who has not answered after two days](/guides/power-automate-approval-reminder-after-2-days/)\ Send a reminder if a Power Automate approval is still open after two days, and stop it the moment the approver answers. Parallel branch, delay and loop. - [Comments on a list item: who gets told](/guides/sharepoint-list-comments-notify-people/)\ Item comments in a SharePoint list do not alert the owner on their own. Learn what a mention does, what it needs, and three ways to make sure someone is told. - [Power Automate cannot add a row to my Excel table: causes and fixes](/guides/power-automate-add-row-to-excel-table-fails/)\ Power Automate "Add a row into a table" fails or adds nothing? Check the file, table, headers, write access, the lock and the 30 second delay. - [Create a document folder automatically for each new list item](/guides/power-automate-create-folder-for-each-list-item/)\ Make Power Automate create a folder named from the item ID for every new SharePoint list item, then write the folder link back to the item. Steps and pitfalls. - [Power Automate sends the same email two or three times](/guides/power-automate-email-sent-multiple-times/)\ Why a Power Automate flow sends duplicate emails from a SharePoint list, and how to stop it with a Yes/No sent flag and a trigger condition. - [Power Automate Get items stops at 100 rows: how to get them all](/guides/power-automate-get-items-only-returns-100/)\ Why the SharePoint Get items action returns only 100 rows by default, and how to fix it with Top Count, Pagination and a filter query, with limits to know. - [Get a Microsoft Forms alert sent to more than one person](/guides/microsoft-forms-notify-several-people/)\ In one Microsoft Q&A thread, the Forms alert reached only the form owner. Build a small Power Automate flow that emails your whole team or posts to Teams. - [Planner does not email me when a task is assigned](/guides/planner-notifications-not-working/)\ Planner sends no email for an assigned task? Check your own setting, the plan owner setting and the Teams app, then add a simple Power Automate backup. - [Create a Planner task automatically from a Forms response](/guides/power-automate-create-planner-task-from-form/)\ Turn each Microsoft Forms response into a Planner task in the right bucket with Power Automate: field mapping, a one-response test, limits and what to avoid. - [Planner tasks not syncing or disappearing in Teams](/guides/teams-planner-tasks-not-syncing/)\ Tasks look different in Teams, the Planner web app and To Do. Why that happens, a checklist to find the cause, and what to try in order. - [Why Power Automate turned your flow off, and how to turn it back on](/guides/power-automate-flow-turned-off-automatically/)\ Power Automate turns flows off after repeated failures, long idle time or a license problem. Find the cause, fix it, turn the flow on, and prevent a repeat. - [Send Power Automate emails from a shared mailbox](/guides/power-automate-send-email-from-shared-mailbox/)\ Send Power Automate emails from a shared mailbox so replies go to the team address. The permission it needs, a test, and what to avoid. - [Late tasks nobody notices: setting up late alerts](/guides/late-tasks-nobody-notices/)\ Tasks slip past due and nobody hears until a customer asks. Build an overdue view and one daily late summary per owner in SharePoint and Power Automate. - [Send a reminder before a due date in a SharePoint list](/guides/send-reminder-before-due-date/)\ Build a Power Automate flow that runs every day, finds SharePoint list items due soon, and emails the owner. Plain steps, with the limits to know. - [Your weekly status report takes hours to build](/guides/weekly-status-report-takes-hours/)\ Hours each week copying numbers into a status report means the data is in the wrong place. A SharePoint list and Power Automate can build it for you. - [Who owns this shipment? Fixing unclear ownership in ops](/guides/who-owns-this-shipment/)\ When nobody knows who owns a shipment, order or task, things stall. How an owner column, views and alerts in a SharePoint list make ownership clear. - [One place for team updates instead of chat, email and spreadsheets](/guides/one-place-for-team-updates/)\ Updates spread across chat, email and spreadsheets leave nobody with the full picture. Give an ops team one SharePoint list, shown in Teams, for status. - [Post to Teams when a SharePoint list item changes](/guides/teams-message-from-sharepoint-list/)\ Build a Power Automate flow that posts a Teams message when a SharePoint list item is added or changed, with a field condition and ways to avoid message floods. - [Save Microsoft Forms answers to a SharePoint list](/guides/microsoft-forms-to-sharepoint-list/)\ How to send every Microsoft Forms response into a SharePoint list with Power Automate: build the form, add columns, build a flow, map fields and test it. - [Recurring task reminders for a team](/guides/recurring-task-reminders/)\ Set up weekly and monthly reminders for jobs that repeat. A SharePoint list holds the tasks, and a scheduled Power Automate flow posts one message to Teams. - [The person who built your flows left: what happens and what to do](/guides/power-automate-flow-owner-left-company/)\ When the person who built your flows leaves, they can fail. Add co-owners, move flows into a solution, fix connections before they go, and keep a flow list. ## Compare tools Plain side by side comparisons for small teams. - [Microsoft Lists vs Notion for a small team](/guides/microsoft-lists-vs-notion/)\ Microsoft Lists vs Notion for a small team: permissions, automation, limits, cost and which one fits. I build on Microsoft 365. - [Microsoft Forms vs Google Forms for a small business](/guides/microsoft-forms-vs-google-forms/)\ Microsoft Forms vs Google Forms: who can respond, sign-in, branching, file upload and where answers go. A plain comparison, with who should pick each. - [Planner: set task dependencies without Premium](/guides/planner-task-dependencies-basic-plan/)\ Planner task dependencies and the basic plan: what Microsoft's feature table says, and three simple ways to show "this waits for that" without Premium. - [Planner Premium or basic Planner for a 10 person team](/guides/planner-premium-vs-basic-small-team/)\ Basic Planner or Planner premium for a 10 person team? What each gives you, what Microsoft says about licenses, and when a SharePoint list fits better. - [Teams vs SharePoint: where should our files and lists live?](/guides/teams-vs-sharepoint/)\ Where do files and lists really live when you use Teams? A plain guide to the Files tab, channel folders, private channels, lists and who can see what. - [SharePoint Lists vs Smartsheet for team tracking](/compare/sharepoint-lists-vs-smartsheet/)\ SharePoint Lists (Microsoft Lists) and Smartsheet side by side for tracking team work: price per user, views, Gantt, forms and automation. - [SharePoint list vs Excel for team tracking: which one fits?](/guides/sharepoint-list-vs-excel/)\ Compare a SharePoint list and an Excel file for team tracking. See limits, strengths, a plain table and who should pick each one. - [Microsoft Planner vs SharePoint list for tracking team work](/guides/planner-vs-sharepoint-list/)\ Planner or a SharePoint list? Plain-words comparison of limits, cost, views and automation, with where each wins. - [Power Automate vs Zapier for Microsoft 365 teams](/guides/power-automate-vs-zapier/)\ Power Automate or Zapier? Costs, limits and who each fits for teams on Microsoft 365. - [Power Automate vs Make for Microsoft 365 teams](/guides/power-automate-vs-make/)\ Power Automate or Make? How each handles errors, run history, pricing units and Microsoft 365 apps. - [Monday.com vs SharePoint for a 50-person team](/guides/monday-vs-sharepoint-50-person-team/)\ Monday.com or SharePoint for 50 people? A plain comparison with a yearly cost example, where each one wins and who should pick which. - [Microsoft Lists vs Airtable for a small team](/guides/microsoft-lists-vs-airtable/)\ Microsoft Lists vs Airtable for a small team: limits, cost model, a plain table and who should pick each. I build on Microsoft 365, so I say so. - [Microsoft Lists vs Trello for a small team](/guides/microsoft-lists-vs-trello/)\ Microsoft Lists vs Trello for a small team: board caps, file sizes, per-seat cost and who should pick each. I build on Microsoft 365, so I say so. - [Power Apps or a SharePoint list form: which one do you need?](/guides/power-apps-vs-lists-forms/)\ Power Apps vs SharePoint list form: what the built-in form and its formatting can do, what a Power Apps custom form adds, and a simple way to choose. - [Microsoft Planner vs Trello for a small team](/guides/planner-vs-trello/)\ Microsoft Planner vs Trello for a small team: limits, cost model, a plain table and who should pick each. We build on Microsoft 365, so we say so. - [Microsoft Lists vs Asana for a small team](/guides/microsoft-lists-vs-asana/)\ Asana is free for 2 users and priced per seat after that. How it compares with Microsoft Lists, in a plain table. I build on Microsoft 365, so I say so. - [SharePoint vs Google Drive for a small team](/guides/sharepoint-vs-google-drive/)\ SharePoint or Google Drive for a small team? A plain comparison of sharing, editing together, search, permissions, tracking and limits, and where Drive wins. ## SharePoint basics Costs, limits and moving off spreadsheets. - [Show totals at the bottom of a SharePoint list](/guides/sharepoint-list-totals/)\ Add a count, sum or average to the bottom of a SharePoint list view, and see why a total may be missing for Choice and calculated columns. - [SharePoint Sync button missing: how to find the cause](/guides/sharepoint-sync-button-missing/)\ The Sync button can vanish from a SharePoint document library. Check offline availability, the view style, your sign-in and the admin setting, in order. - [Change who gets SharePoint access request emails](/guides/sharepoint-access-request-email-settings/)\ Access requests going to the wrong person? See who gets them by default, how to point them at the right owner, and how to approve them. Plain steps. - [Add a SharePoint list as a Teams tab](/guides/add-sharepoint-list-to-teams-tab/)\ Pin a SharePoint list in a Teams channel as a tab. Two ways to add it, who can do it, and what to check so your team can open it and see the right data. - [Rename or hide the Title column in a SharePoint list](/guides/sharepoint-list-rename-title-column/)\ Rename the Title column, make it optional, or hide it from a view in a SharePoint list. Learn what changes and what stays the same under the name Title. - [Keep a running comment log with "Append changes to existing text"](/guides/sharepoint-list-append-changes-to-existing-text/)\ What the Append changes to existing text setting does in a SharePoint list, why versioning must be on, and how to see the full history of notes. - [Print one SharePoint list item: browser print or a PDF](/guides/sharepoint-list-print-item/)\ How to print a single SharePoint list item: use the browser print option, or build a Power Automate flow that fills a Word template and makes a PDF. - [Use and format the gallery view in a SharePoint list](/guides/sharepoint-list-gallery-view/)\ Turn a SharePoint list into cards with the gallery view, then add color to the cards with simple view formatting. Steps, a sample, and what to avoid. - [Set column width in a SharePoint list for everyone](/guides/sharepoint-list-column-width/)\ You dragged a column wider and nobody else sees it. Here is what Microsoft says about saving widths in a view, JSON formatting, and the limits. - [Fix the SharePoint lookup column threshold](/guides/sharepoint-lookup-column-threshold/)\ A SharePoint view that errors on lookup columns hit a limit of 12. See which columns count, how to find them, and how to trim a view to get under it. - [Use today's date in a SharePoint calculated column](/guides/sharepoint-calculated-column-today/)\ A SharePoint calculated column cannot use TODAY. Use a default value, a \[Today\] view filter, or a Yes/No flag column to show late items instead. - [Fix "Access denied" on a SharePoint list](/guides/sharepoint-list-access-denied/)\ Getting "Access denied" on a SharePoint list? Check the site, the list and then the item, in that order. Plain steps and what to ask your admin. - [My SharePoint list view does not show all items](/guides/sharepoint-list-view-not-showing-all-items/)\ Items missing from a SharePoint list view? Check the view filter, the item limit, folders, the 5,000 threshold and which view is open, one at a time. - [New column not showing in the SharePoint list form](/guides/sharepoint-list-new-column-not-showing-in-form/)\ Added a column to a SharePoint list but it is missing from the new-item form? Check the Edit columns pane, form sections, Power Apps forms and content types. - [SharePoint list attachments not showing](/guides/sharepoint-list-attachments-not-showing/)\ Add attachments is missing or the Attachments field is gone from a SharePoint list form? Find which of five causes fits your list and what to try. - [Microsoft Forms not saving responses: what to check](/guides/microsoft-forms-not-saving-responses/)\ Microsoft Forms responses not showing up? Check the account, the form, the response settings and the Excel link in this order, then store answers safely. - [Sort a SharePoint list by more than one column](/guides/sharepoint-list-sort-by-multiple-columns/)\ A SharePoint view sorts on one or two columns. Here is how to set both, and how to get a three-column sort with a calculated sort key column. - [SharePoint list filter not showing all values: what to check](/guides/sharepoint-list-filter-not-showing-all-values/)\ Your SharePoint list column filter shows only some values? Check See all, the 5,000 item threshold, indexes and a saved view. Plain steps, no code. - [Cannot change column type: it is currently being indexed](/guides/sharepoint-column-type-cannot-be-changed-being-indexed/)\ SharePoint says a column type cannot be changed because it is being indexed. Remove the index, turn off unique values, change the type, then add it back. - [Link will not save: hyperlink column limited to 255 characters](/guides/sharepoint-list-hyperlink-255-character-limit/)\ A long web address will not save in a SharePoint list Hyperlink column. Why it happens, and how to store long links in a rich text column instead. - [List form says Something went wrong when I save](/guides/sharepoint-list-form-something-went-wrong/)\ A Microsoft Lists form says Something went wrong on submit. Check the link, the person's access, the list's item settings, and validation rules, in order. - [Edit in grid view is missing or greyed out in a SharePoint list](/guides/sharepoint-list-edit-in-grid-view-missing/)\ Edit in grid view missing or greyed out in SharePoint? Check permission, the Quick Edit setting, view style and column type, with fixes step by step. - [Flow cannot set a Person column: user could not be found](/guides/power-automate-update-person-column-user-not-found/)\ A flow that fills a SharePoint Person column fails with "user could not be found". Build the claim from the email, or use Resolve person, then test it. - [My condition on a choice column always goes to No](/guides/power-automate-choice-column-condition-not-matching/)\ Why a Power Automate condition on a SharePoint Choice column always goes to No, and how to check the real value, the exact text and the internal name. - [Restore a deleted SharePoint list item or list](/guides/restore-deleted-sharepoint-list-item/)\ Deleted a SharePoint list item or a whole list by mistake? Find it in the recycle bin, restore it, and know what to do when it is not there. - [Share a SharePoint list with a client outside your company](/guides/share-sharepoint-list-with-external-users/)\ How to share a SharePoint list with a client outside your company: what must be allowed first, how guests sign in, and what they can see once inside. - [SharePoint list form branching option missing or not working](/guides/sharepoint-list-form-conditional-branching-not-working/)\ Show-if option missing or does nothing in a SharePoint list form? Check the column type, the internal name, the formula quotes and which form you test. - [Microsoft Forms: why "Anyone can respond" is greyed out](/guides/microsoft-forms-anyone-can-respond-greyed-out/)\ "Anyone can respond" is greyed out in Microsoft Forms for two reasons: a file upload question is in the form, or your admin blocked outside sharing. Fix both. - [Microsoft Forms branching sends people to the wrong question](/guides/microsoft-forms-branching-not-working/)\ Microsoft Forms branching skipping questions or jumping to the end? See the usual causes, how to fix the order, and how to test every answer before you share. - [Planner: copy plan option is missing](/guides/planner-copy-plan-missing/)\ Can't find Copy plan or Duplicate plan in Planner? Check the plan's group, the menu next to the plan name, and the plan type. Steps and a fallback. - [Planner: Delete this plan is greyed out](/guides/planner-delete-plan-greyed-out/)\ Delete this plan greyed out or missing in Planner? Only a plan owner can delete it. How to check, what to do if you are not the owner, and how to leave. - [SharePoint list version history is blank or missing](/guides/sharepoint-list-version-history-not-showing/)\ Version history missing or blank in a SharePoint list? Learn the common causes, how to check versioning settings, what can be restored and what to avoid. - [Copy a SharePoint list to another site with its data](/guides/copy-sharepoint-list-to-another-site-with-data/)\ "From existing list" copies columns and views, not rows. Here are three ways to move the data too: template with content, Excel, or a Power Automate flow. - [Filter a view on a lookup column that allows several values](/guides/sharepoint-lookup-allow-multiple-values-filter/)\ Filtering a SharePoint view on a lookup column with several values: what Microsoft covers, helper-column workarounds, and a backup warning first. - [Show or copy the email from a SharePoint Person column](/guides/sharepoint-person-column-get-email-address/)\ A Person column shows a name, not an email. Show the email in the list with column formatting, or copy it into a text column with Power Automate. - [Microsoft Lists phone app is gone: what to use now](/guides/microsoft-lists-mobile-app-retired/)\ The Microsoft Lists app for iPhone and Android was retired in November 2025. Your lists are safe. Here is how to reach them from a phone browser or Teams. - [Delete all items in a SharePoint list without clicking one by one](/guides/sharepoint-list-delete-all-items/)\ Delete-all can fail on a big SharePoint list. Back up first, stop what adds the rows, delete in small batches, or use a short Power Automate flow. - [Update one column for many SharePoint list rows at once](/guides/sharepoint-list-bulk-update-column-from-excel/)\ Change one column across many SharePoint list rows without touching the other columns. Use grid view paste with matched order, or a flow that matches by name. - [SharePoint people picker cannot find a user or guest](/guides/sharepoint-people-picker-user-not-found/)\ A Person column that cannot find a guest, or says a user no longer exists. Find which of four causes applies and fix it, or know what to ask your admin. - [Stop people filling in a Microsoft Form more than once](/guides/microsoft-forms-one-response-per-person/)\ Microsoft Forms can limit one response per person, but only for signed-in people in your organization. For outside people, flag repeats in a SharePoint list. - [Microsoft Forms file upload is greyed out for outside people](/guides/microsoft-forms-file-upload-greyed-out/)\ Why the Upload file option is greyed out when anyone can respond, and two ways to collect files from people outside your company: a file request link or email. - [Planner Export to Excel option is missing: where to find it](/guides/planner-export-to-excel-missing/)\ Can't find Export to Excel in Planner? Open the plan in the Planner web app, not Teams, and look in the plan header menu. Steps and what to try next. - [SharePoint calendar overlay will not show another list](/guides/sharepoint-calendar-overlay-not-showing/)\ Calendar overlay says it cannot find lists with a calendar view? Why it happens, which lists qualify, and a safe order to fix it. No guessing. - [Stop duplicate entries in a SharePoint list](/guides/sharepoint-list-prevent-duplicate-entries/)\ Make a SharePoint list refuse a repeated value with Enforce unique values, how to handle a rule that spans two or more columns, and what to avoid. - [Default a SharePoint column to today or the current user](/guides/sharepoint-list-default-value-current-user/)\ Stop staff from retyping their name and the date in a SharePoint list. Set a default date, use Created and Created By, or fill a Person column for them. - [Cascading dropdown in a SharePoint list form](/guides/sharepoint-list-cascading-dropdown/)\ Make the second choice depend on the first, like Category then Subcategory. What the built-in list form does, what it does not, and the three ways to get close. - [SharePoint calculated column formulas for due dates and status](/guides/sharepoint-calculated-column-formulas/)\ SharePoint calculated column formulas for due dates and status text, plus the limit that trips most teams: a calculated column cannot use today's date. - [SharePoint list validation: end date after start date, and one of two fields](/guides/sharepoint-list-column-validation-formula/)\ Stop bad dates and half-filled rows in a SharePoint list with a validation formula: end after start, one of two fields, plain error messages, and what to avoid. - [Make a SharePoint column required only when another column has a value](/guides/make-sharepoint-column-required-based-on-another/)\ SharePoint has no conditional-required setting. Use a validation formula plus a show-or-hide rule in the form, with a worked example and what to avoid. - [Show each person only their own items in a SharePoint list view](/guides/sharepoint-list-view-filter-current-user/)\ Use the \[Me\] filter to show each person only their own items in a SharePoint list view. The Person column rule, an empty-view fix, and why a view is no lock. - [Replace a spreadsheet tracker with a SharePoint list](/guides/replace-spreadsheet-with-sharepoint-list/)\ When a SharePoint list beats a shared Excel tracker, how to move your data in, what you rebuild by hand, and the limits to know. - [Spreadsheet versions out of sync: why it happens and how to fix it](/guides/spreadsheet-versions-out-of-sync/)\ Why team spreadsheets drift into many versions, and a step-by-step way to get back to one file that everyone updates. - [SharePoint list over 5,000 items: what breaks and the fix](/guides/sharepoint-list-view-threshold/)\ What the SharePoint list view threshold is, what you see past 5,000 items, what it is not, and Microsoft's fixes: indexed columns, filtered views and folders. - [How many items can a SharePoint list hold?](/guides/how-many-items-can-a-sharepoint-list-hold/)\ A SharePoint list holds up to 30 million items. Learn the limits that matter first: the 5,000 view limit, attachments, permissions and versions. - [What a SharePoint tracker costs to build](/guides/what-a-sharepoint-tracker-costs/)\ Fixed prices for a SharePoint and Power Automate tracker, from \$5,000 for one in 2 weeks. What is included, license costs you may already cover, and what to ask any consultant. - [Excel file locked by another user: the fix and the long-term fix](/guides/excel-file-locked-by-another-user/)\ Excel says a file is locked for editing by another user. Here are the steps to get back in, why it happens, and how to stop it for good. - [See who changed a row: SharePoint version history](/guides/who-changed-this-row/)\ How to see who changed an item in a SharePoint list, what changed and when, how to restore an old value, and what the limits are. - [Stop duplicate entries in a shared spreadsheet](/guides/duplicate-entries-shared-spreadsheet/)\ How to stop duplicate rows in a shared Excel file with data validation, highlighting and Remove Duplicates, where each one falls short, and a stronger option. - [Auto-number tickets in a SharePoint list (TKT-0001)](/guides/auto-number-ticket-ids-sharepoint-list/)\ Give every ticket in a SharePoint list a running number like TKT-0001. Show the built-in ID column, build text from it, or write the number back with a flow. - [Let each person see only their own items in a SharePoint list](/guides/people-see-only-their-own-items-sharepoint-list/)\ How to keep requesters from seeing each other's entries in a SharePoint list. A filtered view is not security. Here is what is, and where it stops. - [Keep one column private (like pay or notes) in a shared list](/guides/hide-a-column-from-some-people-sharepoint-list/)\ SharePoint sets permissions down to a single item, not a column, and hiding a column is not security. Keep pay private with a second list. - [Microsoft Lists rule did not send the email: what to check](/guides/microsoft-lists-rules-not-working/)\ A built-in Microsoft Lists rule sent nothing, or only to the wrong person. Use this checklist to find why, and learn when to switch to Power Automate. - [SharePoint lookup column shows blank or too few fields](/guides/sharepoint-lookup-column-not-showing/)\ A SharePoint lookup column that shows blank or one field usually has a type or setup problem. A diagnosis checklist, the fixes, and when Choice is simpler. - [SharePoint list export to Excel fails or misses rows](/guides/sharepoint-list-export-to-excel-not-working/)\ Your weekly report starts with a SharePoint export, and rows are missing or it fails. A diagnosis checklist, the fixes, and the limits Microsoft documents. - [Where SharePoint list attachments are stored, and when to use a library](/guides/where-do-sharepoint-list-attachments-go/)\ Teams attach files to list rows, then cannot find them. What SharePoint documents about list attachments, and when a linked document library fits better. - [Turn a SharePoint list into a simple dashboard](/guides/sharepoint-list-to-power-bi-dashboard/)\ Managers want counts and charts, not a grid. Use a grouped list view first, then connect the list to Power BI when you need more, with a plain decision list. - [Which Power Automate license does a small team need?](/guides/power-automate-license-small-team/)\ What Microsoft 365 already includes for Power Automate, which connectors need a premium license, how to check before you build, and who gets billed. - [Fill a Word template from a SharePoint list](/guides/power-automate-populate-word-template/)\ How to turn a SharePoint list item into a finished Word document with the Populate a Microsoft Word template action, its content controls and its limits. - [Filter Excel Online without changing it for everyone](/guides/excel-online-sheet-view/)\ A Sheet View lets you sort and filter a shared workbook for yourself. Here is how to create one, name it, switch views and exit back to the default view. - [Cannot edit an Excel file in the browser](/guides/excel-online-cannot-edit/)\ Excel in the browser opens a file read-only for a few reasons: view mode, a Can view link, Protected View or a full OneDrive. Check each one in this order. - [Add a dropdown list in Excel Online](/guides/excel-online-data-validation-dropdown/)\ Add a dropdown list to cells with Data Validation. Steps for a typed list or a range, how to block other entries, and what to check when the arrow is missing. - [Restore an older version of an Excel file online](/guides/excel-online-version-history/)\ Open version history in the browser, pick an older version and restore it. Plus what is kept: 25 versions on a personal account, set by the library at work. - [SharePoint alerts are retired: what to use instead](/guides/sharepoint-alerts-retirement-replacement/)\ Microsoft retired SharePoint Alerts in July 2026. Build a list rule to replace each alert, and use a Power Automate flow when a rule cannot do it. - [Add an image to a Microsoft Forms question](/guides/microsoft-forms-add-image-to-question/)\ Select the question, use Insert media, pick Image, and add a picture from search, OneDrive or your computer. Then set Small or Large and alt text. - [Let coworkers edit your Microsoft Form](/guides/microsoft-forms-share-to-collaborate/)\ Use Collaborate or Duplicate to copy a link that lets coworkers view and edit your form and results. Who it works for, the 100 limit, and how to stop. - [Change the default view of a SharePoint list](/guides/sharepoint-list-change-default-view/)\ Make any public view the one people see first: open View options, Edit current view, and tick Make this the default view. Missing option explained. - [Use the image column in a SharePoint list](/guides/sharepoint-list-image-column/)\ The Image column holds one picture per item. Here is what Microsoft says about adding, replacing and deleting it, and the Picture format for links. - [Save a SharePoint list as a template](/guides/sharepoint-list-save-as-template/)\ Where "Save list as template" lives in List Settings, why it can be missing on your site, and what a saved template keeps and leaves out. - [InfoPath support ended: replace your forms with a SharePoint list form](/guides/infopath-forms-retired-replace-with-sharepoint-list-form/)\ InfoPath is past its Microsoft support date. Replace each InfoPath form with a SharePoint list form, customized in Power Apps if it needs rules. - [SharePoint 2013 workflow stopped working: what to rebuild in Power Automate](/guides/sharepoint-2013-workflows-stopped-working-replace/)\ SharePoint 2013 workflows were retired in Microsoft 365. Here is how to list what each one did and rebuild it as a Power Automate flow. - [SharePoint Designer 2013 support ended: what to use for workflows and forms now](/guides/sharepoint-designer-2013-end-of-support-alternative/)\ SharePoint Designer 2013 is past its Microsoft support date. See which modern tool replaces each old Designer job: workflows, list forms and email alerts. - [Teams webhook stopped working? Replace it with a Workflows webhook](/guides/teams-webhook-stopped-working-use-workflows/)\ Alerts to a Teams channel went quiet? Old Office 365 connector webhooks were retired. Build a Workflows webhook, copy the new URL, and swap it in. - [Teams webhook workflow will not post to a private channel: switch Post As to User](/guides/teams-workflow-webhook-post-to-private-channel/)\ A Workflows webhook runs but nothing shows in a private channel? Microsoft lists flow bot posting in private channels as not ready. Post as a user instead. - [Client onboarding checklist for an accounting firm](/guides/client-onboarding-checklist-accounting-firm/)\ Build a client onboarding checklist for an accounting firm in a SharePoint list: one row per client, step columns, and a flow that nudges the owner. - [Copilot Studio agent will not answer from a SharePoint list: checks and a flow workaround](/guides/copilot-studio-sharepoint-list-knowledge-workaround/)\ Microsoft documents SharePoint lists as agent knowledge, with limits. Here are the checks, and a flow that returns list rows when knowledge falls short. - [Court date tracker for a small law firm](/guides/court-date-tracker-sharepoint/)\ A SharePoint list for hearings by case, judge and date, with a view for the next 30 days and a reminder email. A reminder list, not a deadline calculator. - [Refresh Excel Online data connections on a schedule: what works and what does not](/guides/excel-online-refresh-data-connections-schedule/)\ Microsoft says a script run from Power Automate does not refresh data connections except Power BI sources. Here is what is documented and what to do instead. - [In-kind donation tracker for nonprofits](/guides/in-kind-donation-tracker/)\ Track donated goods in one SharePoint list: donor, item, estimated value, date received, and whether a receipt went out. Columns and a flow described. - [Job costing tracker in SharePoint](/guides/job-costing-tracker-sharepoint/)\ Track budget, labor and materials per job in two SharePoint lists, with a calculated over-budget flag and a saved view of jobs going over. Columns in text. - [Microsoft Forms Copilot: where it appears and can you turn it off](/guides/microsoft-forms-copilot-turn-off/)\ Where Copilot shows up in Microsoft Forms, the license it needs, and what Microsoft says about turning it off. Plus what your admin can change. - [Transfer a Microsoft Form to another owner](/guides/microsoft-forms-transfer-ownership/)\ Move a Microsoft Form when its owner leaves. Who can do it, the admin link, the 30 day limit, and what the three error messages mean. - [Loop workspace or component not showing in Teams: what to check](/guides/microsoft-loop-workspace-not-showing-in-teams/)\ Microsoft's pages name the admin switches, the network rule and the file moves that stop Loop from showing in Teams. Here is the check list, in order. - [Planner agent in Copilot: create a plan from a prompt](/guides/planner-agent-copilot-create-plan-from-prompt/)\ Ask the Planner agent in Copilot to draft a plan, review its task cards, and generate tasks from a goal. Who can use it and what it can edit. - [Planner checklist limit and workarounds](/guides/planner-checklist-limit/)\ A Planner task holds 20 checklist items. What else has limits, which plans the page covers, and ways to handle a longer list. - [Power Automate 403 Forbidden on a SharePoint action: what to check](/guides/power-automate-403-forbidden-sharepoint-connection/)\ A 403 means no permission on the resource, or a DLP block. Microsoft's checks: site permissions, admin consent, shared connection owner, DLP. - [Power Automate Delay until stops after 30 days: how to wait longer](/guides/power-automate-delay-until-more-than-30-days/)\ A Power Automate run lasts 30 days at most. To wait 60 days or 6 months, store the date in a SharePoint column and let a daily flow check it. - [Power Automate flow suspended by a DLP policy: what it means and what to tell your admin](/guides/power-automate-flow-suspended-dlp-policy-violation/)\ A DLP policy can suspend a Power Automate flow. Here is how to confirm it, what the status means, and a note to send your admin. - [Power Automate date shows wrong day or time: formatDateTime with time zone](/guides/power-automate-formatdatetime-mm-dd-yyyy-time-zone/)\ Format a Power Automate date as MM/dd/yyyy with formatDateTime, and fix the wrong day or hour by converting from UTC first. Copy-ready expressions. - [Power Automate HTTP action says premium: do you need to pay?](/guides/power-automate-http-premium-connector-license/)\ The Power Automate HTTP action is treated as premium; Microsoft 365 licenses cover standard connectors. Who needs a license, plus standard SharePoint swaps. - [Power Automate new designer: switch back to classic and copy actions](/guides/power-automate-new-designer-switch-to-classic/)\ How to turn the new designer off, what the new designer cannot do yet, and how to copy and paste actions inside a flow. Per Microsoft Learn. - [Power Automate run history only shows 28 days: how to keep a longer record](/guides/power-automate-run-history-28-days/)\ Power Automate keeps flow run data for 28 days. Here is what disappears after that and how to keep your own record in a SharePoint list. - [Project Online is retired: what a small team can use instead](/guides/project-online-retired-what-small-teams-use-instead/)\ Microsoft's pages say Project Online retired on September 30, 2026. A small team can use Planner premium plans or a SharePoint list tracker. Here is the fit. - [Quote tracker in SharePoint](/guides/quote-tracker-sharepoint/)\ Build a quote tracker as a SharePoint list: the columns, three views for open, won and lost quotes, and a flow that avoids duplicate emails. - [Scholarship application tracker](/guides/scholarship-application-tracker/)\ Build a scholarship application tracker in SharePoint: applicants, missing documents, reviewer scores and award status in two lists with saved views. - [Create a SharePoint list with Copilot: what Microsoft documents and what it needs](/guides/sharepoint-list-agent-copilot-create-list/)\ Copilot in SharePoint can create and edit lists with a Microsoft 365 Copilot license. What Microsoft documents, what it omits, and a no-Copilot route. - [SharePoint list view: show only items from the last 7 days](/guides/sharepoint-list-view-filter-today-minus-days/)\ Microsoft says \[Today\] math works on date columns, but you need the classic view editor. Here are the steps and a helper column fallback. - [Teams meeting notes missing](/guides/teams-meeting-notes-missing/)\ Teams meeting notes are Loop files stored in OneDrive or SharePoint. Where each kind is saved, and four reasons they stop loading or appear missing. - [Teams shared channel vs private channel](/guides/teams-shared-vs-private-channel/)\ Who can see each channel type, where files live, who can be added, and which Teams features each one lacks, from Microsoft's own comparison table. - [Can Copilot build a Power Automate flow for you?](/guides/can-copilot-build-power-automate-flows/)\ Copilot can draft a cloud flow from a plain sentence. Microsoft lists limits: a subset of connectors, limited editing, no error fixing. How to use it. - [Power Automate flow or Copilot Studio agent: which one for an operations task](/guides/power-automate-or-copilot-agent-for-operations/)\ A flow runs fixed steps the same way every time. An agent reads a request and picks tools. How to choose for an ops task, and what Microsoft says about cost. - [Power Automate "When an item is deleted" trigger not working](/guides/power-automate-when-an-item-is-deleted-trigger/)\ The SharePoint trigger When an item is deleted works only for site collection admins and returns who deleted it and when, not column values. - [Outlook shared calendar or SharePoint calendar for a team](/guides/outlook-shared-calendar-vs-sharepoint-calendar/)\ Outlook shares busy times and details with people you pick. A SharePoint calendar is a list with columns. How to choose, and how to show both together. - [Best way for a 50 person ops team to track requests in Microsoft 365](/guides/ops-team-request-tracker-50-people-microsoft-365/)\ One SharePoint list, one intake form, a status, an owner, an overdue flow and simple permissions can serve a 50 person ops team. Design and Microsoft limits. - [Department budget requests and approvals in SharePoint for the new fiscal year](/guides/department-budget-request-approval-sharepoint/)\ Build a SharePoint budget request list with a department list, an amount-based approval flow in Power Automate, and a total per department. - [Planner custom views: save filters and grouping for your team](/guides/planner-saved-custom-views/)\ Microsoft's roadmap lists saved custom views for Planner plans. Here is what it says, what Planner filters do today, and when a list fits better. - [Power Automate: write Approved or Rejected back to your SharePoint list](/guides/power-automate-update-sharepoint-status-after-approval/)\ Send a SharePoint item for approval, then write Approved or Rejected back to a Status column with Update item. Includes a stuck Pending fix. - [Company holiday calendar in SharePoint for 2027](/guides/sharepoint-company-holiday-calendar/)\ Build a company holiday list in SharePoint, show it as a calendar view, and keep the dates in one place your flows can read. Steps included. - [SharePoint list board view: which columns work and what to test](/guides/sharepoint-list-board-view/)\ Why your column is missing from Organize board by in a SharePoint list board view, how to test bucket order, and how to check a board that looks wrong. - [SharePoint PTO tracker: request, approve and see who is out](/guides/sharepoint-pto-tracker/)\ Build a PTO tracker in SharePoint: one request list, a team calendar view, a manager approval flow and a balance list for the January 1 carryover. - [SharePoint mobile app: what Microsoft documents and how to open your lists](/guides/sharepoint-mobile-app-open-lists/)\ What Microsoft's pages say the SharePoint mobile app does, what they do not say about a redesign, and how to open a SharePoint list on a phone today. - [Vendor W-9 and 1099 tracker in SharePoint before January](/guides/sharepoint-vendor-w9-1099-tracker/)\ Track which vendors have a W-9 on file and who is near \$2,000 with a SharePoint list, a flag column and a reminder flow. A tracking aid, not tax advice. - [Microsoft Lists vs SharePoint lists: same thing or not](/guides/microsoft-lists-vs-sharepoint-lists/)\ Microsoft Lists vs SharePoint lists: what Microsoft's pages say about where each is made, where it is saved, who can open it, and which to pick for a team. - [Email a SharePoint list as an Excel file every week with Power Automate](/guides/power-automate-export-sharepoint-list-to-excel-weekly/)\ Build a weekly Power Automate flow that copies an Excel template, fills it with SharePoint list rows and emails the .xlsx, with the limits Microsoft lists. - [How to use Filter array in Power Automate](/guides/power-automate-filter-array/)\ Use the Filter array action in Power Automate to keep only the rows you need. Steps, advanced mode expressions, empty checks, and why the output looks empty. - [How to use Parse JSON in Power Automate](/guides/power-automate-parse-json-generate-from-sample/)\ Use the Parse JSON action in Power Automate to turn JSON text into fields you can pick. Steps, Generate from sample, null values, and fixes for schema errors. - [How to use the Switch action in Power Automate](/guides/power-automate-switch-action/)\ Use the Switch action in Power Automate to run one branch per value. Steps, the Default case, equality-only matching, and why a Switch always goes to Default. - [How to use the Do until loop in Power Automate](/guides/power-automate-do-until-loop/)\ Use the Do until loop in Power Automate to repeat actions until a condition is true. Steps, the 60 count limit, the timeout, and how to stop an endless loop. - [How to add a star rating to a SharePoint list](/guides/add-star-rating-column-sharepoint-list/)\ Add a star rating column to a SharePoint or Microsoft Lists list. Steps, how the average works, how to switch to likes, and what to check if it is missing. - [How to handle errors in Power Automate with a Scope try catch](/guides/power-automate-try-catch-scope-error-handling/)\ Build try catch error handling in Power Automate with Scope actions. Steps for Try, Catch and Finally scopes, run after settings, and how to read the error with result(). - [Compose or variable in Power Automate: which should you use?](/guides/power-automate-compose-vs-variable/)\ Compose or variable in Power Automate? Learn what each one does, when a value can change, why Initialize variable must sit at the top, and a simple rule to choose. - [How do you call one Power Automate flow from another?](/guides/power-automate-run-a-child-flow/)\ Learn how to build a Power Automate child flow, call it with Run a Child Flow, return data, fix the embedded connection error and avoid the import trap. - [How to use the Select action in Power Automate](/guides/power-automate-select-action/)\ Use the Select action in Power Automate to rename, add or remove fields in every object of an array. Steps, text mode, and why Select returns the wrong count. - [How to use the Join action in Power Automate](/guides/power-automate-join-action/)\ Use the Join action in Power Automate to turn an array into one text string with a separator. Steps for email lists, the Select plus Join pattern, and fixes. - [How to count items in an array in Power Automate](/guides/power-automate-count-items-in-array-length/)\ Count the items in a Power Automate array with the length() expression. Steps for Get items and Filter array, an empty check, and fixes for wrong counts. - [How to remove duplicates from an array in Power Automate](/guides/power-automate-remove-duplicates-from-array/)\ Remove duplicate values from an array in Power Automate with the union() expression. Steps for text lists, SharePoint columns, and case mismatches. - [How to sort an array in Power Automate](/guides/power-automate-sort-array/)\ Sort an array in Power Automate with the sort() expression. Steps for text, numbers, objects, descending order, and SharePoint items. - [How to combine two arrays in Power Automate](/guides/power-automate-combine-two-arrays-union/)\ Combine two arrays in Power Automate with union(). Learn how it handles duplicates, how to find shared items with intersection(), and how to keep duplicates. - [How to get the first item of an array in Power Automate](/guides/power-automate-get-first-item-from-array-first-function/)\ Get the first or last item of an array in Power Automate with first() and last(). Learn how to use them after Filter array or Get items, and how to handle empty results. - [How to format a number as currency in Power Automate](/guides/power-automate-format-number-as-currency/)\ Format a number as currency or with commas and two decimals in Power Automate. Uses the formatNumber() expression, with locale examples. - [How to check if text or a list contains a value in Power Automate](/guides/power-automate-contains-function-text-array/)\ Use contains() in Power Automate to test if text has a word, a list has an item, or an object has a key. Case rules, examples and fixes. - [How to get part of a text value in Power Automate](/guides/power-automate-substring-extract-text/)\ Use substring() in Power Automate to cut part of a text value. Start index, length, errors on short text, and how to get the first or last characters. - [How to change text to upper or lower case in Power Automate](/guides/power-automate-change-text-case-toupper-tolower/)\ Use toUpper() and toLower() in Power Automate to change text case. Includes a proper case pattern, case-insensitive compares, and fixes for null errors. - [How to remove spaces from text in Power Automate](/guides/power-automate-trim-remove-spaces-from-text/)\ Use trim() in Power Automate to remove leading and trailing spaces. Also how to remove all spaces with replace(), and why a space can survive trim(). - [How to calculate the days between two dates in Power Automate](/guides/power-automate-days-between-two-dates/)\ Count the days between two dates in Power Automate with dateDifference() or ticks(). Working expressions, hours and minutes, and why the result is wrong or blank. - [How to get the first and last day of the month in Power Automate](/guides/power-automate-first-and-last-day-of-month/)\ Get the first and last day of the current, next or previous month in Power Automate with startOfMonth(), addToTime() and addDays(). Working expressions. - [How to replace text in Power Automate](/guides/power-automate-replace-text-replace-function/)\ Replace or remove text in Power Automate with the replace() function. Case rules, line breaks, apostrophes and null errors, with working expressions. - [How to convert text to a number in Power Automate](/guides/power-automate-convert-text-to-number-int-float/)\ Convert text to a number in Power Automate with int() and float(). Fixes for empty values, commas, currency signs and decimals, with working expressions. - [How to check if text starts or ends with a value in Power Automate](/guides/power-automate-startswith-endswith-check-text/)\ Use startsWith() and endsWith() in Power Automate to test the start or end of text. Case rules, file extension checks, Condition setup and indexOf(). - [How to use the if() expression in Power Automate](/guides/power-automate-if-expression-inline-condition/)\ Use the if() expression in Power Automate to pick one of two values without a Condition action. Syntax, and()/or() checks, empty values and nesting. - [How to use coalesce() in Power Automate to set a default for null](/guides/power-automate-coalesce-default-value-null/)\ Use coalesce() in Power Automate to return the first value that is not null. Set a default for empty columns, chain fallbacks and avoid null errors. - [How to generate a unique ID in Power Automate](/guides/power-automate-guid-generate-unique-id/)\ Create a unique ID in Power Automate with the guid() function. Formats, how to keep one value across a flow, and when a GUID is the wrong choice. - [How to add days to a date in Power Automate](/guides/power-automate-add-days-to-date/)\ Add or subtract days, weeks or months from a date in Power Automate. Covers addDays, addToTime, getFutureTime, formats and month-end results. - [How to find the position of text in Power Automate](/guides/power-automate-indexof-find-position-in-text/)\ Find where a word or character sits inside a text value in Power Automate. Covers indexOf, lastIndexOf, nthIndexOf, the -1 result and case rules. - [How to count the characters in text in Power Automate](/guides/power-automate-length-of-text-count-characters/)\ Count the characters in a text value in Power Automate with length(). Covers spaces, empty text, text limits, null errors and how to cut long text. - [How to join text together in Power Automate](/guides/power-automate-concat-join-text-together/)\ Join two or more text values in Power Automate with concat(). Covers spaces, numbers, dates, the @{} shortcut and when to use join() for arrays. - [How to get the day of the week from a date in Power Automate](/guides/power-automate-day-of-week-from-date/)\ Get the day number or day name from a date in Power Automate with dayOfWeek() and formatDateTime(). Sunday is 0. Includes a weekend check and time zone fix. - [How to round a number in Power Automate](/guides/power-automate-round-a-number/)\ Power Automate has no round() in the Math list. Use formatNumber() with int() or float() to round to whole numbers or two decimals, and test your own values. - [How to get the first N items of an array in Power Automate](/guides/power-automate-take-skip-first-n-items-array/)\ Use take() to keep the first N items of an array and skip() to drop them. Combine both to get any slice, and learn the limits of each function. - [How to generate a random number in Power Automate](/guides/power-automate-random-number-rand/)\ Use rand() in Power Automate to get a random whole number. The top value is never returned. Pick a random item from a list and add leading zeros. - [SharePoint document management best practices for a small team](/guides/sharepoint-document-management-best-practices/)\ Set up SharePoint document libraries the simple way: fewer folders, useful columns, versioning, check out, and who gets edit rights. Built for small teams. - [How to set up a SharePoint intranet for a small business](/guides/sharepoint-intranet-small-business/)\ Build a small business intranet in SharePoint: communication site, home page, navigation, news and the trackers people use every day. Steps and examples. - [item() or items() in Power Automate: which one do you use?](/guides/power-automate-item-vs-items/)\ item() or items() in Power Automate? See what each function returns, where each one works, how to name the loop, and what to check when an expression fails. - [SharePoint permissions best practices for a small team](/guides/sharepoint-permissions-best-practices/)\ Set up SharePoint permissions for a small team: use groups, keep inheritance, share by link with care, and know what Owners, Members and Visitors can do. - [How to build a knowledge base in SharePoint, with an FAQ and a glossary](/guides/sharepoint-knowledge-base/)\ Build a knowledge base in SharePoint with site pages, an FAQ web part and a glossary list. Which site type to use, how to link pages, and how to keep it current. - [SharePoint team site vs communication site: which to pick](/guides/sharepoint-team-site-vs-communication-site/)\ Team site or communication site? See how they differ on permissions, navigation, sharing and Microsoft 365 group, plus a simple way to choose for a small team. - [SharePoint hub sites vs subsites: which should a small team use?](/guides/sharepoint-hub-sites-vs-subsites/)\ Hub sites link separate SharePoint sites. Subsites nest inside one site. See how each works, what Microsoft recommends, the limits, and which fits a small team. - [How to change a SharePoint site URL safely](/guides/change-sharepoint-site-url/)\ Change the address of a SharePoint site in the admin center, step by step. See what cannot be renamed, what breaks afterward, and how to undo a change. - [How to use Patch to save to a SharePoint list in Power Apps](/guides/power-apps-patch-sharepoint-list/)\ Use Patch in a Power Apps canvas app to create and update items in a SharePoint list. Examples for new items, edits, many records, errors, and when to use a form. - [How to make a kanban board in Microsoft 365](/guides/kanban-board-microsoft-365/)\ Build a kanban board in Microsoft 365 with Planner or a SharePoint list board view. Steps for each, how they differ, and how to pick the one that fits your team. - [Microsoft 365 Business Basic vs Standard vs Premium: what small teams should know](/guides/microsoft-365-business-basic-vs-standard-vs-premium/)\ Compare Microsoft 365 Business Basic, Standard and Premium for a small team: the 300-seat cap, what Premium adds, what to check on price, and how to choose a plan. - [How to save an email to SharePoint with Power Automate](/guides/power-automate-save-email-to-sharepoint/)\ Save a whole email, not just its files, to SharePoint with Power Automate. Use Export email (V2) with Create file, set the trigger, and fix the usual problems. - [How to create a CSV file in Power Automate](/guides/power-automate-create-csv-table/)\ Use the Create CSV table action to turn an array into CSV text, pick custom columns and headers, and save it as a file or email attachment. - [How to move a file in SharePoint with Power Automate](/guides/power-automate-move-file-sharepoint/)\ Use the SharePoint Move file action to move a file to another folder, library or site, and choose what happens when the name is taken. - [How to delete a file in SharePoint with Power Automate](/guides/power-automate-delete-file-sharepoint/)\ Use the SharePoint Delete file action to remove a file by its identifier. Learn the two fields, where deleted files go, and how to test safely. - [How to create a file in SharePoint with Power Automate](/guides/power-automate-create-file-sharepoint/)\ Use the SharePoint Create file action to save a new file in a library. Learn the four required fields, how to name the file, and how to fix common errors. - [How to rename a file in SharePoint with Power Automate](/guides/power-automate-rename-file-sharepoint/)\ The SharePoint connector has no Rename file action. Use Send an HTTP request to SharePoint to set FileLeafRef. Steps, body, and common errors. - [How to list the files in a SharePoint folder with Power Automate](/guides/power-automate-list-files-in-sharepoint-folder/)\ Use Get files (properties only) with Limit Entries to Folder to list files in one SharePoint folder. Filters, sub-folders, and the Apply to each loop. - [How to append to an array variable in Power Automate](/guides/power-automate-append-to-array-variable/)\ Build a list inside a Power Automate flow with Initialize variable and Append to array variable. Steps, loop tips, and fixes for common errors. - [How to get the current date and time in your time zone in Power Automate](/guides/power-automate-get-current-date-and-time-local-time-zone/)\ Use utcNow() and convertFromUtc() in Power Automate to get today's date and time in your own time zone. Formats, time zone names, and fixes. - [How to add leading zeros to a number in Power Automate](/guides/power-automate-add-leading-zeros-to-number/)\ Pad a number with leading zeros in Power Automate, such as 7 to 0007. Use formatNumber() with a custom format, or concat() and substring() for text. - [How to color-code a choice column in a SharePoint list](/guides/color-code-choice-column-sharepoint-list/)\ Show each choice, such as Done or Blocked, in its own color. Steps for the no-code rules, the pill option, and a JSON block for exact colors. - [How much storage does SharePoint have in Microsoft 365?](/guides/how-much-storage-does-sharepoint-have/)\ A Microsoft 365 business tenant gets 1 TB plus 10 GB per license. See the per-site cap, what counts, how to check your use and how to add more. - [What is the SharePoint file size limit?](/guides/sharepoint-file-size-limit/)\ The largest file you can upload to SharePoint, the smaller limit for list attachments, the 400 character path limit, and what to do when an upload fails. - [How many versions of a file does SharePoint keep?](/guides/how-many-versions-does-sharepoint-keep/)\ How version limits work in a SharePoint document library: the 500 version count limit, time limits, automatic trimming, and how to check your own library. Source: https://250highstreet.com/guides/