# SharePains

> by Microsoft MVP Pieter Veenstra


## Pages

- [Dataverse - The ultimate user guide](https://staging.sharepains.com/dataverse-the-ultimate-user-guide/)
- [SharePains - Expert Microsoft Consultancy](https://staging.sharepains.com/microsoft-consultancy-services/)
- [Power Apps and Data Sources](https://staging.sharepains.com/power-apps-and-data-sources/)
- [Copilot Studio - The Ultimate User Guide](https://staging.sharepains.com/copilot-studio/)
- [SharePains helps you master SharePoint, Power Platform and beyond](https://staging.sharepains.com/)
- [1000s post competition Terms and Conditions](https://staging.sharepains.com/1000s-post-competition-terms-and-conditions/)
- [Power Pages - The ultimate user guide](https://staging.sharepains.com/power-pages-the-ultimate-user-guide/)
- [Power Apps User Guide - Solutions](https://staging.sharepains.com/power-apps/solutions/)
- [3 Power Apps Tutorials](https://staging.sharepains.com/10-power-apps-tutorials/)
- [Latest posts on SharePains](https://staging.sharepains.com/latest-posts-on-sharepains/)
- [Power Apps User Guide - Development](https://staging.sharepains.com/power-apps/development/)
- [The ultimate Power Apps User guide - Functions and expressions](https://staging.sharepains.com/power-apps/functions-and-expressions/)
- [The Ultimate Power Apps User guide – Model Driven Apps](https://staging.sharepains.com/power-apps/model-driven-apps/)
- [8 complete Power Automate Tutorials](https://staging.sharepains.com/power-automate/tutorials/)
- [SharePains by Pieter Veenstra](https://staging.sharepains.com/sharepains-by-pieter-veenstra/)
- [The ultimate Power Apps User guide – Power Automate Flows](https://staging.sharepains.com/power-apps/flows/)
- [The ultimate Power Apps User guide – Forms](https://staging.sharepains.com/power-apps/forms/)
- [The ultimate Power Apps User guide - components](https://staging.sharepains.com/power-apps/components/)
- [Power Apps, the ultimate user guide](https://staging.sharepains.com/power-apps-user-guide/)
- [The Ultimate Power Automate user guide - Power Automate Designer](https://staging.sharepains.com/power-automate/power-automate-designer/)
- [The Ultimate Power Automate guide – Administration](https://staging.sharepains.com/power-automate/administration/)
- [The Ultimate Power Automate guide – Functions and Expressions](https://staging.sharepains.com/power-automate/functions-and-expressions/)
- [SharePains Example Downloads](https://staging.sharepains.com/downloads/)
- [The ultimate Power Automate guide - Connections](https://staging.sharepains.com/power-automate/connections/)
- [The Ultimate Power Automate guide – Patterns](https://staging.sharepains.com/power-automate/patterns/)
- [The ultimate user guide to Power Automate - Custom Connectors](https://staging.sharepains.com/power-automate/custom-connectors/)
- [The ultimate guide to Power Automate Connectors](https://staging.sharepains.com/power-automate/connectors/)
- [The Ultimate Power Automate guide - Start flows](https://staging.sharepains.com/power-automate/start-flows/)
- [The Ultimate Power Automate guide - How to create flows](https://staging.sharepains.com/power-automate/create-flows/)
- [Get started with Power Automate](https://staging.sharepains.com/power-automate/get-started/)
- [The Ultimate Power Automate guide - Opinion Articles](https://staging.sharepains.com/power-automate/the-ultimate-power-automate-guide-opinion-articles/)
- [SharePains Privacy Policy](https://staging.sharepains.com/privacy-policy/)
- [Power Automate, the ultimate user guide!](https://staging.sharepains.com/power-automate-user-guide/)
- [Top Microsoft Technology blogs](https://staging.sharepains.com/top-microsoft-technology-blogs/)
- [Delivering Low Code Applications using Microsoft Flow and PowerApps](https://staging.sharepains.com/delivering-low-code-applications-using-microsoft-flow-and-powerapps/)
- [Share Your Microsoft Technology Challenges](https://staging.sharepains.com/share-your-pains/)
- [My Published Articles elsewhere...](https://staging.sharepains.com/my-published-articles-elsewhere/)
- [Contact SharePains today](https://staging.sharepains.com/contact-me/)
- [About the Author Pieter Veenstra](https://staging.sharepains.com/about/)


## Posts

- [Invoke an HTTP request and External Guest Users in Power Apps](https://staging.sharepains.com/2026/09/15/invoke-an-http-request-external-users-power-apps/)
- [Solution Layers Spaghetti Nightmares in the Power Platform](https://staging.sharepains.com/2026/08/29/solution-layers-in-the-power-platform/)
- [AI Skill Config in Power Platform](https://staging.sharepains.com/2026/08/11/ai-skill-config-in-power-platform/)
- [Bulk update records within a Dataverse table](https://staging.sharepains.com/2026/07/17/bulk-update-records-dataverse-table/)
- [How do I loop through each character in a string in Power Automate?](https://staging.sharepains.com/2026/06/26/loop-through-each-character-string/)
- [Create Generic Dataflows in Fabric and deployment pipelines](https://staging.sharepains.com/2026/06/23/generic-dataflows-fabric-deployment-pipelines/)
- [Understanding Power Automate flow performance](https://staging.sharepains.com/2026/05/22/power-automate-flow-performance/)
- [New Designer Run After Settings in Power Automate](https://staging.sharepains.com/2026/05/20/new-designer-run-after-settings/)
- [Power Platform and Tenant Level Analytics](https://staging.sharepains.com/2026/05/06/power-platform-tenant-level-analytics/)
- [Invisible Power Platform Connection References](https://staging.sharepains.com/2026/05/01/power-platform-connection-references/)
- [Variables inside Apply To Each steps in Power Automate](https://staging.sharepains.com/2026/04/29/variables-apply-to-each-power-automate/)
- [Block Unmanaged Customizations in Power Platform Environments](https://staging.sharepains.com/2026/04/16/block-unmanaged-customizations/)
- [Deployment and Rollback through Power Platform Solution Patches](https://staging.sharepains.com/2026/04/15/deployment-rollback-solution-patches/)
- [[REDACTED] message when turning on a Power Automate flow](https://staging.sharepains.com/2026/04/09/redacted-turning-on-power-automate-flow/)
- [Use Inventory to find your Power Automate flow?](https://staging.sharepains.com/2026/04/09/inventory-find-power-automate-flow/)
- [Bearer tokens, dataflows and Microsoft Fabric](https://staging.sharepains.com/2026/04/01/bearer-tokens-dataflows-and-microsoft-fabric/)
- [Copy and Paste in Power Automate Classic vs New UI](https://staging.sharepains.com/2026/03/03/copy-and-paste-power-automate-classic-vs-new-ui/)
- [5 Steps to Connect your Vibe Coded Apps with Git](https://staging.sharepains.com/2026/02/27/connect-your-vibe-coded-apps-with-git/)
- [Migrate SharePoint Site Designs and Scripts to a new Tenant](https://staging.sharepains.com/2026/02/24/migrate-sharepoint-site-designs-and-scripts-to-a-new-tenant/)
- [Connection references and permissions in Power Automate](https://staging.sharepains.com/2026/02/20/connection-references-power-automate/)
- [Use Copilot to rename controls in Power Apps](https://staging.sharepains.com/2026/02/20/copilot-rename-controls-power-apps/)
- [Show your environment name in Power Apps](https://staging.sharepains.com/2026/02/19/show-your-environment-name-in-power-apps/)
- [Vibe Coding in Power Apps - Is this something for you?](https://staging.sharepains.com/2026/02/13/vibe-coding-in-power-apps-is-this-something-for-you/)
- [Check if a file exists in SharePoint with Power Automate](https://staging.sharepains.com/2026/02/12/file-exists-sharepoint-power-automate/)
- [Create and update multiple items using Patch in Power Apps](https://staging.sharepains.com/2026/02/09/create-update-multiple-items-patch/)
- [ForAll Patch or just Patch in Power Apps](https://staging.sharepains.com/2026/02/06/forall-patch-or-just-patch-in-power-apps/)
- [Excel Filter Query on a Number Column in Power Automate](https://staging.sharepains.com/2026/02/04/excel-filter-query-on-a-number-column-in-power-automate/)
- [Custom menu components for navigation or a Toolbar control?](https://staging.sharepains.com/2026/02/03/toolbar-custom-menu-component-navigation/)
- [5 Dataverse Date Fields and the Date Picker in Canvas Apps](https://staging.sharepains.com/2026/01/29/dataverse-date-fields-date-picker-canvas/)
- [Modern Combo box limitations in Power Apps](https://staging.sharepains.com/2026/01/28/modern-combo-box-limitations-power-apps/)
- [Migrate from Classic Controls to Modern Controls in Power Apps](https://staging.sharepains.com/2026/01/27/migrate-classic-controls-modern-controls/)
- [Controls to set the visibility of other controls](https://staging.sharepains.com/2026/01/26/controls-visibility-other-controls/)
- [SharePoint Embedded - Your first steps](https://staging.sharepains.com/2026/01/23/sharepoint-embedded-your-first-steps/)
- [10 Best Practices for Developing Power Platform Solutions](https://staging.sharepains.com/2026/01/22/10-best-practices-for-developing-power-platform-solutions/)
- [Convert CSV files to JSON in Power Automate](https://staging.sharepains.com/2026/01/21/convert-csv-files-to-json-power-automate/)
- [3 reasons to use the new designer in Power Automate](https://staging.sharepains.com/2026/01/20/3-reasons-new-designer-in-power-automate/)
- [Agents flows and error handling](https://staging.sharepains.com/2026/01/19/agent-flow-and-error-handling/)
- [Create an agent with agent flows](https://staging.sharepains.com/2026/01/19/create-an-agent-with-agent-flows/)
- [Decimal dot or comma in Power Apps](https://staging.sharepains.com/2026/01/16/decimal-dot-or-comma-in-power-apps/)
- [Substring vs Slice in Power Automate](https://staging.sharepains.com/2026/01/16/substring-vs-slice-in-power-automate/)
- [Run a generative action in Power Automate](https://staging.sharepains.com/2026/01/15/run-a-generative-action-power-automate/)
- [Send community news by email using Power Automate](https://staging.sharepains.com/2026/01/15/send-community-news-email-power-automate/)
- [4 ways to filter data in Power Automate](https://staging.sharepains.com/2026/01/13/4-ways-to-filter-data-in-power-automate/)
- [CountRows, CountIf, CountA and Count in Power Apps](https://staging.sharepains.com/2026/01/08/countrows-countif-counta-power-apps/)
- [Organise UI Elements in Power Automate Desktop](https://staging.sharepains.com/2026/01/07/ui-elements-power-automate-desktop/)
- [15 Years of SharePains](https://staging.sharepains.com/2026/01/06/15-years-of-sharepains/)
- [3 approaches to reshape data in Power Automate Efficiently](https://staging.sharepains.com/2026/01/05/reshape-data-power-automate-efficiently/)
- [Your flow has a new trigger URL in Power Automate](https://staging.sharepains.com/2025/12/23/your-flow-has-a-new-trigger-url/)
- [Open an app in Power Automate Desktop](https://staging.sharepains.com/2025/12/22/open-an-app-in-power-automate-desktop/)
- [Power Platform environment variables, default vs current values](https://staging.sharepains.com/2025/12/19/power-platform-environment-variables-default-vs-current-values/)
- [Default retry settings in Power Automate](https://staging.sharepains.com/2025/12/18/default-retry-settings-in-power-automate/)
- [Compress photos in Power Automate](https://staging.sharepains.com/2025/12/17/compress-photos-in-power-automate/)
- [How to Vibe code yourself a Power App on vibe.powerapps.com](https://staging.sharepains.com/2025/12/16/vibe-code-power-app-vibe-powerapps-com/)
- [Create MS Graph subscriptions in Power Apps without Power Automate](https://staging.sharepains.com/2025/12/15/ms-graph-subscriptions-power-apps/)
- [Input and Output Parameters in Power Apps flows](https://staging.sharepains.com/2025/12/12/input-and-output-parameters-power-apps/)
- [Input and Output Parameters for Child Flows in Power Automate](https://staging.sharepains.com/2025/12/11/input-and-output-parameters-child-flows/)
- [5 fundamental Power Automate ideas that will make your flows better!](https://staging.sharepains.com/2025/12/10/power-automate-ideas-make-flows-better/)
- [Replace the Excel Online connector with the Microsoft Graph API in Power Automate](https://staging.sharepains.com/2025/12/09/excel-online-connector-microsoft-graph-api-power-automate/)
- [Automated Testing Power Apps - Controls and More](https://staging.sharepains.com/2025/11/26/automated-testing-power-apps-controls-and-more/)
- [Set the custom publisher on your Vibe coded Power Apps](https://staging.sharepains.com/2025/11/21/custom-publisher-vibe-coded-power-apps/)
- [The Scalability of Office Scripting in Microsoft Excel](https://staging.sharepains.com/2025/11/13/scalability-office-scripting-excel/)
- [Create custom error messages in Power Apps](https://staging.sharepains.com/2025/11/05/create-custom-error-messages-in-power-apps/)
- [UTCNow and that little hidden feature in Power Automate](https://staging.sharepains.com/2025/11/04/utcnow-hidden-feature-in-power-automate/)
- [7 Patterns for Offline Apps in Power Apps](https://staging.sharepains.com/2025/10/28/7-patterns-offline-apps-power-apps/)
- [How to use IfError in Power Apps](https://staging.sharepains.com/2025/10/22/how-to-use-iferror-in-power-apps/)
- [Connection.Connected in Power Apps](https://staging.sharepains.com/2025/10/16/connection-connected-in-power-apps/)
- [10 Types of For Loops Structures in Power Automate](https://staging.sharepains.com/2025/10/09/for-loops-structures-in-power-automate/)
- [Date Only vs User Local dates in the Power Platform](https://staging.sharepains.com/2025/10/01/date-only-user-local-power-platform/)
- [Handling Offline/Online with nested Patch functions in Power Apps](https://staging.sharepains.com/2025/09/30/handling-offline-online-with-nested-patch-functions-in-power-apps/)
- [How to create a Scheduled cloud flow in Power Automate?](https://staging.sharepains.com/2025/09/19/scheduled-cloud-flow-power-automate/)
- [2 Functions to set Context Variables in Power Apps](https://staging.sharepains.com/2025/09/18/2-functions-to-set-context-variables-in-power-apps/)
- [How to make your Excel connector retry in Power Automate](https://staging.sharepains.com/2025/09/15/excel-connector-retry-in-power-automate/)
- [Forms or Controls? That is the question in Power Apps](https://staging.sharepains.com/2025/09/09/forms-or-controls-in-power-apps/)
- [Asynchronous flows and Concurrency Control in Power Automate](https://staging.sharepains.com/2025/08/26/asynchronous-flows-concurrency-control/)
- [2 Actions to run script in Excel from Power Automate flows](https://staging.sharepains.com/2025/08/20/actions-run-script-excel-power-automate/)
- [Sort a collection by a date column in Power Apps](https://staging.sharepains.com/2025/08/15/sort-a-collection-date-column-power-apps/)
- [Create a clone command in Power Apps Model Driven Apps](https://staging.sharepains.com/2025/07/22/clone-command-model-driven-apps/)
- [Variables with Incompatible Type in Power Apps](https://staging.sharepains.com/2025/07/17/variables-incompatible-type-power-apps/)
- [Set vs ClearCollect in Power Apps](https://staging.sharepains.com/2025/07/14/set-vs-clearcollect-in-power-apps/)
- [An Unknown Error Occurred in an offline app in Power Apps](https://staging.sharepains.com/2025/07/11/power-apps-an-unknown-error-occurred/)
- [2 reasons for not using Named Formulas in Power Apps](https://staging.sharepains.com/2025/06/09/not-using-named-formulas-power-apps/)
- [The specified column 'X' does not exist. The column with the most similar name is 'X'](https://staging.sharepains.com/2025/06/05/the-specified-column-x-does-not-exist/)
- [Introduction to Managing a WordPress blog using Power Automate - Part 1](https://staging.sharepains.com/2025/05/30/managing-wordpress-blog-power-automate/)
- [Format Date columns in SharePoint](https://staging.sharepains.com/2025/05/28/format-date-columns-in-sharepoint/)
- [Does Copilot help us write good expressions in Power Apps?](https://staging.sharepains.com/2025/05/23/copilot-help-expressions-power-apps/)
- [When an Item is Deleted trigger is not triggering in Power Automate](https://staging.sharepains.com/2025/05/22/when-an-item-is-deleted-trigger/)
- [How to use the Azure AI Foundry connector in Power Apps](https://staging.sharepains.com/2025/05/22/azure-ai-foundry-connector-in-power-apps/)
- [How to use the Azure AI Foundry connector in Power Automate](https://staging.sharepains.com/2025/05/21/azure-ai-foundry-connector-powerautomate/)
- [How to avoid throttling in Power Automate](https://staging.sharepains.com/2025/05/15/how-to-avoid-throttling-power-automate/)
- [SharePoint Migration Tool, When things don't go 100% right!](https://staging.sharepains.com/2025/05/01/sharepoint-migration-tool-when-tools-fail/)
- [Power Apps Many to Many relationships in Canvas Apps](https://staging.sharepains.com/2025/04/08/many-to-many-relationships-power-apps/)
- [Using Large Excel files in Power Apps](https://staging.sharepains.com/2025/04/07/using-large-excel-files-in-power-apps/)
- [OnChange events in Power Apps](https://staging.sharepains.com/2025/03/09/onchange-events-in-power-apps/)
- [How to dynamically select properties in Power Apps](https://staging.sharepains.com/2025/03/04/dynamically-select-properties-power-apps/)
- [Variables in Copilot Studio](https://staging.sharepains.com/2025/02/20/variables-in-copilot-studio/)
- [Actions in Copilot Studio](https://staging.sharepains.com/2025/02/20/actions-in-copilot-studio/)
- [How to use Activities in Copilot Studio](https://staging.sharepains.com/2025/02/18/how-to-use-activities-in-copilot-studio/)
- [Get the Largest Divisor in Power Apps](https://staging.sharepains.com/2025/02/14/get-the-largest-divisor-in-power-apps/)
- [Allow management of Content Types on SharePoint Lists using Power Automate](https://staging.sharepains.com/2025/02/12/allow-management-of-content-types/)
- [1 Quick Tip - Think positive conditions in Power Automate](https://staging.sharepains.com/2025/02/11/think-positive-conditions-power-automate/)
- [Microsoft Releases Custom Power Fx Functions Feature for Power Automate](https://staging.sharepains.com/2025/02/10/custom-power-fx-functions-power-automate/)