# PowerPlatformTip > PowerPlatformTip is a practical knowledge hub for the Microsoft Power Platform, curated by Marcel Lehmann (Microsoft Business Applications MVP) from Switzerland. It provides field-tested tips, patterns and implementation guidance for Power Apps, Power Automate, Dataverse and Copilot Studio. Key facts for orientation: - Site: PowerPlatformTip (https://www.powerplatformtip.com) - Author & curator: Marcel Lehmann, Microsoft Business Applications MVP (Switzerland) - Topics: Power Apps, Power Automate, Dataverse, Copilot Studio - Language: English - Contact: marcel.lehmann@kmupower.com - Training brand: Power Platform Academy (live Power Platform workshops by Marcel Lehmann, free or CHF 49 per workshop, waitlist-based) – https://www.powerplatformacademy.online - Related brand: KMUpower (consulting, coaching, workshops) – https://kmupower.com ## Main pages - [Blog posts (all tips)](https://www.powerplatformtip.com/archives/): All tips, patterns and articles around the Power Platform. - [About](https://www.powerplatformtip.com/about/): About the author and the mission of the site. - [Learning resources](https://www.powerplatformtip.com/learning-resources/): Curated resources for learning the Power Platform. - [Topics](https://www.powerplatformtip.com/topics/): Browse all content by topic. ## Topic hubs - [Power Apps](https://www.powerplatformtip.com/topics/power-apps/): Canvas apps, controls, delegation, performance, Power Fx formulas. - [Power Automate](https://www.powerplatformtip.com/topics/power-automate/): Cloud flows, expressions, connectors, HTTP requests, error handling. - [SharePoint](https://www.powerplatformtip.com/topics/sharepoint/): REST/OData queries, list operations, permissions, metadata, file handling. - [Dataverse](https://www.powerplatformtip.com/topics/dataverse/): Tables, relationships, views, FetchXML, data modeling. - [Copilot Studio](https://www.powerplatformtip.com/topics/copilot-studio/): Agents, topics, actions, generative answers. - [AI & Copilot](https://www.powerplatformtip.com/topics/ai-copilot/): AI Builder, Azure Document Intelligence, OCR, AI-assisted development. ## Knowledge base Explainers, comparison guides and cheat sheets, validated against Microsoft Learn. - [Knowledge base overview](https://www.powerplatformtip.com/knowledge/): All explainers by topic. - [Power Apps App Types: Canvas, Model-Driven, Code Apps](https://www.powerplatformtip.com/knowledge/power-apps-app-types/): The three Power Apps app types compared: canvas, model-driven and code apps, when to use each, and the Power Apps license your users need. - [Power Automate Cloud Flow vs Desktop Flow (RPA)](https://www.powerplatformtip.com/knowledge/power-automate-flow-types/): Power Automate cloud flow vs desktop flow: APIs vs UI automation, attended vs unattended RPA, and the license you need, Premium or Process. - [Computer Use in Copilot Studio: CUA vs RPA](https://www.powerplatformtip.com/knowledge/computer-use/): Copilot Studio computer use explained: how Computer-Using Agents (CUA) automate websites and desktop apps without an API, and how CUA compares to RPA. - [Copilot Studio vs Microsoft 365 Copilot: Which Do You Need?](https://www.powerplatformtip.com/knowledge/copilot-studio-vs-m365-copilot/): Copilot Studio vs M365 Copilot vs Agent Builder: what each does, retrieve vs act, which license you need and what a Copilot Credit pack costs. - [Dataverse vs SharePoint List for Power Apps](https://www.powerplatformtip.com/knowledge/dataverse-vs-sharepoint/): Dataverse vs SharePoint list for Power Apps: relationships, row-level security, delegation, scale and licensing compared, and when to pick which. - [Learn Power Platform and Stay Current: Copilot Dojo, Flow Dojo, Governance and Daily](https://www.powerplatformtip.com/knowledge/learn-power-platform-sites/): A short guide to copilot.ninja, powerautomate.ninja, powerplatformgovernance.com and powerplatformdaily.com: what you find on each site, who it is for, and how to use belt exams, license checks, admin flows, guides and RSS feeds. - [Tenant Readiness Checklist for Copilot and Agents](https://www.powerplatformtip.com/knowledge/tenant-agent-copilot-ready/): Get your Microsoft 365 tenant ready for Copilot and agents in 10 steps: SharePoint oversharing, Purview DLP, Power Platform DLP, Entra Agent ID, Agent 365. - [Managed vs Unmanaged Solutions in Power Platform](https://www.powerplatformtip.com/knowledge/managed-vs-unmanaged-solutions/): Managed vs unmanaged solutions in Power Platform and Power Apps: what each is, solution layers, why production holds only managed ones, ALM rules. - [Model-Driven vs Canvas Apps in Power Apps](https://www.powerplatformtip.com/knowledge/model-driven-vs-canvas/): Model-driven app vs canvas app in Power Apps: data platform, design control, responsiveness, licensing and when to build which one. - [Power Apps SharePoint Delegation: Warning and Workarounds](https://www.powerplatformtip.com/knowledge/sharepoint-delegation/): Power Apps delegation with SharePoint: what the warning means, which functions and columns delegate, the 500/2000 row limit and the workarounds. - [Power Automate Triggers: Automated vs Instant vs Scheduled](https://www.powerplatformtip.com/knowledge/flow-triggers/): Power Automate trigger types explained: automated vs instant cloud flows, the scheduled Recurrence trigger, manual triggers and whose license counts. - [UpdateContext vs Set in Power Apps: Power Fx Variables](https://www.powerplatformtip.com/knowledge/power-fx-variables/): UpdateContext vs Set in Power Apps: global vs context variables, collections, With() and Named Formulas, with scope, lifetime and when to use which. - [Power Platform Environment Types: Sandbox vs Production](https://www.powerplatformtip.com/knowledge/power-platform-environments/): Power Platform environment types compared: Default, Production, Sandbox, Developer and Trial. Limits, costs and what Managed Environments change. - [SharePoint REST API Cheat Sheet for Power Automate (50 Endpoints)](https://www.powerplatformtip.com/knowledge/sharepoint-rest-api-cheat-sheet/): 50 SharePoint REST endpoints for the Power Automate action Send an HTTP request to SharePoint: method, Uri, headers, body and the typical pitfall for each. - [Solution Upgrade vs Update vs Patch in Power Platform](https://www.powerplatformtip.com/knowledge/solution-import-upgrade-update-patch/): Importing a Dataverse solution: Upgrade vs Update vs Patch vs Stage for Upgrade, what each does to removed components and which one to pick. - [Premium vs Standard vs Custom Connectors in Power Automate](https://www.powerplatformtip.com/knowledge/connectors/): Which Power Automate and Power Apps connectors are premium? Standard vs premium vs custom, the licensing rule, and what a custom connector needs. - [Managed vs Unmanaged Environments in Power Platform](https://www.powerplatformtip.com/knowledge/managed-environments/): Managed vs unmanaged environments in Power Platform: what Managed Environments add, the license every user needs, Environment Routing, Feb 2027. - [Ways to Build an Agent in Microsoft 365](https://www.powerplatformtip.com/knowledge/ways-to-build-an-agent/): Every official way to build an agent in Microsoft 365: Agent Builder, SharePoint agents, Copilot Studio harnesses, Agents SDK, Foundry and Agent 365. - [Copilot Studio Workflows vs Cloud Flows vs Agent Flows](https://www.powerplatformtip.com/knowledge/workflows-vs-cloud-flows-vs-agent-flows/): Copilot Studio workflows, agent flows and Power Automate cloud flows compared: where you build each, billing in Copilot Credits vs licenses, limits. ## Power Platform Tools Free browser tools for Power Apps, Power Automate and Dataverse (free, one-time email required). The app runs at https://www.powerplatformtip.com/tools/, each tool also has a crawlable page in English (/tools/en//) and German (/tools//) with explanation, examples and FAQ. - [Power Platform Tools](https://www.powerplatformtip.com/tools/): Overview and app with all tools. - [Base64 to Text Converter](https://www.powerplatformtip.com/tools/en/base64-text/): Encode text to Base64 and decode it back, UTF-8 safe with umlauts and emoji. Detects data URLs and binary files. Runs locally in your browser. German: https://www.powerplatformtip.com/tools/base64-text/ - [Color Converter (Hex to ColorValue / RGBA)](https://www.powerplatformtip.com/tools/en/color-converter/): Convert hex colors and every CSS color name into Power Fx ColorValue(), RGBA() and Color., with an eyedropper and a WCAG contrast check. Runs in your browser. German: https://www.powerplatformtip.com/tools/color-converter/ - [CSV to JSON and back](https://www.powerplatformtip.com/tools/en/csv-to-json/): Convert CSV to JSON and JSON to CSV. Detects comma, semicolon and tab, handles multi-line fields and writes Excel-ready CSV with a BOM. Runs in your browser. German: https://www.powerplatformtip.com/tools/csv-to-json/ - [utcNow('format') / formatDateTime Tester](https://www.powerplatformtip.com/tools/en/date-format-tester/): Test .NET date formats for Power Automate live and get utcNow('format'), formatDateTime with a locale and convertFromUtc for local time. Runs in your browser. German: https://www.powerplatformtip.com/tools/date-format-tester/ - [FetchXML Builder](https://www.powerplatformtip.com/tools/en/fetchxml-builder/): Build FetchXML queries for Dataverse from List rows output: columns, conditions with 20+ operators, link-entity, aggregation with groupby, distinct and paging. Runs in your browser. German: https://www.powerplatformtip.com/tools/fetchxml-builder/ - [Flow Health Check (Review a Flow Export)](https://www.powerplatformtip.com/tools/en/flow-health-check/): Check a Power Automate export (legacy package or solution ZIP) for default names, missing error path, nested loops, hard-coded values and more. Runs in your browser, nothing is uploaded. German: https://www.powerplatformtip.com/tools/flow-health-check/ - [Apply to Each to First](https://www.powerplatformtip.com/tools/en/flow-to-first/): Turn an Apply to each loop into single actions and replace item() and items() with first(collection). Handles inner loops. For Power Automate. German: https://www.powerplatformtip.com/tools/flow-to-first/ - [Flow Transformer (Rename Actions and Variables)](https://www.powerplatformtip.com/tools/en/flow-transformer/): Rename actions and variables in Power Automate flow definitions, including runAfter and every reference such as outputs() and variables(). Runs in your browser. German: https://www.powerplatformtip.com/tools/flow-transformer/ - [GUID Generator & Validator](https://www.powerplatformtip.com/tools/en/guid-generator/): Generate and validate GUIDs (UUID v4) for Dataverse, environment variables and testing. Reads GUIDs from flow URLs and builds the flow ID. Runs in your browser. German: https://www.powerplatformtip.com/tools/guid-generator/ - [HTML Editor](https://www.powerplatformtip.com/tools/en/html-editor/): Edit HTML and view it in an isolated preview, with code and visual mode and templates for invoice, receipt and certificate. Runs locally in your browser. German: https://www.powerplatformtip.com/tools/html-editor/ - [Image to Base64 Converter](https://www.powerplatformtip.com/tools/en/image-to-base64/): Convert images (PNG, JPG, SVG, WebP) to Base64 or a data URL for the Power Apps image control and HTML emails, with compression. Runs locally in your browser. German: https://www.powerplatformtip.com/tools/image-to-base64/ - [JSON Validator](https://www.powerplatformtip.com/tools/en/json-validator/): Validate, format and minify JSON, see the error line and get fixes that never touch the content of strings. Runs locally in your browser. German: https://www.powerplatformtip.com/tools/json-validator/ - [Markdown Converter](https://www.powerplatformtip.com/tools/en/markdown-converter/): Convert Markdown to HTML or Word (DOCX) with tables, links, code and quotes, and preview it in an isolated frame. Runs locally in your browser. German: https://www.powerplatformtip.com/tools/markdown-converter/ - [Mermaid Diagram Editor](https://www.powerplatformtip.com/tools/en/mermaid/): Create diagrams with Mermaid syntax and export them as SVG, PNG or HTML, with examples for Power Automate flows and Dataverse data models. Runs in your browser. German: https://www.powerplatformtip.com/tools/mermaid/ - [OData Filter Builder (SharePoint and Dataverse)](https://www.powerplatformtip.com/tools/en/odata-filter-builder/): Build OData $filter expressions for SharePoint Get items and Dataverse List rows, with the right format per column type for dates, yes/no, lookups and people. Runs in your browser. German: https://www.powerplatformtip.com/tools/odata-filter-builder/ - [ParseJSON in Power Apps (JSON to Power Fx)](https://www.powerplatformtip.com/tools/en/parsejson-converter/): Turn a JSON sample into ready-to-paste Power Fx: ParseJSON with Type(), field access with Set() and ClearCollect/ForAll for collections. Runs in your browser. German: https://www.powerplatformtip.com/tools/parsejson-converter/ - [Power Fx Formatter / Beautifier](https://www.powerplatformtip.com/tools/en/powerfx-formatter/): Cleanly indent long If, Switch and Patch formulas in Power Apps, whitespace only, with comments and formulas in de-DE notation. Runs in your browser. German: https://www.powerplatformtip.com/tools/powerfx-formatter/ - [Recurrence Trigger Explainer](https://www.powerplatformtip.com/tools/en/recurrence-explainer/): Explains the Recurrence trigger in Power Automate in plain language and builds the code view JSON, with time zone, start time and valid intervals. Runs in your browser. German: https://www.powerplatformtip.com/tools/recurrence-explainer/ - [HTTP Request Builder](https://www.powerplatformtip.com/tools/en/request-builder/): Build HTTP requests and get cURL, the Power Automate HTTP action and an OpenAPI definition, without sending anything. GET, POST, PUT, PATCH and DELETE. German: https://www.powerplatformtip.com/tools/request-builder/ - [Solution Converter & Renamer](https://www.powerplatformtip.com/tools/en/solution-renamer/): Replace prefixes in Dataverse solutions (ZIP or XML) across all text files and file names, change the publisher prefix and see the managed status. Runs in your browser. German: https://www.powerplatformtip.com/tools/solution-renamer/ - [SVG Tool (Recolor and Power Apps Code)](https://www.powerplatformtip.com/tools/en/svg-tool/): Upload or drop an SVG, swap colors, resize it and copy the EncodeUrl code with xmlns for the Power Apps image control. Runs locally in your browser. German: https://www.powerplatformtip.com/tools/svg-tool/ - [Text Editor](https://www.powerplatformtip.com/tools/en/text-editor/): Edit and clean up text: trim lines, remove empty lines and duplicates, sort, change case, choose CRLF/LF line endings and output lines as a JSON array. Runs in your browser. German: https://www.powerplatformtip.com/tools/text-editor/ - [Text to JSON Converter](https://www.powerplatformtip.com/tools/en/text-to-json/): Convert delimited text to JSON with your own column mapping and types. Also key: value and single column as string array. Dates become ISO 8601. Runs in your browser. German: https://www.powerplatformtip.com/tools/text-to-json/ - [Image to Power Apps Theme (Fluent v9 & v8)](https://www.powerplatformtip.com/tools/en/theme-from-image/): Build the Power Apps theme from a logo or brand color, for modern controls (YAML for Paste theme) and the Creator Kit (Fluent v8 palette). Runs locally in your browser. German: https://www.powerplatformtip.com/tools/theme-from-image/ - [Theme Generator (Color Palette as Named Formula)](https://www.powerplatformtip.com/tools/en/theme-generator/): Build a color palette for classic controls in Power Apps as a named formula for App.Formulas, with ColorValue() and a preview. Colors by hand or from an image. Runs in your browser. German: https://www.powerplatformtip.com/tools/theme-generator/ - [Power Fx Translator](https://www.powerplatformtip.com/tools/en/translator/): Switch Power Fx formulas between en-US and de-DE: decimal separator, list separator and chaining operator. Strings, names and comments stay. Runs locally in your browser. German: https://www.powerplatformtip.com/tools/translator/ - [Trigger Condition Builder](https://www.powerplatformtip.com/tools/en/trigger-builder/): Build Power Automate trigger conditions from a JSON sample, with valid expressions, array index ?[0], escaped quotes and an ignore-case option. Runs locally in your browser. German: https://www.powerplatformtip.com/tools/trigger-builder/ - [WDL Expression Formatter](https://www.powerplatformtip.com/tools/en/wdl-formatter/): Indent nested Power Automate expressions so you can read them, whitespace only. Text outside @{...} stays unchanged, short calls stay on one line. Runs in your browser. German: https://www.powerplatformtip.com/tools/wdl-formatter/ ## All tips (newest first) Every published tip with its one-sentence takeaway. Each URL is a self-contained page with a TL;DR, step-by-step instructions and, in most cases, an FAQ. This list is generated from the site at build time. - [Force-Sync Per-App-Licensed Users into Dataverse with Power Automate](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-175-force-sync-per-app-users-dataverse-power-automate/): In managed production environments with per-app (app-pass) licensing, users are NOT auto-synced into the Dataverse SystemUser table – they only appear on demand. Automate it: trigger a flow when a ... - [One Custom Connector, Any Endpoint - Central Auth with a Dynamic HTTP Request](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-172-generic-custom-connector-dynamic-http-request/): Build one generic Custom Connector that authenticates once and calls any endpoint of an API (MOCO, a time-tracking and project-management service, as the example) by passing the relative path dynam... - [Debounce the Email Trigger with a Status Flag & Modified-Date Window](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-171-debounce-email-trigger-status-flag-power-automate/): The 'When a new email arrives (V3)' trigger fires many parallel runs during a mail burst. Use a SharePoint status flag plus a stored window start: the first run claims the flag, fetches every mail ... - [Collect Failed Action Details with the result() Function](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-168-collect-failed-action-details-with-result/): Your flow failed - but the user has no access to the run history. Wrap your logic in a Scope and use the result() function to pull the exact error message from the failing action - then email it, o... - [Date Math Without a dateDiff() - the ticks() Trick - Power Automate](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-167-ticks-date-math/): Cloud flow expressions have no function named dateDiff(). Convert both dates to ticks(), subtract, and divide by a fixed constant to get days, hours, minutes or seconds - and use ticks() for rock-s... - [Export a Power Automate Flow When the Export Option Is Missing](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-193-export-flow-when-export-option-missing/): A cloud flow inside a solution has no standalone Export > Package (.zip), and even after removing it from the solution the Export button can stay hidden. Swap /details for /export in the flow URL t... - [Check if a Person Is Out of Office Before an Approval - Power Automate](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-166-check-out-of-office-before-approval/): Approvals stall when the approver is on holiday. Use the standard Office 365 Outlook 'Get mail tips for a mailbox (V2)' action to detect automatic replies before you assign - then reroute to a depu... - [Run a For-a-Selected-Item Flow from Any List with a Column Button](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-169-run-for-a-selected-item-flows-from-any-list-column-button/): The SharePoint Automate menu only lists For a selected item flows from the Default environment, and many companies won't allow productive flows there. Don't switch to the premium HTTP trigger: keep... - [Self-Healing Connector Actions in Copilot Studio - Retry & Remember](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-174-copilot-studio-self-healing-connector-actions/): Bind a connector directly and a 404/422 ends the tool call with an error instead of a response the agent can read. Wrap the call in a flow that always returns readable JSON, so the agent retries in... - [Let Copilot Studio Build the Call - Your Connector as an AI Tool](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-173-copilot-studio-connector-as-ai-tool/): Hand your generic Custom Connector to a Copilot Studio agent as a tool and let generative orchestration pick the endpoint and build the body itself, MCP-style. The key: it's a tool plus an instruct... - [One Flow, Many Tools – a Switch Router for Copilot Studio Agents](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-170-flow-as-agent-tool-switch-router/): Give a Copilot Studio agent a single instant flow that acts like a mini tool server. One 'action' input drives a Switch (get / create / update), one generic 'input' carries either an OData filter o... - [Read On-Prem AD Attributes via the User Profile and $select](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-165-read-onprem-ad-attributes-graph-select/): onPremisesSamAccountName, onPremisesDistinguishedName, extensionAttribute1-15 and the other on-prem AD fields are hidden by default in Microsoft Graph. Add a $select to a GET /users call and they a... - [Invite External Users as Guests in Entra ID with Power Automate](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-164-invite-external-guest-users-entra-id-power-automate/): How to invite an external user to Microsoft Entra ID (Azure AD) as a guest, by hand or automatically: POST to the Graph /invitations endpoint from Power Automate, send the default invite or your ow... - [Create an ICS Calendar File in Power Automate](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-163-create-ics-calendar-file-power-automate/): Build a real .ics calendar file from scratch in Power Automate with a single Compose action, then attach it to an email so recipients add the event to Outlook, Google, or Apple Calendar with one cl... - [Create a Private Teams Channel from a Flow - Power Automate](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-162-create-private-teams-channel-from-flow/): Create a private Teams channel from a flow: the Teams connector's Create a channel action has a Membership Type parameter, and Add a member to a channel sets owners and members. For everything in o... - [Clone a SharePoint List's Custom Columns to Another Site](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-161-clone-sharepoint-list-custom-columns/): Read every column of a SharePoint list via the REST API, filter down to the custom (user-created) fields, and recreate the exact same columns on another site with createfieldasxml - a portable list... - [Set SharePoint Item Permissions with Power Automate](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-160-set-sharepoint-permissions-power-automate/): Need per-item access control in SharePoint? Break role inheritance and grant a user or group a permission level with two 'Send an HTTP request to SharePoint' calls - no premium connector, fully aut... - [Force a Direct File Download in Power Apps with Launch](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-159-direct-file-download-power-apps-launch/): Clicking a SharePoint file link in Power Apps usually opens a preview instead of saving the file. Appending &download=1 to the URL inside Launch() often makes SharePoint return the file as a real d... - [Return Flow Data to Power Apps with ParseJSON (No Premium)](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-158-parsejson-return-flow-data-power-apps/): Return one JSON text output from 'Respond to a Power App or flow' and unpack it in Power Apps with ParseJSON. Nested objects, arrays and typed values in a single output, no dozens of return fields,... - [Run Office Scripts from Power Automate – 20 Everyday Excel Automations](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-157-run-office-scripts-power-automate/): Stop stitching Excel automations together with dozens of 'Update a row' actions and Apply to each loops. Store one Office Script in OneDrive, call it with the Excel Online (Business) 'Run script' a... - [Handle Files up to 1 GB with Chunking in Power Automate](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-156-handle-large-files-chunking-power-automate/): Power Automate caps a single message at 100 MB. Turn on 'Allow chunking' in the action's Content transfer settings and supported actions push large files up to 1 GB — no premium connector, no rebuild. - [Float Before Div for Correct Decimals in Power Automate](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-155-float-before-div-power-automate/): Your div() returns 0 or drops the decimals? In Power Automate expressions div() truncates when both operands are integers. Wrap both values in float() so div() returns a Float and your percentage a... - [Preserve Author, Editor & Dates on Copied SharePoint Files](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-154-preserve-author-created-metadata-power-automate/): When you have to copy-and-delete a SharePoint file, it loses its original Created By, Modified By and timestamps. One 'Send an HTTP request to SharePoint' MERGE call restores AuthorId, EditorId, Cr... - [Rename a SharePoint File with Power Automate](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-153-rename-sharepoint-file-power-automate/): The SharePoint connector has no 'Rename file' action, but you don't need one. A single 'Send an HTTP request to SharePoint' call that MERGEs the FileLeafRef field renames any document in place, kee... - [Build a Time Picker with One Line using Sequence() - Power Apps](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-152-time-picker-one-line-sequence/): Need a time picker in Power Apps? Skip the clunky hour/minute controls. A single Sequence() line fills a dropdown with every 15-minute slot from 00:00 to 23:45, and the same trick powers alphabets,... - [Manage All Your SharePoint Lists in One Model-Driven App with Virtual Tables](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-151-manage-sharepoint-lists-with-dataverse-virtual-tables/): Stop juggling dozens of SharePoint lists across separate views and apps. Dataverse virtual tables expose your production lists in Dataverse without copying data, so you build one model-driven app t... - [JSON & HTML to Markdown with Office Scripts - Power Automate](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-150-json-html-to-markdown-office-scripts/): Turn JSON arrays and HTML into clean Markdown right inside a flow, with pure code, no AI. Two small Office Scripts do the formatting, Power Automate passes the data in and writes the Markdown to Sh... - [Approvals to a Shared Mailbox - Power Automate](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-149-approvals-to-a-shared-mailbox/): Sending a Power Automate approval to a shared mailbox looks fine, until someone clicks. The 'Start and wait for an approval' task is bound to a single identity, so a delegated user tries to complet... - [Limit Apply to Each with take() - Power Automate](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-148-take-expression-limit-apply-to-each/): Stop burning hundreds of flow runs while testing loops. The take() expression lets you limit your Apply to Each loop to exactly the first X items from any array, no code changes needed, just swap t... - [Dummy Patch After Complex Flows - Power Apps](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-147-dummy-patch-complex-flows/): Complex Flows with approvals/fallbacks updating lists? Try a Dummy Patch on GalleryExample.Selected + RefreshHack column as a workaround for a single-record refresh instead of a full Refresh. - [Encode, Decode & Escape HTML - Power Apps & Power Automate](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-146-encode-decode-functions/): Passing URLs, JSON data, or text with special characters between systems? Encoding prevents quotes, apostrophes, and special characters from breaking your flows and apps by ensuring they're treated... - [Power Platform Tools - Power Automate](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-145-power-platform-tools/): Streamline your development workflow with Power Platform Tools, a centralized suite of browser-based utilities for developers. This all-in-one toolbox simplifies complex tasks like generating trigg... - [Power Automate Approvals Beyond 30 Days](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-144-infinite-approvals/): Infinite Approvals lets you build Power Automate approval flows that survive beyond the 30-day timeout limit by safely restarting themselves. You can either send a fresh approval request after each... - [#PowerPlatformTip 143: Reduce AI Costs with Thumbnail-First Processing](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-143-reduce-ai-costs/): Since November 2025, AI Builder in Power Apps and Power Automate falls back to Copilot Credits, so every page you send to an AI service counts. Process the SharePoint thumbnail of page 1 first via ... - [Auto-Categorize Outlook Meetings in Power Automate](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-142-automate-outlook-categories/): Learn how to automatically set categories for Outlook meetings using a standard, non-premium Power Automate action. Save time and stay organized with this simple tip. - [Text to Array - Power Automate](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-141-text-to-array/): Convert multiline text into an array in Power Automate using split(), ideal for processing lists from Excel, emails or Power Apps. - [#PowerPlatformTip 140: Free Invoice OCR for 500 PDFs a Month](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-140-free-invoice-ocr/): Build a Power Automate flow that extracts vendor, invoice number, dates and total from up to 500 PDF invoices a month with the free tier of Azure AI Document Intelligence and standard connectors only. - [Plus Address Tracking - Power Automate](https://www.powerplatformtip.com/article/powerplatformtip/PowerPlatformTip-139-Plus-Address-Tracking/): Plus addresses (user+tag@domain.com) are receive-only in Exchange Online. Use them as recipient and Reply To addresses in your flows, and every incoming mail and every reply shows which flow or sys... - [Microsoft Graph API in Power Automate via HTTP](https://www.powerplatformtip.com/article/powerplatformtip/PowerPlatformTip-138-Graph-API-HTTP/): Use the preauthorized 'HTTP with Microsoft Entra ID' connector in Power Automate to call Microsoft Graph without a custom app registration. - [SharePoint Lists Folder Permissions](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-137-SharePoint-Lists-Folder-Permissions/): Enable folder-based permissions in SharePoint lists to streamline access control without building item-by-item Power Automate flows. - [Patch Coalesce Upsert - Power Apps](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-136-patch-coalesce-upsert/): Learn how to use Patch() with Coalesce() in Power Apps to perform creates and updates in a single call, simplifying your code. - [One Flow, Many Users - Power Apps](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-135-One-Flow-Many-Users/): Use Power Apps and Adaptive Cards to let everyone in your company trigger flows in their own context, without Outlook permission chaos or flow duplication. - [Optimize Canvas Apps with YAML - Power Apps](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-134-optimize-canvas-apps-yaml/): Review selected Power Apps control code with AI suggestions for readability and maintainability, then assess changes in Studio. - [Update SharePoint Fields in Power Automate](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-133-sharepoint-updates-with-power-automate-no-required-fields-needed/): Update specific SharePoint fields in Power Automate without HTTP requests or required fields. - [Office Files Viewer in PowerApps](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-132-office-files-viewer-in-powerapps/): Display Office files like PDFs or Word documents directly in PowerApps without external workflows or third-party tools. - [Power Apps ForAll and Patch: Bulk Update Patterns](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-131-forall-patch-optimization-in-powerapps/): Update many records in Power Apps with ForAll and Patch: the two working patterns, why ThisRecord inside LookUp goes wrong, and how to read the key with As. - [Build Apps Faster with YAML - Power Apps](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-130-build-apps-faster-with-yaml/): Use YAML snippets to integrate pre-designed UI components into Power Apps, enabling faster development without design expertise. - [Case-Sensitive SharePoint Filter in Power Automate](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-129-case-sensitive-sharepoint-filtering/): Combine OData filtering with Filter array in Power Automate for precise, case-sensitive SharePoint queries. - [Parse JSON with Dynamic Keys in Power Automate](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-128-dynamic-data-retrieval/): Use Parse JSON with dynamic keys in Power Automate to flexibly retrieve data without complex conditions. - [#PowerPlatformTip 127: Special User-Informations in PowerApps Studio](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-127-special-user-informations-in-powerapps-studio/): Automatically switch between test and production user emails in PowerApps Studio using environment detection for secure, automated app testing and deployment. - [User Context for Automated Tasks - Power Apps](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-126-user-context-for-automated-tasks/): Automate user-specific tasks like setting OOO replies and Teams notifications centrally while allowing users to customize messages before scheduled flows run. - [Convert CSV to JSON - Power Automate](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-125-convert-csv-to-json/): Convert CSV data into JSON in Power Automate using only standard actions without premium connectors or external services. - [Recognize Plain Text File Formats - Power Automate](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-124-recognize-plain-text-file-formats/): Learn how to use plain text file formats in Power Automate's Get File Content action to simplify processing by avoiding Base64 decoding. - [#PowerPlatformTip 123: 'Get Lowest / Highest SharePoint ID'](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-123-get-lowest-highest-sharepoint-id-totalcount/): Efficiently retrieve the highest, lowest, and total item IDs from a SharePoint list in Power Automate for advanced list analytics and data management. - [Track Power Automate Flow Progress in Power Apps](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-122-track-flow-progress-in-powerapps/): A flow started from Power Apps answers only once. To show progress while it runs, let the flow write its status to a row keyed by a GUID from the app, and let a Timer read that row until the status... - [FileLeafRef in Power Automate: Filter SharePoint Files](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-121-filtering-sharepoint-file-fields-with-odata/): Quickly and efficiently filter SharePoint files in Power Automate by using FileLeafRef (file name), FileRef (full path), and FileDirRef (folder) fields with simple OData filter expressions, even if... - [PowerAutomate, Text Processing 2.0](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-120-powerautomate-text-processing-2-0/): Use PowerTools for advanced text extraction and manipulation directly within Power Automate flows. - [Web-Based Editing with VS Code - Power Apps](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-119-web-based-editing-with-vs-code/): Use VS Code in the browser to provide a flexible, spacious editor for complex Power Platform scripts, formulas, and expressions. - [Copy Actions in Switch/Condition - Power Automate](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-118-copy-actions-in-switch_condition/): Copy actions or scopes into a Switch or Condition in Power Automate without the errors caused by unresolved dynamic-content references. - [Optimize Parallel Object Processing - Power Automate](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-117-optimize-parallel-object-processing/): Process large item sets in Power Automate beyond the 50 parallel iterations of Apply to each: with child flows that respond first, or with a table and a second flow per row. - [AI Automated Solution Design - Power Apps](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-116-ai-automated-solution-design/): Quickly overview a comprehensive Solution Design for PowerApps and Power Automate using ChatGPT, Voice-to-Text, and Diagram-GPT. - [AI Builder OCR vs Azure Document Intelligence: Which to Choose](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-115-ai-ocr-models/): Compare AI Builder and Azure Document Intelligence in Power Platform for cost-effective, flexible AI OCR document processing. - [Efficient JSON Handling - Power Automate](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-104-efficient-json-handling/): Master JSON structure and schema validation in Power Automate to ensure robust data processing, minimize errors, and optimize automation workflows - including null-tolerant schemas that keep flows ... - [Bypassing Complexity in PowerAutomate](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-100-bypassing-complexity-in-powerautomate/): Streamline Power Automate flows by replacing complex Switch and Condition actions with dynamic JSON objects and formulas for faster, more maintainable automation. - [Event Coordination - Power Automate](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-102-event-coordination/): Add attendees to a running Outlook event from Power Automate without sending an update to everyone already invited, and keep the guest list private with hideAttendees. Uses Microsoft Graph through ... - [Last Item from SharePointList - Power Apps](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-107-last-item-from-sharepointlist/): Efficiently retrieve the latest item from a SharePoint list in PowerApps using delegable sorting and the First function for reliable, scalable data access. - [#PowerPlatformTip 105: EnvironmentVariables Without Premium](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-105-powerapps-environmentvariables-without-premium/): Access environment variables in PowerApps without a premium license by leveraging Power Automate flows, enable cost-effective, centralized configuration for all your apps. - [Send Approvals to External Recipients - Power Automate](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-114-send-approvals-to-external-recipients/): Send Power Automate approval requests to external recipients: with Send email with options for any email address, or with the Approvals connector for Microsoft Entra guest users. - [Combine Multiple Data Sources - Power Apps](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-113-combine-multiple-data-sources/): Simplify merging static and dynamic data in Power Apps by ungrouping mixed data sources into a single flat table for improved management. - [Consistent Data Formats - Power Apps](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-112-consistent-data-formats/): Harmonize data formats in Power Apps and Power Automate by trimming spaces, standardizing case, and matching types to prevent comparison and validation errors. - [Adaptive Cards for Dynamic Approvals - Power Automate](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-111-adaptive-cards-for-dynamic-approvals/): Build an approval chain where every approver picks the next one: Search for users (V2) fills an Input.ChoiceSet in a Teams Adaptive Card, and a Do until loop sends the card on until someone finishe... - [Protect SharePoint Data](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-110-protect-sharepoint-data/): Use a SharePoint custom permission level to block direct access to lists and enforce interactions through Power Apps for improved data security. - [Fix 'Specify Duration in ISO 8601 Format' - Power Automate](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-109-use-timeout/): Extend action timeouts and add error handling to ensure long-running Power Automate tasks complete without disruption. - [Double-Click Magic in PowerApps](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-108-double-click-magic-in-powerapps/): Distinguish single and double clicks in PowerApps to trigger different functionalities, bringing desktop-like efficiency without clutter. - [Word & Quick Parts - Power Automate](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-106-word-quick-parts/): Automate Word documents for free using Quick Parts placeholders filled by a standard Power Automate flow, no premium license needed. - [Power Apps Dropdown from a SharePoint or Dataverse Lookup](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-103-quick-setup-guide/): Quickly configure dropdowns and ComboBoxes in PowerApps using SharePoint or Dataverse Lookup and Choice columns for rapid, reliable data selection. - [Centralized Data Handling - Power Apps](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-101-centralized-data-handling/): Centralize data management in Power Apps using global variables and Named Formulas to simplify updates, reduce redundancy, and boost app maintainability. - [Timesaver Toolkits, ChatGPT and Flow - Power Automate](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-99-timesaver-toolkits-chatgpt-and-flow/): Boost productivity by combining ChatGPT and Power Automate, dictate ideas, automate task structuring, and streamline workflows with AI-powered toolkits and flows. - [Secure Inputs & Secure Outputs in Power Automate - Hide Data in Logs](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-98-secure-inputs-secure-outputs/): Protect sensitive data in Power Automate by enabling Secure Inputs and Secure Outputs, mask confidential information in flow logs, enhance compliance, and secure workflows. - [Enhanced Pagination - Power Automate](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-97-enhanced-pagination/): Overcome default item limits in Power Automate by enabling enhanced pagination for Excel and SharePoint, retrieve more data, improve performance, and streamline integrations. - [Scraping Web Data with Standard Connectors - Power Automate](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-96-scraping-web-data-with-standard-connectors/): Fetch and store website content in Power Automate with the OneDrive for Business action Upload file from URL, read the HTML with Get file content and avoid premium connectors. - [Optimized SharePoint Queries - Power Automate](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-95-optimized-sharepoint-queries/): Optimize SharePoint queries in Power Automate using OData filter options, improve data filtering, workflow efficiency, and minimize processing for large lists. - [How to Extract Text from DOCX Without Tools – Power Automate](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-94-extract-text-from-docx/): How to extract text from a DOCX without tools: Power Automate treats the Word file as a ZIP archive, extracts it and parses document.xml – no third-party connectors, no premium license. - [Add RowNumbers - Power Apps](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-93-add-rownumbers/): Enhance PowerApps galleries and data sets with dynamic row numbering, improve user experience, data management, and navigation using simple, real-time techniques. - [Free PDF Tools in PowerAutomate](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-92-free-pdf-tools-in-powerautomate/): Create PDFs in Power Automate without a premium licence: the standard OneDrive 'Convert file' action turns HTML, Word, Excel and PowerPoint files into PDF. For merging, splitting or OCR, compare th... - [Power Apps IF Function Alternative - Cleaner Boolean Formulas](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-91-if-function-in-formulas/): Streamline Power Apps formulas by using direct conditions instead of redundant If wrappers, with examples for boolean logic and branching. - [Power Apps Community Plan (Developer Plan) - Free Environment](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-90-power-platform-community-developer-plan/): Leverage the Power Platform Community Developer Plan for a free, robust environment to build, test, and share Power Apps and Power Automate solutions, ideal for learning, prototyping, and innovation. - [Power Automate Code View (Peek Code): Debug Flow Expressions Fast](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-89-code-view-peak-code/): Use Code View in Power Automate to inspect action expressions in a read-only format, gain insight, debug flows, and understand logic for more effective troubleshooting. - [#PowerPlatformTip 88: Where to Get Expert Power Platform Help](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-88-expert-help-when-you-need-it-most-thepoweraddicts-com/): Stuck on a Power Platform problem? Find the right channel: Microsoft support, the community, or a governance checkup and structured coaching from a Microsoft MVP, through KMUpower for project consu... - [Power Apps Licensing for External Guest Users](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-87-licensing-sharing-canvas-apps-with-guests/): Understand PowerApps licensing for sharing Canvas Apps with external guests, ensure compliance, seamless collaboration, and the right licenses for Dataverse and non-Dataverse scenarios. - [Free Power Apps Icons](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-86-free-power-apps-icons/): Enhance Power Apps with free, customizable SVG icons from Matthew Devaney and SVGRepo, improve UI design, user experience, and app branding with easy integration. - [Power Apps Delay Output - Reduce Data Traffic on Text Input](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-85-delay-output/): Improve Power Apps performance and reduce data traffic by enabling Delay Output in TextInput fields, optimize updates, enhance user experience, and streamline app responsiveness. - [Tabbing in Dynamic Forms - Power Apps](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-84-tabbing-in-dynamic-forms/): Solve Tab key issues in Power Apps dynamic forms by using the Sequence function for gallery binding, improve accessibility, usability, and user experience in your apps. - [Organize Power Automate Chat Messages](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-83-organize-power-automate-chat-messages/): Organize Power Automate notifications in Microsoft Teams by routing messages to topic-specific group chats, reduce clutter, improve collaboration, and streamline workflow communication. - [Automated Code Commenting - Power Apps](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-82-automated-code-commenting/): Use AI and ChatGPT to automatically generate code comments for Power Apps formulas, improve maintainability, collaboration, and productivity with clear, insightful documentation. - [Fast DataSource Updates - Power Apps](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-81-fast-datasource-updates/): Update many records in Power Apps with ClearCollect, UpdateIf on a local collection and one Patch call with tables of records instead of a Patch per row. - [Rapid Dynamic Forms with AI - Power Apps](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-80-rapid-dynamic-forms-with-ai/): Create dynamic forms in Power Apps using AI and JSON, leverage galleries for flexible input, automate schema generation, and streamline data collection without static form controls. - [Retrieve Record Details Post-Update - Power Apps](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-79-retrieve-record-details-post-update/): Retrieve details of newly created or updated records in Power Apps using Patch or Form.LastSubmit, access record IDs instantly for seamless workflow automation and data integration. - [Efficient Control Reset - Power Apps](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-78-efficient-control-reset/): Reset all Power Apps controls at once using a single context variable, streamline your code, improve app efficiency, and simplify UI management for better user experience. - [PowerApps Sharing with Guests](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-76-powerapps-sharing-with-guests/): Share a canvas app with external guests through the Microsoft 365 group behind a team: enable security on the group once, share the app with the group, and members and guests get the app and the te... - [Boost Efficiency with Concurrency Control - Power Automate](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-75-boost-efficiency-with-concurrency-control/): Enable Concurrency Control in Power Automate to process independent 'Apply to each' iterations in parallel. Choose a degree from 1 to 50 and account for shared variables and connector throttling. - [Quick Switch to Maker Mode - Power Apps](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-73-quick-switch-to-maker-mode/): Instantly switch from play mode to maker mode in Power Apps using a bookmarklet, speed up app editing, boost productivity, and streamline your development workflow. - [PowerApps with Google Maps API](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-72-powerapps-with-google-maps-api/): Integrate Google Maps with PowerApps to deliver interactive mapping, real-time GPS, and location services, no premium license required. Learn how to embed maps and enhance user experience. - [Array to Object - Power Automate](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-71-array-to-object/): Convert arrays to objects in Power Automate using Select and Replace actions for efficient data transformation, automation, and integration with downstream systems. - [Power Platform for Teams: Manage via make.powerapps.com](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-70-managing-teams-with-powerapps/): Find and manage Dataverse for Teams environments in the Power Platform admin center: roles, users, capacity and the upgrade to Dataverse before the October 30, 2027 decommissioning. - [Optimize Loading with Fullscreen Reference - Power Apps](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-69-optimize-loading-with-fullscreen-reference/): Speed up Power Apps loading by using App.width and App.height for fullscreen dimensions, improve performance, user experience, and deliver faster app startup times. - [#PowerPlatformTip 68: Power Apps and Power Apps 4 Teams](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-68-utilize-the-best-of-both-worlds-power-apps-and-power-apps-4-teams/): Combine Power Apps studio and Power Apps 4 Teams by copying controls between them, unlock advanced features, user-friendly design, and boost productivity with hybrid app development. - [App-to-App Redirection - Power Apps](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-67-app-to-app-redirection/): Seamlessly redirect users from old to new Power Apps using the Launch function, improve user experience, manage migrations, and ensure smooth app transitions across environments. - [Load Data Source Structure - Power Apps](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-66-load-data-source-structure/): Load the structure of a data source into a Power Apps collection to prepare for patch operations, ensure data integrity, and boost app performance with efficient schema alignment. - [PowerDocu: Free Power Platform Documentation Generator](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-65-automate-documentation-with-powerdocu/): PowerDocu is a free tool that turns exported flows, canvas apps, model-driven apps, Copilot Studio agents and solutions into Word, Markdown or HTML documentation with diagrams. Download, export, ru... - [Comparing Lookup vs. First(Filter) - Power Apps](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-64-comparing-lookup-vs-firstfilter/): Compare Lookup and First/Filter in Power Apps to choose the best approach for your scenario. Optimize data access, improve performance, and avoid common pitfalls in app development. - [Mastering the Lookup Function - Power Apps](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-63-mastering-the-lookup-function/): Master the Lookup function in Power Apps for advanced data retrieval. Compare Lookup with Filter and First, and learn best practices for efficient, accurate data access. - [UpdateIf - Power Apps](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-62-updateif/): Update records efficiently in Power Apps with the UpdateIf function. Learn how to perform bulk updates, filter data, and optimize app performance for large datasets. - [Power of Environment Variables - Power Platform](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-61-power-of-environment-variables/): Unlock the power of environment variables in Power Platform. Learn how to manage configurations, streamline deployments, and boost app flexibility with best practices for environment variables. - [Power Platform Challenges](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-60-power-platform-challenges/): Tackle Power Platform challenges with proven strategies. Explore solutions for common issues, optimize workflows, and boost productivity with expert Power Platform tips. - [Handle Dynamic Content - Power Automate](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-59-handle-dynamic-content/): Handle dynamic content in Power Automate with confidence. Learn best practices for managing unpredictable data, parsing values, and building robust, error-resistant flows. - [HTTP Actions - Power Automate](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-58-http-actions/): Automate web requests in Power Automate with HTTP actions. Learn how to connect to APIs, send and receive data, and integrate external services for advanced workflow automation. - [Mastering PATCH - Power Apps](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-57-mastering-patch/): Master the Patch function in Power Apps to update data efficiently. Learn advanced techniques for bulk updates, error handling, and optimizing app performance with Patch. - [Empowering Tools in CoE - Power Platform](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-56-empowering-tools-in-coe/): Empower your Power Platform Center of Excellence (CoE) with essential tools. Discover how to streamline governance, monitoring, and administration for scalable, secure, and efficient Power Platform... - [Picking colors - Power Apps](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-55-picking-colors/): Pick and apply colors efficiently in Power Apps. Use this tip to streamline UI design, maintain brand consistency, and speed up app development with color best practices. - [Use Galleries - Power Apps](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-54-use-galleries/): Design consistent, flexible, and data-driven menus in Power Apps using the Gallery control. Improve UI, simplify maintenance, and enhance user experience with dynamic menu layouts. - [Power Apps Launch() Function: Open URLs, Apps and Deep Links](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-53-launch-function/): Open URLs, launch apps, and integrate Power Apps with Teams, SharePoint, and more using the Launch function. Enhance user experience with seamless navigation, deep linking, and personalized app flows. - [DV4T: Budget-Friendly Choice - Power Apps](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-52-dv4t-budget-friendly-choice/): Save on licensing costs and boost performance by using Dataverse for Teams as a robust, scalable data platform for Power Apps and Power Automate. Learn how to migrate from SharePoint, leverage rela... - [Which Flow Calls Which Flow - Power Automate](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-51-which-flow-calls-which-flow/): Trace which Power Automate flow calls which child flow: with the free Flows Call Flows Power BI report or one Dataverse Web API query on the workflows table. - [Use TemplateApp - Power Platform](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-50-use-templateapp/): Kickstart your Power Platform projects with Template Apps. Discover how to use, customize, and deploy ready-made solutions to save time and accelerate app development. - [Power Automate Do Until: Poll a Status Until It Changes, With Limits and Error Handling](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-49-do-until/): Build a Do Until loop that polls a status with a Delay, exits on equals(variables('Status'), 'done'), and respects the Count and Timeout limits - plus what really happens when an action inside the ... - [Sharing of Flows & Power Apps - Power Automate](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-48-sharing-of-flows-and-power-apps/): Easily share Power Automate flows and Power Apps with colleagues. Learn best practices for secure sharing, permissions, and collaboration in the Power Platform ecosystem. - [Power Apps Dynamic Form Schema: Add Controls on the Fly](https://www.powerplatformtip.com/article/powerplatform/2023/04/26/power-apps-dynamic-form-schema-add-controls/): Learn how to build dynamic forms in Power Apps without using the traditional Forms control. Create custom, schema-driven forms that can add controls on the fly. - [Batch-Method within SharePoint](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-47-batch-method-within-sharepoint/): Create, update or delete many SharePoint list items with one 'Send an HTTP request to SharePoint' call to the REST $batch endpoint instead of one action per item. With a complete batch body you can... - [PowerToys - Power Platform](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-46-powertoys/): Boost Power Platform productivity on Windows with Microsoft PowerToys. Learn how FancyZones, PowerToys Run, Keyboard Manager, Color Picker, Text Extractor, and Image Resizer streamline app developm... - [Use Scopes - Power Automate](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-45-use-scopes/): Organize Power Automate flows with Scopes for better error handling, flow management, and reusable templates. Enhance troubleshooting and structure. - [Calculate the Distance - Power Apps](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-44-calculate-distance/): Calculate accurate great-circle distances directly in your Power Platform app using the Haversine formula and a ready-made JSON snippet. - [With function - Power Apps](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-43-with-function/): Use the With function in PowerApps to group variable declarations and simplify complex formulas for improved code readability and maintainability. - [Dataverse Views for Canvas Apps: Server-Side Filtering](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-42-dataverse-views/): Use Dataverse Views for targeted filtering and improved performance in PowerApps. Push filters to the server for faster, more efficient apps. - [Dataverse Standard Tables: Account, Contact & More](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-41-standard-tables-in-dataverse/): Use standard tables in Dataverse for common business processes to ensure consistency, interoperability, and efficient data modeling. - [Delete Apps / Flows - Power Apps](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-40-delete-apps-flows/): Efficiently remove outdated test apps and flows in Power Platform by exporting and reimporting solutions. Declutter your workspace with bulk cleanup. - [FetchXML Queries in Dataverse & Dynamics 365](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-39-mastering-fetchxml/): Master FetchXML for advanced data queries in Dataverse and Dynamics 365. Retrieve complex data with powerful XML-based queries. - [Data Refresh - Power Apps](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-38-data-refresh/): Use a Boolean variable to selectively refresh PowerApps gallery data, improving performance and user experience without reloading all data. - [Table to JSON - Power Automate](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-37-table-to-json/): Convert two-column tables to JSON in Power Automate for easier data access. Use Parse JSON for efficient data transformation and automation. - [Static Result - Power Automate](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-36-static-result/): Use Static Result in Power Automate to simulate action outcomes during testing, preserve data, and speed up flow development. - [Concurrent Control - Power Automate](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-35-concurrent-control/): Enable Concurrency Control in Power Automate to run flows sequentially, prevent data duplication, and ensure data integrity. Optimize automation reliability. - [PowerApps V2](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-34-powerapps-v2/): Use the PowerApps V2 trigger in Power Automate for enhanced security, precise input control, and flexible flow management. Improve integration and automation. - [Power Apps Coalesce: Syntax & Examples](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-33-coalesce/): Coalesce in Power Apps returns the first non-blank value from a list – replace nested If(IsBlank()) checks with one function. Syntax, examples and the Power Automate equivalent. - [Optimize with GroupBy - Power Apps](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-32-use-groupby/): Optimize PowerApps performance by loading data once and using GroupBy for dependent filters. Reduce data loads and boost app speed. - [Free Power Platform Learning Resources: Training, Docs, Roadmap](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-31-microsoft-power-platform-learning-resources/): Which official, free resource answers which Power Platform question: Microsoft Learn training, product docs, connector reference, release plans, community and certifications. - [PowerApps: Code Review](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-30-powerapps-code-review/): Use App checker, solution checker and the PowerCAT Power Apps Review Tool to ensure high-quality, efficient Power Apps solutions. Improve performance and accessibility. - [ParseJSON Description - Power Automate](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-29-parsejson-description/): Add custom descriptions in Power Automate's Parse JSON action to organize and distinguish similar Dynamic Content entries. Improve flow clarity. - [Fast tips - Power Platform](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-28-fast-tips/): A personal shortcut to this tips collection, the official Microsoft maker and admin addresses worth bookmarking, and how to tell the two apart at a glance. - [Overwrite Existing Files in Power Automate (SharePoint)](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-27-overwrite-existing-files/): In the classic designer, switching off 'Allow Chunking' unlocked a hidden Overwrite toggle on SharePoint Create file. In the new designer there is no such toggle, and Create file replaces an existi... - [Microsoft Cloud Skills Challenge - Power Platform](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-26-microsoft-cloud-skills-challenge/): Boost your Power Platform skills with the Microsoft Cloud Skills Challenge - free, gamified Microsoft Learn modules with leaderboards and prizes. - [Weekly tips, insights and updates - Power Platform](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-25-weekly-tips-insights-and-updates/): Two community newsletters plus four official Microsoft sources that together keep you up to date on Power Platform features, releases and changes, in one fixed slot a week. - [Power Automate: Merge, Combine or Join Two Arrays (Keep Duplicates)](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-24-merge-arrays-or-tables/): How to merge or combine two arrays in Power Automate: union() for unique values, or the join-concat-split pattern to keep duplicates. Copy-paste expressions included. - [Merge Images in PowerApps Without Flow or Code Components](https://www.powerplatformtip.com/article/powerplatform/2023/01/29/merge-images-powerapps-without-flow/): A free canvas component that merges a photo with drawings, arrows and text into one SVG image, inside the app, without Power Automate, connectors or code components. - [Filter Blank - Power Apps](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-23-filter-blank/): Show all gallery items in PowerApps when filter input is blank using IsBlank in your filter logic. Improve user experience and data access. - [Change Fill & Color - Power Apps](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-22-change-fill-and-color/): Change fill and color across a PowerApps Canvas App by centralizing colors in a theme variable and using the formula editor's Find & Replace. - [Use Triggeroutput - Power Automate](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-21-use-triggeroutput/): Use triggerOutputs() in Power Automate to notify flow starters, extract header info, and handle errors for robust automation. - [How to Change a Power Automate Flow Owner (No Export/Import)](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-20-change-flow-owner/): Change a Power Automate flow owner in place by making it solution-aware. Avoid export/import and keep all connections and run history intact. - [Resize files - Power Automate](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-19-resize-files/): Easily resize large images in Power Automate using SharePoint thumbnails and file management actions. Streamline image processing and automation. - [Download & Save Files - Power Automate](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-18-download-and-save-files/): Download and save public or password-protected files in Power Automate using HTTP requests and file management actions. Ensure secure, automated file handling. - [Format data by example - Power Automate](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-17-format-data-by-example/): Master data formatting in Power Automate! Use 'Format data by example', or its Copilot successor, the expression assistant, to generate accurate expressions for dates, strings and numbers. - [PowerApps: Collections Cookbook](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-16-powerapps-collections-cookbook/): Access ready-to-use PowerApps collection code snippets with the Collections Cookbook. Enhance data manipulation and boost app development productivity. - [try-catch-finally - Power Automate](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-15-try-catch-finally/): Implement the try-catch-finally pattern in Power Automate with Scope actions and Configure run after for robust error handling, reliable flows, and guaranteed cleanup. - [Template Screens - Power Apps](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-14-template-screens/): Accelerate Power Apps development with pre-built template screens for common functions. Save time, boost productivity, and streamline app creation. - [PowerApps4Teams in make.powerapps.com](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-13-powerapps4teams-in-make-powerapps-com/): Edit PowerApps4Teams apps directly in make.powerapps.com using a URL hack. Save time and boost productivity by bypassing the standard Teams creation process. - [Components for PowerAutomate](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-12-components-for-powerautomate/): Boost productivity in Power Automate by saving and reusing scopes with the clipboard feature. Streamline flow development and ensure consistency. - [Trigger Condition - Power Automate](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-11-trigger-condition/): Create precise trigger conditions in Power Automate using Filter Array and advanced expressions to streamline your flow and boost efficiency. - [Use all variables in PowerApps](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-10-use-all-variables-in-powerapps/): Master all variable types in PowerApps: Go beyond Set and UpdateContext with With and Param for more dynamic, flexible app development. - [Test Your Flow Before Activation - Power Automate](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-9-powerautomate-preview/): Test Power Automate flows before activation: Use the built-in Test feature to catch errors early, improve reliability, and streamline flow development. - [Automate Backups & Restores for Flows, Apps & Solutions](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-8-automate-export-and-import-flows-powerapps-solutions/): Put your flows and apps in a solution, export it on a schedule with the Dataverse ExportSolution action and keep every .zip in SharePoint. Restore by importing the file, and know the built-in optio... - [Power Automate UNION & Filter Array - Merge and Deduplicate Data](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-7-union-and-filterarray/): Merge and filter arrays in Power Automate: Use UNION and FilterArray for efficient data manipulation, deduplication, and smarter workflows. - [formatDateTime in utcNow - Power Automate](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-6-formatdatetime-in-utcnow/): Format dates in Power Automate with utcNow: Skip extra functions, simplify flows, and boost efficiency with direct date formatting. - [Less Variables - Power Automate](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-5-less-variables/): Reduce variables in Power Automate by using Parse JSON or Compose for static parameters. Keep flows readable and loop concurrency intact, reserve variables for values that actually change. - [JSON Viewer - Power Automate](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-4-json-viewer/): Visualize and format JSON data in Power Automate using a browser extension. Simplify data handling, boost productivity, and make complex JSON easy to read. - [Advanced Filtering Array - Power Automate](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-3-advanced-filtering-array/): Unlock advanced filtering in Power Automate: Use Filter Array with custom expressions to streamline flows, boost accuracy, and optimize workflow performance. - [Transfer PowerApp Ownership - Power Apps](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-2-transfer-powerapp-ownership/): Transfer Power Apps ownership after a maker leaves, using the CoE Starter Kit admin apps or the Set-AdminPowerAppOwner PowerShell cmdlet. Keep apps governed and running. - [Explore Community Resources - Power Platform](https://www.powerplatformtip.com/article/powerplatformtip/powerplatformtip-1-explore-community-resources/): Discover the Microsoft Power Platform Community: Get expert support, find ready-to-use sample apps, and boost your productivity with shared resources and solutions. - [Extract an HTML Table from an Email in Power Automate](https://www.powerplatformtip.com/article/powerplatform/2022/11/10/extract-html-table-email-power-automate/): Reports, invoices and order confirmations often arrive as HTML tables buried in an email body. Damien Bird parses the HTML as XML and pulls out exactly the rows and columns needed with XPath - no r... - [How to Restore and Create a Backup from a Flow - Power Automate](https://www.powerplatformtip.com/article/powerplatform/2022/08/30/how-to-restore-create-backup-flow/): Safeguarding your workflows with Power Automate: Learn comprehensive methods to create and restore backups for your flows using solutions and direct flow management approaches. - [How to Load Multiple Data Sources into ONE Collection - Power Apps](https://www.powerplatformtip.com/article/powerplatform/2022/07/20/how-to-load-multiple-data-sources-into-one-collection/): Combine several data sources into one Power Apps collection with ClearCollect: what happens with different columns, how to align them with ShowColumns and RenameColumns, and how to add lookup data. - [Return an Array from Power Automate to Power Apps (No Premium)](https://www.powerplatformtip.com/article/powerplatform/2022/05/23/return-an-array-from-powerautomate-to-powerapps-split-method/): How to return an array from a Power Automate flow to Power Apps without premium connectors: send the array as one JSON text output and unpack it with ParseJSON. The classic Split method is still in... - [Run Power Apps Connections with Elevated Permissions via Power Automate](https://www.powerplatformtip.com/article/powerplatform/2022/05/18/power-apps-elevated-permissions-power-automate/): A flow's connections belong to whoever set them up, not to whoever triggers the flow. Reza Dorrani uses that to let end users create SharePoint items or Dataverse records they personally have no pe... - [How to Track the Current Progress of a Flow in PowerApps](https://www.powerplatformtip.com/article/powerplatform/2022/05/18/how-to-track-the-current-progress-of-a-flow-in-the-powerapp/): Learn how to track Power Automate flow progress in real-time within your PowerApps using a StateLog table and timer controls. Complete solution with downloadable example. - [Fill and Sign a Word Document Without Premium Connectors](https://www.powerplatformtip.com/article/powerplatform/2022/04/27/fill-and-sign-word-document-power-apps-automate/): Word documents are XML under the hood. Save the template as a Word XML Document, let a flow replace the placeholders and the signature image, and fill and sign a Word document from Power Apps witho... - [Power Apps OnKeyDown / OnKeyPress Workaround for Text Input](https://www.powerplatformtip.com/article/powerplatform/2022/04/20/implement-onkeydown-onkeypress-powerapps-text-input/): Discover ingenious workarounds for implementing keyboard event handling in PowerApps text inputs using creative control repurposing. Paulie M demonstrates innovative slider and toggle techniques. - [Power Automate Flows vs SharePoint Automate Rules: Which Is Faster?](https://www.powerplatformtip.com/article/powerplatform/2022/03/09/power-automate-flows-vs-automate-rules/): Explore the differences between Power Automate Flows and SharePoint Automate Rules. Daniel Christian analyzes performance implications and optimal use cases for each automation approach. - [How to Send a 1:1 Message via Power Automate in Teams: Direct Personal Messaging Solution](https://www.powerplatformtip.com/article/powerplatform/2021/10/13/send-1-1-message-flow-teams/): Learn how to send direct 1:1 messages via Power Automate in Microsoft Teams using your own account instead of the flow bot. Perfect for personal communication and support scenarios. - [Power Apps: Why Refresh() Is Killing Your App Performance](https://www.powerplatformtip.com/article/powerplatform/2021/08/23/power-apps-refresh-alternative-method-performance/): Refresh() reloads an entire data source. Paul O'Flaherty's alternative: use the record Patch() returns to update just what changed, and refresh only when other users or processes changed the data. - [Power Apps PDF Viewer for SharePoint Documents (No Flow Needed)](https://www.powerplatformtip.com/article/powerplatform/2021/06/11/powerapps-pdf-viewer-sharepoint-document-library/): A normal SharePoint document link opens the browser's file-preview UI, not a raw file - which breaks Power Apps' PDF Viewer control. Reza Dorrani's fix: rewrite the link to SharePoint's download.as... - [Build a Simple Multilingual Canvas App in 3 Steps - Power Apps](https://www.powerplatformtip.com/article/powerplatformtip/build-simple-multilingual-canvas-app-3-steps/): Make a canvas app multilingual without editing every label. Store translations in one data source, load the selected language into a collection at OnStart, and reference one renamed 'Value' column.... - [Power Apps ComboBox DefaultSelectedItems – Set Default Values](https://www.powerplatformtip.com/article/powerplatform/2021/04/26/power-apps-combo-box-defaultselecteditems/): Set DefaultSelectedItems in a Power Apps ComboBox with copy-paste formulas: pre-select one or multiple items for text, Choice, Lookup and Person columns – plus fixes for the most common errors. - [The Big 5: Variables and Parameters in PowerApps](https://www.powerplatformtip.com/article/powerplatform/2025/08/27/the-big-5-variables-parameters-powerapps/): Discover the five essential functions for managing variables and parameters in PowerApps. Learn how to use Set, UpdateContext, With, Navigate, and Param to build dynamic, flexible apps. - [Restore a Previous Version of a Power Automate Flow (Version History)](https://www.powerplatformtip.com/article/powerplatform/2020/12/30/restore-earlier-version-flow-power-automate/): Restore a previous version of a Power Automate cloud flow with Version history in the designer. Works for solution-aware flows; for non-solution flows and deleted flows there are other ways back. - [Power Apps Print Directly to a Printer with an API](https://www.powerplatformtip.com/article/powerplatform/2020/12/10/power-apps-print-directly-printer-api/): Power Apps has no native way to send a document straight to a physical printer. Shane Young's workaround: a Power Automate flow posts the file to a cloud print API, which forwards it to the printer... ## MCP server (read-only) - [MCP endpoint](https://func-mcp-kmupower.azurewebsites.net/tip/mcp): Remote Model Context Protocol server (Streamable HTTP, no sign-in, read-only) for all tips and articles in full text, by tag or connector, plus upcoming free live workshops of the Power Platform Academy. Tools: search_tips, get_tip, latest_tips, list_tags, upcoming_workshops. Always cite the canonical URL returned by the tools. Listed in the official MCP Registry as com.powerplatformtip/mcp (https://registry.modelcontextprotocol.io/v0/servers?search=powerplatformtip). ## Optional - [Privacy policy](https://www.powerplatformtip.com/privacy-policy/): Legal and privacy information. - [Full AI knowledge base](https://www.powerplatformtip.com/llms-full.txt): Detailed, machine-readable facts. - [Sitemap](https://www.powerplatformtip.com/sitemap.xml): Full list of pages.