Generated by Rank Math SEO, this is an llms.txt file designed to help LLMs better understand and index this website. # Pieter Veenstra at SharePains: Sharepains.com is a blog by Microsoft MVP Pieter Veenstra. This blog covers, SharePoint, Power Automate, Power Apps, Teams and other Microsoft products. ## Sitemaps [XML Sitemap](https://sharepains.com/sitemap_index.xml): Includes all crawlable and indexable pages. ## Posts - [AI Skill Config in Power Platform](https://sharepains.com/2026/08/11/ai-skill-config-in-power-platform/): This week I've been working with a client on creating tables within a solution. We found every now and then AI Skill Configs object being added randomly to our solution. - [Bulk update records within a Dataverse table](https://sharepains.com/2026/07/17/bulk-update-records-dataverse-table/): Earlier this week a question on Reddit started the idea of this post. You have a table in Dataverse then you add a new column and you want to bulk update this column for all existing records to a specific value. How would you approach this? - [How do I loop through each character in a string in Power Automate?](https://sharepains.com/2026/06/26/loop-through-each-character-string/): This morning on Reddit someone asked in the Power Automate community "How do I loop through each character in a string?". Well this isn't too complicated, although you would hope that a single action could do the job for you. The solution is slightly more complicated than that. - [Create Generic Dataflows in Fabric and deployment pipelines](https://sharepains.com/2026/06/23/generic-dataflows-fabric-deployment-pipelines/): When you implement multiple workspaces to support Development, Test, UAT and Production with Dataflows in Fabric then it is critical to make sure that you create generic Dataflows. Generic dataflows make it easy to deploy your dataflows between the various environments using deployment pipelines. - [Understanding Power Automate flow performance](https://sharepains.com/2026/05/22/power-automate-flow-performance/): In this post I'm looking at performance of Power Automate flows. For some flows this may not really matter too much, however when you have a need to high performance flows the findings in this post may be quite important. To make your flows perform well, it is important to understand where time is wasted. - [New Designer Run After Settings in Power Automate](https://sharepains.com/2026/05/20/new-designer-run-after-settings/): I will start this post with a warning about the New Designer Run After settings. The steps described in this post do not make it easier to understand what your flow will do. But I'm sure someone will comment on this post with a "That is exactly what I need" - [Power Platform and Tenant Level Analytics](https://sharepains.com/2026/05/06/power-platform-tenant-level-analytics/): Today I'm looking at the Tenant Level Analytics setting. The Power Platform Admin Center is getting more and more features that we would have used the Center of Excellence for in the past. Like the Inventory and Usage sections. The Tenant Level Analytics setting also enables some interesting insights into the usage of the Power Platform within your organisation. - [Invisible Power Platform Connection References](https://sharepains.com/2026/05/01/power-platform-connection-references/): On a Power Platform project with multiple developers Connections and Connection references can be tricky. You have some connection references added to a solution by a colleague, now you want to use these connection references and this is where the troubles start. - [Variables inside Apply To Each steps in Power Automate](https://sharepains.com/2026/04/29/variables-apply-to-each-power-automate/): For many years I've been saying, don't use variables in Power Automate as it hurts the flow's performance. Recently it was pointed out to me that variables don't lock Apply to Each loops. But is it safe to use variables in loops? - [Block Unmanaged Customizations in Power Platform Environments](https://sharepains.com/2026/04/16/block-unmanaged-customizations/): This post is all about how to block unmanaged customizations within production environments. I'm going to assume that you have followed the advice of creating a Development, Test, UAT and Production environment. And that each of these environments should be treated in a very different way. - [Deployment and Rollback through Power Platform Solution Patches](https://sharepains.com/2026/04/15/deployment-rollback-solution-patches/): Recently I needed to deploy parts of a solution to a test environment. I also had to be able to rollback the solution. Solution Patches within the Power Platform can help with this. In this post I'm looking at how Solution patches work. - [[REDACTED] message when turning on a Power Automate flow](https://sharepains.com/2026/04/09/redacted-turning-on-power-automate-flow/): We all like useful error messages. How about the Message when you turn on a flow? In this post you will find the steps to fix this issue. - [Use Inventory to find your Power Automate flow?](https://sharepains.com/2026/04/09/inventory-find-power-automate-flow/): Recently Microsoft added the Inventory to the Power Platform Admin Center. This is really worth a look. - [Bearer tokens, dataflows and Microsoft Fabric](https://sharepains.com/2026/04/01/bearer-tokens-dataflows-and-microsoft-fabric/): Recently I worked on a project using Microsoft Fabric where I needed to create a connection to an API that used Bearer tokens to access the data. In this post some of the challenges that I hit. - [Copy and Paste in Power Automate Classic vs New UI](https://sharepains.com/2026/03/03/copy-and-paste-power-automate-classic-vs-new-ui/): Copy and Paste has existed for a while in the classic Power Automate UI. With the new UI however there are a few additional features in this area worth to be aware of. - [5 Steps to Connect your Vibe Coded Apps with Git](https://sharepains.com/2026/02/27/connect-your-vibe-coded-apps-with-git/): Ok, Code Apps are hot at the moment. But which type of Code Apps are we talking about? Have you created your first Vibe Coded App through https://vibe.powerapps.com? Or did you use the Power platform CLI approach? - [Migrate SharePoint Site Designs and Scripts to a new Tenant](https://sharepains.com/2026/02/24/migrate-sharepoint-site-designs-and-scripts-to-a-new-tenant/): I was asked recently to migrate SharePoint site designs and site scripts to a new tenant. In this post all the steps including exporting the site designs and site scripts before importing them. All using PnP PowerShell. - [Connection references and permissions in Power Automate](https://sharepains.com/2026/02/20/connection-references-power-automate/): Have you ever battled with connection references in Power Automate? If not, you probably haven't worked on projects with multiple developers or you aren't using solutions to deploy your flows. In this post I'm covering how to deal with connections, connection references when you have multiple developers. - [Use Copilot to rename controls in Power Apps](https://sharepains.com/2026/02/20/copilot-rename-controls-power-apps/): Do you rename controls in Power Apps? Well of course you do! What if you have an app with many controls and they all use the out of the box names? It can becomes quite a task to name your controls properly. In this post the quick trick to get all controls renamed with Copilot within seconds. - [Show your environment name in Power Apps](https://sharepains.com/2026/02/19/show-your-environment-name-in-power-apps/): Do you use Dev, Test, UAT and Production environments within you Power Platform. Would you like to show your environment name in the app so that you don't get confused? In this post I'm showing you a quick trick to get the environment name to display in you app. - [Vibe Coding in Power Apps – Is this something for you?](https://sharepains.com/2026/02/13/vibe-coding-in-power-apps-is-this-something-for-you/): As a software developer, I like to have control over what I get. Does Vibe Coding give you what you expect? In this post I'm gong through some of the experiences that you might have had too. Will Power Apps Vibe coding work for you? - [Check if a file exists in SharePoint with Power Automate](https://sharepains.com/2026/02/12/file-exists-sharepoint-power-automate/): Sometimes it is useful to create small helper flows to get a small tasks done. Today I needed to check if a file exists or not and all I had was the URL of the site and the file path. - [Create and update multiple items using Patch in Power Apps](https://sharepains.com/2026/02/09/create-update-multiple-items-patch/): Following last week's post about using a single patch to replace Patch inside ForAll, I was asked about, how to not only update multiple items, but also create new items in SharePoint lists. Although this is not difficult, there is a small trick needed. In this post all the details. - [ForAll Patch or just Patch in Power Apps](https://sharepains.com/2026/02/06/forall-patch-or-just-patch-in-power-apps/): Yesterday, on Reddit I saw a question asked about Nesting a Patch inside a ForAll loop. Is a Patch function inside a ForAll loop, to update many records, the most efficient way to update your records? - [Excel Filter Query on a Number Column in Power Automate](https://sharepains.com/2026/02/04/excel-filter-query-on-a-number-column-in-power-automate/): A few years back I wrote a post about how to write a filter query for Excel in Power Automate. Today I found an issue with number columns in filter queries while working with a client on a flow. - [Custom menu components for navigation or a Toolbar control?](https://sharepains.com/2026/02/03/toolbar-custom-menu-component-navigation/): Toolbar or custom menu components? How do you develop your navigation controls in your app? During Power Apps projects I see many different ways clients have implemented navigation controls, in this post some of the options. I'm of course concluding with the easiest and most manageable way of getting your menus sorted out. - [5 Dataverse Date Fields and the Date Picker in Canvas Apps](https://sharepains.com/2026/01/29/dataverse-date-fields-date-picker-canvas/): Within Dataverse we can configure date fields in 5 different ways. When we use these fields in a Power Apps Canvas App they will behave slightly different. Today on the SharePains chat I was asked about the Modern Date Picker control and the Time Zone Independent setting. In this post I'm looking at all of the options. - [Modern Combo box limitations in Power Apps](https://sharepains.com/2026/01/28/modern-combo-box-limitations-power-apps/): Following my post about migrating from the Classic Controls to Modern Controls, today a bit of a closer look at the Modern Combo box. - [Migrate from Classic Controls to Modern Controls in Power Apps](https://sharepains.com/2026/01/27/migrate-classic-controls-modern-controls/): Have you considered moving you Canvas Apps from Classic Controls to Modern Controls? Unfortunately it isn't as easy as just replacing each control. In this post I'll help you find the matching controls and their properties. - [Controls to set the visibility of other controls](https://sharepains.com/2026/01/26/controls-visibility-other-controls/): Recently a few times I've been asked about how to make controls visible or invisible depending on the value selected in dropdowns, combo boxes and various other controls. In this post I'm going through the most common controls used for this. - [SharePoint Embedded – Your first steps](https://sharepains.com/2026/01/23/sharepoint-embedded-your-first-steps/): As the SharePoint Embedded connector was released last night, I thought it would be useful to start a series of posts about SharePoint Embedded within the Power Platform. - [10 Best Practices for Developing Power Platform Solutions](https://sharepains.com/2026/01/22/10-best-practices-for-developing-power-platform-solutions/): Why does Microsoft hide the best practices in the Power Platform? In this post I will go through some best practices that aren't always obvious to find. - [Convert CSV files to JSON in Power Automate](https://sharepains.com/2026/01/21/convert-csv-files-to-json-power-automate/): How do you convert CSV files to JSON? When you have data in CSV format and you want to use this within Power Automate, there used to be a lot of splitting by end of lines, commas and various other challenges. Nowadays, converting CSV files to JSON can be done in an easier way. - [3 reasons to use the new designer in Power Automate](https://sharepains.com/2026/01/20/3-reasons-new-designer-in-power-automate/): Hardly ever, I've seen a software change take so long for people to accept. How long will it be before developers just get on with as the new designer in Power Automate? Some people end up using it, but the majority of the experienced flow developers still use the old designer most of the time. - [Agents flows and error handling](https://sharepains.com/2026/01/19/agent-flow-and-error-handling/): Following my earlier post about creating an agent flow. I'm now writing about error handling in Agent Flows. How do we handle basic failures within agent flows? - [Create an agent with agent flows](https://sharepains.com/2026/01/19/create-an-agent-with-agent-flows/): If you're new to agent flows, this post will help you get started. I'll share more about agent flows in upcoming posts. - [Decimal dot or comma in Power Apps](https://sharepains.com/2026/01/16/decimal-dot-or-comma-in-power-apps/): How do you write 1,234.56? Do you have a decimal dot or a decimal comma? Well most likely this depends on where you live. How do you deal with this in Power Apps? - [Substring vs Slice in Power Automate](https://sharepains.com/2026/01/16/substring-vs-slice-in-power-automate/): Power Automate has quite a few string functions that can help you sort out textual issue. Two of these functions are Substring and Slice. Do you know the difference? - [Run a generative action in Power Automate](https://sharepains.com/2026/01/15/run-a-generative-action-power-automate/): Recently the Run a generative action was added to Power Automate. To make this action work is not as easy as you might hope. - [Send community news by email using Power Automate](https://sharepains.com/2026/01/15/send-community-news-email-power-automate/): Yesterday on Reddit I was asked about how to collect and send community news articles from websites using Power Automate so that news letters can be sent out to colleagues. Of course my initial response was to get some AI to do the trick. And Power Automate has that useful Run a prompt action for this - [4 ways to filter data in Power Automate](https://sharepains.com/2026/01/13/4-ways-to-filter-data-in-power-automate/): Yesterday, I looked at how to filter data when making an API call using the HTTP action and noticed that filtering data isn't always straight forward. In this post, you will find the details on how to filter data in Power Automate. - [CountRows, CountIf, CountA and Count in Power Apps](https://sharepains.com/2026/01/08/countrows-countif-counta-power-apps/): How often would you like to count the number of records without really wanting to load all the records that exist in a list or table. CountRows, CountIf, CountA and Count are four functions to get a record count in Power Apps. In this post you will find the best ways to get your record count. - [Organise UI Elements in Power Automate Desktop](https://sharepains.com/2026/01/07/ui-elements-power-automate-desktop/): In recent months, I have begun using Power Automate Desktop for automated testing within Power Apps. In this post I will have a look at how we can organise UI elements in our PAD flow a bit better. - [15 Years of SharePains](https://sharepains.com/2026/01/06/15-years-of-sharepains/): At the end of 2025, I already announced on LinkedIn that SharePains.com is 15 years old. After nearly 1100 posts about Microsoft Tech in 15 years, it is time to celebrate. - [3 approaches to reshape data in Power Automate Efficiently](https://sharepains.com/2026/01/05/reshape-data-power-automate-efficiently/): Earlier this week I was asked to reshape data in Power Automate. Having an array of data that needs to be reshaped just sot that an API can take the data can be tricky. So often I find clients using the Append to array action inside an apply to each. Now if your array only has a few records it probably doesn't matter too much but what if you have 1000s of records? - [Your flow has a new trigger URL in Power Automate](https://sharepains.com/2025/12/23/your-flow-has-a-new-trigger-url/): Recently I've been receiving email reporting Your flow has a new trigger URL. In this post I will address this issue and how to avoid your flows breaking. - [Open an app in Power Automate Desktop](https://sharepains.com/2025/12/22/open-an-app-in-power-automate-desktop/): When you open an app in Power Automate Desktop, and you need to run this Power Automate Desktop flow multiple times it becomes important to handle the multiple instances of your browser. In this post the steps to make this work for you. - [Power Platform environment variables, default vs current values](https://sharepains.com/2025/12/19/power-platform-environment-variables-default-vs-current-values/): When you use multiple environments (and you always should do) in the Power Platform, then it is almost impossible to avoid environment variables. Each environment variable can have default and current values. What is the difference between default and current? - [Default retry settings in Power Automate](https://sharepains.com/2025/12/18/default-retry-settings-in-power-automate/): When actions in Power Automate flows go wrong, they may rerun depending on the failure occurred. One of the errors that may trigger is the 429 Error that is reported when there are throttling issues - [Compress photos in Power Automate](https://sharepains.com/2025/12/17/compress-photos-in-power-automate/): One of my clients, takes many photos as part of their data entry process using a Canvas app. We need to compress the photos as the collected data, including the photos, is used to generate a PDF. This PDF generation was timing out every now and then. - [How to Vibe code yourself a Power App on vibe.powerapps.com](https://sharepains.com/2025/12/16/vibe-code-power-app-vibe-powerapps-com/): Recently Microsoft released a new way of developing apps within the Power Platform on vibe.powerapps.com. In this post, I will look at different approaches to vibe coding, the challenges and how to resolve them. - [Create MS Graph subscriptions in Power Apps without Power Automate](https://sharepains.com/2025/12/15/ms-graph-subscriptions-power-apps/): A while back I wrote a post about MS Graph subscriptions in Power Automate. Today I managed to do this directly within Power Apps. - [Input and Output Parameters in Power Apps flows](https://sharepains.com/2025/12/12/input-and-output-parameters-power-apps/): Following on from yesterday's post about Input and Output Parameters in Power Automate, today I'm looking at the same for flows that are called from a Power Apps canvas app. We will find that child flows and flows called from an app are very different. - [Input and Output Parameters for Child Flows in Power Automate](https://sharepains.com/2025/12/11/input-and-output-parameters-child-flows/): In this post, I will look at the input and output parameter types for child flows. Recently I hit a couple of small issues with the various data types that are worth sharing. - [5 fundamental Power Automate ideas that will make your flows better!](https://sharepains.com/2025/12/10/power-automate-ideas-make-flows-better/): It's time to have a look at some of my older posts. In this post I'm going to have another look at these Power Automate ideas. Back in 2017/2018 when Power Automate was still called Microsoft Flow, I wrote 100s of posts about developing flows. How many of these ideas do you still use now? - [Replace the Excel Online connector with the Microsoft Graph API in Power Automate](https://sharepains.com/2025/12/09/excel-online-connector-microsoft-graph-api-power-automate/): If you have worked with the Excel Online connector in Power Automate then you will most likely know the pains of this connector. In this post I'm giving an easy way to replace the connector with the much more reliable Microsoft Graph API alternative. - [Automated Testing Power Apps – Controls and More](https://sharepains.com/2025/11/26/automated-testing-power-apps-controls-and-more/): A while back I wrote an introduction post about automated testing Power Apps using Power Automate Desktop. Today, I'm going to look at automated testing in more detail focussing on the various controls available. - [Set the custom publisher on your Vibe coded Power Apps](https://sharepains.com/2025/11/21/custom-publisher-vibe-coded-power-apps/): Have you tried out the new Vibe coding at vibe.powerapps.com? Did you notice that your solutions will use the default publisher? - [The Scalability of Office Scripting in Microsoft Excel](https://sharepains.com/2025/11/13/scalability-office-scripting-excel/): Today's post is all about the scalability of Office Scripting in Microsoft Excel using the Run Script action in Power Automate. Do you know the limitations for solutions based on Office Scripting? - [Create custom error messages in Power Apps](https://sharepains.com/2025/11/05/create-custom-error-messages-in-power-apps/): We've all seen those error messages that don't make any sense. Have you ever wanted to replace an error messages with your own custom error messages? - [UTCNow and that little hidden feature in Power Automate](https://sharepains.com/2025/11/04/utcnow-hidden-feature-in-power-automate/): If you have been following my posts on SharePains.com, then you will know about the UTCNow function generating the current UTC time. But did you know that there is a hidden parameter that comes with this function? - [7 Patterns for Offline Apps in Power Apps](https://sharepains.com/2025/10/28/7-patterns-offline-apps-power-apps/): For apps it can be important to handle situations where you don't have a connection. These Offline Apps need to work, without losing any functionality while you are offline. - [How to use IfError in Power Apps](https://sharepains.com/2025/10/22/how-to-use-iferror-in-power-apps/): IfError is a function in Power Apps to handle expected and unexpected errors in your code. There are however, a few issues you may run into if you don't exactly know how this function works. - [Connection.Connected in Power Apps](https://sharepains.com/2025/10/16/connection-connected-in-power-apps/): Anybody ever had problems with Connection.Connected in Power Apps? Connection.Connected is a piece of code in Power Apps that helps you identify if you are online or not. But what if it doesn't work? - [10 Types of For Loops Structures in Power Automate](https://sharepains.com/2025/10/09/for-loops-structures-in-power-automate/): For loops are one of the basic structures in coding. There are however many different types of loops. How can we implement various types of loops that we know in languages like Python in Power Automate an Power Apps? In this post you will find the Power Automate loops. - [Date Only vs User Local dates in the Power Platform](https://sharepains.com/2025/10/01/date-only-user-local-power-platform/): In this post I'm looking at Date Only vs User Local dates in Dataverse and how this may affect your solutions in the Power Platform. Have you ever had a date appear in Power Automate as a day out? - [Handling Offline/Online with nested Patch functions in Power Apps](https://sharepains.com/2025/09/30/handling-offline-online-with-nested-patch-functions-in-power-apps/): So you developed an app that handles offline and online using LoadData and SaveData, and then you come across this weird behaviour where screens are cleared out. This is exactly what happened to me with an inherited app. - [How to create a Scheduled cloud flow in Power Automate?](https://sharepains.com/2025/09/19/scheduled-cloud-flow-power-automate/): Am I going back to the real basics of Power Automate? No not really. Have you ever tried to create a scheduled cloud flow as part a solution, while your flows shouldn't trigger at the same time? - [2 Functions to set Context Variables in Power Apps](https://sharepains.com/2025/09/18/2-functions-to-set-context-variables-in-power-apps/): Do you know how to set Context variables in Power Apps? I thought, I did as well. But I had forgotten that there are two ways to set context variables. In this post further details. - [How to make your Excel connector retry in Power Automate](https://sharepains.com/2025/09/15/excel-connector-retry-in-power-automate/): Last week, I came across an issue with actions failing in the Excel connector. Making try Excel Connector retry actions, was slightly harder than expected. - [Forms or Controls? That is the question in Power Apps](https://sharepains.com/2025/09/09/forms-or-controls-in-power-apps/): I get often asked, should I use Forms or Controls in Power Apps for data entry. This question can be answered either way. But do you know why you should pick on or the other? What's the difference anyway? - [Asynchronous flows and Concurrency Control in Power Automate](https://sharepains.com/2025/08/26/asynchronous-flows-concurrency-control/): In this post I will look at Asynchronous flows vs Synchronous flows, Concurrency controls and multiple response actions in Power Automate flows. Last week a few updates were added to the Respond to a Power App or flow action read this post for further details. - [2 Actions to run script in Excel from Power Automate flows](https://sharepains.com/2025/08/20/actions-run-script-excel-power-automate/): Within Power Automate, it has been possible to run scripts in Excel using the Run Script actions. Did you know that the is a Run Scripts from SharePoint library action too? - [Sort a collection by a date column in Power Apps](https://sharepains.com/2025/08/15/sort-a-collection-date-column-power-apps/): Recently I came across a Power Apps solution that needed to sort a collection by a date column. In this post the pains of sorting by date fields and how to work around them. - [Create a clone command in Power Apps Model Driven Apps](https://sharepains.com/2025/07/22/clone-command-model-driven-apps/): In Power Apps you can create custom commands in your views when developing Model Driven Apps. In this post I'm looking at how you can develop a clone command button to clone records in specific tables. - [Variables with Incompatible Type in Power Apps](https://sharepains.com/2025/07/17/variables-incompatible-type-power-apps/): Last week, one of the issues I ran into as I re-engineered an app, I suddenly ended up with my Power Apps Studio complaining about 100s of incompatible types. - [Set vs ClearCollect in Power Apps](https://sharepains.com/2025/07/14/set-vs-clearcollect-in-power-apps/): Last week, I came across a bug in an app that got me confused for a while. When you set a variable to a collection of records, you might find this behaviour too. At least it is good to be aware of this maybe unexpected behaviour. - [An Unknown Error Occurred in an offline app in Power Apps](https://sharepains.com/2025/07/11/power-apps-an-unknown-error-occurred/): This week I spent a lot of time working on an app that had offline functionality half implemented. I got the error "An Unknown Error Occurred.", and that was all I got. - [2 reasons for not using Named Formulas in Power Apps](https://sharepains.com/2025/06/09/not-using-named-formulas-power-apps/): When Named Formulas first came out, I very much liked the idea of using them. However, I have found that there are a few reasons for not using them. - [The specified column ‘X’ does not exist. The column with the most similar name is ‘X’](https://sharepains.com/2025/06/05/the-specified-column-x-does-not-exist/): Today I came across the following error message: The specified column 'X' does not exist. The column with the most similar name is 'X'. This sounds like nonsense! - [Introduction to Managing a WordPress blog using Power Automate – Part 1](https://sharepains.com/2025/05/30/managing-wordpress-blog-power-automate/): My WordPress blog SharePains.com has been running on WordPress for a very long time now, and with so many posts it is a real challenge to make sure that there aren't any broken links and other issues in any of the posts. - [Format Date columns in SharePoint](https://sharepains.com/2025/05/28/format-date-columns-in-sharepoint/): Column formatting in SharePoint has been around for a while but today I was asked about making how to format date columns to appear appear like yyyy-MM-dd. - [Does Copilot help us write good expressions in Power Apps?](https://sharepains.com/2025/05/23/copilot-help-expressions-power-apps/): It is Friday and I thought to get the weekend started I try-out Copilot to generate an expression for me. When using Copilot it is so easy to switch your brain off. - [When an Item is Deleted trigger is not triggering in Power Automate](https://sharepains.com/2025/05/22/when-an-item-is-deleted-trigger/): Today Connor and I found that a flow with the When an Item is deleted, was not being triggered. Why could this possibly happen? - [How to use the Azure AI Foundry connector in Power Apps](https://sharepains.com/2025/05/22/azure-ai-foundry-connector-in-power-apps/): Yesterday I looked at how to use the Azure AI Foundry connector in Power Automate today I'm doing the same within Power Apps, creating a Q&A app using GPT 4.1. - [How to use the Azure AI Foundry connector in Power Automate](https://sharepains.com/2025/05/21/azure-ai-foundry-connector-powerautomate/): Today I had a look into the Azure AI Foundry connector in Power Automate. My findings on this connector are in the post below. - [How to avoid throttling in Power Automate](https://sharepains.com/2025/05/15/how-to-avoid-throttling-power-automate/): It's quite an old problem, when you use Power Automate for many connectors when you push them hard enough you will get throttled. How do we avoid throttling from happening. - [SharePoint Migration Tool, When things don’t go 100% right!](https://sharepains.com/2025/05/01/sharepoint-migration-tool-when-tools-fail/): Quite a while ago I wrote an introduction post about the SharePoint Migration Tool. Recently I found myself doing a couple of migrations and found some issues that are easily resolved. In this post all the details. - [Power Apps Many to Many relationships in Canvas Apps](https://sharepains.com/2025/04/08/many-to-many-relationships-power-apps/): Many to Many relationships can be painful in Canvas Apps . In this post I'm looking at how we can work with many to many relationships in Power Apps. I will cover the creation of the relationships, updating the relationships and querying the relationships. - [Using Large Excel files in Power Apps](https://sharepains.com/2025/04/07/using-large-excel-files-in-power-apps/): We all know that Excel isn't a good place to store your Power Apps data in. Still way to often developers use large Excel files for their Power apps data. But why is Excel not a good data source? Why do people still use it? And why are Excel files supported as datasources in Power apps? What are the limitations that we need to consider? - [OnChange events in Power Apps](https://sharepains.com/2025/03/09/onchange-events-in-power-apps/): What can be easier than the OnChange event in Power Apps? When a user selects or types a new value for a control we can configure our app to do something. But what if that OnChange event triggers at the wrong time? - [How to dynamically select properties in Power Apps](https://sharepains.com/2025/03/04/dynamically-select-properties-power-apps/): In Power Apps there is sometimes a need to select a property dynamically. You get the name of the property from ,for example, a dropdown, and now you want to retrieve the value of that property in a record. - [Variables in Copilot Studio](https://sharepains.com/2025/02/20/variables-in-copilot-studio/): In the my previous posts about Copilot Studio, I've already had a look at Variables and how to work with variables. However it will be useful to take this a bit further. In this post I'm looking at all the things you can do with variables in Copilot Studio. - [Actions in Copilot Studio](https://sharepains.com/2025/02/20/actions-in-copilot-studio/): After yesterday's post about Activities in Copilot Studio, today I'm looking at Actions in Copilot Studio. The terminology here is confusing for Power Automate users. - [How to use Activities in Copilot Studio](https://sharepains.com/2025/02/18/how-to-use-activities-in-copilot-studio/): After looking at Triggers in Copilot Studio a few weeks ago, I'm taking the next step in this post. Activities in Copilot Studio. - [Get the Largest Divisor in Power Apps](https://sharepains.com/2025/02/14/get-the-largest-divisor-in-power-apps/): Last week I someone ask me about calculating the largest divisor for a number within Power Apps. This had to be fast! With the right approach, this is easy to do. - [Allow management of Content Types on SharePoint Lists using Power Automate](https://sharepains.com/2025/02/12/allow-management-of-content-types/): Within SharePoint there is the option to allow management of content types. But how do you manage this setting within Power Automate? - [1 Quick Tip – Think positive conditions in Power Automate](https://sharepains.com/2025/02/11/think-positive-conditions-power-automate/): This is a quick tip blog post about Power Automate conditions in Power Automate. With the new(?) development UI, it is important to think positive. - [Microsoft Releases Custom Power Fx Functions Feature for Power Automate](https://sharepains.com/2025/02/10/custom-power-fx-functions-power-automate/): Today Microsoft released custom Power Fx functions to support reusable code within Power Automate. In this post how to create and use these custom functions. - [Create your Copilot agent and add it to Microsoft Teams](https://sharepains.com/2025/02/07/create-copilot-agent-add-microsoft-teams/): In my last few posts, I've looked at creating an Copilot agent. Now the next step is to put the agent somewhere useful. In this post I'll create a basic agent and add it to Microsoft Teams. - [Trigger your Topics in Copilot Studio](https://sharepains.com/2025/02/06/trigger-your-topics-in-copilot-studio/): After yesterday's general introduction into developing agents in Copilot Studio. Today I will have a look at the first step of topics, triggers. - [Get started with Copilot Studio](https://sharepains.com/2025/02/05/get-started-with-copilot-studio/): To get started with Copilot Studio is easy visit https://copilotstudio.microsoft.com/ and we are ready to get started with the creation of our first Agent. - [Use Power Automate Connector Actions directly from Power Apps](https://sharepains.com/2025/01/30/connector-actions-power-apps/): Often people create flows to call Microsoft Graph end points or Approval from within Power Apps rather than "Power Automate connector actions" from within Power Apps. - [Use Microsoft 365 Self-Help connector instead of Microsoft support](https://sharepains.com/2025/01/29/microsoft-365-self-help-connector/): Microsoft has released a new connector in Preview. The Microsoft 365 Self-Help connector can now be used in a Power Automate flow. - [Restore deleted flows in Power Automate](https://sharepains.com/2025/01/28/restore-deleted-flows-in-power-automate/): Now, it might happen to all of us. We delete a flow in Power Automate and then there is this oops moment. How do I restore deleted flows? - [6 Essential Data Strategies for Success in the Power Platform](https://sharepains.com/2025/01/21/data-strategies-power-platform/): I'm very often asked, where should I store my data? Most of the time data strategies include one or more of the following: - SharePoint - Dataverse - SQL - Excel In this post 6 data strategies that you could consider before you design your next app. - [Using Power Automate Desktop to do automated testing for Power Apps](https://sharepains.com/2025/01/14/power-automate-desktop-automated-testing-power-apps/): Power Apps studio includes test tools, however these are not available when you use co-authoring. So how about automated testing your Canvas Apps using Power Automate Desktop? - [HTTP vs Send an HTTP Request in Power Automate](https://sharepains.com/2025/01/09/send-an-http-request-in-power-automate/): HTTP vs Send an HTTP Request in Power Automate One of my favourite actions in Power Automate is the HTTP action. However it is premium, while for a lot of the Graph API endpoints there are standard actions available. - [Create an Avatar with presence status indicator in Power Apps](https://sharepains.com/2025/01/07/avatar-presence-status-indicator-power-apps/): How can we get the modern Avatar control to use the Microsoft Teams' presence to set its status indicator? One of the modern controls is the Avatar Control. This control includes a badge property that allows you to indicate the user's current presence status. However, this feature is not automatically connected to the user's Teams status. In this post, we will explore how to integrate Microsoft Teams presence status into the Avatar control, ensuring it accurately reflects the user's availability. - [User Defined Types in Power Apps](https://sharepains.com/2024/12/16/user-defined-types-in-power-apps/): Recently I already mentioned Named Formulas and User Defined Functions in my posts. Today I'm looking at User Defined Types. - [SQL Functions for Encrypting and Decrypting Large text fields](https://sharepains.com/2024/12/13/encrypt-decrypt-functions-sql-large-text/): After my post about Encrypting Rich Text fields in Power Apps that store their data in SQL server now the promised decryption code in this post as well. - [Encrypt a large rich text field in SQL Stored Procedures](https://sharepains.com/2024/12/11/encrypt-rich-text-sql-stored-procedures/): Recently I have done a lot of work with SQL Stored Procedures in Power Apps. But what do you do if you want to have some fields encrypted in your SQL database. In this post how to Encrypt and decrypt using stored procedures. - [Weird date handling in Power Apps](https://sharepains.com/2024/12/06/weird-date-handling-in-power-apps/): This is a typical post on a Friday afternoon, about weird date handling in Power Apps. But understanding this issue will help in many situations. - [When an item is created vs When an item is created or modified](https://sharepains.com/2024/11/27/when-an-item-is-created-or-modified/): As part of my SharePoint connector series, I had a look at the When an item is created and the When an item is created or modified triggers in this post. - [SQL Stored Procedures in Power Apps and the maximum data row limit](https://sharepains.com/2024/11/18/sql-stored-procedures-power-apps-data-row-limit/): With connectors in Power Apps we can collect 2000 items at a time when we read data from lists and libraries. However with SQL Stored Procedures in Power Apps we have an option to avoid this limit! - [How to develop business critical applications in Microsoft Excel?](https://sharepains.com/2024/11/01/business-critical-applications-excel/): Recently I have spoken with quite a few organisation who are interested in Microsoft 365, about business critical applications developed in Microsoft Excel. Quite a high percentage of organisations seem to run on Excel. - [5 Best Practices for Power Apps Named Formulas](https://sharepains.com/2024/10/22/best-practices-named-formulas-power-apps/): Quite a few of my recent posts have been about Power Apps named formulas. In this post I'm going through some of the best practices. - [Compare multi-select people fields in Power Apps](https://sharepains.com/2024/10/10/compare-multi-select-people-fields/): Yesterday, I needed to compare the values of two collections with people records. In this posts the details on how to compare multi-select people fields. - [Type cast tables coming from SQL Server stored procedures in Power Apps](https://sharepains.com/2024/09/12/type-cast-tables-stored-procedures/): A new feature in Power Apps is SQL Stored Procedures that can be called directly form the Power App. This will give you an UnTypedObject, but how do we type cast Tables? In this post the slow and the fast way. - [This app ran into a problem in Power Apps](https://sharepains.com/2024/09/11/this-app-ran-into-a-problem-in-power-apps/): Today, one of my client's app showed the This app ran into a problem error. - [User Defined Functions vs Named Formulas in Power Apps](https://sharepains.com/2024/09/02/user-defined-functions-named-formulas/): Microsoft recently released User Defined Functions in Preview. In this post I'm going to compare User Defined Functions with Named Formulas. - [How to use Named Formulas in Power Apps](https://sharepains.com/2024/08/22/how-to-use-named-formulas-in-power-apps/): Named Formulas were recently introduced into Power Apps. They can be great, but they do have a bit of a user guide. - [The Visible property in forms in Power Apps](https://sharepains.com/2024/08/20/visible-property-in-forms-in-power-apps/): Recently I came across a bit of a weird behaviour in Power Apps where the Visible property of a data card and a DataCardValue control's Visible property was giving me false values while fields were shown within forms in my app. - [1000th blog post on SharePains.com](https://sharepains.com/2024/07/18/1000th-blog-post-on-sharepains-com/): A couple of weeks ago I announced that the 1000th blog post on SharePains.com was on its way! Well, you are looking at this post now. - [Time to celebrate my 7th Microsoft MVP award](https://sharepains.com/2024/07/10/celebrate-my-7th-microsoft-mvp-award/): I just received that email for the 7th time confirming my 7th Microsoft MVP award. Every year it is that MVP Buzz confirming the renewal (or not). - [Dates in Dataverse written by Power Apps and read using Power Automate](https://sharepains.com/2024/06/26/dates-in-dataverse-power-apps-power-automate/): Dates in Dataverse used by Power Apps and Power Automate can cause all sorts of challenges. How often have you had a date being an hour out from what you expect them to be? - [It is time to win! Nearly 1000 blog posts on SharePains.com](https://sharepains.com/2024/06/19/it-is-time-to-win-nearly-1000-blog-posts-on-sharepains-com/): In the last 15 years, I've nearly written nearly 1000 blogs posts about Microsoft technology. So, it is time for a competition on https://sharepains.com/. - [Set SharePoint Item-Level Permissions using Power Automate](https://sharepains.com/2024/06/11/sharepoint-item-level-permissions-power-automate/): In this post I'm going through the steps to update SharePoint Item-level permissions using Power Automate and The SharePoint Rest API. - [Fast performing nested galleries with Named Formulas in Power Apps](https://sharepains.com/2024/06/11/nested-galleries-named-formulas-power-apps/): For a long time it has been struggle to have nested galleries when you have high volume of data. But not with Named Formulas in Power apps. - [Code after the navigate function in Canvas Power Apps](https://sharepains.com/2024/06/05/code-after-the-navigate-function-canvas-apps/): Within Canvas Apps it is quite common to navigate from one screen to another screen. During app health checks I often find code after the navigate function. Is this a good idea? Or do we need to be careful? - [Make use of Dataverse Views in Canvas Apps](https://sharepains.com/2024/06/03/use-dataverse-views-in-canvas-apps/): When you create model driven apps you would expect to create Dataverse views to display your data, but how about Canvas apps? In this post an easy way to create a dropdown to control your data in your galleries. - [Do until in the new Power Automate Designer](https://sharepains.com/2024/05/29/do-until-new-power-automate-designer/): The new Power Automate designer is getting a lot of negative attention. There are however a quite a few improvements in new Power Automate Designer. The Do Until step is one of those improvements in the new UI. - [Preferred solution in the Power Platform](https://sharepains.com/2024/05/21/preferred-solution-in-the-power-platform/): Recently Microsoft released the preferred solution feature in Power Apps and Power Automate. But how does the Preferred solution configuration work? - [Is it time to switch to the new Power Automate Designer UI?](https://sharepains.com/2024/05/16/the-new-power-automate-designer-ui/): I have been hesitant to move to the new Power Automate Designer UI, but is it maybe time to give that new UI a new try? - [When a file is created or modified trigger in the new Power Automate Designer](https://sharepains.com/2024/05/08/when-a-file-is-created-or-modified/): When you use the When a file is created or modified trigger in Power Automate you had no control over how often the flow would check for new items. With the new Power Automate Designer that is now changing! - [The Header Control in Power Apps](https://sharepains.com/2024/05/03/the-header-control-in-power-apps/): In this post I'm looking at the modern Header control available Within Power Apps - [Version history in Power Automate flows](https://sharepains.com/2024/04/26/version-history-in-power-automate-flows/): When you create flows in solutions in Power Automate using the new Power Automate Studio, then you will have noticed the new Version history option. In this post all the information you need to get started with version history in Power Automate. - [Introducing 8 AI Functions for Dataverse in Power Apps](https://sharepains.com/2024/04/24/introducing-8-ai-functions-for-dataverse-in-power-apps/): Recently Microsoft added AI Functions to Dataverse that can be used in Power Apps. In this post all the steps needed to take advantage of these AI functions. - [Copy and paste Scope steps in the new Power Automate Designer](https://sharepains.com/2024/04/17/copy-and-paste-scope-power-automate/): One of the outstanding issues with the new Power Automate Designer is Copy and Paste for Scope steps and other steps that can contain multiple actions. - [Receive the available storage within your SharePoint Online tenant](https://sharepains.com/2024/03/26/receive-the-available-storage-within-your-sharepoint-online-tenant/): Within the SharePoint admin centre there is that little detailed overview, telling you the available storage out of your total storage. But how do you get that without visiting the SharePoint Admin Centre every day? - [Options for Documenting Your Power Apps: Comments, Code, and Controls](https://sharepains.com/2024/03/20/document-your-apps-comments-power-apps/): Within Power Apps there are various ways to document your app. In this post I'm looking at comments in Power Apps - [2 ways to duplicate SharePoint Lists to support your Power Apps](https://sharepains.com/2024/03/18/duplicate-sharepoint-lists-power-apps/): Recently I've been asked quite a few times to duplicate SharePoint lists as part of creating a Development, Test and production environment in Power Apps. - [Update a Hyperlink Column in SharePoint with Power Automate](https://sharepains.com/2024/03/14/update-hyperlink-sharepoint-power-automate/): Today, I was asked about how to create a lookup to a document or item in a SharePoint form. Sometimes a slightly different solution, using a Hyperlink field can do the trick. - [429 Errors reported by the trigger in your flow in Power Automate](https://sharepains.com/2024/03/14/429-errors-trigger-flow-power-automate/): This morning I was asked about 429 Errors in flows, But rather than 429 errors in actions, this time it was about 429 errors in triggers of a flow. - [Dataflow timeouts in Power Apps](https://sharepains.com/2024/03/11/dataflow-timeouts-in-power-apps/): Last week one of my clients had an issue with timeouts in their dataflows in Power Apps. It had worked for a while, but then suddenly the dataflow was experiencing timeouts. - [Synchronise Microsoft Shifts with Outlook Calendars in Power Automate the 2026 way](https://sharepains.com/2024/03/07/synchronise-microsoft-shifts-outlook-calendars/): Why is there no way to sync Microsoft Shifts with Outlook? This post gives you a download and the steps to develop this yourself. - [Show mobile device notification area in Power Apps](https://sharepains.com/2024/03/06/show-mobile-device-notification-area/): By default the Show mobile device notification area setting is switched off. But it is something that you might want to switch on. - [Relationships in Dataverse managed with Power Automate](https://sharepains.com/2024/03/01/relationships-dataverse-power-automate/): In Dataverse you can create relationships between tables, but how do you manage the relationships from a flow in Power Automate? - [The good and the bad of using Copilot in the Power Platform](https://sharepains.com/2024/02/29/copilot-in-the-power-platform/): Copilot is everywhere within Microsoft technology nowadays. But it is really helping or is it just a step in the wrong direction. In this post the good and the bad of using Copilot. - [How to Run SQL Server stored procedures in Power Apps without Power Automate in 2024](https://sharepains.com/2024/02/28/sql-server-stored-procedures-power-apps/): Recently Microsoft released a new feature in the ultimate Power Apps user guide that will let you call SQL Stored procedures without needing to call a flow in Power Automate - [4, 5 or 7 syntaxes for the Patch function in Power Apps](https://sharepains.com/2024/02/15/syntaxes-for-the-patch-function-power-apps/): Did you know that there are 5 different syntaxes for the patch function? Or are there 7, or maybe just 4. In this post all about the various syntaxes for the Patch function. - [Check permissions like a Pro Low Coder](https://sharepains.com/2024/02/14/check-permissions-like-a-pro-low-coder/): When you develop an app using Dataverse, you might have a button to update data in Dataverse. How do you check permissions before Power Apps tells you that the Patch function has failed? - [Help! My Dataverse flow does not trigger anymore!](https://sharepains.com/2024/02/14/help-my-dataverse-flow-does-not-trigger/): Today suddenly my flow does not trigger anymore. My flow should trigger when a new account is created but suddenly it doesn't trigger my flow anymore. - [When to create child flows in Power Automate?](https://sharepains.com/2024/02/08/create-child-flows-power-automate/): When you use solutions (and you always should use solutions!) there is the option to run Child flows. But when should you create a child flow? - [Excel Filter Query in List Rows Present in a Table Action in Power Automate](https://sharepains.com/2024/01/26/excel-filter-query-power-automate/): Filter queries are important when you work with SharePoint Get Items actions or Dataverse Get Rows, but how about the Excel Filter Query setting? - [Process AI Builder data using xpath in Power Automate](https://sharepains.com/2024/01/17/process-ai-builder-data-using-xpath-in-power-automate/): Today I was asked to have a look at the dynamic data that is generated by AI builder and make it easier to process AI Builder data. - [Do you have multiple developers working on 1 flow in Power Automate?](https://sharepains.com/2024/01/16/multiple-developers-flow-power-automate/): This post is all about some issues that I ran into yesterday. Multiple developers worked on one flow in Power Automate and my app in Power Apps broke. - [System Updates in SharePoint from Power Automate using the ValidateUpdateListItem endpoint](https://sharepains.com/2024/01/05/system-update-sharepoint-power-automate/): Today I wanted to update Documents/Items without triggering other flows. The ValidateUpdateListItem endpoint in the REST API made this System Update possible. - [Power Platform First Aid sessions](https://sharepains.com/2024/01/04/power-platform-first-aid-sessions/): Are you looking for help with your Power Platform. Do you need some first aid? And you had enough of looking for help by searching on the internet? - [A new approach to error handling in Power Automate in 2024 with the Flow Run table](https://sharepains.com/2024/01/03/error-handling-power-automate/): For quite a few years now I've promoted the Try-Catch error handling pattern. But there is a new approach on its way with the Flow Run table. - [Activate and Deactivate Features in SharePoint from Power Automate Flows](https://sharepains.com/2023/12/21/activate-and-deactivate-features-in-sharepoint-form-power-automate-flows/): Enabling a SharePoint feature from a flow in Power Automate is easy, but how do you deactivate features? - [Auto height, Containers and flexible font sizes in Power Apps](https://sharepains.com/2023/12/05/auto-height-containers-font-sizes/): It is important that each control on your screen fits and that nothing overlaps. Auto Height and Containers can help you be with flexible font sizes. - [Paginated REST API calls in Power BI](https://sharepains.com/2023/11/29/paginated-rest-api-calls-in-power-bi/): Last week I was asked about handling paginated REST API calls in Power BI. The REST API end point would only return 200 records while a lot more records should be returned. - [Replace Edit with Contribute permissions with SharePoint Site Templates](https://sharepains.com/2023/11/27/replace-edit-with-contribute-permissions/): How do we replace Edit with contribute permissions? When you create a new team site members will have Edit permissions, but often we only want members to have Contribute permissions. - [Managed Identities in Logic Apps to access Microsoft Graph](https://sharepains.com/2023/11/15/managed-identities-logic-apps-graph/): In this post I'm going through the steps to configure Logic apps to use Managed Identities to access SharePoint sites using Microsoft Graph. - [A scheduled flow that locks an app](https://sharepains.com/2023/11/14/scheduled-flow-that-locks-an-app/): Earlier this week I was asked on the chat how to handle scheduled flows that need to lock an app in Power Apps while the flow is running. - [4 new undocumented functions to encode and decode Xml in Power Automate](https://sharepains.com/2023/11/10/encode-and-decode-xml-power-automate/): First of all, why would we need to encode xml? Sometimes characters in the xml could cause problems when you use them in an actions. Encoding characters can then typically solve this issue. - [Connect to Microsoft Graph using PowerShell with certificates](https://sharepains.com/2023/11/01/connect-microsoft-graph-certificates/): Earlier this week I fixed some PowerShell scripts that connected into Microsoft Graph using the Thumbnail of a certificate installed on my local system. Some of the challenges in this post. - [Finding actions/steps in Power Automate](https://sharepains.com/2023/10/26/finding-actions-steps-in-power-automate/): In Power Automate, it has always been a good habit to rename actions so that other developers can understand your flows as well. - [Is Copilot going to fix your problems?](https://sharepains.com/2023/10/23/is-copilot-going-to-fix-your-problems/): Microsoft's only talking about Copilot and the new Power Automate Designer at there events but does Copilot actually solve your problems? In this post I'm putting Copilot for Power Automate to the test. - [Flow Failed: _scrubbedSensitiveData_ in Power Automate](https://sharepains.com/2023/10/19/scrubbedsensitivedata-power-automate/): Today I hit one of those unclear error messages in Power Automate. All I got was Flowname.Run failed: _scrubbedSensitiveData_. What does that mean? - [10 new features in the new Power Automate Designer](https://sharepains.com/2023/10/12/new-power-automate-designer/): Currently the new Power Automate Designer is only available in the US base Preview environments. But some point soon this new UI will become the new standard. - [Generate Documents using Microsoft Syntex in SharePoint using Power Automate](https://sharepains.com/2023/10/06/syntex-sharepoint-power-automate/): Today I had a look into how to generate documents from lists items using Microsoft Syntex with Power Automate. In this post all the steps. - [1 Step to create the REPT function in Power Automate](https://sharepains.com/2023/09/20/create-rept-function-power-automate/): Today I was asked on the chat about how to create a REPT function in Power Automate. Excel has a REPT function to repeat the same text a specified number of times. Howe to do this in Power Automate. - [4 avoidable pitfalls of Low Code development?](https://sharepains.com/2023/09/07/4-pitfalls-of-low-code-development/): Low Code Development is all about anybody can do it! But what are the pitfalls of low code development? - [Implement Power Apps calendar booking in less than 5 minutes](https://sharepains.com/2023/07/14/power-apps-calendar-booking/): Today I was asked how to implement in Power Apps calendar booking. In this post all the steps to get this done yourself - [Delegation with SharePoint lists Power Apps vs Power Automate](https://sharepains.com/2023/07/10/delegation-with-sharepoint-lists/): We all know about delegation warnings in Power Apps, but how about delegation with SharePoint lists in Power Automate? Ever seen those blue lines in Power Automate? - [Timing issues in relation to App OnStart, Screen OnVisible, Timers and user interruptions in Power Apps](https://sharepains.com/2023/07/04/timing-issues-onstart-screen-onvisible/): When you create apps, it is important to understand the timing issues that may happen. When various elements manipulate data, things could go wrong quite easily. fixing these issues however is not an easy task. - [Implement a PDF preview in a Model Driven Apps](https://sharepains.com/2023/07/03/pdf-preview-in-a-model-driven-apps/): Recently I needed to implement a PDF preview in a Model Driven App. This should be quite an easy thing to implement. - [Performance of the Graph API, REST and Web Services with SharePoint and Power Automate](https://sharepains.com/2023/06/13/performance-of-the-graph-api/): When you build your flows do you consider performance? SharePoint has multiple APIs available. The Performance of the Graph API, REST API and Web Services is very different. - [Develop your own chatbot in Power Apps](https://sharepains.com/2023/06/12/develop-your-own-chatbot-in-power-apps/): Recently a new feature to added to Power Apps to add your Power Virtual Agent chatbot in Power Apps. In this post the step by step guide. - [SharePoint Enterprise Content Types and the Graph API](https://sharepains.com/2023/06/07/sharepoint-enterprise-content-types-graph-api/): Following my posts about the Content Type Gallery and my series about the Graph API, today a post about Enterprise Content Types in SharePoint and how to access them through the Graph API. - [Stop missing reminders in Outlook](https://sharepains.com/2023/05/30/stop-missing-reminders-in-outlook/): Do you ever miss the start of a meeting because those reminders don't pop up when you want them to pop up? Do you want to stop missing reminders? - [Don’t Update or Insert records but Upsert in Dataverse when using Power Automate](https://sharepains.com/2023/05/19/update-insert-dataverse-upsert/): An Upsert in Dataverse can be implemented in two different ways. Check before you do or just a plain Upsert action. - [Size your Power Apps with Height and Width in SharePoint webparts](https://sharepains.com/2023/05/12/size-power-apps-height-webparts/): Sizing you apps in Power Apps isn't any more complicated than setting the height and the width of the app. But tday I came across a situation where I needed a banner shaped app. - [Filter rows by null values in Dataverse using Power Automate](https://sharepains.com/2023/05/08/filter-null-dataverse-power-automate/): First of all I would like to have a look at the null function. Many times, I've seen people ask the question why their null values haven't been working. Below 3 examples. Only one will really work. - [Lock and wipe devices using Microsoft Graph in Power Automate](https://sharepains.com/2023/04/26/lock-wipe-devices-microsoft-graph/): On a recent project I needed to be able to lock and wipe devices. I used Microsoft Graph, Power Automate and HTTP requests to get this done. In this post the details. - [2 Liquid tips – Generate GUIDs and base urls in Power Pages](https://sharepains.com/2023/04/25/generate-guids-and-base-urls-power-pages/): In this post I'm looking at Power Pages and how to get the base url of my site and generate Guids in Liquid. - [I don’t believe this is true (or false) in Power Automate child flows](https://sharepains.com/2023/04/11/i-dont-believe-this-is-true-or-false-in-power-automate-child-flows/): Sometimes Power Automate can be difficult to understand. Today I'm looking at the how child flows handle the boolean values true and false. - [Create a stack trace in Power Automate flows](https://sharepains.com/2023/03/31/create-a-stack-trace-in-power-automate-flows/): Many pro developers will be familiar with the concept of stack traces. Can we take this idea into the low code world? - [Get your Microsoft Teams 1on1 chats with Power Automate using the Graph API](https://sharepains.com/2023/03/17/teams-1on1-chats-power-automate/): You can get some details of 1on1 chats in Microsoft Teams using the Microsoft Teams connector in Power Automate, but getting the actual details is slightly harder. - [Fetch Xml vs Filter Queries in Power Automate](https://sharepains.com/2023/03/16/fetch-xml-filter-queries-power-automate/): When you query rows in Dataverse using Power Automate you have a few options. Fetch Xml and Filter queries are the two obvious options to go for. But when should you use which? - [Query Excel tables using Power Automate](https://sharepains.com/2023/03/10/query-excel-tables-using-power-automate/): This week I was asked three times about how to query Excel files using Power Automate. Time for a SharePains post on this subject. - [Managing high volumes of flow runs within Power Automate using Power Apps](https://sharepains.com/2023/03/09/high-volumes-flows-power-automate/): When you have high volumes like 100s of flows in your environment how do you manage these flows. All these flows are kicking off whenever they need to run. It can be a challenge to find out which flows are actively running. - [Calculate work in progress of tasks in SharePoint using Power Automate](https://sharepains.com/2023/02/22/calculate-work-in-progress-tasks/): Today, I was asked about how to Calculate work in progress on a task list in SharePoint using Power Automate - [Graph API responding with Unexpected response from the service in Power Automate](https://sharepains.com/2023/02/21/graph-api-responding-with-unexpected-response-from-the-service-in-power-automate/): Today in a flow that makes a call to the Microsoft Graph API, I saw "Unexpected response from the service". This is as good as something went wrong. - [Site designs failing to apply to SharePoint site](https://sharepains.com/2023/02/01/site-designs-failing-sharepoint/): Today I tried to apply a site design to a SharePoint site using Power Automate, however this would just not work without any failure being reported. - [Using the new SharePoint Content Type Gallery in with existing sites](https://sharepains.com/2023/01/30/sharepoint-content-type-gallery/): Recently the Content Type Hub in SharePoint Online turned into the SharePoint Content Type Gallery and this is more that just a rename of a feature. Once you have tried the new SharePoint Content Type Gallery you will like it! - [Data in collections not appearing in Power Apps](https://sharepains.com/2023/01/24/data-in-collections-not-appearing-in-power-apps/): Have you ever found that data in collections not appearing in Power Apps? Are you displaying data in collections from a data source while you haven't used this data source directly in your UI controls? - [How to use Microsoft Graph for SharePoint within Power Automate](https://sharepains.com/2023/01/24/microsoft-graph-sharepoint-power-automate/): In this post a variety of options on how to use Microsoft Graph for SharePoint within Power Automate. - [Item vs items in Apply to each steps in Power Automate](https://sharepains.com/2023/01/18/item-vs-items-apply-to-each/): Today a short post, about the item vs items functions in Power Automate apply to each steps. When to use which one and why? The choice between the item function and the items function isn't as clear cut as you may expect. - [2 Approaches to filtering and selecting data from Microsoft Graph in Power Automate](https://sharepains.com/2023/01/13/filter-select-graph-power-automate/): Within my series about Microsoft Graph in the Power Platform I've collected data using customer connectors and HTTP actions but how do we filter and select data in Microsoft Graph? - [MS Graph subscriptions using Power Automate](https://sharepains.com/2023/01/12/ms-graph-subscriptions-power-automate/): In my series about the Graph API, I'm going to look at subscribe to 'things' to trigger a flow when events happen using MS Graph subscriptions in Power Automate. - [Manage Calendars and Events using Microsoft Graph in Power Automate](https://sharepains.com/2023/01/06/calendars-events-graph-power-automate/): As part of my series of blog posts about Microsoft Graph, I'll now look at Calendars and Events. - [Manage Users using the Graph API in Power Automate](https://sharepains.com/2023/01/04/manage-users-graph-api-power-automate/): When you manage user accounts within Power Automate, you can user the Office 365 Users connector, but sometimes the Graph API can give you more possibilities. - [Microsoft Graph API and the Power Platform, the Ultimate Guide](https://sharepains.com/2023/01/03/microsoft-graph-api-the-power-platform/): This is going to be a large series of posts about the Microsoft Graph API and the Power Platform. Power Automate and the Graph API are just made for each other. - [A form with a multi-select dropdown with additional information collected for each selected option in Power Apps](https://sharepains.com/2022/12/22/form-multi-select-dropdown-additional-information-power-apps/): Yesterday I was asked on the chat here, if it is possible to use a multi-select dropdown in a form and then ask for each selected option some additional information. In this post the pattern that you could follow. - [Quickly find the parent from the child flow in Power Automate](https://sharepains.com/2022/12/09/find-parent-child-flow-in-power-automate/): When you have used child flows and attempted to debug issues you will have come across the issue where you want to find the parent flow for the failing child flow. - [Create multi user real time apps in Power Apps](https://sharepains.com/2022/11/18/create-multi-user-real-time-power-apps/): When multiple users edit data and you want your app to show real time data, you will need a multi user real time app. It isn't a good idea to reload all your data every time someone might have updated data. - [Sort by Title in your Highlighted Content web part in SharePoint](https://sharepains.com/2022/11/17/sort-by-title-highlighted-content-web-part-sharepoint/): Yesterday I was asked about how to sort Documents in the Highlighted Content web part by the Title property. To sort by Title you will have to go through some extra steps. - [Copy large files from SharePoint to Azure Blob Storage using Power Automate](https://sharepains.com/2022/11/15/copy-large-files-sharepoint-azure-blob/): When you try to copy large files from SharePoint to Azure Bob Storage with Power Automate, you will find that you have a few options. But quite a few of them fail straight away. In this post the solution. - [Sort an array by dates in Power Automate](https://sharepains.com/2022/11/10/sort-an-array-by-dates-in-power-automate/): When we use the Sort function to sort arrays in Power Automate, it is soo much easier than the 3 step approach that we had before. But when you try to sort an array by dates, there are a few potential issues when you really start to use this function. - [New! Format data by examples in Power Automate](https://sharepains.com/2022/10/21/new-format-data-by-examples-in-power-automate/): This feature "Format data by examples" will kill one of my most popular posts! How to format dates using formatDateTime. - [Named formulas in Power Apps using App.Formulas](https://sharepains.com/2022/10/19/named-formulas-power-apps-app-formulas/): Do you use the App onstart to set a lot of variables? And then do you repeat this same within other places of the app to keep things up to date? The new named formulas in App.Formula might be a better option. - [Introduction to the PDF function in Power Apps](https://sharepains.com/2022/10/07/introduction-pdf-function-in-power-apps/): Have you ever wanted to create a PDF from your Power Apps Screens? Now you can using a the new PDF function in Power Apps - [Do Power Platform updates come as a surprise?](https://sharepains.com/2022/10/06/do-power-platform-updates-come-as-a-surprise/): How often does it happen that you are working in Power Automate or Power Apps and suddenly on of those new Power Platform Updates features appears. - [Use ParseJSON in Power Apps to retrieve data from Power Automate](https://sharepains.com/2022/09/30/parsejson-powerapps-power-automate/): Recently a new ParseJSON feature was added to Power Apps. ParseJSON in Power Apps is possibly one of the most complex functions available. - [1 step to update an item in an array in Power Automate](https://sharepains.com/2022/09/21/update-an-item-array-power-automate/): The question is easy. How to update an item in an array. This array could of course be an array given by another action and this array could contain objects. For simplicity sake, I'm going with the array of numbers. If you have objects, then the principle will be the same however. - [Failed to load in Azure Synapse Workspace](https://sharepains.com/2022/09/20/failed-to-load-azure-synapse-workspace/): After last week's post about how to configure Azure Synapse Link to export data from Dataverse into SQL Server, today a post about some issues. How do you deal with the failed to load messages that users might get when accessing the data. - [Buckinghamshire & Northamptonshire Power Platform User Group launch](https://sharepains.com/2022/09/20/buckinghamshire-northamptonshire-power-platform-user-group-launch/): Have you been waiting for a new face to face Power Platform User Group in Buckinghamshire & Northamptonshire? - [Configure Dataverse exports using Azure Synapse Links for Azure SQL Databases](https://sharepains.com/2022/09/14/dataverse-azure-synapse-links-azure-sql-databases/): In this post I'm looking at the Azure SQL databases option that is part of the Azure Synapse link configuration. - [5 steps to implement word based search in Power Apps](https://sharepains.com/2022/09/05/word-based-search-in-power-apps/): A common requirement in Power Apps is to create a word based search on data in galleries. - [900th post on SharePains.com, it is a time to celebrate and win!](https://sharepains.com/2022/08/18/900th-post-on-sharepains-com-it-is-a-time-to-celebrate-and-win/): This is the 900th post on SharePains.com and I thought this would be a good moment to celebrate that milestone. Ok, it is not the 1000th post but 900 is still quite a lot. - [Resolved – Avoid variables in Apply To Each steps in Power Automate](https://sharepains.com/2022/08/17/avoid-variables-apply-to-each-power-automate/): Yesterday I was asked about how to avoid variables when you want an index number of the item processed by an apply to each step. - [Debug Compose actions and Conditions in Power Automate](https://sharepains.com/2022/08/15/debug-compose-condition-power-automate/): Debug compose actions and condition steps can be difficult as flow runs will only show the output of your expressions. In this post a workaround, to make this easier. - [What can I do with my Power Automate Licenses?](https://sharepains.com/2022/08/10/power-automate-licenses/): Do you know what you can do when you purchased Power Automate licenses? Or what does that Trial that you enabled give you? - [Azure Application Insights and Error Handling in Power Apps](https://sharepains.com/2022/08/09/power-apps-azure-application-insight/): This post is all about error handling in Power Apps with Azure Application Insight. Logging all events in your app (wanted and unwanted) within an easy to use log. - [Boolean logic made easy in Power Apps](https://sharepains.com/2022/07/22/boolean-logic-in-power-apps/): This post is all about Boolean logic in the ultimate Power Apps user guide. So that is all the true/false stuff within your app. - [Secure your SharePoint data in Power Apps using Power Automate](https://sharepains.com/2022/07/21/secure-sharepoint-data-power-apps-power-automate/): Although Dataverse is available many of us still use SharePoint to store their data. But how do you secure your SharePoint data? Or are you just happy for people to edit your data outside your app? - [Application Lifecycle Management (ALM) and Power Pages](https://sharepains.com/2022/07/18/application-lifecycle-management-power-pages/): In my recent posts about Power Pages, I've looked at development of pages, but I've not considered Application Lifecycle Management (ALM) yet. - [User relevant Power BI components in Power Pages](https://sharepains.com/2022/07/14/power-pages-user-relevant-power-bi-components/): Do you want to have a different Power BI component configuration in Power Pages depending on who is logged in, making the data user relevant? - [Get started with Liquid in Power Pages](https://sharepains.com/2022/07/14/get-started-with-liquid-in-power-pages/): In this post I'm going to introduce some code into my Power Pages ultimate user guide, by introducing Liquid. - [5 years of Microsoft MVP-ness](https://sharepains.com/2022/07/05/5-years-of-microsoft-mvp-ness/): Today I received an email confirming my 5th Microsoft MVP award. Time has flown since those first nomination emails in 2017. - [Error when trying to retrieve data from the network](https://sharepains.com/2022/07/04/error-when-trying-to-retrieve-data-from-the-network/): Today I got the error: Error when trying to retrieve data from the network - [Return Arrays from Power Automate to Power Apps without a premium licence](https://sharepains.com/2022/07/01/return-arrays-power-automate-power-apps/): When you want to return arrays from a flow in Power Automate to an app in Power Apps you could use the Response action, however this requires a premium connector. - [Display the environment name in your Canvas App in Power Apps](https://sharepains.com/2022/06/30/environment-name-canvas-app-power-apps/): There are two easy options to get the environment name while running an app. - [Style your Power Pages, the easy way](https://sharepains.com/2022/06/27/style-your-power-pages-the-easy-way/): And for site the navigation you can also enable an on-hover and style - [1 Client ID, 1 Secret and a Bearer token in Power BI](https://sharepains.com/2022/06/17/secrets-client-ids-bearer-token-power-bi/): Connecting to data sources in Power BI can be very easy. But when you need to call three end points to get to your data with Secrets, Client IDs and Bearer tokens it can be a bit harder to get your data. - [Create custom content instead of components in Power Pages](https://sharepains.com/2022/06/17/create-custom-content-power-pages/): After yesterday's post about components today I'm looking at a bit more detail and how we can create custom content on our pages. - [Components in Power Pages, a quick overview](https://sharepains.com/2022/06/16/components-in-power-pages-a-quick-overview/): As we saw in my most recent post about Power Pages, content of pages are made up of components. In this post I will go through the existing Power Pages components - [Edit Pages in Power Pages, a quick overview](https://sharepains.com/2022/06/15/edit-pages-in-power-pages/): So you got started with Power Pages, and now you're ready to edit pages in Power Pages. This post will guide you through the first steps. - [Get started with Power Pages super quickly in 5 minutes](https://sharepains.com/2022/06/14/get-started-with-power-pages/): In this post I will look at how to get started with Power Pages. In this post I will guide you through the first steps that you can take with this amazing platform. - [Runtime error when running tests: TypeError: Cannot read properties of null (reading ‘errorMessage’)](https://sharepains.com/2022/06/07/typeerror-cannot-read-properties-of-null/): How do you deal with Runtime error when running tests: TypeError: Cannot read properties of null (reading 'errorMessage') in your Power Apps Test Studio? - [Create an app using the new image import in Power Apps](https://sharepains.com/2022/05/27/create-app-new-image-import-power-apps/): But, this is a great start for even faster app development. And all starts with you drawing a picture or mock-up and the using the image import the development jobs becomes just that little easier to get started with your development. - [3 steps to implementing a better date picker in Power Apps](https://sharepains.com/2022/05/17/implementing-date-picker-power-apps/): One of the biggest annoyances of Canvas Apps in Power apps is the date picker. It just doesn't feel right. - [Power Automate Flow run failed: Connection not configured for this service](https://sharepains.com/2022/04/27/connection-not-configured-for-this-service/): Today I was battling with the Connection not configured for this service error. - [Open Word documents in the desktop app from Power Apps](https://sharepains.com/2022/04/01/open-word-documents-desktop-power-apps/): When you open Word documents from Power Apps you might have noticed that Word Online is used, but can we open documents in the Word Desktop app instead? - [Introducing Portal Apps in Power Apps](https://sharepains.com/2022/03/15/introducing-portal-apps-in-power-apps/): Power Apps has three types of apps. One of them is the Portal app. In this post a how to get started with these websites that present data from Dataverse. - [NEVER give your SharePoint fields the displayname of Value!](https://sharepains.com/2022/03/10/sharepoint-fields-displayname-value/): After an hour of banging my head against a brick wall when my Patch command failed I found the issue with a field named Value. - [Collect flow runs of your failed child flows](https://sharepains.com/2022/03/07/flow-runs-of-your-failed-child-flows/): When you use child flows, you might need to collect the flow runs of your failed child flows to identify any issues. In this post some error handling tips. - [Cancel Flow Run instead of Terminate in the middle of an apply to each in Power Automate](https://sharepains.com/2022/02/25/cancel-flow-run-terminate-power-automate/): Using the Cancel Flow Run action you can now cancel your flow runs. - [Copy SharePoint files from one tenant to another using Power Automate](https://sharepains.com/2022/02/16/one-tenant-to-another-power-automate/): Have you ever tried copying files from one tenant to another using Power Automate? - [Create vibrating icons in Power Apps](https://sharepains.com/2022/02/14/create-vibrating-icons-in-power-apps/): Last week I got a strange question about how to make vibrating icons. So this post is to show you how to make icons vibrate so that you can point them in the right direction. - [Create a custom connector in the Power Platform – The WordPress example](https://sharepains.com/2022/02/11/custom-connector-powerplatform-wordpress/): Have you tried to create a custom connector in the Power Platform? As I was getting annoyed with the limitations of the existing WordPress connector here a full example. - [Compare two arrays, tables or lists a lot faster in Power Automate](https://sharepains.com/2022/01/27/compare-two-arrays-power-automate/): When you want to compare two arrays, lists or tables in Power Automate and you might end up with a very slow flow. In this post the speedy solution. - [Handle unmanaged changes made to Dataverse tables in the default solution](https://sharepains.com/2022/01/20/handle-unmanaged-changes-tables-default-solution-power-platform/): The default solution in the Power Platform is an unmanaged solution even in production. How do you handle unmanaged changes in the default solution that are edited manually? - [Disable editing of your production apps and flows in the Power Platform](https://sharepains.com/2022/01/19/disable-editing-app-flow-power-platform/): So often people edit apps and flows in production environments just to make them work. In this post I will look at why you shouldn't and how to disable editing. - [Comparing collections, table variables and data sources in Power Apps](https://sharepains.com/2022/01/17/collection-variable-data-source-power-apps/): In the ultimate Power Apps user guide you can use data sources directly or you could use collections or you could use variables. But what is the difference? - [Ambiguity in Power Apps](https://sharepains.com/2022/01/13/ambiguity-in-power-apps/): Recently I was asked about issues related to ambiguity in Power Apps code. In this post I will look at how to avoid any ambiguity issues in Power Apps. - [Set the task priority in Microsoft Planner using Power Automate](https://sharepains.com/2022/01/10/task-priority-in-microsoft-planner/): For quite a while I've been looking to set the task priority in Microsoft Planner when using Power Automate. The preview version of the Create a task actions can do this. - [Co-Authoring in Power Apps](https://sharepains.com/2022/01/05/co-authoring-in-power-apps/): Recently Microsoft added the option to use Co-Authoring as an experimental feature to Power Apps. - [Control access with RecordInfo and DataSourceInfo in Power Apps](https://sharepains.com/2021/12/22/recordinfo-and-datasourceinfo-power-apps/): When you create apps, you might find that different users get different things to do. With RecordInfo and DataSourceInfo you can control elements in your app by using Dataverse permissions - [Loaddata, Savedata and Cleardata in Power Apps](https://sharepains.com/2021/12/21/loaddata-savedata-cleardata-power-apps/): Today I'm having a look at some of the preview features arriving in Power Apps. This post is about the new LoadData, savedata and cleardata in web players feature. - [Enable the new Power Automate pane feature](https://sharepains.com/2021/12/21/enable-the-new-power-automate-pane-feature/): You might want to Enable the new Power Automate pane feature when you add a flow to your app and you have to find the right flow in a long list of flows. - [Synchronize two data sources with Power Automate](https://sharepains.com/2021/12/17/synchronize-two-data-sources-power-automate/): Over the last few weeks I've been asked a number of times how to setup a flow to synchronize two data sources. In this post a data synchronization pattern that can be easily reused. - [3 Ways to avoid duplicate records in Power Apps](https://sharepains.com/2021/12/15/avoid-duplicate-records-in-power-apps/): When you create items or records in your data sources using Power Apps, you will often want to avoid duplicate records. In this post 3 ways to avoid duplicates. - [Handling SharePoint file locks with Power Automate child flows](https://sharepains.com/2021/12/14/sharepoint-file-locks-power-automate/): In 2019 I wrote a post about SharePoint file locks and how to handle these with a retry pattern. But there is an easier way when you use child flows. - [The must have features of an app in Power Apps using community connectors (well, on a Friday afternoon that is)](https://sharepains.com/2021/12/10/community-connectors-power-apps/): Every week there are new connectors added to Power Apps and Power Automate. This week I'm looking at two community connectors that were added recently by on of the Power Platform community leaders, Daniel Laskewitz. - [Become part of your presentation with Presenter Modes in Microsoft Teams](https://sharepains.com/2021/12/01/presenter-modes-in-microsoft-teams/): When you present in Microsoft Teams and you share your screen you might not be visible. Presenter modes make it easier to interact with your audience. - [Get the current environment of an app in Power Apps](https://sharepains.com/2021/11/30/current-environment-app-in-power-apps/): Today I tried to display the current environment in a canvas app in Power Apps. This was slightly harder than expected. - [Containers in responsive apps in Power Apps](https://sharepains.com/2021/11/26/containers-responsive-apps-power-apps/): When you develop responsive apps in containers become very important. In this post I'm trying to help with the common challenges. - [Create recursive flows in Power Automate](https://sharepains.com/2021/11/17/create-recursive-flows-in-power-automate/): With the introduction of child flow, have you tried creating recursive flows? - [Error handling in child flows in Power Automate](https://sharepains.com/2021/11/10/error-handling-in-child-flows-power-automate/): In the past I've looked at error handling for flows and this resulted in the Try-Catch pattern. In this post I will focus on error handling in Child flows. - [The making of: A successful Microsoft Ignite table talk](https://sharepains.com/2021/11/04/making-of-microsoft-ignite-table-talk/): A couple of months ago Anna Chu asked me to co-host a table talk at Microsoft Ignite about best practices within the Power Platform. - [Comments in Power Automate flows](https://sharepains.com/2021/11/03/comments-in-power-automate-flows/): As it is Microsoft Ignite week, new features are being added to all products. This post is all about comments in Power Automate - [SharePoint Site Scripts and Site Designs in Power Automate](https://sharepains.com/2021/11/02/site-scripts-designs-power-automate/): When you look at SharePoint site provisioning solutions, you will quite quickly bump into Site Scripts and Site Designs. In this post some options on handling these in Power Automate - [Using Dataverse views to simplify filter queries in Canvas Apps in Power Apps](https://sharepains.com/2021/10/19/using-dataverse-views-canvas-power-apps/): Do you find that your queries in filters become complicated? In this post a way to simplify your queries using Dataverse views. - [7 reasons to use child flows in Power Automate](https://sharepains.com/2021/10/12/7-reasons-child-flows-in-power-automate/): When you develop your flows inside solutions you have the option to use child flows. But are they worth it? - [Get into Space with Power Automate and the EONET by NASA connector](https://sharepains.com/2021/10/08/eonet-by-nasa-connector-power-automate/): Have you tried the EONET by NASA or also known as Earth Observatory Natural Event Tracker connector in Power Automate yet? - [Calculate travel distance using Power Automate](https://sharepains.com/2021/09/27/calculate-travel-distance-power-automate/): When you have an app that has a current location and a destination postcode and you want to calculate travel distances, you could use Power Automate. - [1 Top tip! Make your compose actions self documenting in Power Automate](https://sharepains.com/2021/09/23/compose-action-outputs-power-automate/): Very often I hear flow people telling others that we should use Compose actions instead of variables. But when you reference a compose action it just shows "Outputs". - [Error when you turn on solution based flows in Power Automate](https://sharepains.com/2021/09/16/turn-on-solution-based-flow-power-automate/): After I imported the solution and then tried to turn on the flow, I was presented with the following error: - [The Weekday and Calendar functions in Power Apps](https://sharepains.com/2021/09/10/weekday-calendar-functions-power-apps/): The weekday function in Power Apps gives us a numbers between 1 and 7 while the Calendar function can give you an array Sunday - Saturday. - [Responsive designs in Power Apps, the basics](https://sharepains.com/2021/09/08/responsive-designs-in-power-apps-the-basics/): When you want to leave it up to the user what device they use, responsive designs in Power Apps becomes important. - [Format numbers locally to your user in Power Apps](https://sharepains.com/2021/09/03/format-numbers-local-user-power-apps/): A while back I wrote about formatting numbers in Power Automate. Today a quick post about how to format numbers in Power Apps. - [Request to XRM API failed with error, the flow is missing a connection for api ‘< null >‘](https://sharepains.com/2021/09/01/request-to-xrm-api-failed-with-errorthe-flow-is-missing-a-connection-for-api/): Today when i tried to save my flow I got the following error message Request to XRM API failed with error. What to do when you get this error? - [Migrating file shares with SharePoint Migration manager](https://sharepains.com/2021/08/27/migrating-file-shares-with-sharepoint-migration-manager/): A while back I wrote about the SharePoint Migration Tool. Today I will share my experiences of the SharePoint Migration Manager. - [Step 1 in Application Lifecycle Management and the Power Platform](https://sharepains.com/2021/08/24/application-lifecycle-management/): As you take software development more seriously, Application Lifecycle Management (ALM) becomes more important. - [Get the local trigger time in Power Automate](https://sharepains.com/2021/07/29/local-trigger-time-in-power-automate/): What's the time a flow was triggered locally to the user who triggered a flow? How do we get the local trigger time? - [Using PnP PowerShell with Azure Automation Accounts](https://sharepains.com/2021/07/09/pnp-powershell-azure-automation-accounts/): In the past I often used Azure Functions to run PnP PowerShell from my flows in Power Automate, but there is a good alternative, Azure Automation Accounts. - [How to export and import solutions using flows in Power Automate](https://sharepains.com/2021/06/29/export-and-import-solutions-power-automate/): Have you ever wanted to export and import solutions using a flow? In this post all you need to know to get started. - [2 Ways to insert dates into Excel using Power Automate](https://sharepains.com/2021/06/21/insert-dates-into-excel-power-automate/): Today I looked at how to insert dates into Excel after a while back I tried to read dates from Excel - [Sharing flows in Power Automate](https://sharepains.com/2021/06/15/sharing-flows-in-power-automate/): Recently I tried to share a flow and I got trial warning. It took a while before I started to understand how Sharing flows in Power Automate works. - [There’s a problem that needs to be fixed in Power Automate](https://sharepains.com/2021/06/14/theres-a-problem-that-needs-to-be-fixed/): Have you ever had your flows showing the following error: There's a problem that needs to be fixed to trigger this flow. To see more details open flow checker. - [Get started with child flows in Power Automate](https://sharepains.com/2021/06/10/get-started-with-child-flows-in-power-automate/): Child Flows is one of the subjects that has been on my list of things to write about for quite a while. In this post the steps to get started with child flows. - [Implementing 2 levels of grouping in Power Apps](https://sharepains.com/2021/06/08/2-levels-of-grouping-in-power-apps/): When you want to implement 2 levels of grouping in Power Apps you will discover quite soon that you can't have more than 1 nested gallery. So how can we implement a dual grouping view of data? - [Power Automate Approvals and Dataverse](https://sharepains.com/2021/06/04/power-automate-approvals-and-dataverse/): Power Automate Approvals are often one of those unclear things that people try to avoid. - [Classic vs Modern app designer in Model Driven Apps](https://sharepains.com/2021/06/01/modern-app-designer-vs-classic-model-driven-apps/): When you create a new Model Driven App today, you will find that you have an options between the Modern app designer and the Classic app designer. - [Environment Variables in Power Apps](https://sharepains.com/2021/05/27/environment-variables-in-power-apps/): We can now dynamically select the lists using environment variables in Power Apps. - [Environment variables in Power Automate](https://sharepains.com/2021/05/26/environment-variables-in-power-automate/): When you create flows inside a solution you might have noticed these Environment Variables. What are they and what can you do with them? - [Power Automate flow or app code in Power apps?](https://sharepains.com/2021/05/13/power-automate-flow-or-app-code-apps/): Power Automate and Power Apps use the same connectors. So do you use a flow or app code? It can be an important choice. - [Create a Microsoft Teams team template](https://sharepains.com/2021/05/05/create-a-microsoft-teams-team-template/): Recently I was asked about creating a team template in Microsoft Teams and apply this team template to a team created using Power Automate. - [Who is in the office tomorrow, using Power Automate?](https://sharepains.com/2021/04/28/who-is-in-the-office-power-automate/): Do you want to know who is in the office tomorrow or the day after? With some COVID restrictions still in place it can important to know who is in the office. - [8 top reasons to use Dataverse or SharePoint lists in the Power Platform](https://sharepains.com/2021/04/15/dataverse-or-sharepoint-lists/): Dataverse or SharePoint lists, that is the question. - [Filter by calculated fields in SharePoint using Power Automate](https://sharepains.com/2021/04/14/filter-by-calculated-fields/): When you read items from a SharePoint list and you want to filter by calculated fields in that list filter queries will fail. So how can you filter your items? - [Expected String but got Null, when calling a flow from a Model Driven app](https://sharepains.com/2021/04/12/expected-string-but-got-null/): A few weeks ago I looked at calling flows from model driven apps. And for a while my flow worked as expected and then suddenly it broke with an "Expected String but got Null" message - [Get all your broken connections using Power Automate](https://sharepains.com/2021/04/08/broken-connections-using-power-automate/): To get all your broken connections in the Power Platform can be a challenge. In this post I will use flow to collect the broken connections. - [Customer Voice a.k.a. Forms Pro the database behind the magic](https://sharepains.com/2021/04/07/customer-voice-forms-pro-database/): If you call Customer Voice still Forms Pro or not, have you ever looked into the Databases sitting behind Customer Voice? - [Many running flows in Power Automate](https://sharepains.com/2021/04/01/many-running-flows-in-power-automate/): Recently I noticed that some of my flows end up with many running flows. - [Set yourself to Do Not Disturb using Power Automate Desktop](https://sharepains.com/2021/03/26/set-yourself-to-do-not-disturb-using-power-automate-desktop/): A while back I tried setting people to Do Not Disturb using Power Automate. In this post I will use Power Automate Desktop. - [Filter SharePoint list items without a date in Power Automate](https://sharepains.com/2021/03/22/items-without-a-date-power-automate/): So you have a list and that list has a date field. Now you only want to get the items that have a date set and filter out the items without a date. - [SQL Server vs Azure SQL in Power Automate](https://sharepains.com/2021/03/19/sql-server-vs-azure-sql-power-automate/): So often I have said, it doesn't matter where your data lives, but have you ever compared SQL Server with SQL in Azure when you use Power Automate? - [Create Views in Microsoft Teams](https://sharepains.com/2021/03/17/create-views-in-microsoft-teams/): Recently I discovered Views in Microsoft Teams. - [Create Dynamic Adaptive Cards in Teams using Power Automate](https://sharepains.com/2021/03/11/dynamic-adaptive-cards-power-automate/): Recently I looked at the basics of Adaptive cards, but what if you want more dynamic adaptive cards in Teams that respond to user input? - [Call Microsoft Graph from an HTTP Action vs Custom Connector in Power Automate](https://sharepains.com/2021/03/04/microsoft-graph-http-custom-connector/): Is there a difference between calling Microsoft Graph Endpoints using an HTTP action or creating a custom connector? In this post I will compare these two options. - [Calculate the Sum for a SharePoint column in Power Automate](https://sharepains.com/2021/03/01/sum-sharepoint-column-power-automate/): Last week Shane Young asked me about calculating the Sum for a SharePoint column in Power Automate. In this post the super fast solution to calculating totals. - [Object must implement IConvertible in Power Apps](https://sharepains.com/2021/02/25/object-must-implement-iconvertible-power-apps/): In Power Apps when you do a Patch to create a new item or to update an existing item you migth have found the error Object must implement IConvertible - [Get started with adaptive cards in Power Automate](https://sharepains.com/2021/02/19/adaptive-cards-power-automate-teams/): Getting started with adaptive cards can be difficult. In this post i have written some guidelines to get you started. - [Create PDF documents from data in Power Automate](https://sharepains.com/2021/02/18/create-pdf-documents-data-power-automate/): In this post I will look at how to create PDF documents from data. - [Unnest nested arrays in Power Automate](https://sharepains.com/2021/02/10/unnest-nested-arrays-in-power-automate/): We all know this problem, you have a nested array in Power Automate but how do we unnest these arrays? It is not easy! - [Advanced settings not loading in Power Platform](https://sharepains.com/2021/02/04/advanced-settings-loading-power-platform/): Yesterday one of my clients showed me an issues where the Advanced settings didn't load. - [1 Better way to use Create Item in SharePoint with Power Automate](https://sharepains.com/2021/02/02/create-item-sharepoint-power-automate/): Have you been using the REST API instead of the create item action in Power Automate. Create Item in the SharePoint connector is now just as good! - [Filter by Content Type using Get Items in Power Automate.](https://sharepains.com/2021/02/02/filter-by-content-type-power-automate/): In a comment on my Filter Query on Get Items in the SharePoint connector post I was asked about how to filter by content type. - [Experimental Filter Query in SharePoint Get Items in Power Automate](https://sharepains.com/2021/01/19/filter-query-get-items-power-automate/): Have you tried the experimental version of Filter query in the SharePoint Get Items action in Power automate yet? - [3 Ways to add a column to an array in Power Automate](https://sharepains.com/2021/01/15/add-a-column-to-an-array-power-automate/): When you have an array in Power Automate and you would like to add a column, you have 3 ways of doing this. - [Patch any field type in a SharePoint list item using Power Apps](https://sharepains.com/2021/01/13/patch-field-type-sharepoint-power-apps/): In Power Apps the Patch function is very important when you work with data. In this post it's all about how to update any field type in SharePoint lists. - [Call flows from a model driven app](https://sharepains.com/2021/01/08/call-flows-from-a-model-driven-app/): Wouldn't it be great if you could call flows from a model driven app? Well you can , but it is not without its difficulties. - [Variables or Compose? Consider neither in Power Automate](https://sharepains.com/2021/01/06/variables-or-compose-power-automate/): The question is Variables or Compose actions in Power Automate? - [Your 1st lesson in Power Apps, in a few easy steps!](https://sharepains.com/2020/12/23/your-1st-lesson-in-power-apps/): 1st lessons can be so important when you want to get started with Power apps. - [Create new tabs in your Teams in Microsoft Teams using Power Automate](https://sharepains.com/2020/12/21/new-tabs-microsoft-teams-power-automate/): Have you ever tried adding new tabs in your teams in Microsoft Teams? When you do this with Power Automate you might need to have a look at Microsoft Graph. - [Who can create new environments in the Power Platform](https://sharepains.com/2020/12/15/create-new-environments-power-platform/): It is important to create multiple environment when you use the Power Platform, but how do you control who can create new environments? - [How to handle leavers in Power Automate](https://sharepains.com/2020/12/10/how-to-handle-leavers-in-power-automate/): Nobody likes it when people leave your organisation, but apart from the emotional part of this. What do you do when leavers own flows in Power Automate? - [How to embed a canvas app in your model driven app](https://sharepains.com/2020/12/07/embed-a-canvas-app-model-driven-app/): Do you want to create a button in the forms in your model driven app? You could embed a Canvas App in your model driven app to do this. - [Automatically re-enable flows that were suspended in Power Automate](https://sharepains.com/2020/12/02/re-enable-flows-power-automate/): Do you want to re-enable flows that were suspended automatically? Have you noticed that flows that aren't running are automatically switched off? - [The target in the Launch function in Power Apps](https://sharepains.com/2020/11/30/launchtarget-launch-function-power-apps/): The Launch function in Power Apps helps you to open links in your browser from your app. - [Create new group alert using Power Automate](https://sharepains.com/2020/11/24/create-new-group-alert-power-automate/): Do you want to know when a new group has been created with for example Microsoft Teams? How do you create a new group alert? - [Delegation Warnings in Power Apps](https://sharepains.com/2020/11/23/delegation-warnings-in-power-apps/): We have all seen them, Delegation Warnings, but what is delegation and how do you clear your Power Apps from these warnings - [1 Top tip: PowerPlatformLearn.com and master the Power Platform within no time](https://sharepains.com/2020/11/16/master-power-platform-powerplatformlearn/): It can be difficult to get started with the Power Platform, blogs help, training helps, but powerplatformlearn.com can definitely help! - [Compare 2 Excel files using Power Automate](https://sharepains.com/2020/11/11/compare-2-excel-files-power-automate/): This is such a common scenario. You receive Excel files on a regular basis and you want to compare the files collect the new rows with Power Automate. - [Rename SharePoint folders using Power Automate in 2 easy steps](https://sharepains.com/2020/11/03/rename-sharepoint-folder-power-automate/): Have you ever wanted to rename SharePoint folders with Power Automate? - [Read dates from Excel with Power Automate](https://sharepains.com/2020/11/02/read-dates-from-excel-power-automate/): To read dates from Excel files can be tricky, as Excel only give you the number of days since 1 January 1900. - [SharePoint 2010 workflows retiring next week!](https://sharepains.com/2020/10/30/sharepoint-2010-workflows-retiring/): Are you ready for your SharePoint 2010 Workflows retiring next week? - [Create Distinct filters for Power Apps galleries](https://sharepains.com/2020/10/26/distinct-filters-power-apps-galleries/): So you add a gallery to your app in Power Apps and you want to create some filters (distinct filters of course!). - [Send push notifications to start your app in Power Apps](https://sharepains.com/2020/10/21/push-notifications-start-app-power-apps/): Have you ever wanted to send push notification to people's phones to run a Power App? - [Patch the Common Data Services with Power Apps](https://sharepains.com/2020/10/19/patch-common-data-services-power-apps/): Using the patch Function to update records in the Common Data Services can be easy, but a lot depends on the field types used. - [Deploy Canvas Apps and Flows through solutions](https://sharepains.com/2020/10/14/deploy-canvas-apps-and-flows-solutions/): When you deploy Canvas Apps and Flows in Power Apps and Power Automate you can choose to deploy them one by one but adding them to solutions is easier. - [Address Input in Power Apps](https://sharepains.com/2020/10/12/address-input-in-power-apps/): When you app needs users to input addresses, you can now use the Address input control. - [Just 3 clicks to disable an action in Power Automate](https://sharepains.com/2020/10/08/disable-an-action-in-power-automate/): Have you ever wanted to disable an action in your Power Automate flow? It is just 3 clicks away. - [Actions function in Power Automate](https://sharepains.com/2020/10/06/actions-function-in-power-automate/): Most flow developers will know about functions like body and outputs in Power Automate. But how about the actions function? - [Business Rules in Model Driven Apps](https://sharepains.com/2020/10/01/business-rules-in-model-driven-apps/): When you develop model driven apps, business rules can be very useful. - [Use Azure Computer Vision to name your images with Power Automate](https://sharepains.com/2020/09/28/azure-computer-vision-power-automate/): To recognize images in SharePoint Azure Computer Vision can be a great help. In this post an example. - [Better error handling with Power Automate parallel branches](https://sharepains.com/2020/09/25/error-handling-parallel-branches-power-automate/): This post is all about error handling and parallel branches. - [Get the changes made to SharePoint Items with Power Automate](https://sharepains.com/2020/09/24/changes-sharepoint-items-power-automate/): Recently the Get changes for an item or file action was added to SharePoint. Here a full overview - [Azure Key Vault and Power Automate](https://sharepains.com/2020/09/23/azure-key-vault-and-power-automate/): Can you keep a secret? Have you tried using Azure Key Vault with Power Automate? here is an overview of the Azure Key Vault connector. - [Be careful with your 30 private channels in Microsoft Teams](https://sharepains.com/2020/09/21/private-channels-in-microsoft-teams/): When you create private channels in Microsoft Teams there are some limitations that you need to be aware of. - [Avoid unwanted apply to each steps in Power Automate](https://sharepains.com/2020/09/17/unwanted-apply-to-each-power-automate/): When you add dynamic content to actions you will get those unwanted apply to each actions added by Power Automate. - [Compare 2 SharePoint libraries at lightning speed with Power Automate](https://sharepains.com/2020/09/15/compare-sharepoint-libraries-power-automate/): Yesterday Jon Levesque asked me if I had any posts helping to compare two SharePoint document libraries with Power Automate. - [Security and Common Data Services/Dynamics 365](https://sharepains.com/2020/09/10/security-common-data-services-dynamics/): In this post I will look at the security aspects of Dynamics 365 and the Common Data Services. - [Create a SharePoint list using Power Automate](https://sharepains.com/2020/09/08/create-sharepoint-list-power-automate/): So your flow is creating a new SharePoint site and now you want to create a SharePoint list in the site as well. Can this be done in Power automate? - [Handle commas in CSV files in Power Automate](https://sharepains.com/2020/09/08/handle-commas-csv-files-power-automate/): In the last week I've been asked 3 times how to handle commas in csv files. - [Export data and import it in Dynamics 365](https://sharepains.com/2020/09/03/export-data-import-dynamics-365/): Recently I've been doing quite a data migrations in Dynamics 365 or the Common Data Services using the export data and import data operations. - [Now set yourself to Do Not Disturb in Teams in Power Automate in 2 steps](https://sharepains.com/2020/08/17/set-do-not-disturb-teams-power-automate/): Have you tried to set yourself to Do Not Disturb (DND) in Power Automate? - [Filter by a SharePoint people field in Get items action in Power Automate](https://sharepains.com/2020/08/07/people-field-get-items-power-automate/): Filter queries in the Get items action in the SharePoint connector are quite easy, but what if you want to filter by a SharePoint People field? - [Populate 1 Excel template faster with Power Automate](https://sharepains.com/2020/08/04/populate-excel-template-power-automate/): Over the last week I've had multiple clients asking me about populating Excel template files with data. - [Microsoft Forms and Customer Voice in Power Automate](https://sharepains.com/2020/08/03/microsoft-forms-pro-in-power-automate/): Microsoft Forms is great to create a survey, but what if you want to use Power Automate to process responses? Should you upgrade to Customer Voice ( aka Forms Pro)? - [Synchronize Shifts from Microsoft Teams to Outlook Calendars](https://sharepains.com/2020/07/23/synchronize-shifts-teams-calendars/): Have you ever wanted to synchronize shifts in Microsoft Teams to evens in Outlook calendars? This is how you can do that! - [Run Script with Excel in Power Automate](https://sharepains.com/2020/07/21/run-script-with-excel-in-power-automate/): Did you notice the new run script action in the Excel connector when you use Power Automate? - [How to @mention someone in Microsoft Teams using Power Automate](https://sharepains.com/2020/07/07/mention-microsoft-teams-power-automate/): How many time have I seen people want to @mention someone in Microsoft Teams using Power Automate? Many Time! - [Developing code components in Power Apps](https://sharepains.com/2020/07/07/developing-code-components-in-power-apps/): In last week's post I introduced code components and the process of building them. in this post it is all about developing code components.  - [‘Real’ code to extend Power Apps](https://sharepains.com/2020/07/03/real-code-to-extend-power-apps/): In this post I will look at the options to extend Power Apps with code. - [Use mail folders in Microsoft Graph using Power Automate](https://sharepains.com/2020/07/01/use-mail-folders-in-microsoft-graph-using-power-automate/): One of my clients wanted to process mail in shared mail folders. - [SharePoint Migration Tool, Wow!](https://sharepains.com/2020/06/25/sharepoint-migration-tool-wow/): Have you used the SharePoint migration tool yet? - [New Chatbots in Power Apps!](https://sharepains.com/2020/06/24/new-chatbots-in-power-apps/): Today in Power Apps you will find a new option in the menu, Chatbots! - [Multiple SharePoint list forms on 1 Power Apps custom form](https://sharepains.com/2020/06/23/multiple-sharepoint-list-form-power-apps/): In Power Apps it is possible to have multiple SharePoint list forms on one list's custom form. - [Only 1 Input property needed for all Power Apps components](https://sharepains.com/2020/06/22/1-input-property-power-apps-components/): Do you end up with many input properties when you develop Power Apps components? You only need 1 input property! - [Call Power Automate flows from Power Apps components](https://sharepains.com/2020/06/22/power-automate-flow-powerapps-components/): Within you Power Apps there might sometimes be a need to call Power Automate flows, doing this from a component will reduce the number of flow calls that you need to configure. - [Power Apps Patch vs SubmitForm, Update and UpdateIf, 4 unique methods to change data](https://sharepains.com/2020/06/19/patch-vs-submitform-vs-update-power-apps/): When you update a record in Power Apps you can use Power Apps Patch, SubmitForm, Update or UpdateIf, but what is the difference between Patch, SubmitForm, Update and UpdateIf in PowerApps? - [Dynamically loaded images in Power Apps are invisible](https://sharepains.com/2020/06/16/dynamically-loaded-images-in-power-apps-are-invisible/): In this post i will look at dynamically loaded images and how these images may not appear in play mode. - [Get-TenantSettings and Set-TenantSettings in Power Apps](https://sharepains.com/2020/06/15/get-tenantsettings-and-set-tenantsettings-in-power-apps/): In this post I will have a look at changing some of the Power apps tenant settings using Get-TenantSettings and Set-TenantSettings. - [Roles in Microsoft 365](https://sharepains.com/2020/06/11/roles-in-microsoft-365/): Most administrators will be familiar with the 8 main admin roles in Microsoft 365. These 8 Microsoft 365 roles are called suggested roles as we will see later on in this post. - [Super Fast Update Excel using Power Automate](https://sharepains.com/2020/06/08/super-fast-update-excel-using-power-automate/): Have you tried to update Excel from a Power Automate flow? This can be slow if you do this the wrong way. - [Debug Power Apps better with Monitor](https://sharepains.com/2020/06/04/debug-power-apps-with-monitor/): Quite a while ago in 2018 I wrote about how to debug Power Apps. Then we still had to go through development steps just to understand what was happening in your app. - [Audience Targeting in SharePoint Online](https://sharepains.com/2020/06/02/audience-targeting-in-sharepoint-online/): A long time ago there was something like Audience targeting in SharePoint. Now that there is Audience Targeting in SharePoint Online it is time to write another post. - [Power Apps ThisItem, Parent and Self](https://sharepains.com/2020/06/02/parent-self-and-thisitem-in-power-apps/): With lasts week's new Self feature in Power Apps, I thought that it would be useful to have a look at Self, Parent and ThisItem. - [Customize meeting invitations in Microsoft Teams](https://sharepains.com/2020/06/01/customize-meeting-invitations-microsoft-teams/): Wouldn't it be nice if you could customize meeting invitations sent by Microsoft Teams? - [6 hidden functions in Power Apps until today](https://sharepains.com/2020/05/28/6-hidden-functions-in-power-apps-until-today/): Today I came across the SetFocus function and a few until now hidden functions in Power Apps as Microsoft updated the Function reference document. - [Game development, Create 1 awesome Othello app with Power Apps](https://sharepains.com/2020/05/26/create-othello-game-with-power-apps/): Game development in Power Apps can be a fun and awesome way of learning how to use the tools. - [8 supported file formats in the Power Apps Image Control](https://sharepains.com/2020/05/14/file-formats-power-apps-image-control/): Do you know which image formats are supported in the Power Apps Image Control? - [Components and Custom Properties in Power Apps](https://sharepains.com/2020/05/12/components-and-custom-properties-in-power-apps/): Moving data, with custom properties, between your app and components in Power Apps can be difficult. In this post I will look at updating data inside a component. - [Export Planner to Excel using Power Automate](https://sharepains.com/2020/05/07/export-planner-to-excel-using-power-automate/): Planner can be a great tool to manage your tasks, but how do you export planner to Excel files with Power Automate? - [5 reasons why you get a different user experience when you join a Microsoft Teams meeting](https://sharepains.com/2020/05/06/different-user-experience-join-teams/): How often does it happen that you join a Microsoft Teams meeting and you get a slightly different user experience from before. - [Incompatible Type and Variable Errors in Power Apps](https://sharepains.com/2020/04/30/incompatible-type-and-variable-errors-in-power-apps/): Incompatible Type errors are like apples and pears. Things just aren't all the same and you can expect to get some troubles. - [Containers vs Groups in Power Apps](https://sharepains.com/2020/04/30/container-vs-groups-in-power-apps/): Recently a new experimental feature, Container Control, has been released in Power Apps. - [Better Formula-level error Management and Power Apps Patch](https://sharepains.com/2020/04/27/power-apps-patch-with-formula-level-error-management/): Have you tried the Power Apps Patch function to update list items with formula-level error management enabled? - [Inputs in Manually trigger a flow](https://sharepains.com/2020/04/24/inputs-in-manually-trigger-a-flow/): During yesterday's user group meeting Paul Hunt mentioned an issue with inputs in the manually trigger a flow trigger. - [Free Power Apps and Power Automate in 2 minutes](https://sharepains.com/2020/04/23/free-power-apps-and-power-automate-in-2-minutes/): Did you know that you can get free Power Apps and free Power Automate in just 2 minutes? - [New PowerApps4Kids for you 365 days a year!](https://sharepains.com/2020/04/20/power-apps-for-kids/): When should you start with Power Apps? Is there any age restrictions? No there isn't! Kids can get started with PowerApps. - [Power Platform updates? Easy with Update Now!](https://sharepains.com/2020/04/16/power-platform-updates-easy-with-update-now/): Do you find that the Power Platform updates appear randomly. There is now an options to Update Now! - [Use 1 Parse JSON action to validate data](https://sharepains.com/2020/04/14/use-parse-json-action-to-validate-data/): Have you used the Parse JSON Action to generate Dynamic Content? Did you know that you can use it to validate json data? - [4 Data sources in the Power Platform](https://sharepains.com/2020/04/07/4-data-sources-in-the-power-platform/): You have a great idea for an app. You have no idea where to store your data. Which data sources do you use? - [3 ways of emailing data in Power Automate](https://sharepains.com/2020/04/02/3-ways-of-emailing-data-in-power-automate/): Have you tried emailing data from SharePoint lists to people? Have you ever found that you end up with one email for each item. - [Select All for a Multi-select choice field in Power Apps](https://sharepains.com/2020/04/01/select-all-in-power-apps/): How do you select all items in a multi-select choice column in a SharePoint form? - [Get 1 item in an array in Power Apps](https://sharepains.com/2020/03/31/get-1-item-in-an-array-in-power-apps/): A While back I wrote a post about arrays in Power Automate. Today I will look at arrays in Power Apps. - [The new Tests feature in Power Apps](https://sharepains.com/2020/03/27/power-apps-tests-feature/): Recently the option to add tests to your Power Apps has been added. This this post I will have a look at this new experimental feature. - [10 Policies to consider when implementing Microsoft Teams](https://sharepains.com/2020/03/25/policies-implementing-microsoft-teams/): If Microsoft Teams is just about turning it on and point people to the right location to get started then why are there so many policies to be configured in the Teams admin Center? - [Quickly edit data in your Common Data Service](https://sharepains.com/2020/03/23/edit-data-in-you-common-data-service/): When you use the Common Data Service as a data source it can be quite cumbersome to edit data. - [Create super fast joins of 2 arrays in Power Automate](https://sharepains.com/2020/03/20/create-joins-in-power-automate/): In my The advanced Pieter's method in Power Automate post, I received a comment asking about joins when using json arrays. - [2 New filter options in Get Files action in SharePoint connector](https://sharepains.com/2020/03/19/2-new-filter-options-in-get-files-in-sharepoint/): Remember last week's posts about getting all files in a folder in SharePoint? I used the Send an http request to SharePoint action avoiding the odata filter options in the get files action. - [Enable controls for owners in Power Apps](https://sharepains.com/2020/03/19/enable-controls-for-owners-only-in-power-apps/): How often do you want to enable controls for owners only when you work with Power Apps? - [5 Power Platform projects developers must know!](https://sharepains.com/2020/03/18/power-platform-projects-developers-must-know/): When you get started with Power Platform projects, you will quite quickly find all sorts of hurdles on your way. The Power Platform projects mentioned in this post may help you to get started in a smoother way. - [Get all files in a SharePoint folder using Power Automate](https://sharepains.com/2020/03/12/get-all-files-in-a-sharepoint-folder/): So often I hear complaints about SharePoint actions in flow not working. In this post I will look at the complication when you try to get all files in a folder in SharePoint. - [The advanced Pieter’s method in Power Automate in 2024](https://sharepains.com/2020/03/11/pieters-method-for-advanced-in-flows/): Yesterday, I noticed John Liu and Brian Dang discuss Pieter's method. This method is referring to my post of using a compose action inside an apply to each and then referring to this Compose action outside the Apply to each. - [3 steps to read csv files from SharePoint](https://sharepains.com/2020/03/09/read-csv-files-from-sharepoint/): In this post I will give a pattern for reading a csv file form SharePoint. - [Get the result of your failed actions in Power Automate](https://sharepains.com/2020/03/06/get-the-result-of-your-failed-actions/): Today, I bumped into the result function in Flow. We can now collect failed action details directly within the flow and report the failures in flows. - [Sort an array in Power Automate in 3 easy steps](https://sharepains.com/2020/03/05/sort-an-array-in-power-automate/): A while back I wrote about how to sort an array in Power Automate and I used an Azure function to do the job. One of the annoying things of that approach is that you will need to use a premium licence. - [What is better Multiple flows or 1 single flow?](https://sharepains.com/2020/02/28/multiple-flows-or-1-flow/): Today I got an interesting question submitted by one of my followers on the Share your pains page. How do you choose between multiple flows or a single flow? - [Install PowerShell for the Power Platform without admin rights](https://sharepains.com/2020/02/25/install-powershell-for-the-power-platform-without-admin-rights/): Have you tried installing PowerShell for the Power Platform yet? One of the annoying things is that you need to have admin rights. - [2 Concurrency options to better control speed in the Power Platform](https://sharepains.com/2020/02/24/concurrency-in-the-power-platform/): The Power Platform has a number of places where you can set or control concurrency. In this post I will have a look at the concurrency options available in the Power Platform and compare the different options in Power Apps and Power Automate. A while back I already wrote about the sense and nonsense of the concurrent function in Power Apps, in this post I will have a look at running multiple flows in a concurrent way or in a sequential order. - [Filter outlook contacts with birthdays only](https://sharepains.com/2020/02/20/filter-outlook-contacts-with-birthdays/): In outlook you may keep the contacts. For some of these outlook contacts you may have birthdays and for others you may not. What if you want to find all the people with a birthday in your Power Automate flows. - [Collect intermediate responses of Flow Approvals](https://sharepains.com/2020/02/17/collect-intermediate-responses-of-flow-approvals/): We are now ready to collect intermediate responses of my approval step that was started in the first flow. - [Now format numbers like $1,234.00 in Power Automate](https://sharepains.com/2020/02/14/format-numbers-in-power-automate/): How many times have you tried to format numbers in Power Automate. When you have a number and you would like to convert this to a currency formatted like $1,234.00 - [1 Flow Performance tip to get your flows out of the stone age](https://sharepains.com/2020/02/10/1-flow-performance-tip-to-get-your-flows-out-of-the-stone-age/): Are you flows slow, and did you wish that you could take your flows out of the stone age? Flow performance can be very important. - [How to size Power Apps components dynamically in 1 easy step!](https://sharepains.com/2020/02/07/size-power-apps-components-the-right-way/): The new Power Apps components feature adds a lot of options for reusing elements within your App. In this post I'm going to look at how to size Power Apps components. - [Classic SharePoint sites will be updated to modern in May 2020](https://sharepains.com/2020/02/05/classic-sharepoint-sites-will-be-updated-to-modern-soon/): Are you still running classic SharePoint team sites? Microsoft have announced that they will upgrade classic team sites to modern team sites soon, in March/May 2020. - [Power Platform Environment Product Settings](https://sharepains.com/2020/02/04/power-platform-environment-product-settings/): In the Product Settings section you can find settings grouped in 4 categories. - [Convert your time faster in Power Apps to all time zones using Power Automate](https://sharepains.com/2020/02/03/convert-your-time-in-power-apps-to-all-time-zones-using-power-automate/): So what you do when you want to convert your time to other multiple other time zones? - [Create backups of your Power Apps environment](https://sharepains.com/2020/01/31/create-backups-of-your-power-apps-environment/): Are you creating backups of your Power Apps? just in case someone damages the app or accidentally deletes the app? Do you export each app and keep the files somewhere secure? - [Secure your Input and Output in flows with Power Automate](https://sharepains.com/2020/01/30/secure-input-output-flows-power-automate/): Today, I noticed a new security feature in Power Automate. It is now possible to secure your data in flows. - [Power Apps Components and collections](https://sharepains.com/2020/01/27/power-apps-components-and-collections/): One of the known limitations with Power Apps Components is that collections are not supported. - [Paging in Power Apps galleries](https://sharepains.com/2020/01/23/paging-in-power-apps-galleries/): Today I found in on of my app an unexpected behaviour in related to paging in Power Apps Galleries. - [Data Cache timeout and background refresh in Power Apps](https://sharepains.com/2020/01/23/data-cache-timeout-and-background-refresh-in-power-apps/): After yesterdays post about preloading my Power Apps, today I found another feature related to performance in my newly created apps only. - [Start your Power Apps faster](https://sharepains.com/2020/01/22/start-your-power-apps-faster/): Do you want to Start your Power Apps faster? This morning I noticed a new setting on a new Power App that I created. - [Customize Forms on SharePoint Document Libraries with Power Apps](https://sharepains.com/2020/01/09/customize-forms-on-sharepoint-document-libraries-with-power-apps/): Today I noticed a new feature that I've been waiting for for quite a long time. It was already possible to customize forms on lists but now it is also possible to customize forms on SharePoint document libraries. - [Managing URIs in your flows with Power Automate](https://sharepains.com/2020/01/07/managing-uris-in-your-flows-with-power-automate/): Often I see the need to manage URIs when creating a flow. Power Automate has 6 operations available that can make your life easier. - [Search through all your Flow runs in Power Automate](https://sharepains.com/2020/01/06/search-through-all-your-flow-runs-in-power-automate/): Would it not be good if you could search run through all the output from actions in your flow runs? - [Microsoft Ignite the Tour – London](https://sharepains.com/2020/01/03/microsoft-ignite-the-tour-london/): Friday, January 17 I will speak at Microsoft Ignite the Tour in London. If you haven't registered yet for my sessions and you are going to the Microsoft Ignite the Tour London then please use the links below to register for my sessions: - [Get the user ID to update a people field in Microsoft SharePoint with Power Automate](https://sharepains.com/2019/12/17/get-the-user-id-to-update-a-people-field-in-sharepoint-with-power-automate/): A While back I wrote a post about Updating People Fields in SharePoint using Flow. On of the requirement is to get the user ID of the user that you want to set a field to. - [Power Automate Analytics – An overview](https://sharepains.com/2019/12/12/power-automate-analytics-an-overview/): Ok, there is still plenty of improvements possible. For example, it would be great if you could click through on the errors. The start of this global Power Automate analytics is a great step forwards. - [The sense and nonsense of the Concurrent function in Power Apps](https://sharepains.com/2019/12/06/the-sense-and-nonsense-of-the-concurrent-function-in-power-apps/): Recently I have found many Power Apps solutions that use the Concurrent function all the time. The idea that the Concurrent function will always make things run faster is not right. Sometimes however it does make sense to use the concurrent function. - [SharePoint Backups, Recycle bin and Version history](https://sharepains.com/2019/11/28/sharepoint-backups-recycle-bins-and-version-history/): Do you create any backups of your SharePoint libraries? - [7 golden rules of Flow development in Power Automate](https://sharepains.com/2019/11/28/7-golden-rules-of-flow-development/): In this post I'm going to give 7 golden rules of Flow development. Within Power Automate it is all too easy to develop Flows and forget about some standards that you might want to follow. - [Configuring UI Flows](https://sharepains.com/2019/11/27/configuring-ui-flows/): We weren't able to find the UI flows browser extension running - [External sharing in PowerApps](https://sharepains.com/2019/11/15/external-sharing-in-powerapps/): Recently external sharing of Power Apps has been enabled. - [Using Power Apps Patch to create a SharePoint list item](https://sharepains.com/2019/11/11/power-apps-patch-sharepoint-list-item/): The Power Apps Patch function can be used to create or update data, including SharePoint lists. - [1st Milton Keynes Power Platform User Group](https://sharepains.com/2019/11/08/1st-milton-keynes-power-platform-user-group/): Milton Keynes Power Platform user group about Power BI, Power Apps and Power Automate - [Renaming flows run from Power Apps](https://sharepains.com/2019/11/08/renaming-flows-run-from-power-apps/): Have you tried renaming flows? What if these flows are called from an app in Power Apps? - [Auto-refresh data in Power Apps](https://sharepains.com/2019/11/06/auto-refresh-data-in-power-apps/): When you use galleries in Power Apps to display data from a data source you will need to consider refreshing data. As the data is updated by other users you might want to auto-refresh your data. This post described a pattern for this. - [UI Flows in Power Automate](https://sharepains.com/2019/11/04/ui-flows-in-power-automate/): One other major new feature that I just discovered is the UI Flows. It is still marked as Preview but it looks like something that could be a game changer. - [How to make your flows run on a flow rather than user based licence](https://sharepains.com/2019/10/23/how-to-make-your-flows-run-on-a-flow-rather-than-user-based-licence/): How do you make your flows run on a flow based licence? Today I found an additional edit option in Microsoft Flow. This option can help you change the licence used by your flows. - [Connectors and the location of your environment in Flow](https://sharepains.com/2019/10/18/connectors-and-the-location-of-your-environment-in-microsoft-flow/): Initially I was just missing some connectors that I'd seen in some other environments. When you build your solutions in Flow you might want to consider the location of your environment. - [Store your files in the Common Data Service with Flow](https://sharepains.com/2019/10/17/store-your-files-in-the-common-data-service-with-microsoft-flow/): In general I will store my files in SharePoint. As SharePoint's document management capabilities of SharePoint match what I need. Document Libraries offer the option to store files and manage my files better than most other document stores. I do however sometimes need to store files in a different location, away for SharePoint. Today I had a look at storing documents in the Common Data Service using Microsoft Flow. - [Join us at the PowerApps and Flow User Group UK (London)](https://sharepains.com/2019/10/17/join-us-at-the-powerapps-and-flow-user-group-uk-london/): The next PowerApps and Flow user group meeting in London will be held on 21 November 2019 from 6:30 PM to 9:00 PM (GMT) with the following amazing speakers: - [Debugging flows, exclude steps temporarily](https://sharepains.com/2019/10/16/debugging-flows-exclude-some-steps-temporarily/): Have you ever tried debugging flows? Did you want to exclude some steps in your flow temporarily? Just so that you can test the steps that are failing. - [AI Builder – Form Processing](https://sharepains.com/2019/10/15/ai-builder-form-processing/): AI Builder was recently added to the Power Platform. In this post I will look at the Form Processing module. - [Update cells in Excel using Power Automate Flows](https://sharepains.com/2019/10/14/update-cells-in-excel-power-automate/): When you try to update cells in Excel using Power Automate you could use the Update a row action.  - [Long running flows in Power Apps in 2024](https://sharepains.com/2019/10/10/calling-long-running-flows-in-powerapps/): How often do you need to do something complicated in Power Apps and you use Flow to do this for you? Long running flows can cause problems. - [Handling apostrophes in a Flow](https://sharepains.com/2019/10/07/handling-apostrophes-in-power-automate/): In this post i will look at handling apostrophes in Power Automate. - [No Flow with PowerApps solutions](https://sharepains.com/2019/10/04/to-flow-or-not-to-flow-with-powerapps-solutions/): Have you found that you get no Flow/Automate option in Power Apps when you use solutions? - [Power Platform for Admins connector in PowerApps](https://sharepains.com/2019/10/04/manage-your-power-platform-with-the-powerplatform-for-admins-connector-in-powerapps/): After yesterday's post about the Power Platform for Admins connector, today it is time for the same connector in Power Apps. - [PowerPlatform for Admins connector in Flow](https://sharepains.com/2019/10/03/manage-your-power-platform-with-the-powerplatform-for-admins-connector/): Have you come across the PowerPlatform for Admins connector yet? This connector can be used to manage your PowerPlatform. Be very careful, when you try this connector as the delete actions options work very well! - [Automate business processes with the Power Platform](https://sharepains.com/2019/09/30/automate-business-processes/): Getting started within your organisation to improve and automate business processes that are currently paper of Excel based can be difficult. - [Get the version number of your app in Power Apps](https://sharepains.com/2019/09/27/version-number-of-your-app-in-powerapps/): Have you ever tried to get the version number of your app developed in Power Apps to display in your app? - [Retry after failures in Power Automate](https://sharepains.com/2019/09/27/retry-after-failures-power-automate/): What should you do when your flows hit some failures? In this post I will go through the retry pattern. - [Power Automate – Handling file locks in SharePoint](https://sharepains.com/2019/09/26/file-locks-sharepoint-power-automate/): Have you ever struggled to handle file locks in SharePoint when you are running your flows? - [Announcements in Microsoft Teams](https://sharepains.com/2019/09/24/announcements-in-microsoft-teams/): Have you ever wanted your announcements in Microsoft Teams to grab people's attention? in this post I will go through the steps to make sure that you get more out of Microsoft Teams using ht announcements feature. - [Record a video with Microsoft Teams](https://sharepains.com/2019/09/17/record-a-video-microsoft-team/): Have you ever tried to record a video but you found that you haven't got the right tools? Microsoft Teams can help! - [Query json in Power Automate](https://sharepains.com/2019/09/16/query-json-in-power-automate/): One of the important fundamental parts of Power Automate flow development is understanding how to query json. - [Document Properties in MS Word, 3 major issues?](https://sharepains.com/2019/09/13/document-properties-in-ms-word-3-major-issues/): In this post I'm looking at 3 major issues with document properties in MS Word. When you use SharePoint Online and rely on document properties used in document content to be correct. Recently some changes must have been made as the updates that you make in a SharePoint library form appear in document preview and my desktop client. - [Error Handling with Function Libraries in Flow](https://sharepains.com/2019/09/12/error-handling-with-function-libraries-in-microsoft-flow/): As the final episode of the Function Library pattern in Flow I'm going to look at error handling. Before I go any further please do review the following posts: - [Multiple Functions in Function Libraries in Power Automate](https://sharepains.com/2019/09/12/function-libraries-in-microsoft-flow-part-2/): In part 2 of this mini series about organising your flows into functions I will look at calling multiple functions. If you missed part 1 then please have a look at Function Libraries in Microsoft Flow, for the introduction of the function library pattern. - [Function Libraries in Power Automate](https://sharepains.com/2019/09/11/function-libraries-in-microsoft-flow/): When you think as a code developer and you start with Power Automate there will be a few patterns that you miss. In a first attempt to make every developer welcome, I developed the Try, Catch , Finally pattern in Microsoft Flow. Today I will have a look at being able to create reusable functions (in some languages called methods) in function libraries. - [Time travel with Power Automate](https://sharepains.com/2019/09/05/time-travel-with-microsoft-flow/): Hopefully you will have some spare time to go through this post. Recently I've been playing with time fields in Power Automate and it has been a struggle when times in systems don't match my local time. Calculations often don't make sense and it is important to offer the user the right time rather than the time used by a system. - [Option Sets in the Common Data Service](https://sharepains.com/2019/09/04/option-sets-in-the-common-data-service/): Within the CDS we have a drop down option available. As we saw in Entities in the CDS we can create fields of all sorts of types, one being the Option Set. - [Entities in the Common Data Service – Part 2](https://sharepains.com/2019/09/03/entities-in-the-common-data-service-part-2/): As part of my Common Data Service series I introduced entities in the first part of this post. Time to get on with creating an Entity. In this post I will create an entity for Cars.  The New Entity form will ask me for the singular and the plural name for the entity. - [Introduction to Entities in the Common Data Service](https://sharepains.com/2019/09/03/entities-in-the-common-data-service-part-1/): In this Introduction to Entities in the Common Data Service I will step through all the elements important when you start with CDS development. - [Common Data Service operations available in Power Apps](https://sharepains.com/2019/09/02/common-data-service-operations-available-in-powerapps/): As part of my Common Data Services series I'm looking at the operations available in the Common Data Service connector in Power Apps. - [Common Data Service actions and triggers available within Power Automate](https://sharepains.com/2019/09/02/common-data-service-actions-and-triggers-available-within-microsoft-flow/): In this post I will look at actions and triggers available in the Common Data Service connector. - [What is the Common Data Service?](https://sharepains.com/2019/09/02/what-is-the-common-data-service/): If you have been using Microsoft Flow, Power Apps or Power BI for a while then I'm sure that you have been using the Common Data Service (CDS). - [Common Data Service – a complete overview](https://sharepains.com/2019/09/02/common-data-service-a-complete-overview/): In this series of posts I will look at all the different elements in the Common Data Services (CDS). The subjects covered in this series are: - [Copy and paste in Microsoft Flow](https://sharepains.com/2019/08/30/copy-and-paste-in-microsoft-flow/): One of the great new features added to Flow has been copy and paste. Very often it really helps when you've got a complicated action that you want to use multiple times. There are however a few issues with this new feature but then we shouldn't forget that this is still in Preview. In this post I will give you some of my findings. - [How to Cancel workflows and Reassign approvals in Microsoft Flow](https://sharepains.com/2019/08/27/how-to-handle-cancel-workflows-and-reassign-approvals-in-microsoft-flow/): When you use approvals in Microsoft Flow you might have found the recent additions of Approve, Reject and Reassign in the Approvals UI. - [All about Timers in PowerApps](https://sharepains.com/2019/08/22/all-about-timers-in-powerapps/): When you create applications in Power Apps quite quickly you might want to create things that run in the background, using the timer control. - [Clear multi user fields in SharePoint Online using Power Automate with the REST API](https://sharepains.com/2019/08/21/clear-multi-user-field-power-automate/): I covered most types of fields previously but I didn't cover the clear multi user field problem in SharePoint Online. - [Collect emails and store details in Excel using Power Automate](https://sharepains.com/2019/08/20/collecting-emails-and-storing-details-in-excel-using-microsoft-flow/): Recently I was asked if it is possible to collect emails from a mailbox and store the email details in for example Excel using Microsoft Flow. Using Flow it is actually extremely easy to create an mail box as a way for people to update a data source. In my example here I will use Excel on OneDrive for Business but you could store the data in any other data store. - [1000000th visitor this week](https://sharepains.com/2019/08/19/sharepains-will-see-the-1-000-000th-visitor-this-week/): Since my first post in December 2010 a lot has changed to the SharePains blog. SharePains wasn't called SharePains and all my posts then were about SharePoint. 9 Years later I write about a lot more than just SharePoint. I never expected that 9 years later I would hit the 1000000th visitor. I'm not there yet though, but with just a few 1000 to go I would expect to hit the 1,000,000 this week. - [Microsoft Flow approvals from within outlook](https://sharepains.com/2019/08/07/microsoft-flow-approvals-from-within-outlook/): Note: This problem has now been fixed. I would like to thank Microsoft for the quick turn around for this approvals issue! - [PowerApps distinct collections](https://sharepains.com/2019/07/15/powerapps-distinct-collections/): When you have large arrays or collections of data and and the data has duplicates, you migth want to use the PowerApps distinct function - [Sort an array in Power Automate](https://sharepains.com/2019/07/13/sort-an-array-power-automate/): Have you ever tried to sort an array or collection in Power Automate? - [Create a hidden list in SharePoint Online](https://sharepains.com/2019/07/12/create-a-hidden-list-in-sharepoint-online/): I then started to think about this and hidden lists. How do you create hidden lists without code? First I created a new list. - [7 options to store data in Azure with Microsoft Flow](https://sharepains.com/2019/07/10/7-options-to-store-data-in-azure-with-microsoft-flow/): When you create flows you could store data in SharePoint or in CDS and Microsoft Flow will give you easy actions to create new items. But what if you want to store data in Azure. There are quite a few different options possible. In this post I will compare the options. - [Compose actions inside apply to each steps in Power Automate](https://sharepains.com/2019/07/09/compose-apply-to-each-power-automate/): In the run history each file was listed and I was quite happy with this. Inside the apply to each step can use this value. - [Using Markdown in Microsoft Flow approval actions](https://sharepains.com/2019/07/09/using-markdown-in-microsoft-flow-approval-actions/): Today I had a look at the option to use Markdown in Approval tasks. All the basic information can be found in the documentation, Use Markdown in Microsoft Flow approval requests. - [Power Apps just got more helpful when you get it all wrong](https://sharepains.com/2019/07/05/powerapps-just-got-more-helpful-when-you-get-it-all-wrong/): Power Apps just got more helpful, when things are wrong in your app. - [10 reasons to use Power Automate instead of Azure Logic Apps](https://sharepains.com/2019/07/04/power-automate-azure-logicapps/): Approvals is another one of these features that you will only find in Microsoft Flow and not in Logic Apps. Can you do without approvals? - [5 reasons to use Azure LogicApps instead of Microsoft Flow.](https://sharepains.com/2019/07/03/5-reasons-to-use-azure-logicapps-instead-of-microsoft-flow/): If you have been following my posts over the recent year you will know that I like writing about Microsoft Flow. Microsoft Flow is the tool to use if you want to implement workflow or automation processes,however there are some reasons why you may want to use Azure Logic apps instead. - [Inform authors when a document is deleted from SharePoint with Microsoft Flow](https://sharepains.com/2019/07/01/inform-authors-when-a-document-is-deleted-from-sharepoint-with-microsoft-flow/): In my post about the When a file is deleted trigger in Microsoft Flow I described the trigger that will fire when a document is deleted. - [App not appearing in Power Apps web part with new app url](https://sharepains.com/2019/06/28/app-not-appearing-in-powerapps-web-part-with-new-app-url/): This morning I noticed that the Power Apps web links changed and from within my Power Apps web part in SharePoint the app did not appear - [Dynamics 365 Plans and licensing](https://sharepains.com/2019/06/27/dynamics-365-plans-and-licensing/): I always thought that SharePoint licensing was complicated. Recently I have changed my mind on this. Have you ever looked into Dynamics 365 Plans and  licensing? On the Dynamics 365 Pricing site you can find a great overview in the licensing guide with 60 pages of details explaining it all. - [Better Performance in Power Apps](https://sharepains.com/2019/06/25/performance-in-powerapps/): Power Apps is all about user experience. If performance is poor then your Power App might not be very well received by your users. - [Do Until in Power Automate](https://sharepains.com/2019/06/24/do-until-in-microsoft-flow-first-do-then-think/): Whether you use Dynamics 365 or SharePoint Online, in Power Automate there are quite a lot of controls that help you build your business processes. One of those controls is the Do Until control. - [Azure Functions vanishing into thin air](https://sharepains.com/2019/06/18/azure-functions-vanishing-into-thin-air/): Have you ever developed Azure Functions and suddenly they vanished into this air? - [Cancel pending approvals in Power Automate](https://sharepains.com/2019/06/13/cancel-your-pending-approvals-in-microsoft-flow/): There are quite a few posts about approvals in Power Automate. Have you ever noticed that when you have one of your flows sending an approval that there is no option to cancel the pending approval step? - [Filter queries in the List records action using the Microsoft Dataverse connector](https://sharepains.com/2019/06/10/filter-queries-in-the-list-records-action-in-the-microsoft-dataverse-connector/): Today I'm writing about the Filter queries in the List records action when you use the Microsoft Dataverse connector in Power Automate. - [Comparing Nintex workflow with Microsoft Flow – part 1](https://sharepains.com/2019/06/07/comparing-nintex-workflow-with-microsoft-flow-part-1/): When comparing Nintex and Flow there are some major differences. One of the main differences is the scope of the products. - [Move a list item attachment to a Document Library with Power Automate](https://sharepains.com/2019/06/05/move-item-attachments-document-libraries/): In this post the easy steps for the creation of files when you receive list item attachments. - [Exit PowerApps, Are you sure?](https://sharepains.com/2019/06/03/exit-powerapps-are-you-sure/): Today I had a look at exiting a Powerapp. I create the My Exit App. This app has just a single button. - [Copy large files with Power Automate](https://sharepains.com/2019/05/31/copy-large-files-with-microsoft-flow/): When you work with large files in Power Automate you will find that there are some things that you need to consider when you copy large files. - [Secure your data gateway with Microsoft Flow and PowerApps](https://sharepains.com/2019/05/30/secure-your-data-gateway-with-microsoft-flow-and-powerapps/): Have you looked at connecting to on-premises data with the PowerPlatform yet? Are you worried about security? In this post I'm looking at the available security options in the Data Gateway. - [How to create a multi-lingual app in PowerApps.](https://sharepains.com/2019/05/29/how-to-create-a-multi-lingual-app-in-powerapps/): To create a multi-lingual app in PowerApp there are a number of things that you need to consider. First of all which languages are your users using and which languages are you going to support. To identify which language your user is using there is the useful function Language() available - [Get file content x2 from SharePoint in Microsoft Flow](https://sharepains.com/2019/05/28/get-file-content-x2-from-sharepoint-in-microsoft-flow/): SharePoint is all about document management. Therefore to get file content from a file must be something easy. - [Aggregate all tasks from your plans in Planner and PowerApps](https://sharepains.com/2019/05/24/aggregate-all-your-tasks-in-planner-and-powerapps/): Would it not be nice if you could aggregate all tasks and present them all in a single location? - [Multiple arrays in a single object in Microsoft Flow](https://sharepains.com/2019/05/24/multiple-arrays-in-a-single-object-in-microsoft-flow/): Reformatting data in flow is one of those critical patterns. Taking multiple arrays and reshaping them  can be a challenge. - [How responsive is your app developed in PowerApps?](https://sharepains.com/2019/05/20/how-responsive-is-your-app-developed-in-powerapps/): We all want to to create our apps in a responsive manner, but how do you check that your Power App that you developed is actually responsive? For this post I've created a simple Power Apps that will show some of the issues. - [MQ Series, you need LogicApps rather than Power Automate](https://sharepains.com/2019/05/17/mq-series-when-you-need-logicapps-rather-than-microsoft-flow/): I'm sure all my followers are aware that I use Power Auotmate for a lot of the solutions that I deliver to my clients. Sometimes however Flow needs a bit of help from its Azure friend,  LogicApps. LogicApps and Flow are almost the same, but there are a few reasons why you might want to use LogicApps. In this post I will look at the MQ Series connector that I recently implemented for one of my clients. - [Power Automate – Sometimes you just have to wait](https://sharepains.com/2019/05/15/power-automate-wait/): Sometimes in Flow you just have to wait for a while. There are a few options available that I will look at in this post. Before I dive into Microsoft Flow I will have a look at traffic control systems. Yes that is these traffic lights that are always on red when you are in a hurry. - [3 options to create your flows in Microsoft Flow](https://sharepains.com/2019/05/08/3-new-options-to-create-your-flows-in-microsoft-flow/): Recently some new options have been added to create new flows in Microsoft Flow. - [7 one line expressions that could help you in Power Automate](https://sharepains.com/2019/05/06/one-liner-expressions-power-automate/): Sometimes it is the small things in power Automate that make it difficult to get the job done! In this post I'm looking at 10 one-line expressions that can help. Most of these on liners will fit in that small expression box. - [Flooded Microsoft Flow showing Error Loading Component](https://sharepains.com/2019/05/02/flooded-microsoft-flow-showing-error-loading-component/): And when I hover over the warnings I see the Error loading component. - [Implementing a Try, Catch, Finally in Logic Apps](https://sharepains.com/2019/05/01/logic-apps-implementing-a-try-catch-finally-in-a-logic-app/): On a regular basis I refer Microsoft Flow developers to my Try-Catch-Finally-patttern, but what if you need to use LogicApps. Can you use the same pattern? - [Deploy flows to all your project sites, or maybe not!](https://sharepains.com/2019/04/29/microsoft-flow-deploying-flows-to-all-your-project-sites-or-maybe-not/): Have you had a need to deploy flows in Power Automate to many SharePoint sites? - [Microsoft PowerApps CLI](https://sharepains.com/2019/04/24/microsoft-powerapps-cli-time-for-the-non-citizen-developers-to-get-more-involved/): We already had PowerApps PowerShell for a while. Yesterday, the PowerApps CLI was released. - [Formatting dates in Power Apps](https://sharepains.com/2019/04/23/formatting-dates-in-power-apps/): A while back I wrote about formatting dates in Power Automate. Today it's Power Apps time! - [Are Microsoft Flow and PowerApps really only for citizen developers?](https://sharepains.com/2019/04/21/are-microsoft-flow-and-powerapps-really-for-citizen-developers/): I hear a lot of people talk about citizen developer tools. These tools are there to make development of software easy. In this post I'm going to have a look at PowerApps and Flow. Are these two Low-Code tools really for citizen developers? Are these tools also great for the 'real developers'? Will citizen developers be able to get the most out of these products? - [Drag and Drop in Power Apps](https://sharepains.com/2019/04/16/drag-and-drop-in-powerapps/): Power Apps is great but there are some limitations. One of these limitations is drag and drop. Wouldn't it be nice if you could drag a document into a Power App and then Power Apps uploads the document to a Document library. Well, you can do this with Power Apps. - [Visio to Microsoft Flow is it going to help you?](https://sharepains.com/2019/04/16/visio-to-microsoft-flow-is-it-going-to-help-you/): Microsoft is every now and then releasing some information about their new Visio to Microsoft Flow feature.  Last week yet another article describing this new feature but is this really something that you are going to use? - [Power Automate and Power Apps Q & A](https://sharepains.com/2019/04/12/microsoft-flow-and-powerapps-q-a/): Many people start with Power Automate or Power Apps every day. In this post I'm answering many questions that I've been asked on a regular basis. - [3 Ways of using the “For a selected item” trigger on large lists in Microsoft Flow](https://sharepains.com/2019/04/12/3-ways-of-using-the-for-a-selected-item-trigger-on-large-lists-in-microsoft-flow/): Sometimes you want users to be able to select an item in SharePoint and then run a flow for the selected item. The For a selected item trigger is great but what if you have many items. There are a few options available. in this post I will look at the options. - [Broken connections in Power Automate](https://sharepains.com/2019/04/11/broken-connections-in-microsoft-flow/): When you use connectors in Power Automate you may have seen broken connections. - [Go Pro with Microsoft Flow and Power Studio – Part 2](https://sharepains.com/2019/04/09/go-pro-with-microsoft-flow-and-flow-studio-part-2/): The HTTP Webhook -> Send an email(V2) flow had the word flic in the email body. Wow this is definitely a reason to go Pro. You can find in now time the right flow. This probably isn't too important when you only have 1 or 2 flows, but ones your organisation has adopted Microsoft Flow  like my customers have done you will want this feature - [Using John Liu’s Flow Studio](https://sharepains.com/2019/04/08/microsoft-flow-with-flow-studio-part-1/): This is a great opportunity for the Microsoft community to create some add-ons.  Like with all Microsoft Technology there are 3rd party tools around that can help you with all sorts of things that aren't there yet in the standard product. For Microsoft Flow there is one of those amazing tools that can help you too. In this post I will go through the free version of Flow Studio. More about the Pro version you can read in my post about the Pro version of Flow Studio too. - [Has external access to PowerApps stopped your organisation?](https://sharepains.com/2019/04/05/has-external-access-to-powerapps-stopped-your-organisation/): Now that Microsoft has started to develop external access for PowerApps a whole new world of app opportunities will open up. Are you interested in finding out what this could mean for your organisation? Feel free to contact me or any of my colleagues and I'm happy to discuss the possibilities. - [Help! My Microsoft Flow, Power Apps and Power BI are not working as expected, where do I go?](https://sharepains.com/2019/04/05/help-my-microsoft-flow-powerapps-and-powerbi-are-not-working-as-expected-where-do-i-go/): How often does it happen, you are working on Microsoft Flow, Power BI or Power Apps and something isn't working as you hoped for. Of course before you blame yourself, the tools just don't work! But how do you confirm that something that you are using is not working.  You can't be the only one having this problem. - [Cancel all your approvals in Microsoft Flow using PowerShell](https://sharepains.com/2019/04/04/cancel-all-your-approvals-in-microsoft-flow-using-powershell/): Have you ever been silly enough to develop a flow that creates a lot of approval actions in Microsoft Flow?  I have! Now you need an easy way to cancel them all in this post I'm going to go through the steps. - [Relative positioning in PowerApps, the options](https://sharepains.com/2019/04/03/powerapps-relative-positioning-in-powerapps-the-options/): Today I will have a look at relative positioning of elements in PowerApps. As you add elements like labels, icons,input boxes or anything else on the screen you will find that you often change your mind about the exact location of these elements. - [Create your menus using a gallery in Power Apps](https://sharepains.com/2019/04/02/create-your-menus-using-a-gallery-in-powerapps/): Quite a common task in Power Apps is to create a menu. You might already have figured out that a menu is easily created using a Gallery. Remember my recent post about galleries? Today I'm looking at some more advanced techniques related to navigation options within Power Apps. - [Do you give any praise to your colleagues, Microsoft Teams makes giving praise easy!](https://sharepains.com/2019/04/01/microsoft-teams-do-you-give-any-praise-to-your-colleagues-teams-makes-giving-praise-easy/): In Microsoft Teams there is now a new option available to give praise to your colleagues. - [Microsoft Flow – Trigger flows on specific fields only](https://sharepains.com/2019/04/01/microsoft-flow-trigger-flows-on-specific-fields-only-using-a-shadow-list-in-sharepoint/): One of the long outstanding improvements needed in Microsoft Flow has been discussed for a long time. Solutions provided have always been either too complicated or just impossible to work with. Related to this issue is also the difficulty to find out previous values of the list items in SharePoint in your flows. - [Update a multi select choice field in a SharePoint list with Power Automate](https://sharepains.com/2019/04/01/update-a-multi-select-choice-power-automate/): Have you tried to update a multi select choice field in a SharePoint list with Power Automate? - [8 ways to create your next app in PowerApps](https://sharepains.com/2019/03/28/8-ways-to-create-your-next-app-in-powerapps/): There are many different ways that you can create a new app in PowerApps. When you decide that you need an app you might be making a choice that you later on may regret. - [PowerApps – Get your unique items listed in a gallery](https://sharepains.com/2019/03/26/powerapps-get-your-unique-items-listed-in-a-gallery/): Now I'm going to take that same array of items but I want to only display unique items. In short on of the two "4" items should disappear. - [SharePoint Online – Hub sites and global navigation placeholders](https://sharepains.com/2019/03/22/sharepoint-online-hub-sites-and-global-navigation-placeholders/): Recently I created a hub site for a new intranet. Initially the idea was to create a global navigation that would match the navigation needed by my client, however only a limited number of navigation options would have real links. As my client was happy with the general structure we decided to add a few more real sites behind the links in the navigation. Quite quickly I ran into the problem where it wasn't possible to update the links. - [PowerApps – Galleries are everywhere](https://sharepains.com/2019/03/22/powerapps-galleries-are-everywhere/): In this post I'm going to have a look at galleries in PowerApps. - [SharePoint Online – Custom branding for modern sites](https://sharepains.com/2019/03/21/sharepoint-online-custom-branding-for-modern-sites/): The custom branding options in SharePoint Online change quite frequently. I found a few different options of doing things but not all options work when you are using Hub Sites. - [5 Accessibility features in PowerApps that every app developer should consider](https://sharepains.com/2019/03/20/powerapps-5-accessibility-features-in-powerapps-that-every-app-developer-should-consider/): Accessibility is not important! Unless you have a real need for it. This is exactly the problem with developing apps in PowerApps. How many developers have a need for accessibility to be considered? How many developers understand accessibility? Within this post I'm looking at some of the accessibility features available within PowerApps. - [Power Automate – How to find your overdue tasks?](https://sharepains.com/2019/03/18/microsoft-flow-how-to-find-your-overdue-tasks/): Today, I was asked how to get overdue tasks in a SharePoint task list. In SharePoint tasks are nicely marked red when they are due, but to query the tasks by due date in Flow is slightly harder, or maybe it is not that difficult after all. - [Negative queries with OData in Power Automate](https://sharepains.com/2019/03/14/microsoft-flow-time-to-look-at-negative-queries-with-odata/): Yesterday I was asked about OData filters in Power Automate. In the past I wrote a post about OData filters.  When you try to query with the startswith function  it is possible to get all the items in a SharePoint that have a title that start with 'Get'. - [How to make your Flic Button work in Microsoft Flow](https://sharepains.com/2019/03/13/microsoft-flow-how-to-make-your-flic-button-work/): Recently I got hold of a Microsoft Flow Flic button. In this post I'm going through the steps of configuring my Flic button and how you could use it. If you don't have a flic button yet, then you can order yours on the flic site. Note that you will need to use your mobile connection to make your button work. So if you don't have a connection on your mobile your flic button will not work either. - [5 reasons to use Peek code in Power Automate](https://sharepains.com/2019/03/08/peek-code-in-power-automate/): Have you used the peek code option in Power Automate yet? - [How to clear fields in SharePoint list items using Power Automate](https://sharepains.com/2019/03/07/clear-fields-in-sharepoint-list-items/): Yesterday on LinkedIn I was asked about how to clear fields using Power Automate, by Matthew Bourne working at Heathrow. - [Microsoft Flow – Custom Connectors – How to read an Excel file from SharePoint?](https://sharepains.com/2019/03/04/microsoft-flow-custom-connectors-how-to-read-an-excel-file-from-sharepoint/): A while back I wrote a post about reading Excel files stored in SharePoint using Microsoft Graph. This has been a post that has been helpful to many people so why hasn't this been turned into a custom connector? - [Microsoft Ignite the tour London two amazing MVP days](https://sharepains.com/2019/03/01/microsoft-ignite-the-tour-london-two-amazing-days-out-of-an-mvps-life/): This week was the first time the Microsoft Ignite the tour event came to London. I was fortunate enough to be involved in 3 sessions over two days. Looking through the list of speakers shown in Anna Chu's tweet you can see how amazing this event is. - [Power Automate – Is timeout handling your worst nightmare?](https://sharepains.com/2019/02/22/microsoft-flow-is-timeout-handling-your-worst-nightmare/): In my above example I'm sending emails when a timeout has occurred or when a HTTP call has failed. Depending on what the call was doing you might need to redo or correct something. This is where timeout handling becomes potentially complicated. - [Microsoft Flow – Are state machines really needed?](https://sharepains.com/2019/02/20/microsoft-flow-are-state-machines-really-needed/): Is there anything that stops you from using Microsoft Flow? Whenever this question is asked there are some people responding, "State Machine are needed!" Many people are comparing Microsoft Flow with SharePoint Designer workflows or Nintex. Although SharePoint Designer has never had State machines, Nintex has had a State Machine action for many years. Over the past years the state machine pattern has become a standard way of developing complex processes. Just in case you are new to state machines please have a look at Vadim's blog post.  Many years ago I wrote a post about State machines in Nintex too. Do I like state machines? Of course I do! But are they really necessary? - [Get started with offline apps in Power Apps](https://sharepains.com/2019/02/13/power-apps-offline-apps/): In this post I'm looking at the first steps of creating offline apps. - [SharePoint Online – Failed to instantiate file “CustomStrings.js” from module](https://sharepains.com/2019/02/06/sharepoint-online-failed-to-instantiate-file-customstrings-js-from-module/): Failed to instantiate file "CustomStrings.js" from module "_catalogsmasterpageDisplay TemplatesLanguage Filessr-latn-cs_Features\SearchWebParts\sr-latn-cs": Source path "Features\SearchWebParts\sr-latn-cs\CustomStrings.js" not found. - [Microsoft Flow – Peek code](https://sharepains.com/2019/02/05/microsoft-flow-peek-code/): Today I bumped into the Peek code option in Microsoft Flow. Peek code in no code platforms. Of course LogicApps has had this peek code for a while. But this is new to Flow. - [PowerApps – Add a Google search web part to your modern SharePoint page in 5 minutes](https://sharepains.com/2019/02/04/powerapps-add-a-google-search-web-part-to-your-modern-sharepoint-page-in-5-minutes/): For most organisations google is the most used site. As many organisations set the default browser home page to a SharePoint intranet many users may find that they are redirected to the site that they don't want to get to. An easy solution would be to add a Google web part to a page. - [PowerApps – Connect to your SharePoint document library](https://sharepains.com/2019/02/04/powerapps-connect-to-your-sharepoint-document-library/): Within PowerApps it is easy to take data from almost anywhere. As a SharePoint developer you might store data in SharePoint lists, but what if your data is stored with documents then it's a whole different story or maybe not, but you will find some hurdles on your way. - [1 Parameter to send your data from Power Apps to Power Automate](https://sharepains.com/2019/01/29/powerapps-data-power-automate-parameters/): When you send data from Power Apps to Power Automate, do you use more than one parameter? - [Access your Common Data Service using PowerShell](https://sharepains.com/2019/01/28/powerapps-microsoft-flow-access-your-cds-using-powershell/): Recently Microsoft have added the Common Data Service to PowerApps and Power Automate. The easiest way to manage some of the CDS is PowerShell. - [Power Apps Functions and Expressions](https://sharepains.com/2019/01/25/power-apps-functions-expressions/): Power Apps functions and expressions are the base of the low code success of your apps. - [PowerApps – Experiment with error handling](https://sharepains.com/2019/01/24/powerapps-experimenting-with-error-handling/): Within PowerApps there is an experimental feature that could be quite useful. Time to experiment with these features. - [Manage your flow owners from SharePoint list permissions in Power Automate](https://sharepains.com/2019/01/22/flow-owners-sharepoint-list-permissions/): Wouldn't it be easy if you could just reuse permissions and set your flow owners on SharePoint lists on your flows? - [PowerApps / Microsoft Flow – Using data in SQL Azure](https://sharepains.com/2019/01/21/powerapps-microsoft-flow-using-data-in-sql-azure/): It feels like there is some sort of PowerApps to SQL cache that is taking time to update. I'm struggling to find any information on the architecture between PowerApps and SQL Azure DBs. - [PowerApps – Camera vs Add Picture and get your images to your Flow](https://sharepains.com/2019/01/18/powerapps-camera-vs-add-picture-and-get-your-images-to-your-flow/): Using these controls I created an app that gives the user the options to upload a picture using the Add Picture control or take a picture using the camera control. - [Microsoft Flow – PowerApps – Create your own custom version of standard connectors](https://sharepains.com/2019/01/10/microsoft-flow-powerapps-create-your-own-custom-version-of-standard-connectors/): Did you know that you can customize standard connectors in Microsoft Flow? Well you actually can't modify them but you could create your own version as a custom connector. - [Microsoft Flow / PowerApps – Common Data Service or SharePoint Lists](https://sharepains.com/2019/01/09/microsoft-flow-powerapps-common-data-services-or-sharepoint-lists/): In this post i'm considering SharePoint lists and I'm considering the Common Data Service ( CDS ). Which one of these lists is better? There is always the choice Common Data Service or SharePoint Lists - [PowerApps – Common Data Services, the Ins and the Outs of your data store](https://sharepains.com/2019/01/07/powerapps-common-data-services-the-ins-the-outs-of-your-data-store/): In my previous post I mentioned the Common Data Services. In this post I will look at the ins and outs of CDS in more detail. - [Dynamics 365 vs the Common Data Service](https://sharepains.com/2019/01/03/dynamics-365-vs-the-common-data-services/): Dynamics CRM, Dynamics 365, Common Data Service it can be very confusing. What is what? - [Twitter Sentiment and Power Automate](https://sharepains.com/2018/12/19/twitter-sentiment-and-power-automate/): Using Azure cognitive services to check sentiment in tweets about you can help you find any negative news about yourself - [Filter an array or collection in Power Automate](https://sharepains.com/2018/12/18/filter-an-array-power-automate/): When you want to filter an array in a Power Automate flow, there are a couple of challenges you might face. - [Create custom connectors in Power Automate](https://sharepains.com/2018/12/17/create-custom-connectors-power-automate/): In Part 1 of this series of posts I have looked at how to create custom connectors in Power Automate. - [Write custom flow connectors in Power Automate](https://sharepains.com/2018/12/17/microsoft-flow-write-your-own-custom-connectors-part-1/): Sometimes you might find that you need to create custom Flow connectors for applications that aren't available in the list of connectors. - [User or service accounts in Power Automate](https://sharepains.com/2018/12/12/user-or-service-accounts-power-automate/): Many people are asking the question, should I use my personal account or should I use service accounts in my Power Automate flows? - [Work with Outlook tasks using Microsoft Flow](https://sharepains.com/2018/12/07/microsoft-flow-work-with-outlook-tasks-using-microsoft-flow/): Personally I don't really like working with outlook tasks, but I know that a lot of people do use outlook tasks. In this post I will have a look at creating tasks and completing tasks using Microsoft Flow. All the actions used in the below examples are using the Outlook Tasks connector. - [5 ways to send an SMS from a Flow in Power Automate](https://sharepains.com/2018/12/07/send-an-sms-flow-power-automate/): In Power Automate it is possible to send an SMS. The various connectors in this overview will help you with this task. - [Microsoft Flow – The INs and OUTs of triggers and actions](https://sharepains.com/2018/12/06/microsoft-flow-the-ins-and-outs-of-triggers-and-actions/): When I started with Microsoft Flow, I started with understanding triggers and actions. Then quite quickly I discovered dynamic content and expressions. Data moves from one a step to another with ease but sometimes things get a bit harder.In this post I will look at the input and the output of each step in Microsoft Flow. - [Record Teams meetings and now quickly find the recording](https://sharepains.com/2018/12/05/record-meetings-find-recordings-teams/): So many people ask me where are Microsoft teams recordings stored? - [Microsoft Flow – Create currency output](https://sharepains.com/2018/12/04/microsoft-flow-create-currency-output/): Today, I tried to convert a number into currency using Microsoft Flow. - [Import an Excel spreadsheet into SharePoint lists with Power Automate](https://sharepains.com/2018/12/03/import-an-excel-spreadsheet-sharepoint/): Over the last few weeks I have seen quite a few people asking questions about comparing two lists, synchronize lists and import an excel into SharePoint lists. Within this post I'm going to include an approach to getting all of this done with just 1 flow. - [Is PowerShell preview turning into PowerShell deprecated?](https://sharepains.com/2018/11/28/azure-functions-is-powershell-preview-turning-into-powershell-deprecated/): Today I tried to move one of my PowerShell scripts that I was running as a scheduled task to my Azure Functions. Remembering how I did this a while back with some PnP PowerShell scripts I knew that Azure Functions could do this. I found quite quickly that the preview functionality looked like turning into deprecated options. - [Multi select choice fields in Power Automate](https://sharepains.com/2018/11/27/multi-select-choice-field-power-automate/): I have a list with a multi select choice field, depending on which option has been selected I want to run some steps in a Power Automate flow. - [PowerApps – Office 365, P1, P2 or Dynamics 365](https://sharepains.com/2018/11/27/powerapps-office-365-p1-p2-or-dynamics-365/): After yesterday's post about licensing in Microsoft Flow, I thought it would be useful to do the same comparison for PowerApps. - [Microsoft Flow Free, P1 or P2 licences?](https://sharepains.com/2018/11/26/microsoft-flow-free-p1-or-p2-licences/): I'm quite sure that you like the first flavour! Maybe like me, you have been asking why bother with P1 or P2? The pricing of the Premium products may stop you. Are the paid for options worth it? In this post I will go through the differences. - [Is security important to you?](https://sharepains.com/2018/11/21/is-security-important-to-you/): This morning I was told a story about someone who lost a lost of money as a bank gave access to someone's account after some basic security questions were asked. Is security important? - [PnP PowerShell – Apply-PnPProvisioningTemplate stuck on initializing engine](https://sharepains.com/2018/11/20/pnp-powershell-apply-pnpprovisioningtemplate-stuck-on-initiliazing-engine/): Today I used PnP PowerShell to provision one of my sites. For some reason my Apply-PnPProvisioningTemplate  CmdLet just didn't want to run properly. Every time I ran Apply-PnPProvisioningTemplate it would just hang on Initializing engine.  I enabled the debugging for my PnP Powershell, but still I didn't have much luck finding out what was happening. - [Microsoft Flow – Generate PDFs from anything and a lot more](https://sharepains.com/2018/11/16/microsoft-flow-generate-pdfs-from-anything-and-a-lot-more/): Sometimes, the new connectors are added to Microsoft Flow that open up a lot of options. One of those connectors was added to Flow last night. The Encodian connector makes it possible to do a lot with PDFs. - [Nested arrays with a single item in Power Automate](https://sharepains.com/2018/11/13/nested-arrays-single-item-power-automate/): This post is all about unnecessarily complicated data structures like nested arrays with a single item in them. - [SharePoint Online, should content types still be used?](https://sharepains.com/2018/11/13/sharepoint-online-to-content-type-or-not-to-content-type-that-is-the-question/): Quite a while ago when the modern libraries were introduced I already started to question the use of content types. In my post Are content types dead? I first questioned the use of content types. Looking at the latest changes in Document Libraries I'm starting the question if the end of the content types is near. - [formatDateTime in Power Automate](https://sharepains.com/2018/11/12/formatdatetime-power-automate/): Quite often people want to send dates in an email, however formatting these dates doesn't seem to be that easy. In this post I will look at formatDateTime to format dates in Power Automate. - [SharePoint odata filter query in Get items actions in Power Automate in 2025](https://sharepains.com/2018/11/12/microsoft-flow-filter-queries-in-sharepoint-get-items/): The SharePoint odata filter query in get items actions can optimize your flows in Power Automate. - [Microsoft Flow – Share photos or other files in SharePoint](https://sharepains.com/2018/11/09/microsoft-flow-share-photos-or-other-files-in-sharepoint/): Today I had a look at the button options in Microsoft Flow. - [Set a people field in SharePoint with Power Automate when all you have is a user’s name.](https://sharepains.com/2018/11/05/microsoft-flow-set-a-people-field-in-sharepoint-when-all-you-have-is-a-users-name/): Have you tried updating a people field in SharePoint? It can actually be very simple. In my case all I had was a list of firstnames and lastnames of the people and I needed to update a list of items in SharePoint. - [Microsoft Flow – Types of flows](https://sharepains.com/2018/11/05/microsoft-flow-types-of-flows/): Have you ever noticed that some flows start immediately, where other flows seem to take a while before they get started. Different types of triggers work in different ways. The flow team has now made it easier to recognise the different type of triggers used by your flows. - [Compare dates using conditions in Power Automate](https://sharepains.com/2018/11/02/compare-dates-using-conditions/): When you compare dates in Power Automate conditions, you will quickly hit some difficulties. - [Error code: ‘InvalidApprovalSubscribeRequestAssignedToMissing’.](https://sharepains.com/2018/10/30/invalidapprovalsubscriberequestassignedtomissing/): Today I ran into the following error, after I found the following request on the Flow community site. - [Microsoft Flow – Get your data out of email using Parseur](https://sharepains.com/2018/10/29/microsoft-flow-get-your-data-out-of-email-using-parseur/): Maybe not the first option for integrations,but have you ever wanted to get information out of emails that you receive form applications? Imagine that you need to integrate with an application that you don't own. - [Microsoft Flow – Sending out reminders](https://sharepains.com/2018/10/23/microsoft-flow-sending-out-reminders/): Quite a common problem is to send out reminders when SharePoint list items or documents haven't been modified for a while. The tricky part of this is that there is no trigger for 'something happened a while back'. - [Power Apps – Screen templates, now this is a feature that I really like](https://sharepains.com/2018/10/22/powerapps-screen-templates-now-this-is-a-features-that-i-really-like/): One of the difficulties with Power Apps is to get started. You could of course start by using one of the Application Templates. Although these may look good, none of these really do what I want to do. - [Content types and bulk edit properties in SharePoint Online](https://sharepains.com/2018/10/22/content-types-and-bulk-edit-properties/): Do you work with content types in SharePoint Online? Do you bulk edit properties? If the answers to both these questions is yes then you will have noticed the content type field on the edit forms.  - [Power Automate – Read large Excel files within seconds without creating tables using Microsoft Graph](https://sharepains.com/2018/10/17/read-large-excel-files-power-automate/): In Microsoft Flow it is possible to use the Excel connectors to read data form a spreadsheet. When you want to read large Excel files you might run into issues. - [Improve your flow’s performance in a few easy steps](https://sharepains.com/2018/10/15/microsoft-flow-improve-your-flows-performance-in-a-few-easy-steps/): In recent days I've had a look at performance in Microsoft Flow and how to improve the performance of my flows with easy steps or patterns. We all know that nested Apply to each steps are not a great idea or maybe ... - [Business process flows from a traditional Flow perspective](https://sharepains.com/2018/10/15/microsoft-flow-business-process-flows-from-a-traditional-flow-perspective/): Recently Microsoft added Business process flows to their Microsoft Flow platform. If you thought that this was just like Flow then you will very quickly find out that it is not. - [Get an alert before connections expire and flows fail](https://sharepains.com/2018/10/10/microsoft-flow-get-an-alert-before-connections-expire-and-flows-fail/): Have you had flow connection expire? For example when your flow owners use MFA and it is time to re-authenticate? - [Update a Hyperlink or Picture field in Power Automate](https://sharepains.com/2018/10/03/update-a-hyperlink-or-picture-sharepoint/): Quite often I get asked about updating hyperlinks or pictures using Power automate. - [SharePoint Attention Views and check in/out with Power Automate?](https://sharepains.com/2018/10/03/sharepoint-online-microsoft-flow-attention-views-do-you-remember-check-in-and-check-out/): Recently Microsoft introduced Attention Views in the modern SharePoint look and feel. - [SharePoint – Install-SPUserSolution fails on slow or busy systems](https://sharepains.com/2018/10/01/sharepoint-long-running-powershell-migration-scripts-fail-on-install-spusersolution/): Sometimes you run into an issue that is difficult to resolve. Recently I've been running a PowerShell script that needs to create 6000 site collections and even more sub sites within each site collection. Each of these site collections and sites have small adjustments made to them as a few custom lists and libraries are added to each site and web parts are added to the pages. During this process I was hitting one issues that I just couldn't get resolved for a long time. I was using Install-SPUserSolution and I found that this command fails on slow or busy systems. - [State Machine template in Power Automate](https://sharepains.com/2018/09/28/microsoft-flow-state-machine-template/): State machines has been a concept of workflow development for quite a while. In Power Automate there isn't a single step that you can use, however with multiple steps you can recreate these state driven flows quite quickly. - [Do you process your invoices with Microsoft Flow and DocParser?](https://sharepains.com/2018/09/26/do-you-process-your-invoices-with-microsoft-flow-and-docparser/): Today I created an invoice handling system for the virtual company Juniper Telecoms using Microsoft Flow and DocParser. With the DocParser connector it is easy to process your invoices or any other document like Bank Statements, Purchase Orders or Contracts. - [Uploaded Documents to SharePoint using OneDrive/Sync ignored by Power Automate](https://sharepains.com/2018/09/19/uploaded-documents-sharepoint-onedrive/): I had a chat with Paul Culmsee about Power Automate missing triggers when he uploaded documents with OneDrive Sync. - [Turn your folders into Microsoft Teams channels](https://sharepains.com/2018/09/19/microsoft-teams-turn-your-folders-into-channels/): You started using Microsoft Teams and someone didn't understand the difference between folders and channels. - [You only need the try catch template, to get started with Flow](https://sharepains.com/2018/09/19/microsoft-flow-you-only-need-one-template-to-get-started/): As I wanted to make things easier for my self I submitted this as a template in Microsoft Flow - [What is new in Microsoft Flow?](https://sharepains.com/2018/09/18/microsoft-flow-what-is-new-in-microsoft-flow/): Did you ever wonder what is new in Microsoft Flow? - [SharePoint Online – Looking for a hub site, get it all hooked up with Microsoft Flow](https://sharepains.com/2018/09/17/sharepoint-online-looking-for-a-hubby-get-it-all-hooked-up-with-microsoft-flow/): Have you noticed that the SharePoint connector in Microsoft Flow was extended with a number of action helping you to manage hub sites? Getting it all hooked up is easy with Microsoft Flow. - [Add a row into an Excel table without failure with Power Automate](https://sharepains.com/2018/09/13/microsoft-flow-excel-add-a-row-into-a-table-without-failure/): One of the connectors in Power Automate is the Excel connector.In this post I will take a look at the Add a Row action. - [SharePoint Online – A modern library drag ‘n drop hidden gem in Edge only.](https://sharepains.com/2018/09/13/sharepoint-online-a-modern-library-drag-n-drop-hidden-gem-in-edge-only/): I also tested if I could drag 'n drop the whole email, but unfortunately that doesn't work yet. Hopefully that will happen one day too. - [Microsoft Flow – Never terminate your flows unless you like failure](https://sharepains.com/2018/09/11/microsoft-flow-never-terminate-your-flows-unless-you-like-failure/): One of those actions in Flow that I never use is the Terminate action. Ok, unless my clients really want flows to report their failures in the Power Automate UI. I've created a few example flows to explain why. - [Microsoft Flow – Provision your SharePoint Online sites without any code](https://sharepains.com/2018/09/06/microsoft-flow-provision-your-sharepoint-online-sites-without-any-code/): How many times have you had a need to provision sites? Project sites, Teams sites and whatever kind of other sites. So many times I hear people say that Microsoft Flow is only there for small processes. - [Microsoft Flow – Large switches 25+ options](https://sharepains.com/2018/09/06/microsoft-flow-large-switches-25-options/): Recently, I was told by one of my followers that the switch step in Microsoft flow can only handle 27 options. So I thought today I will put this to the test. - [The 250 flows limit in Microsoft Flow](https://sharepains.com/2018/09/04/microsoft-flow-how-to-avoid-the-250-flows-limit-in-microsoft-flow/): NOTE: This limit has now been changed. You can now create more than 250 flows in Microsoft Flow! - [Handling calculated fields in Microsoft Flow](https://sharepains.com/2018/09/03/microsoft-flow-handling-calculated-fields-in-microsoft-flow/): Have you noticed that when you have calculated fields that for example displays the difference between two date fields in SharePoint and Microsoft Flow you will get a number like 13.00000000000 returned: - [Automate your projects with Microsoft Flow and Project Online](https://sharepains.com/2018/09/03/project-online-automate-your-projects-with-microsoft-flow/): Today I had a look at Project Online and although there have been some changes  to Project Online since I last used it, the fundamental product is still similar. I'm especially interested in the Project Online Connector in Microsoft Flow. The connector is a bit limited, however there are some basic operators available that would have helped me in past projects. I guess all this connector needs is more users requesting new actions and triggers. - [Send an HTTP request to SharePoint action in Microsoft Flow, Common error messages](https://sharepains.com/2018/08/30/common-error-message-when-using-send-an-http-request-to-sharepoint-action-in-microsoft-flow/): Many things can go wrong when you use the Send an HTTP request to SharePoint action. In this post the Common error messages that I have found. - [Microsoft Flow – Taking ownership of someone else’s flows.](https://sharepains.com/2018/08/29/microsoft-flow-taking-ownership-of-someone-elses-flows/): Have you ever noticed that when you have a flow that you are the owner and there is no way for other users to view the flow or modify the flow? - [Maintain list items for no-code developers](https://sharepains.com/2018/08/28/sharepoint-microsoft-flow-maintain-list-items-for-no-code-developers/): In this post I will look at how to maintain list items in SharePoint lists. This post is part of my User guide to using the SharePoint REST API in Microsoft Flow for no-code developers series. - [Get Site details for no-code developers](https://sharepains.com/2018/08/28/sharepoint-microsoft-flow-get-site-details-for-no-code-developers/): This post is part of my User guide to using the SharePoint REST API in Power Automate for no-code developers series. - [User guide to using the SharePoint REST API in Power Automate for no-code developers](https://sharepains.com/2018/08/28/sharepoint-rest-api-power-automate/): Often I recommend to use the send HTTP request to SharePoint action in Power Automate. A lot of Flow users however struggle with the SharePoint REST API. - [SharePoint / Microsoft Flow – Maintain List details for no-code developers](https://sharepains.com/2018/08/28/sharepoint-microsoft-flow-maintain-list-details-for-no-code-developers/): This post is part of my User guide to using the SharePoint REST API in Microsoft Flow for no-code developers series. - [Why do you use Microsoft Flow and PowerApps?](https://sharepains.com/2018/08/10/why-do-you-use-microsoft-flow-and-powerapps/): Today I had a look at the Templates available in Microsoft Flow and in PowerApps. When I looked at the templates available in Flow I found many templates all doing small little things that don't really impress me and if I was new to Flow I would probably have the feeling  of why bother? - [Create folders in a SharePoint document library using Power Automate](https://sharepains.com/2018/08/09/create-folders-sharepoint-power-automate/): Recently, I've seen quite a few people asking about how to create folders in SharePoint Document Libraries using Power Automate. - [Microsoft Flow – Get your flow trigger retries right](https://sharepains.com/2018/08/08/microsoft-flow-getting-your-flow-trigger-retries-right/): After last week's post where I changed the number of retries  in my triggers I thought that it would be a good to find the right retry settings for Microsoft Flow. - [Microsoft Flow – Protect your SharePoint flows from overload better](https://sharepains.com/2018/08/03/microsoft-flow-protect-your-sharepoint-flows-from-overload-better/): Recently I have created some great SharePoint flows using Microsoft Flow. One problem I have been battling with however is the 429 error that occurs when your SharePoint Online environment is struggling to keep up with the requests. - [Check price changes with Microsoft Flow and Amazon](https://sharepains.com/2018/07/31/microsoft-flow-check-price-changes-with-microsoft-flow-on-amazon/): Did you know that you can earn money by buying your products at the right time? The variable pricing model that is used at Amazon is great, but it does mean that you have to check the price every day. Why would you? It is a lot quicker and easier to get Microsoft Flow to do this for you! - [CSOM Throttling in the SharePoint connector in Power Automate](https://sharepains.com/2018/07/30/sharepoint-online-microsoft-flow-csom-throttling-in-the-sharepoint-connector/): Throttling in the SharePoint connector in Power Automate is a very common issue with many flows. But how do you deal with those pains? - [How to create environments for Development, UAT and Production in Power Automate](https://sharepains.com/2018/07/18/create-environments-development-production/): Do you know how to create environments in Power Automate to manage your flows better? - [Power Automate Connector limits](https://sharepains.com/2018/07/17/power-automate-connector-limits/): When you design your flows it is important to be aware of the Power Automate connector limits. - [Error 429 – Rate limit is exceeded. Try again in X seconds in Power Automate](https://sharepains.com/2018/07/16/error-429-rate-limit-is-exceeded/): Recently I wrote about common issues with the SharePoint connector in Flow. One of the common issues  I found is the error 429. No I am not talking about the Ford Mustang 429. - [Avoiding failures in Power Automate or are you first do then think?](https://sharepains.com/2018/07/13/microsoft-flow-are-you-avoiding-failure-or-are-you-first-do-then-think/): Do you like to avoid problems? Do you spend all day trying to avoid any possible problem making sure that nothing could possibly go wrong? - [Power Automate – Error Handling for small flows](https://sharepains.com/2018/07/12/error-handling-for-small-flows/): In this post I'm reviewing the different approaches for error handling with the well known Try / Catch patterns and error handling for small flows. - [Creating generic flows in Microsoft Flow using the SharePoint connector](https://sharepains.com/2018/07/12/microsoft-flow-creating-generic-flows-in-microsoft-flow-using-the-sharepoint-connector/): Now when you create multiple copies of the same flow you can simply update the variables and potentially the trigger and you can copy flows from one list to another within seconds. It woud still be nice if you could get the list name and the site url out of the trigger but at least this is a good start towards creating generic flows. - [Mastering Arrays in Power Automate](https://sharepains.com/2018/07/10/microsoft-flow-shed-some-light-on-arrays/): Are you struggling with arrays in Power Automate? This post will help you master arrays. - [SharePoint 2016 – Office Online – Why are we passing a null request when creating a response?](https://sharepains.com/2018/07/06/sharepoint-2016-office-online-why-are-we-passing-a-null-request-when-creating-a-response/): Why are we passing a null request when creating a response? - [Microsoft Flow – Setting multi-people fields in SharePoint](https://sharepains.com/2018/07/05/microsoft-flow-setting-multi-people-fields-in-sharepoint/): Today, on the community site I found a post about setting multi-people columns in SharePoint  that worried me. - [SharePoint Connector’s common error messages and their resolutions in Power Automate](https://sharepains.com/2018/07/04/sharepoint-connector-error-power-automate/): Today, in the series of error handling posts I will look at the SharePoint connector's error messages. - [Update a people field in a SharePoint List using REST API using Power Automate](https://sharepains.com/2018/07/02/people-field-rest-api-power-automate/): Updating a people field in SharePoint with Power Automate can be tricky. The REST API will make this a bit easier. - [SharePoint Online/2016 – Document Properties vs DocProperty](https://sharepains.com/2018/06/29/sharepoint-online-2016-document-properties-vs-docproperty/): It is Friday and it is very sunny and rather than enjoying the sun I'm struggling behind my laptop with document properties. - [Microsoft Flow – Handle trigger failures](https://sharepains.com/2018/06/26/microsoft-flow-handle-trigger-failures/): And even when looking at the Show all activity screens I'm not getting any alerts. Well at least not the ones that are caused by the trigger failures. - [Power Automate – Calculate next month – Resolved with workaround](https://sharepains.com/2018/06/25/microsoft-flow-calculate-next-month-resolved-with-workaround/): One of the known challenges in Power Automate is to calculate next month's date. When you use the DateTime connector quite often flow gives you a date that is roughly right. In this post I'm giving a number of steps that can calculate next month's date. - [Which flow run is related to my SharePoint list item or document](https://sharepains.com/2018/06/25/microsoft-flow-which-flow-ran-on-my-sharepoint-list-item-or-document-part-2/): In one of my recent posts I mentioned the workflow function in Power Automate. In this post I looked at which elements are needed to create the flow run URL used by your flow. - [Filter Power Apps drop downs by other fields](https://sharepains.com/2018/06/21/powerapps-filter-your-drop-downs-by-other-fields/): Today I tried to create a form in Power Apps where I needed to filter the options available in the drop down depending on an option selected in a different field. - [The file Document.docx is locked for shared use by user in SharePoint](https://sharepains.com/2018/06/19/sharepoint-online-the-file-document-docx-is-locked-for-shared-use-by-usernametenant-onmicrosof/): The file "Document.docx" is locked for shared use by username@tenant.onmicrosoft.com - [Which Power Automate Flow ran on my item?](https://sharepains.com/2018/06/19/which-power-automate-flow-ran-on-my-item/): In SharePoint Designer workflows it was easy to find your workflows, but how do you find out which Power Automate flow ran related to a specific item? - [My conditional love in Microsoft Flow](https://sharepains.com/2018/06/19/microsoft-flow-my-conditional-love-in-microsoft-flow/): One of the important steps in Flow is the Condition. By supplying the conditions for your Yes and No branches you can make a flow a run a set of steps or a different set of steps. - [SharePoint 2016 – Contribute permissions, if you think this is right then let me know!](https://sharepains.com/2018/06/18/sharepoint-2016-contribute-permissions-if-you-think-this-is-right-then-let-me-know/): Today, I was working on a SharePoint 2016 environment and I noticed that my user with Contribute permissions were able to edit pages. Then when I searched for this issue I found quite a few people with the same issue. As far back as SharePoint 2010. Of course the work around of applying unique permissions to my pages libraries can work, but does that make this okay? I don't think so. - [How to play Chess with Microsoft Flow!](https://sharepains.com/2018/06/14/microsoft-flow-how-to-play-chess-with-microsoft-flow/): So far most of my posts in Microsoft Flow have been about business processes. In this post I'm going have a look at the a maybe not so obvious solution. Of course, you might not really want to use Microsoft Flow just to play a game of chess, but this does show that there is a lot more that is possible. Following the principles of "The art of the (im)possible", I will go through some of the considerations that you may face when you want to implement a process and don't know where to get started. - [Recover from failure in Power Automate, Advanced Error Handling](https://sharepains.com/2018/06/11/microsoft-flow-advanced-error-handling-recover-from-failure/): In this post I will look at how we can recover a process when a flow has failed. - [Using the REST API in Power Automate to get all lists in a SharePoint site](https://sharepains.com/2018/06/08/rest-api-access-sharepoint-get-all-lists/): In this post I'm looking at getting all the lists in a SharePoint site using the REST API. - [Throw in Power Automate flow, Advanced Error Handling](https://sharepains.com/2018/06/06/microsoft-flow-advanced-error-handling-throw-in-flow/): This is where we need to introduce the throw in flow. If you want to know more about throw logic in programming languages please have a look at this Throw error example. - [Microsoft Flow vs SharePoint Designer Workflows](https://sharepains.com/2018/06/05/microsoft-flow-vs-sharepoint-designer-workflows/): Today I ran a couple of tests comparing Microsoft Flow with SharePoint Designer Workflows and I found a number of interesting differences in the way the two engines work. - [Microsoft Flow – How to make your flows perform better](https://sharepains.com/2018/06/04/microsoft-flow-how-to-make-your-flows-perform-better/): In this post I'm going through one of the ways to increase the performance of your flows. - [Coalesce to Improve your switch case in Power Automate](https://sharepains.com/2018/05/29/switches-coalesce-power-automate/): In this post I'm going to have a look at the Switch step and how we can use the coalesce function in switch steps. Coalesce is one of those functions that is really useful, but it is often forgotten about. - [When a file is created or modified (properties only) has been extended](https://sharepains.com/2018/05/29/microsoft-flow-when-a-file-is-created-or-modified-properties-only-has-been-extended/): I did not realize that the When a file is created or modified (properties only)  trigger was also extended. Until I noticed some flows reporting the following error: - [SharePoint Online – Are you still using classic lists, try to drag a document into a group!](https://sharepains.com/2018/05/24/sharepoint-online-are-you-still-using-classic-lists-try-dragging-documents-into-a-group/): Every now and then I discover one of those features in SharePoint Online that is just awesome! - [Power Automate – How to find your failed flows?](https://sharepains.com/2018/05/24/microsoft-flow-how-to-find-your-failed-flows/): Earlier this week there were a few new announcements related to Microsoft Flow. One of the important once for me is the option to find failed flows. - [SharePoint Online – Are your lists/Libraries failing with more than 5000 items/documents?](https://sharepains.com/2018/05/24/sharepoint-online-are-your-lists-libraries-failing-with-more-than-5000-items-documents-dont-panic/): Recently I've had a library with roughly 8000 documents and my REST API was failing to find documents that weren't in the set of first 5000 documents in the library. - [Microsoft Flow – Querying large libraries – Resolved](https://sharepains.com/2018/05/23/microsoft-flow-querying-large-libraries/): Today I'm looking at querying libraries using flow. Flow is making this easy as it has an action called Get Files (properties only) - [SharePoint Online – 5000 documents and the library is full, well it might be or maybe not kind of bug](https://sharepains.com/2018/05/14/sharepoint-online-5000-documents-and-the-library-is-full-well-it-might-be-or-maybe-not-kind-of-bug/): Then I tried to copy a document to a different library and all seem to work. After while the reason for the hanging copies became clearer. When the destination library exceeds the 5000 documents you will see this error. - [Microsoft Flow is not just a SharePoint workflow engine](https://sharepains.com/2018/05/08/microsoft-flow-is-not-a-sharepoint-workflow-engine/): Over the past years many SharePointers got used to SharePoint Designer workflows. The SharePoint Designer workflows were connected to SharePoint lists or content types and some event in SharePoint would start the workflow process. Initially the workflow engine was part of SharePoint and later Workflow Manager 1.0 became the new SharePoint 2013 engine that needed to be installed on a separate server. Some of the exiting features wee removed and some new features were introduced by Workflow Manager 1.0 but the product development never really took off as that version 1.0 never changed. - [Get the first working day of the month in Power Automate](https://sharepains.com/2018/05/08/office-365-microsoft-flow-get-the-first-working-day-of-the-month/): On the Power Automate community site I found an interesting question about finding the first working day of the month using Microsoft Power Automate So I thought I'll take that challenge! First of all I need a date. (No not that kind of date!). As this is a test flow I'm using a manual start of the flow to collect any date from the user starting the flow. This will give me the DateInMonth as shown below. in the format of 2013-01-18. Then I'll replace the day with 01 and I've got the first day of the month. Easy, just a bit of text cutting and replacing and we're done. The following expression does the trick: concat(substring(variables('MyDate'),0,8), '01')  Then we need to check if this day is a holiday. I took the 2013-01-18 date here so that I've got a holiday being returned for the first of the month. I found a web service that can give me the UK bankholidays at http://www.work-day.co.uk/api_documentation.php So now I can check with a simple condition of the first day of the month is a holiday or not. The condition will simply look like this: @greater(indexOf(body('HTTP'), variables('FirstDay')), 0) Ok. This is easy but we haven't got the weekends covered yet. This is where flow has an answer out of the box. With the following expression using the dayOfWeek function your done in no time: @equals(dayOfWeek(variables('FirstDay')), 0) Now all we need to do is increment the 1st day of the month to the 2nd day of the month and rerun our tests until we have found working day. - [Get to all your site collection details within your Office 365 tenant using Power Automate?](https://sharepains.com/2018/05/03/get-to-all-your-site-collection-details/): Have you ever tried to get the all site collection details using Power Automate? - [Create a new sub site using Power Automate!](https://sharepains.com/2018/05/02/create-new-sub-site-using-power-automate/): In this post I'm going to have a look at how to get site details out of SharePoint and after that I will look at the more exciting bit of how to create a new sub site. This will open many doors to site request processes in Office 365. Imagine creating a site request list, go through an approval process and create your team site all within no time at all. - [When a file or item is deleted triggers in Power Automate](https://sharepains.com/2018/05/02/when-a-file-an-item-deleted-triggers/): Today I had a look at the SharePoint connector in Power automate and there are two when a file and when an item is deleted triggers. - [Microsoft Flow – use PowerShell to manage your flows](https://sharepains.com/2018/05/01/microsoft-flow-use-powershell-to-manage-your-flows/): Microsoft has released a preview version of PowerShell for PowerApps but actually you can use this PowerShell to manage your flows in general. It all starts by installing the PowerShell module as described in the earlier mentioned article. Please don't forget to unblock the files that you downloaded otherwise your module will not load properly. - [Microsoft Flow – Next Month is okay, but don’t go any further!](https://sharepains.com/2018/04/30/microsoft-flow-next-month-is-okay-but-dont-go-any-further/): Update: 28 February 2020, This problem has now been resolved and the Add to time now calculates the next month better. - [Microsoft Flow – This is the limit!](https://sharepains.com/2018/04/30/microsoft-flow-this-is-the-limit/): A while back I created a post about limits in Microsoft Teams. Today I'm looking at limits within Microsoft Flow. - [Microsoft Flow – Create SharePoint list items using Xml](https://sharepains.com/2018/04/27/microsoft-flow-create-sharepoint-list-items-using-xml/): You have data stored in XML and you want to use this to create list items in SharePoint and you thing that Microsoft Flow might be able to help you. You couldn't be more right. Flow can help you, but is it something that is easy to do? No! Although once you know how to do it it is quite easy. - [SharePoint’s multi-people fields in Power Automate](https://sharepains.com/2018/04/23/sharepoints-multi-people-fields-power-automate/): Quite a common requirements for Microsoft Flow is to use a multi-people field to create a single event in a calendar or a single email. - [Getting SharePoint field values in Power Automate](https://sharepains.com/2018/04/20/sharepoint-field-values-power-automate/): Getting the field values out of SharePoint with Power Automate requires knowledge of both Microsoft technologies. - [Microsoft Flow – Create SharePoint list item and get a BadRequest](https://sharepains.com/2018/04/18/microsoft-flow-create-sharepoint-list-item-and-get-a-badrequest/): Have you tried creating a SharePoint list item using Microsoft Flow? - [Microsoft Flow – Create a trigger on multiple lists! SharePoint Designer workflows can’t do this!](https://sharepains.com/2018/04/17/microsoft-flow-create-a-trigger-on-multiple-sharepoint-lists-sharepoint-designer-workflows-cant-do-this/): Have you ever wanted to create a flow in Microsoft Flow where you trigger on multiple lists? So if you create a list item in one list or an other you want to trigger the flow? - [Manage your Microsoft Flow solution in production and development](https://sharepains.com/2018/04/17/microsoft-flow-manage-your-flow-solution-in-production-and-development/): Once you have started with Microsoft Flow in your production environments you will find that you want to update those Flows without affecting the existing production flows. Small changes you might dare to risk but what if you have a number of days work to do to existing flows. How do you now update those flows? - [Delivering Low Code Applications with Flow and PowerApps](https://sharepains.com/2018/04/16/delivering-low-code-applications-using-microsoft-flow-and-powerapps/): In this post I will discuss Delivering Low Code Application with Flow and PowerApps. - [PowerApps – How to mess up your app by removing flows from Microsoft Flow](https://sharepains.com/2018/04/10/powerapps-how-to-mess-up-you-app-by-removing-flows-from-microsoft-flow/): Have you tried creating Flows from within PowerApps? Did you need a couple of attempts to get your flows right? Did you delete your unwanted flows? - [SharePoint Online – Microsoft Flow – Request Sign Off](https://sharepains.com/2018/04/06/sharepoint-online-microsoft-flow-request-sign-off/): As I'm catching up after a few days having been offline, I noticed the Request sign-off now available in SharePoint Online - [Microsoft Flow – New Feature! – Test your flows](https://sharepains.com/2018/04/06/microsoft-flow-new-feature-test-your-flows/): Today I noticed the Test Flow option in my Microsoft Flow designer next to the Update Flow option - [Microsoft Flow – Connectors, more and better](https://sharepains.com/2018/04/05/microsoft-flow-connectors-more-and-better/): The connector model in Microsoft Flow  is great, however you will most likely find that quite quickly you run into limitations. Microsoft Flow is getting more connectors, and better. - [Microsoft Flow – Working with Excel, Excel and Excel](https://sharepains.com/2018/03/27/microsoft-flow-working-with-excel-excel-and-excel/): When working with Excel in Microsoft Flow you will find that there are 3 connectors available. - [PowerApps and Microsoft Flow – Things you can’t do (yet)!](https://sharepains.com/2018/03/23/powerapps-and-microsoft-flow-things-you-cant-do-yet/): Earlier this week I asked on twitter which issues people were running into when developing solutions with PowerApps and Microsoft Flow. - [PowerApps – Grouping fields on forms](https://sharepains.com/2018/03/19/powerapps-grouping-fields-on-forms/): Have you tried to create forms in PowerApps? Once you added your 20 labels and controls to hold your data you suddenly want to move your fields a bit more to the left, right, top or bottom. and then you have to move all your fields to their new location. this can be a very painful process. - [Microsoft Flow – The hidden gems, are you aware of all of these?](https://sharepains.com/2018/03/19/microsoft-flow-the-hidden-gems-are-you-aware-of-all-of-these/): Microsoft Flow has many connectors available. A lot of these connectors give you an API into applications, but there are a few connectors that feel like the core of Microsoft Flow. Hopefully there connectors will be extended soon as some of them feel like a very good start, but could do with more. Although, in some cases you could of course try the hard way using Microsoft Flow expressions. - [Microsoft Flow – Ideas that could do with some upvoting!](https://sharepains.com/2018/03/16/microsoft-flow-ideas-that-could-do-with-some-upvoting/): In recent months I've been very active within the Microsoft Flow community and in general Flow has very much matured as a product over the last year. As with all Microsoft Products  Microsoft Flow has it's uservoice site where you can submit your ideas for the product. - [Are you ready to create apps in PowerApps?](https://sharepains.com/2018/03/15/powerapps-are-you-ready-to-create-apps-in-powerapps/): I've seen quite a few people asking the all important question: - [Create multiple versions of a flow in Power Automate](https://sharepains.com/2018/03/12/multiple-versions-flow-power-automate/): Do you keep multiple versions of your flow? Just in case your update breaks your flow. Or do you just risk it? - [PowerApps – Debugging your apps in Power Apps](https://sharepains.com/2018/03/12/powerapps-debugging-your-apps-powerapps/): Note: There is now a new way of debugging your power apps. Please read my updated post about debugging Power Apps with Monitor. - [UpdateContext in Power Apps](https://sharepains.com/2018/03/08/develop-power-apps-updatecontext/): After my introduction post about How to develop your apps in PowerApps. Today a second post about getting started with UpdateContext variables in Power Apps. - [PowerApps – How to develop your apps in PowerApps?](https://sharepains.com/2018/03/07/powerapps-how-to-develop-your-apps-in-powerapps/): Developing apps in PowerApps can be quite difficult in the beginning. This post is aimed at getting started with PowerApps hopefully avoiding the amount of time to get started with PowerApps. I'm by no means trying to create a full app. this is just a way to get you started. - [Where should you use your PowerApps?](https://sharepains.com/2018/03/05/powerapps-where-should-you-stick-your-powerapps/): Within recent years there have been many shifts within the Office 365 world. For a long time SharePoint development could only be done by the hard core SharePoint developers. - [Microsoft Flow – SharePoint triggers and their limitations](https://sharepains.com/2018/02/28/microsoft-flow-sharepoint-triggers-and-their-limitations/): Microsoft Flow is a great product that lets you trigger processes when items or files in SharePoint are changed. This works very well and better than in SharePoint Designer, however there are a few limitations that need to be addressed. - [Microsoft Flow – Make a long story short](https://sharepains.com/2018/02/27/microsoft-flow-make-a-long-story-short/): first I had a variable longstory ( with a value long story) - [PowerApps – Start your Microsoft Flow from PowerApps](https://sharepains.com/2018/02/26/powerapps-start-your-microsoft-flow-from-powerapps/): When you develop PowerApps you will quite quickly find that you can start your flow directly from your PowerApp. But is this the best way? Or is this the only way? - [Microsoft Teams – Discover your private teams](https://sharepains.com/2018/02/26/microsoft-teams-discover-your-private-teams/): Today I noticed a message in my Message Centre about joining private teams being made easier. - [Microsoft Flow – Manage your LinkedIn posts from SharePoint](https://sharepains.com/2018/02/26/microsoft-flow-manage-your-linkedin-posts-from-sharepoint/): Today I'm having a look at the LinkedIn connector available in Microsoft Flow. I want to create a SharePoint list which can manage my LinkedIn posts. - [SharePoint 2016 – There was an exception in the database.](https://sharepains.com/2018/02/22/sharepoint-2016-there-was-an-exception-in-the-database/): With all the new products and updates in Office 365 Microsoft 365, I've not been able to write many real SharePains articles anymore. But today I had a real pain with SharePoint. - [Are you running out of runs with Microsoft Flow?](https://sharepains.com/2018/02/21/microsoft-flow-are-you-running-out-of-runs-with-microsoft-flow/): Now, we will look at the situation where you already created a flow. You don't want to reorganise your flow but you are running out of runs. - [Microsoft Flow – Where your dynamic content comes from?](https://sharepains.com/2018/02/20/microsoft-flow-are-you-confused-and-unable-to-figure-out-where-your-dynamic-content-comes-from/): Do you get confused when you open a Microsoft Flow? There are many actions and one of these actions is using dynamic content called Title. - [Microsoft Flow – Get your manager to approve documents](https://sharepains.com/2018/02/19/microsoft-flow-get-your-manager-to-approve-documents/): Today, a very quick post about Microsoft Flow.  You want to get the manager of the user that created a document to approve a document. You don't want to specify who the manager is within the flow. Instead Flow should find the manager. - [Microsoft Flow – Get your flow to trigger on the creation of a Document Set](https://sharepains.com/2018/02/19/microsoft-flow-get-your-flow-to-trigger-on-the-creation-of-a-document-set/): Today, I was asked about triggering a flow only when a document set is created. - [Out of the box web parts on Team and Communication sites](https://sharepains.com/2018/02/19/office-365-sharepoint-online-out-of-the-box-web-parts-on-team-and-communication-sites/): Recently Microsoft has added a lot of new modern out of the box web parts to SharePoint Online. - [SharePoint Online – Page Author surveys on the way.](https://sharepains.com/2018/02/19/sharepoint-online-page-author-surveys-on-the-way/): Today I noticed in the Admin Center's Message Center in Office 365 that Microsoft announced that they will ask page authors to submit a survey. A new feature on its way. - [Microsoft Flow – Send out reminders](https://sharepains.com/2018/02/15/microsoft-flow-send-out-reminders/): I've seen many people creating flows in Microsoft Flow where there was a need for reminders to be sent. All sorts of complicated loops are developed and it doesn't really do the job. - [Microsoft Flow – Do you have an approval process? I’ve got 2!](https://sharepains.com/2018/02/14/microsoft-flow-do-you-have-an-approval-process-ive-got-2/): Within Microsoft Flow it is possible to create approval processes. Nothing special! Simply create an approval action - [Update Hyperlink or Picture fields using Microsoft Flow](https://sharepains.com/2018/02/13/microsoft-flow-updating-hyperlink-or-picture-fields-using-microsoft-flow/): Today I tried to update a field that contains a URL field (AKA Hyperlink or Picture). To update these kind of field you would normally have to set the field to - [Microsoft Flow – Share your flows with a team](https://sharepains.com/2018/02/09/microsoft-flow-share-your-flows-with-a-team/): Until recently  when I tried to share flows with a group of people I wasn't able to do this in one go as it was only possible to select one person at a time. - [Microsoft Flow – Do you have a plan?](https://sharepains.com/2018/02/07/microsoft-flow-do-you-have-a-plan/): We could pick one of the above plans to increase the number of runs needed. - [Try-Catch-Finally in Power Automate flows](https://sharepains.com/2018/02/07/try-catch-finally-in-power-automate-flow/): For most developers the Try, Catch, Finally  construction is a very common way of handling errors. Try Catch Finally in Power Automate has become a common pattern in recent years as well. - [Microsoft Teams actions in Flow](https://sharepains.com/2018/02/05/microsoft-flow-microsoft-teams-actions/): Within Microsoft Flow there are many triggers and actions available. With a strong interest i Microsoft Flow and Microsoft Teams I had a look into what is available. For Microosft Teams there are no triggers (yet). I'm sure it would be nice to have triggers on the creation of a Team, channel, or adding members. But then of course you might as well use SharePoint triggers that fire on the creation of a channel folder in a document library - [Microsoft Flow – HTTP – calling webservices, XML vs JSON](https://sharepains.com/2018/02/04/microsoft-flow-http-calling-webservices-xml-vs-json/): Last week I was asked about making a webservice work in Microsoft Flow. We were using the floatrates url to get some XML back with exchange rates. - [Microsoft Flow – What SharePoint actions follow the triggers?](https://sharepains.com/2018/02/02/microsoft-flow-what-sharepoint-actions-follow-the-triggers/): After yesterday's post about the triggers available for SharePoint in Microsoft Flow, today it is time to look at the Actions available. - [Triggers in Power Automate for SharePoint Online](https://sharepains.com/2018/02/01/microsoft-forms-sharepoint-online-what-triggers-all-the-action/): In this post I will look at triggers in flows. As a regular follower of my posts you will have noticed the many posts about Power Automate. - [Search for or type a command in Microsoft Teams – a complete overview](https://sharepains.com/2018/01/31/microsoft-teams-search-for-or-type-a-command-a-complete-overview/): You will notice the search bar at the top of your Microsoft Teams today with the Search for or type a command suggestion. - [Microsoft Flow – 8 improvements that I would like to see in 2018!](https://sharepains.com/2018/01/30/microsoft-flow-8-improvements-that-i-would-like-to-see-in-2018/): Have you had any time investigating the options in Microsoft Flow yet? For many years I've had to every now and then use SharePoint Designer workflows and I've disliked most of these workflows. Microsoft Flow is a whole different beast! There are still improvements to be made in Flow however. In this post I'm listing a number of things I would like to see improved in Microsoft Flow. - [Manipulating Files in SharePoint with Microsoft Flow](https://sharepains.com/2018/01/26/microsoft-flow-manipulating-files-in-sharepoint/): Today I tried to copy a file using Microsoft Flow. I started with a When a file is created or modified in a folder trigger. - [Microsoft Flow: The field ‘FieldName’ is not supported in query. The lookup list is in another web.](https://sharepains.com/2018/01/23/microsoft-flow-the-field-fieldname-is-not-supported-in-query-the-lookup-list-is-in-another-web/): The field 'MapRef' is not supported in query. The lookup list is in another web. - [Migrate to Power Automate from SharePoint Designer practical examples – part 1 – Clone list items](https://sharepains.com/2018/01/23/migrate-to-power-automate-sharepoint-designer/): I will start today with a series of posts with practical examples of how to migrate to Power Automate. - [Migrate from SharePoint Designer to Power Automate](https://sharepains.com/2018/01/22/microsoft-flow-how-to-migrate-from-sharepoint-designer-to-flow-or-azure-logic-apps/): Recently I've looked at many SharePoint Designer workflows and migrated them to Microsoft Flow or Azure Logic Apps. There isn't really a set approach that will work for all but as a starting point you could consider going for a like for like migration. Each Condition, Action and Loop in your SharePoint Designer workflows  can quite quickly be replaced with the equivalent in Microsoft Flow. In this post I'm going through a full list of steps that you can migrate across. - [Microsoft Teams – SharePoint News connector](https://sharepains.com/2018/01/22/microsoft-teams-sharepoint-news-connector/): Then you select the SharePoint News connector: - [Microsoft Teams Education – How to keep your students quiet?](https://sharepains.com/2018/01/19/microsoft-teams-education-how-to-keep-your-students-quiet/): Within the educational version of Microsoft Teams there is an option available to Mute students. With this option you can keep your students quiet within a team. In my tenant I created a Student user and I had a look at what muting student does, other than upsetting the student of course! - [You’re missing out! Ask your IT administrator for access to Microsoft Teams](https://sharepains.com/2018/01/19/microsoft-teams-education-youre-missing-out-ask-your-it-administrator-for-access-to-microsoft-teams/): Today I will look at the You're missing out! message reported in Microsoft Teams. - [SharePoint online vs 2016 – Composed looks.](https://sharepains.com/2018/01/16/office-365-sharepoint-online-vs-sharepoint-2016-composed-looks/): When I look at the composed looks in Office 365 the Current composed look seems to be linked to the selected composed look. For both the Current and Blossom (my source composed look), palette002 is being used. - [How reliable is Microsoft Flow? – Error handling](https://sharepains.com/2018/01/15/office-365-microsoft-flow-how-reliable-is-microsoft-flow-part-4/): In this post I'm going to look at error handling in Microsoft Flow. - [How reliable is Microsoft Flow – Triggers](https://sharepains.com/2018/01/12/office-365-microsoft-flow-how-reliable-is-microsoft-flow-part-3/): After my 2 recent posts I didn't want to give up on the failing Flows that I developed. In this post I will show you how to develop reliable Flows. - [Reliability of triggers in Power Automate](https://sharepains.com/2018/01/12/office-365-microsoft-flow-how-reliable-is-microsoft-flow-part-2/): After yesterday's post, How reliable is Microsoft Flow?, today it is time to look at the reliability of triggers. - [How reliable is Microsoft Flow?](https://sharepains.com/2018/01/11/office-365-microsoft-flow-how-reliable-is-microsoft-flow/): During this series I'm going through my conclusions as I try to get to developing reliable Flows. - [SharePoint Online – Edit less, update more](https://sharepains.com/2018/01/11/sharepoint-online-edit-less-update-more/): Today, Microsoft announced their new Bulk edit SharePoint metadata feature that will be rolled out to SharePoint Online. - [The next 11 things I would like to see in Microsoft Teams](https://sharepains.com/2018/01/10/microsoft-teams-the-next-11-things-i-would-like-to-see-in-microsoft-teams/): Microsoft Teams has been a great new addition to  the Office 365 family but there are still plenty of things that I would like to see added or improved. - [SharePoint 2016 – PnP ApplyProvisioningTemplate – Error: Value cannot be null. Parameter name: input](https://sharepains.com/2018/01/10/sharepoint-2016-pnp-applyprovisioningtemplate-error-value-cannot-be-null-parameter-name-input/): Error: Value cannot be null. Parameter name: input - [SharePoint 2016 – Copying SharePoint Designer Workflows from one list to another](https://sharepains.com/2018/01/09/sharepoint-2016-copying-sharepoint-designer-workflows-from-one-list-to-another/): This time a short post with a quick win if you make a lot of similar workflows on SharePoint lists. I'm by no means a SharePoint Designer workflow expert and often I don't like SharePoint Designer but today I came across a useful feature. - [Integrate with Python based solutions using SharePoint 2016 REST API](https://sharepains.com/2018/01/04/sharepoint-2016-integrate-with-python-based-solutions-using-sharepoint-rest-api/): Today, I worked with my customer on a project where we want to create list items in SharePoint from a Python based application. - [Office 365 – Working anywhere you like? Aaah, certificates blocked.](https://sharepains.com/2018/01/04/office-365-working-anywhere-you-like-aaah-certificates-blocked/): Today, I traveled to London to visit one of my customers. I thought that using the train's wifi would be a great way to quickly pickup some documents from my Office 365 SharePoint online configuration but no luck there: - [Microsoft Forms – Reports and quizzes, the full starter guide](https://sharepains.com/2018/01/03/microsoft-forms-quizzes-the-full-starters-guide-part-2/): If you are a starter or if you have been using Microsoft Forms already, in this post I'm hoping to give you an introduction in the full feature set of reports and quizzes in Microsoft Forms. - [SharePoint 2016 – Aaah, SharePoint Designer workflows!](https://sharepains.com/2017/12/22/sharepoint-2016-aaah-sharepoint-designer-workflows/): Just before the 2017 year ends however I'm now working on a SharePoint 2016 project and it's quite a challenge to go back to technology like SharePoint Designer workflows. Today one of those small problems that can be a bit of a challenge is to get the value of a Managed Metadata column. - [Microsoft Forms – Quizzes the full starters guide, create a quiz](https://sharepains.com/2017/12/21/microsoft-forms-quizzes-the-full-starters-guide-part-1/): In Microsoft Forms it is possible to create Quizzes and Forms. In this series of posts, the full starters guide you will find out that there isn't too much of a difference between the Quizzes and Forms. The main difference is the way the responses are received. Within quizzes Microsoft forms gives you the option to specify the correct answers. - [Microsoft Teams, Forms and SharePoint all in one.](https://sharepains.com/2017/12/20/microsoft-forms-microsoft-teams-microsoft-forms-and-sharepoint-all-in-one/): After a bit of a quiet week so far on my blog, now a post that hits multiple Applications. Microsoft Teams, Microsoft Forms and SharePoint. - [Office 365 – Moving from TLS 1.0/1.1 to TLS 1.2](https://sharepains.com/2017/12/20/office-365-moving-away-from-tls-1-0-1-1-to-tls-1-2/): Today I noticed one of those action required Looking at the content of this message, this might be a warning that you shouldn't ignore. We are moving to TLS 1.2 for encryption MC126199 Plan For Change Published On : 19 December 2017 Action required by 1 March 2018 To provide best-in-class encryption, and to ensure our service is more secure by default, we are moving all of our online services to Transport Layer Security (TLS) 1.2+. As a result, we will be removing support for TLS versions less than 1.2 from our online services, beginning March 1, 2018. How does this affect me? Starting on March 1, 2018, all client-server and browser-server combinations must use TLS 1.2 or later protocol versions to be able to connect without issues to Office 365 services. This may require certain client-server and browser-server combinations to be updated. Although current analysis of connections to Microsoft Online services shows that very few customers still use TLS 1.0 and 1.1, we are providing notice of this change so that you can update any affected clients or servers as necessary before support for TLS 1.0 and 1.1 is disabled. If you are using any on-premises infrastructure for hybrid scenarios or Active Directory Federation Services, make sure that these infrastructures can support both inbound and outbound connections that use TLS 1.2. What do I need to do to prepare for this change? We recommend you proactively address weak TLS usage by removing TLS 1.0/1.1 dependencies in your environments and disabling TLS 1.0/1.1 at the operating system level where possible. Begin planning your migration to TLS 1.2+, today. Please click Additional Information to learn more. So if you are still using TLS 1.0 or TLS 1.1 then you might want to get these upgraded to TLS 1.2 - [Microsoft Teams – Stuck in an account and no way out?](https://sharepains.com/2017/12/15/microsoft-teams-stuck-in-an-account-and-no-way-out/): Yesterday, my account was added to an external team to another tenant and ever since I'm struggling to switch between tenants. This could of course be a coincidence and maybe something has changed  within the Microsoft Teams configuration. The new external account that I'm connecting to has MFA enabled. So there is an additional dialog appearing when I log in. - [Microsoft Teams – Integration with Visual Studio Team Services using PowerApps.](https://sharepains.com/2017/12/11/microsoft-teams-integration-with-visual-studio-team-services-using-powerapps/): This of course gives you unlimited options to create new applications without any coding work. Today, I tried to create an app that helps me maintain my Visual Studio Team Services backlog within Microsoft Teams. - [Microsoft Teams – How do you control client updates?](https://sharepains.com/2017/12/07/microsoft-teams-how-do-you-control-client-updates/): And for Microsoft Teams controlling client updates make even less sense as Microsoft Teams can also be accessed through the browser through your Office 365 App Launcher. - [Office 365 – Admin Center uses your local language and will end up doing your building work!](https://sharepains.com/2017/12/07/office-365-admin-center-uses-your-local-language-and-will-end-up-doing-your-building-work/): Most of my posts are directed at anybody in the world in any location. This time I'm going to have a look at the new language options in the Admin Center. - [Office 365 – Are you on First Release? Not anymore!](https://sharepains.com/2017/12/07/office-365-are-you-on-first-release-not-anymore/): Microsoft have changed the name of First Release, to Targeted Release. - [Microsoft Whiteboard, the next new thing in the Office 365 family](https://sharepains.com/2017/12/07/office-365-microsoft-whiteboard-the-next-new-thing-in-the-office-365-family/): Microsoft Whiteboard is a freeform digital canvas where people, ideas, and content can come together for creative collaboration. The app is built for anyone who engages in creative, freeform thinking before getting to their final output. It’s designed for teams that need to ideate, iterate, and work together both in person and remotely, and across multiple devices. This Preview will be turned off by default. You will need to turn it on within the Admin Center for users to be able to access the app with their organization ID. - [Install PnP PowerShell using InlineScript within a release definition in VSTS](https://sharepains.com/2017/12/07/azure-powershell-install-pnp-powershell-using-inlinescript-within-a-release-definition-in-vsts/): Today I tried to install PnPPowerShell within an Azure PowerShell Environment. In the past I tried just to copy all files in a folder within my Azure environment and user $env:PSModulePath to include the PowerShell Module. - [Office 365 – SharePoint Online – How to waste some space on your pages.](https://sharepains.com/2017/12/04/office-365-sharepoint-online-how-to-waste-some-space-on-your-pages/): The modern pages in SharePoint online look absolutely great! With the additional web part that are added to the available web parts improvements are made. Today I noticed a few new web parts. - [Office 365 – SharePoint Online – Dirty form protection with SPFx](https://sharepains.com/2017/12/04/office-365-sharepoint-online-dirty-form-protection-with-spfx/): I noticed however that that when I simply type a different URL in the address bar of my browser that there is no way of protecting the dirty form. - [Log in to Microsoft Teams, log-out and log out again](https://sharepains.com/2017/11/29/microsoft-teams-log-in-log-out-and-log-out/): All these log in windows in Microsoft Teams can be very confusing. As you use the windows app, a browser or a InPrivate browser and even when you use different browsers. - [Office 365 – SharePoint online – Content approval gives too many warnings](https://sharepains.com/2017/11/29/office-365-sharepoint-online-content-approval-give-too-many-warnings/): For one of my customers I enabled content approval on a list. This should all be quite easy. I simply went to the Versioning settings of the list and I found the right options. - [Office 365 – SharePoint Online – Compare different versions of a document.](https://sharepains.com/2017/11/28/office-365-sharepoint-online-compare-different-versions-of-a-document/): Most likely you are aware that it is possible to have version control on SharePoint libraries. Most likely you will also know how to get to the Version History option in the document libraries once it has been enabled:  - [Visual Studio – Git failed with a fatal error: repository ‘xyz’ not found](https://sharepains.com/2017/11/27/visual-studio-git-failed-with-a-fatal-error-repository-xyz-not-found/): Git failed with a fatal error: repository 'xyz' not found - [Microsoft Teams General channel settings](https://sharepains.com/2017/11/23/microsoft-teams-general-channel-setting/): Recently I noticed a new settings in the Member permissions related to the Microsoft Teams General channel. - [Office 365 – Create a new SharePoint Online team site and …. I’m lost in a black hole!](https://sharepains.com/2017/11/23/office-365-create-a-new-sharepoint-online-team-site-and-im-lost-in-a-black-hole/): Today I tried to create a new team site and I first noticed a slightly different message once my site 'finished' created. - [Create a feedback form with SharePoint Online and Microsoft Forms](https://sharepains.com/2017/11/23/office-365-create-a-user-feedback-form-within-minutes-with-sharepoint-online-and-microsoft-forms/): After my last week's post Feedback is important, but please don’t bother my users, I thought about creating a feedback form within the modern experience of Office 365. I'm going to restrict myself to out of the box functionality. So no development! And I want it quick! - [Office 365 – Updates to team sites, Is Microsoft trying to deliver end solutions or a framework?](https://sharepains.com/2017/11/21/office-365-updates-to-team-sites-is-microsoft-trying-to-deliver-end-solutions-or-a-framework/): Today, Microsoft announced some changes to the modern team sites. Over the last few months we all got used to the modern team sites: - [Office 365 – PowerApps is the new InfoPath, at last](https://sharepains.com/2017/11/20/office-365-powerapps-is-the-new-infopath-at-last/): For many years I've disliked InfoPath. (I always start a blog post on a positive note). - [SharePoint – Cloud vs On-Premises](https://sharepains.com/2017/11/20/sharepoint-cloud-vs-on-premises/): Just a few years ago if you had asked me which I preferred Office 365 or SharePoint 2013? I would probably still have preferred the on-premises versions of SharePoint from a developer's perspective. For a very long time the restriction simply outweighed the benefits. - [Office 2016 – The Document Information Panel has been removed, but it is back now!](https://sharepains.com/2017/11/20/office-2016-the-document-information-panel-has-been-removed-but-it-is-back-now/): You might have noticed that The document Information Panel was removed in MS Office 2016. Or more likely you probably never really missed it. - [Office 365 – Compliance Manager, no time to waste!](https://sharepains.com/2017/11/17/office-365-compliance-manager-no-time-to-waste/): Microsoft has announced the all new Compliance Manager public preview. I had already seen Compliance manager at quite a few Microsoft events, but now finally it is possible to play with the tools ourselves. - [Microsoft Bookings – Yet another baby added to the Office 365 family](https://sharepains.com/2017/11/15/microsoft-bookings-yet-another-baby-added-to-the-office-365-family/): Today I noticed the following in my Message Center in the Admin Center of Office 365: Microsoft today announced that Microsoft Bookings will be available for your users. It is available as part of the Business Apps (free) add-on subscription. Microsoft Bookings helps simplify how customers schedule and manage appointments with businesses. It can also be used for scheduling appointments for internal customers and staff in a larger organisation. If you add the Business Apps (free) add-on to your existing subscriptions, Microsoft Bookings will be available to your users. It is released off-by-default to give you a chance to explore the new capabilities. Once turned-on users will see the Microsoft Bookings icon in the App Launcher and on their office.com homepage after log-in. 1. Add the “Business Apps (free)” add-on to your existing subscription. 2. Assign licenses to your users for this add-on. Please click Additional Information to learn more. You can enable the Microsoft booking by going through the steps in the Get access to the Office 365 Business apps for Enterprise subscriptions article. Once you've gone through the steps you should see Bookings in you App Launcher, Just to give you a quick preview of the app: Having  tried to enable Bookings, I got the following error message in my Admin Center, so it looks like things are on their way:   - [SharePoint – Are you ready to migrate from Office 365 to Office 365?](https://sharepains.com/2017/11/15/sharepoint-are-you-ready-to-migrate-from-office-365-to-office-365/): So are you ready to migrate from Office 365 to Office 365? Do you want any help? Feel free to leave a comment below or contact me using the contact me form. - [Export flows and import them in Azure Logic Apps.](https://sharepains.com/2017/11/14/microsoft-flow-export-your-flows-and-import-them-in-azure-logic-apps/): You can export your Flows in Power Automate and import them in Logic Apps. - [Office 365 – Feedback is important, but please don’t bother my users](https://sharepains.com/2017/11/14/office-365-feedback-is-important-but-please-dont-bother-my-users/): Have you noticed that Microsoft keeps asking for feedback? - [SharePoint Online – Required info and Flow, is this really needed?](https://sharepains.com/2017/11/13/sharepoint-online-required-info-and-flow-is-this-really-needed/): When documents have required fields that haven't been completed then there will be a very visible yellow "Required Info" where ever there is information missing. - [Microsoft Flow- Do you approve?](https://sharepains.com/2017/11/13/microsoft-flow-do-you-approve/): In the past I've seen many customers asking for approvals to be easier. Having to go to tasks simply didn't work well enough and a simple email where you can reply with approve or reject was always a required option. - [Office 365 – SharePoint Online – Accessibility mode or PDF converter?](https://sharepains.com/2017/11/10/office-365-sharepoint-online-accessibility-mode-or-pdf-converter/): Then within the Preview screen there is the option Accessibility mode - [Office 365 – SharePoint Online – New little icons](https://sharepains.com/2017/11/10/office-365-sharepoint-online-new-little-icons/): Since yesterday there have been a few new visual icons in Office 365. - [Office 365 – The new App Launcher has arrived.](https://sharepains.com/2017/11/09/office-365-the-new-app-launcher-has-arrived/): A few weeks ago Microsoft announced that the App Launcher would be updated. Below you can see the two options.  - [Microsoft Teams – Create your own apps! Part 2](https://sharepains.com/2017/11/09/microsoft-teams-create-your-own-apps-part-2/): Yesterday I created a custom bot for Microsoft Teams. Today I'm going for a deeper dive. Where in yesterday's post I looked at how to create a bot that simply copies what you tell the bot, today I'm going to have a look at the code behind this bot. - [Microsoft Teams – Create your own apps!](https://sharepains.com/2017/11/08/microsoft-teams-create-your-own-apps/): Recently I've been looking into creating custom apps within Microsoft Teams. Within Microsoft Teams you can create different type of apps. - [Microsoft Teams – PowerShell, a complete getting started guide.](https://sharepains.com/2017/11/06/microsoft-teams-powershell-a-complete-getting-started-guide/): With the release of PowerShell for Microsoft Teams  a massive step has been taken towards an easier to manage application. I like Microsoft  Teams and PowerShell, so what more could I wish for with PowerShell for Microsoft Teams. - [Microsoft Teams – Get all YOUR teams using PowerShell ( Part 2) – Resolved!](https://sharepains.com/2017/11/04/microsoft-teams-get-all-your-teams-using-powershell-part-2-resolved/): After last weeks post Microsoft Teams - Get all your team sites using PnP Powershell, Now my next attempt with the all new Microsoft Teams PowerShell. - [Microsoft Teams – Get all your Team sites using PnP PowerShell!](https://sharepains.com/2017/11/03/microsoft-teams-get-all-your-team-sites-using-pnp-powershell/): Today, I wanted to get a full overview of all the Microsoft Teams teams sites that I have in my tenant. I decided to put PnP PowerShell to the test for this. - [Future Decoded – MVPBuzz – My first conference experiences as a Microsoft MVP](https://sharepains.com/2017/11/02/future-decoded-mvpbuzz-my-first-conference-experiences-as-a-microsoft-mvp/): Many years, I've been going to Microsoft conferences, first the Evolution conferences in London and then for the last 4 years the Future Decoded. For the last 2 days I've enjoyed many sessions. - [Microsoft Teams and any other Microsoft product – How Accessible are they?](https://sharepains.com/2017/11/02/microsoft-teams-and-any-other-microsoft-product-how-accessible-are-they/): But if you want to know how accessible a Microsoft product is where do you go? - [Microsoft Teams – be careful with email links to channels!](https://sharepains.com/2017/11/02/microsoft-teams-be-careful-with-email-links-to-channels/): Over the last few days I spent time at the Future Decoded event in London. One of the sessions I went to on Microsoft Teams a question was asked about security of a Team. - [Office 365 – SharePoint Online – Performance, what to expect?](https://sharepains.com/2017/10/30/office-365-sharepoint-online-performance-what-to-expect/): Recently I had a few customers with performance issues and it helps to know what to expect with performance in Office 365. - [SharePoint Online – Sharing List items vs Documents](https://sharepains.com/2017/10/30/sharepoint-online-sharing-list-items-vs-documents/): Today I had a look at Sharing Documents and List Items in modern lists and libraries in SharePoint online following a post on Tech Community. Recently the interface for this has changed and When you share a document you get a dialog like this: - [Microsoft Teams – Search and Wiki pages](https://sharepains.com/2017/10/30/microsoft-teams-search-wiki-pages/): One of the features that Microsoft teams offers is Wiki pages. Wikis will typically be used as a knowledge base. The general problem with a knowledge base is that people might not exactly know what they are looking for therefore a search or filtering is critical to the success of the knowledge base. It's the same within Microsoft Teams. - [Microsoft Teams – Is the success of uservoice killing off your voice?](https://sharepains.com/2017/10/27/microsoft-teams-is-the-success-of-uservoice-killing-off-your-voice/): I am a great fan of the Microsoft Teams uservoice site. Looking at the number of ideas that have been raised over the past year or so you would expect that the Microsoft Team development team must be drowning in ideas. - [Office 365 – Are content types dead?](https://sharepains.com/2017/10/26/office-365-are-content-types-dead/): I noticed a while back that you can't select content types in the views in modern lists. It seems to be that users need to be able to create new list columns. At my first moment of thought, I find this actually a bad step backwards, as a good way of organizing your information architecture seems to be less important than ease of use. But then who are we serving? Developers or users? - [Microsoft Teams – Get your dates right – moving time zone](https://sharepains.com/2017/10/25/microsoft-teams-get-your-dates-right-moving-time-zone/): Have you noticed that in Microsoft Teams all dates are always in American format: - [Office 365 – GDPR Activity hub – Are you panicking yet?](https://sharepains.com/2017/10/20/office-365-gdpr-activity-hub-are-you-panicking-yet/): Many organisations are really worried about GDPR. Did you know that if you deal with any company inside the EU that GDPR is relevant to you? Are you ready for it? - [Office 365 – SharePoint Admin Center is changing](https://sharepains.com/2017/10/17/office-365-sharepoint-admin-center-changing/): It will all start by going to the SharePoint Admin Center: - [Conversations in Microsoft Teams, plenty to talk about!](https://sharepains.com/2017/10/16/microsoft-teams-conversations-in-microsoft-teams-plenty-to-talk-about/): Today, I'm having a look at Microsoft Teams' conversations. Last week, I tried to create posts within the conversation section of Microsoft Teams using Microsoft Flow and Azure Logic Apps and I found that I hit a few limitations. Well a lot of this is still in preview so some limitations can be expected. - [Office 365 – SharePoint Online – Column formatting arriving](https://sharepains.com/2017/10/16/office-365-sharepoint-online-column-formatting-arriving/): Today, I noticed in the Message Center an interesting new feature about Column Formatting that will arrive very soon in First Release tenants. - [Office 365 – Major updates have arrived](https://sharepains.com/2017/10/13/office-365-major-updates-have-arrived/): Today, I noticed the first Major updates in my Message Center. As announced earlier this month, the way Microsoft announces their major updates has changed. - [Microsoft Teams – Azure Logic Apps – Don’t mention it!](https://sharepains.com/2017/10/13/microsoft-teams-azure-logic-apps-dont-mention-it/): But then the trouble started. I wanted everybody to receive an alert using the Mentions in Microsoft Teams. My team name is Triad.Microsoft.Development so @Triad.Microsoft.Development should work. - [Microsoft Teams – Notifications – I don’t get it!](https://sharepains.com/2017/10/12/microsoft-teams-notifications-i-dont-get-it/): After my previous post on Notification settings in Microsoft Teams I noticed a couple of people complaining about not getting the notification. - [Microsoft Teams – Notebooks, Sections and Pages in Education](https://sharepains.com/2017/10/11/microsoft-teams-notebooks-sections-and-pages-in-education/): The above screen is important for understanding the permissions of each of the sections stored within the Notebooks. - [Office 365 – Check your site for broken links in SharePoint Online – Part 2](https://sharepains.com/2017/10/09/office-365-check-your-site-for-broken-links-in-sharepoint-online-part-1-2/): Before we can have a look at finding all broken links within a site, we will need to identify where the broken links may be stored.  A quick look at SharePoint gives me the following lists - [Microsoft Teams – How to create a Team when you can’t create Office 365 groups?](https://sharepains.com/2017/10/06/microsoft-teams-how-to-create-a-team-when-you-cant-create-office-365-groups/): Within Microsoft Teams it is possible to create new teams if you have sufficient permissions to create a new Office 365 Group. However, what happens if you don't have enough permissions to create a group? What if you want to create a team and use an existing group? - [Office 365 – Check your site for broken links in SharePoint Online – Part 1](https://sharepains.com/2017/10/05/office-365-check-your-site-for-broken-links-in-sharepoint-online-part-1/): On Tech Community I came across a question about how to  check for broken links on your SharePoint sites in SharePoint Online. - [Office 365 – Workflow options – Azure Logic Apps vs Microsoft Flow](https://sharepains.com/2017/10/05/office-365-workflow-options-azure-logic-apps-vs-microsoft-flow/): Within my Office 365 environment I've got quite a few options when I want to develop workflows. The two options that I'm looking at in this post are Microsoft Flow and Azure Logic Apps. - [Thank you all for your support!](https://sharepains.com/2017/10/03/thank-you-all-for-your-support/): Thank you very much for your continuous support! Last Sunday I received the email below from Microsoft. One of the main reasons  for receiving this MVP Award is related to my work on my blog.  I couldn't have done this without all the followers motivating me to write more and more. - [Office 365 – Architecture choices for your App development](https://sharepains.com/2017/09/29/office-365-architecture-choices-for-your-app-development/): I absolutely love the speed at which Microsoft releases new pieces of functionality in Office 365. But I'm struggling to keep up with "What is my best option?". Take as an example the App model(s). - [SharePoint – Migrations without 3rd party tools … soon](https://sharepains.com/2017/09/29/sharepoint-migrations-without-3rd-party-tools-soon/): Hmm, my document didn't get migrated. Ok, this is only version 0.2.60.0 of the tool. But at least it gives us a bit of an idea where Microsoft is heading with migrations. - [Office 365 – I have found a bug! What to do now?](https://sharepains.com/2017/09/29/office-365-i-have-found-a-bug-what-to-do-now/): But what do you do when you have found a bug in Office 365? Has anyone else found this? Is Microsoft already aware? Or are they even working on fixing things? - [Microsoft Forms – The hidden options of branching in Forms](https://sharepains.com/2017/09/28/microsoft-forms-the-hidden-options-of-branching-in-forms/): So far I've liked the general setup of Forms.It's a nice a light interface very good for questionnaires of up to 95 questions. - [All 13 Notifications settings in Microsoft Teams](https://sharepains.com/2017/09/28/microsoft-teams-notifications/): In my long running series about Microsoft Teams, I've decided to have a look at the Microsoft Teams Notifications settings in Microsoft Teams. - [100s of awesome Apps in Microsoft Teams, a complete overview](https://sharepains.com/2017/09/27/microsoft-teams-apps-a-complete-overview/): Within Microsoft Teams there are many apps, but what do they all do and how can they help you? In this post I'm giving a complete overview of the currently available apps . - [Tech Academy – Do you want to learn anything about any Microsoft technology?](https://sharepains.com/2017/09/27/tech-academy-do-you-want-to-learn-anything-about-any-microsoft-technology/): Today, when I visited https://Techcommunity.microsoft.com I noticed a new option, Tech Academy. - [Microsoft Teams – Do you want a demo? Don’t need to ask me!](https://sharepains.com/2017/09/26/microsoft-teams-do-you-want-a-demo-dont-need-to-ask-me/): Ok, of course you can ask me for a demo of Microsoft Teams! I'm always happy to introduce people to the must have application that has launched recently. So I would not turn you down if you asked me for a demo. But today I came across the Microsoft Teams demo site . - [Microsoft Teams – Roles, a deep dive through Assignments](https://sharepains.com/2017/09/26/microsoft-teams-roles-a-deep-dive-through-assignments/): The first things that you will notice is that a teacher has a Assignments option.  Note that this option disappears when you switch the developer preview on! This shouldn't be the case so it looks like this is a bug. - [Microsoft Teams – The application database has been wiped. this tab must be refreshed or be closed](https://sharepains.com/2017/09/26/microsoft-teams-the-application-database-has-been-wiped-this-tab-must-be-refreshed-or-be-closed/): The application database has been wiped. this tab must be refreshed or be closed - [Microsoft Teams – Discover Bots has been replaced by Discover Apps](https://sharepains.com/2017/09/26/microsoft-teams-discover-bots-has-been-replaced-by-discover-apps/): Well this week it is all change again. I can still find the Discover bots in some of my tenant, but one tenant I'm now seeing Discover apps instead: - [Office 365 – SharePoint Online – How do I manage permissions on a document?](https://sharepains.com/2017/09/25/office-365-sharepoint-online-how-do-i-manage-permissions-on-a-document/): Hmm, I wonder if this is really what you want in a library with certain permissions set. If I offer users a document library with certain permissions would I want them to take permissions away from that default. I can see the potential positives here, but I could also imagine some issues with this empowerment. This option needs a bit more investigation. - [Office 365 – SharePoint Online – Performance, how to gain 3-4 seconds](https://sharepains.com/2017/09/22/office-365-sharepoint-online-performance-how-to-gain-3-4-seconds/): Recently quite a few of my customers have been complaining about performance of their SharePoint Online sites. Where home pages take about 8- 12 seconds to load. Even Microsoft Support just tells me that it is acceptable for pages to take 8 seconds to load. - [Microsoft Teams – You have done it! And I know you have …](https://sharepains.com/2017/09/22/microsoft-teams-you-have-done-it-and-i-know-you-have/): Earlier this week I noticed a message in the Message center about Auditing in Microsoft Teams being rolled out. - [Microsoft Teams – Guest access and Apps](https://sharepains.com/2017/09/20/microsoft-teams-guest-access-and-apps/): Could you please test Microsoft Teams with guest access and disable all features that don't work for guests when a guest is logged in. - [Microsoft Teams vs Classic Intranet](https://sharepains.com/2017/09/20/microsoft-teams-vs-classic-intranet/): Microsoft is currently making a huge investment in a new style intranet, Microsoft Teams. - [Enable Apps in Microsoft Teams](https://sharepains.com/2017/09/19/microsoft-teams-enable-apps-in-microsoft-teams/): Have you noticed the Apps option in Microsoft Teams yet? - [Microsoft Teams – This is the limit in 2020!](https://sharepains.com/2017/09/19/microsoft-teams-this-is-the-limit/): Every now and then I find people asking about limitation of Microsoft Teams. In this post I've listed all the known limitations of Microsoft Teams. - [Microsoft Teams – Bots and Settings](https://sharepains.com/2017/09/19/microsoft-teams-bots-and-settings/): And not just the Settings, but also the Bots option. Yes, I did notice Member and Channels but those options you can find in other places in Microsoft Teams as well. - [Office 365 – Authentication – That didn’t work](https://sharepains.com/2017/09/18/office-365-authentication-that-didnt-work/): After a week of many Microsoft Teams posts, this week I'm going to start with  a SharePoint post. Or actually Office 365. - [Microsoft Teams – Users without access to a tenant in Video Calls](https://sharepains.com/2017/09/15/microsoft-teams-users-without-access-to-a-tenant-in-video-calls/): Yesterday one of my colleagues logged into a different tenant using the Microsoft Teams App. All worked really well! - [Microsoft Teams – Assignments with guests](https://sharepains.com/2017/09/14/microsoft-teams-assignments-with-guests/): Today I tried out the assignments functionality available in the EDU version of Microsoft Teams. In this post I describe how this work and the issues that I found on the way. I didn't want to go for just normal users. I included a few guest accounts. - [Microsoft Teams – Meetings with guest access. Did you get anyone to turn up?](https://sharepains.com/2017/09/14/microsoft-teams-meetings-with-guest-access-did-you-get-anyone-to-turn-up/): I've now played around with Microsoft Team's guest access and I found a few issue. - [Microsoft Teams – is Microsoft reinventing the wheel?](https://sharepains.com/2017/09/13/microsoft-teams-is-microsoft-reinventing-the-wheel/): As Microsoft is publishing the updates through their Office 365 products and Microsoft Teams things are getting better and better. Quite often this might feel like reinventing the wheel. - [Microsoft Teams through Microsoft Teams](https://sharepains.com/2017/09/12/microsoft-teams-through-microsoft-teams/): On the 3rd of October I will be speaking at SharePoint Showcase  at Auburn University about Microsoft Teams. - [Microsoft Teams – Where do I find my guest teams?](https://sharepains.com/2017/09/12/microsoft-teams-where-do-i-find-my-guest-teams/): So I've been using Microsoft Teams for quite a while now. I've got access to many internal teams and now that Microsoft has introduced external access teams I've been given access to a team within a different tenant. - [Microsoft Teams – External Sharing has arrived!](https://sharepains.com/2017/09/11/microsoft-teams-external-sharing-has-arrived/): One of the most wanted features, External Sharing seems to have arrived! - [Microsoft Teams – Co-Authoring made easy](https://sharepains.com/2017/09/11/microsoft-teams-co-authoring-made-easy/): Another one of my favourite features in SharePoint is Co-Authoring. So I was wondering if Co-Authoring would work. So I got one of my colleagues to try this out with me: - [Office 365 – Are your safe traditional pages going to break in October?](https://sharepains.com/2017/09/08/office-365-are-your-safe-traditional-pages-going-to-break-in-october/): Ever since Microsoft released the new style pages , I've been wondering about what will happen to the traditional pages. I've seen many companies implementing master pages and page layouts  in Office 365. - [Microsoft Teams – The top 10 features that are on their way](https://sharepains.com/2017/09/06/microsoft-teams-the-top-10-features-that-are-on-their-way/): Note: This post was written in September 2017 and reflects the situation then. - [How to record your Video call in Teams](https://sharepains.com/2017/08/31/microsoft-teams-how-to-record-your-video-call/): So you are running a video call within Microsoft Teams and you would like to record the video and your presentation that you are sharing. Well, one of the limitations compared to Skype for Business is that you cannot record your video calls. But the good news is that Microsoft is listening to its users. - [Office 365 – SPFx – downgrade your npm](https://sharepains.com/2017/08/30/office-365-spfx-downgrade-your-npm/): A while back I upgraded npm to version 5 using - [Business vs educational tenant with Microsoft Teams](https://sharepains.com/2017/08/30/business-educational-tenant-teams/): Today, I'm comparing Microsoft Teams within and Educational tenant and a business tenant. - [Office 365 – Have you created a demo or development tenant recently?](https://sharepains.com/2017/08/29/office-365-have-you-tried-creating-a-demo-or-development-tenant-recently/): One of the major strengths of Office 365 is that it is very easy to create a new demo or development tenant. In a matter of minutes you can have a new environment created and your are up and running and development work can start. - [Microsoft Teams – Where have all my chats gone to?](https://sharepains.com/2017/08/11/microsoft-teams-where-have-all-my-chats-gone-to/): I have found however that only the most recent 2 weeks worth is still there with the default bot message showing the date when I started my chats. Where have all the other chats gone to then? How do I get to these? - [Microsoft Teams – Troubleshooting – Error Messages found so far](https://sharepains.com/2017/08/11/microsoft-teams-troubleshooting-error-messages-found-so-far/): After my posts about troubleshooting Microsoft Teams I have received quite a few logs from people reporting issues. this post is a collection of error messages found so far. - [Office 365 – Is PowerApps to replace InfoPath?](https://sharepains.com/2017/08/10/office-365-is-powerapps-to-replace-infopath/): One of the thoughts I had is that the combination of PowerApps and Flow are there to replace InfoPath in SharePoint. I know that Microsoft have always said that PowerApps doesn't replace InfoPath, but I never really believed them. - [Microsoft Teams – How to troubleshoot the Windows 10 Mobile App](https://sharepains.com/2017/08/09/microsoft-teams-how-to-troubleshoot-the-windows-10-mobile-app/): After my last two posts about troubleshooting Microsoft Teams on my PC, troubleshooting the Windows 10 app and troubleshooting the background process that runs on Windows 10, I'm now looking at the app on my windows 10 Mobile. - [Microsoft Teams – Conversations around a document](https://sharepains.com/2017/08/07/microsoft-teams-conversations-around-a-document/): With Microsoft Teams it is possible to discuss document straight from within the App. This post walks through the step on how this can be done. - [How to troubleshoot Microsoft Teams process logs](https://sharepains.com/2017/08/07/microsoft-teams-how-to-troubleshoot-microsoft-teams-part-2/): Last week in my first post about troubleshooting Microsoft Teams. I mentioned how to get the logs for the Microsoft Teams client. In this post I will look at the other logs in Microsoft Teams? - [All Keyboard short cuts in Microsoft Teams](https://sharepains.com/2017/08/03/microsoft-teams-all-keyboard-short-cuts/): Within Microsoft teams there are a number of keyboard short cuts available. They are not always obvious (e.g. Alt E for Search). In this post there is a complete overview of the available shortcuts: - [How to troubleshoot Microsoft Teams client logs](https://sharepains.com/2017/08/03/how-to-troubleshoot-microsoft-teams/): How do you troubleshoot Microsoft Teams? - [Azure Function Apps – SharePoint lists – Creating web hooks that run PowerShell triggered by item creation](https://sharepains.com/2017/08/02/azure-function-apps-sharepoint-lists-creating-web-hooks-that-run-powershell-triggered-by-item-creation/): Recently I was asked to add a post about web hooks. - [Office 365 – SharePoint – SPFx web parts that are not part of the SPFx samples](https://sharepains.com/2017/08/01/office-365-sharepoint-spfx-web-parts-that-are-not-part-of-the-spfx-samples/): After my recent post where I went through all  samples in the SPFX web part repository. I'm now having a look at web parts that aren't included in this repository. - [Office 365 – SharePoint Online – Creating a site collection with new style pages](https://sharepains.com/2017/07/31/office-365-sharepoint-online-creating-a-site-collection-with-new-style-pages/): After the recent additions of Modern Team sites and Community sites I've been missing the option to create new style site collections. Today however I managed to get this to work. - [Office 365 – SPFx – make all the samples work](https://sharepains.com/2017/07/20/office-365-spfx-making-all-the-samples-work/): In one of my recent posts I went through all the SPFx samples that are available on GitHub. When your interested in one of these samples and then you try to make them work you might find that things aren't as easy as you would like. Especially when you're not familiar with SPFx yet. these samples are however a great source of learning material when you try to get familiar with SPFx. - [Office 365 – SPFx samples – A Complete Overview](https://sharepains.com/2017/07/18/office-365-spfx-samples-a-complete-overview/): In the recent 7 months the new SharePoint Framework has been taking off. Many developers have started to look into the options and this has resulted in many contributions on GitHub. - [Tech Community is 1 year!](https://sharepains.com/2017/07/18/tech-community-is-1-year/): Once upon time there was a Yammer community then the tech community came around and ate the Yammer community. - [Office 365 – Visio Online available](https://sharepains.com/2017/07/17/office-365-visio-online/): Microsoft has now made Visio Online available. Similar to Word, Excel, Powerpoint and OneNote it is now possible to maintain your Visio Drawings directly within a document library. - [Microsoft 365 – The 365 world is growing even more](https://sharepains.com/2017/07/10/microsoft-365-the-365-world-is-growing-even-more/): Today at the Microsoft Inspire partner conference it was announced that Microsoft 365 will now be the name of Office 365, Windows 10 and Enterprise Mobility + Security. The 365 world is growing! - [The Basics of PowerApps & Flow – Using multiple environments](https://sharepains.com/2017/07/10/powerapps-flow-the-basics-using-multiple-environments/): Continuing with my posts about the basics of PowerApps I'm now looking at using multiple environments. Quite often with Office 365 based solution I would consider creating multiple tenants, however with PowerApps and Flow I have not found a reason to do so yet. - [Implementing a State Machine using Microsoft Flow](https://sharepains.com/2017/07/10/office-365-flow-implementing-a-state-machine-using-microsoft-flow/): In the past I wrote Workflow articles about Nintex Workflow and how to setup the workflows. I have always liked the state machine workflows and I was wondering if I could setup my Flows in a similar way. - [Office 365 – PowerApps – Could not acquire storage. Try again later](https://sharepains.com/2017/07/06/office-365-powerapps-could-not-acquire-storage-try-again-later/): Could not acquire storage. Try again later - [Table does not define any key columns in Power Apps](https://sharepains.com/2017/07/06/office-365-powerapps-table-dbo-table-does-not-define-any-key-columns/): Table '.' does not define any key columns.Session ID: b6b3017a-1ae5-a4ac-2af3-3f36837e68b6 - [PowerApps – The Basics – Device options](https://sharepains.com/2017/07/05/powerapps-the-basics-device-options/): So far the PowerApps I've looked at all looked at Phone Layouts. Within this post I will look at other options too. - [Power Apps – The Basics – Creating Screens](https://sharepains.com/2017/07/04/powerapps-the-basics-creating-screens/): This is all there is about creating screens. Now we just have to go through the options of each control that can be added to the screens and a lot of the from creations within PowerApps will become clear. - [PowerApps – The Basics – Creating new PowerApps](https://sharepains.com/2017/07/04/powerapps-the-basics-creating-new-powerapps/): In this post I'm going to create a basic App based on a SharePoint custom list. I have already create a custom list and I'm creating an app form the menu  PowerApps -> Create an app. - [The Basics – An introduction to Power Apps](https://sharepains.com/2017/07/04/powerapps-the-basics-an-introduction-to-powerapps/): In this introduction to Power Apps series I will go through all the basics as they currently exist within Power Apps. - [OneDrive – Getting the latest Insider updates – Files On-Demand](https://sharepains.com/2017/07/04/onedrive-getting-the-latest-insider-updates-files-on-demand/): Then now the right way of testing insider updates. - [Office 365 – Communication sites are there](https://sharepains.com/2017/06/29/office-365-communication-sites-are-there/): Today the communication sites arrived in my development tenant. After using Marc's trick I was able to create a communication site. - [Office 365 – How to purchase an app](https://sharepains.com/2017/06/28/office-365-how-to-purchase-an-app/): Today on the tech community site a question appeared how to add an app as apps weren't appearing. - [Office 365 – SPFx – Introduction to gulp](https://sharepains.com/2017/06/28/office-365-spfx-introduction-to-gulp/): In recent weeks I wrote quite a few articles about SPFx. During the build process of the SPFx web parts there have been quite a few moments where I've been supplying the gulp commands. This post will give you a further introduction of gulp. - [SharePoint 2016 – Connect search between two farms.](https://sharepains.com/2017/06/23/sharepoint-2016-connecting-search-between-two-farms/): Today I tried to configure search between two SharePoint 2016 farms and connect the search results - [Office 365 – Microsoft Forms is now in preview](https://sharepains.com/2017/06/21/office-365-microsoft-forms-is-now-in-preview/): Today Microsoft released the preview for Microsoft Forms. An all new questionnaire solution. - [Office 365 – SharePoint – PnP Tenant Migration Sample is now available!](https://sharepains.com/2017/06/19/office-365-sharepoint-pnp-tenant-migration-sample-is-now-available/): Have you ever tried to migrate a site from an on-premises SharePoint environment to Office 365? Or have you tried keeping development, test and production sites in sync? - [SharePoint 2013 – The Path has lost its way for Markdown files within SharePoint search](https://sharepains.com/2017/06/13/sharepoint-2013-the-path-has-lost-its-way-for-markdown-files-within-sharepoint-search/): The Url in ctx.CurrentItem.Path for my documents in team site would look like this: - [How to create a form framework using SPFx in Office 365 and SharePoint Online](https://sharepains.com/2017/06/08/office-365-sharepoint-how-to-create-a-form-framework-using-spfx-part-3/): Within this series of posts about creating forms using the SharePoint Framework, I will go through the following steps: - [Office 365 – SharePoint – How to create a form framework using SPFx – Part 2](https://sharepains.com/2017/06/07/office-365-sharepoint-how-to-create-a-form-framework-using-spfx-part-2/): This is the second part of a series of posts in which I will go through the following steps: - [Office 365 – SharePoint – How to create a form framework using SPFx – Part 1](https://sharepains.com/2017/06/06/office-365-sharepoint-how-to-create-form-framework-using-spfx-part-1/): Within this series of posts I will go through the following steps: - [Office 365 – SharePoint SPFx – Creating a clickable zone](https://sharepains.com/2017/06/06/office-365-sharepoint-spfx-creating-a-clickable-zone/): Within this series of posts about SPFx I will go through the following steps: - [Office 365 – SharePoint – How to create forms using SPFx](https://sharepains.com/2017/06/05/office-365-sharepoint-how-to-create-forms-using-spfx/): The all new SharePoint Framework (SPFx) is one of the exciting new developments in the Office 365/SharePoint world. When I first started to look at SPFx, I played around with  the Hello World examples. Quite quickly I wanted to do more with the new web parts. In this series of posts I will describe to steps to develop a reusable forms solution. - [Office 365 – Displaying SharePoint data in the SPFx web part](https://sharepains.com/2017/06/05/office-365-displaying-sharepoint-data-in-the-spfx-web-part/): So if I use mock data or if I use SharePoint data in both cases this._renderBids(bids) will be called. Now we only need to implement - [Office 365 – Support was so good](https://sharepains.com/2017/05/22/office-365-support-was-so-good/): When I logged a support call I received the following from Microsoft support: - [Office 365 – Secure Score, what is your score?](https://sharepains.com/2017/05/19/office-365-secure-score/): Today I had a look at the new Secure Score site that Microsoft is offering and I found that my score on  my development tenant is 75 - [Office 365 – Azure – Running PnP PowerShell using Azure Functions](https://sharepains.com/2017/05/18/office-365-azure-running-pnp-powershell-using-azure-functions/): One of the great new features in Azure is Azure Functions. Azure functions will let you run PowerShell scripts at a very low cost within an Azure tenant.  In this post I go through all the steps needed to set this up. - [The content pack is temporary unavailable …](https://sharepains.com/2017/05/16/office-365-sharepoint-demos-microsoft-com-the-content-pack-is-temporary-unavailable/):  The content pack is temporary unavailable while we replenish our supply of QuickTenants. Please check back in 24 hours - [Office 365 – SharePoint – SPFx – There was a network problem](https://sharepains.com/2017/05/09/spfx-there-was-a-network-problem/): ***ERROR MESSAGE: ***Failed to load component "4fb1a04a-1d7e-4683-8046-de1646f94fb0" (MyClientSideWebPartWebPart). Original error: ***Failed to load URL 'https:/ /myclientsidewebpart.azureedge.net/my-client-side-webpart/myclientsidewebpart-myclientsidewebpartstrings_en-us_536e65149b0acf4d52c0043073b9fc59.js' for resource 'myClientSideWebPartStrings' in component '4fb1a04a-1d7e-4683-8046-de1646f94fb0' (MyClientSideWebPartWebPart). There was a network problem. This may be a problem with a HTTPS certificate. Make sure you have the right certificate. ***CALLSTACK: i/<@https://spoprod-a.akamaihd.net/files/sp-client-prod_2017-04-28.005/sppages-assembly_en-us_03284083c09713dfb7fbb719a51b09de.js:144:54695 - [Office 365 – SharePoint – Create a Client Side Web Part using SPFx and CDN](https://sharepains.com/2017/05/09/office-365-sharepoint-create-a-client-side-web-part-using-spfx-and-cdn/): I'm going to create CDN in Azure.  I must say that I find Azure extremely confusing and it is difficult to find the right options. So I'm going to document all the little steps that are needed here. First I logged on to portal.azure.com - [SharePoint – PnP – Github – This branch is 245 commits behind SharePoint:master.](https://sharepains.com/2017/05/05/sharepoint-pnp-github-this-branch-is-245-commits-behind-sharepointmaster/): Now I'm seeing in my forks messages : "This branch is X commits behind SharePoint:master - [Office 365 – something new today MyAnalytics](https://sharepains.com/2017/05/04/office-365-something-new-today-myanalytics/): Today I noticed something new in my demo tenant. In the application tiles I now have MyAnalytics. - [SharePoint 2010, 2013, 2016 – Monitor your SharePoint logs.](https://sharepains.com/2017/05/04/sharepoint-2010-2013-2016-monitor-your-sharepoint-logs/): Quite a while ago I developed tool to monitor SharePoint logs. Since I developed this it's been available for download on Codeplex. Recently I noticed that codeplex is going to shut down. - [Office 365 – Microsoft Teams – a look under the hood of the wiki pages](https://sharepains.com/2017/04/27/office-365-microsoft-teams-a-look-under-the-hood/): I always had the idea that the wiki pages were stored somewhere outside the scope of SharePoint. - [SharePoint – Get list items using JavaScript](https://sharepains.com/2017/04/24/sharepoint-get-list-items-using-javascript/): Many times I've used the examples in this article to get lists items from SharePoint using JavaScript. - [Office 365 / SharePoint 2013/2016 – Moving sites around](https://sharepains.com/2017/04/19/office-365-sharepoint-20132016-moving-sites-around/): Have you ever tried to migrate a site from an on-premises SharePoint environment to Office 365? Or have you tried keeping development, test and production sites in sync? - [SharePoint – Nintex – Request Data vs Nintex Forms](https://sharepains.com/2017/04/07/sharepoint-nintex-request-data-vs-nintex-forms/): My initial thought was to create an appraisal form and then create a workflow with a number of Request Data tasks as the form bounces between the reviewee and the reviewer. - [New-PnPWeb : Provisioning did not succeed](https://sharepains.com/2017/03/31/new-pnpweb-provisioning-did-not-succeed/): New-PnPWeb : Provisioning did not succeed. Details: Failed to initialize some site properties for Web at Url: 'https:/ /mytenant.sharepoint.com/clients/client1' OriginalException: The request uses too many resources. - [Office 365 – SharePoint 2013/2016 – Replicating or migrating SharePoint sites.](https://sharepains.com/2017/03/30/office-365-sharepoint-20132016-replicating-or-migrating-sharepoint-sites/): So this isn't just about provisioning a solution, it is also about replicating your solutions between Development, Test and Production. - [The object is used in the context different from the one associated with the object](https://sharepains.com/2017/03/29/the-object-is-used-in-the-context/): Exception calling "Load" with "1" argument(s): "The object is used in the context different from the one associated with the object."At line:1 char:1+ $web.Context.Load($list.Fields)+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~+ CategoryInfo : NotSpecified: (:) , MethodInvocationException+ FullyQualifiedErrorId : InvalidOperationException - [Office 365 – PnP – Pages are not replicated](https://sharepains.com/2017/03/23/office-365-pnp-replicating-sharepoint-based-intranets-pages-are-not-replicated/): Over the last year or so many of my posts have been related to the PnP Provisioning Engine. - [Office 365 – OfficeDev PnP PowerShell – Get all files in a folder](https://sharepains.com/2017/03/20/office-365-officedev-pnp-powershell-get-all-files-in-a-folder/): Today I tried to get a list of all files within a folder in SharePoint Online using PnP PowerShell. - [Office 365 – Office Dev PnP PowerShell – Mixing up releases](https://sharepains.com/2017/03/20/office-365-office-dev-pnp-powershell-mixing-up-releases/): It's not often that I work with SharePoint on-premises anymore, but recently I had a look at PnP PowerShell for SharePoint 2013.  - [Cannot process argument transformation on parameter ‘VARName’.](https://sharepains.com/2017/03/20/powershell-cannot-process-argument-transformation-on-parameter-varname/): Cannot process argument transformation on parameter 'Environment'. Cannot convert value "System.Xml.XmlElement" to type "System.Xml.XmlDocument". Error: "The specified node cannot be inserted as the valid child of this node, because the specified node is the wrong type." - [SharePoint Online – Document Library is not a Document Library](https://sharepains.com/2017/03/10/office-365-sharepoint-document-library-is-not-a-document-library/): That pages are different in publishing site and a team site is quite clear. A less known difference between publishing sites and team sites are the document libraries. You might have noticed the difference in the Url Documents and Shared Documents, but that doesn't matter much. It's just a library! - [Performance issues with Business Connectivity Services](https://sharepains.com/2017/03/07/office-365-bcs-performance-issues-dont-use-it/): Today, one of my colleagues reported some issues with Business Connectivity Services (BCS )  in Office 365. - [Outlook – Focused Inbox, how to switch it off](https://sharepains.com/2017/03/06/outlook-focused-inbox-how-to-switch-it-off/): There is the option to didable focused inbox email. - [Office 365 – PnP – Exporting sites with welcome pages not set to a page](https://sharepains.com/2017/03/03/office-365-pnp-exporting-sites-with-welcome-pages-not-set-to-a-page/): Today I tried to export a site as a PnP template and I was getting an annoying error: - [Microsoft Teams – What’s new in March](https://sharepains.com/2017/03/02/microsoft-teams-whats-new-in-march/): Microsoft Teams is the new exciting piece of software released by Microsoft. Although not fully GA yet, many people are already using/testing it. - [Office 365 – SharePoint – Create your own Contact list](https://sharepains.com/2017/02/28/office-365-sharepoint-create-your-own-contact-list/): SharePoint has it's own Contact list with its own content type, Contact. But what if you want to customize this list. What should you do? - [Apply-PnPProvisioningTemplate – Exception has been thrown by the target of an invocation](https://sharepains.com/2017/02/24/office-365-apply-pnpprovisioningtemplate-exception-has-been-thrown-by-the-target-of-an-invocation/): Exception has been thrown by the target of an invocation. - [Office 365 – SharePoint Designer workflows calling long running web services](https://sharepains.com/2017/02/23/office-365-sharepoint-designer-workflows-calling-long-running-web-services/): Today I created a SharePoint Designer workflow calling web services. The web service call creates a SharePoint site and applies a PnP template to the site. - [Office 365 – PnP Provisioning Engine – Make external lists work](https://sharepains.com/2017/02/08/office-365-pnp-provisioning-engine-making-external-lists-work/): The current version of the PnP provisioning engine doesn't like external lists.To make this work you will need to do some work. - [Apply-PnPProvisioningTemplate not updating pages.](https://sharepains.com/2017/01/25/apply-pnpprovisioningtemplate-updating-pages/): Today I ran the latest version of the PnP PowerShell Apply-PnPProvisioningTemplate Cmdlet to apply some templates and I noticed that pages weren't updated. - [Microsoft Edge – Is there a new browser war?](https://sharepains.com/2017/01/19/microsoft-edge-is-there-a-new-browser-war-going-on/): Today, I started Chrome. Yes even as a Microsoft only person, I sometimes am I sinner! - [Office 365 – Which version have I got?](https://sharepains.com/2017/01/17/office-365-which-version-have-i-got/): Today I'm trying to use PnP PowerShell to check the version of my SharePoint farm in Office 365. - [Office 365 – Release Management and Agile](https://sharepains.com/2017/01/04/office-365-release-management-and-agile/): In recent months Microsoft have been releasing new pieces of functionality to their Office 365 platform. - [Office 365 – Do you take the risk?](https://sharepains.com/2016/12/22/office-365-do-you-take-the-risk/): Many years ago one of my customers had 4 environments for each of their IT systems. But for some reasons many people take a risk and only use one environment for SharePoint Online. - [New OneDrive Admin Center – An Overview](https://sharepains.com/2016/12/22/new-onedrive-admin-center/): Ever wanted to look through the audit logs in OneDrive? The link to the Compliance is now available within the  OneDrive Admin Center. - [New OneDrive Admin Center Preview](https://sharepains.com/2016/12/16/new-onedrive-admin-center-preview/): Today the announcement of a new admin center preview appeared in my Message Center. - [OneDrive for Business vs SharePoint – Synchronizing folders in libraries](https://sharepains.com/2016/12/14/onedrive-for-busniness-vs-office-365-vs-sharepoint-2013-synchronizing-folders-in-libraries/): When I use OneDrive for Business  to synchronize documents in my SharePoint libraries I have found some differences between Office 365 and SharePoint on-premises. - [Office 365 – Apply-PnPProvisioningTemplate with publishing pages](https://sharepains.com/2016/12/08/office-365-apply-pnpprovisioningtemplate-with-publishing-pages/): Today I tried to apply a PnP template to a publishing site and I was getting the following error. - [Angular 2- My first steps](https://sharepains.com/2016/12/07/angular-2-my-first-steps/): Ok, recently I have started with Angular 2. With this article I'm trying to help others that want to get into Angular 2 and are trying to get familiar with all of the new Angular 2 stuff. - [Web parts in modern team sites in Office 365 – Part 2](https://sharepains.com/2016/12/02/office-365-web-parts-in-new-team-sites-in-office-365-part-2/): A few weeks ago I wrote the first part of the new web part included in the modern team sites. - [SharePoint – Nintex – finding the number of actions left on your license](https://sharepains.com/2016/12/01/sharepoint-nintex-finding-the-number-of-actions-left-on-your-license/): Nintex workflow has a number of different ways you can license their products. For on-premises installations Nintex have had a server based license for a long time. Since Nintex Workflow has appeared in office 365 they have had a different licensing model which makes the number of workflows and action relevant. they offer this model both in Office 365 and for on-premises solutions. - [First SharePoint Team Sites then Office 365 Groups and now Microsoft Teams](https://sharepains.com/2016/11/29/office-365-first-sharepoint-team-sites-then-office-365-groups-and-now-microsoft-teams/): So it's all about teams and Office 365 groups nowadays. But what should you use when and why should we use all these different options? - [Office 365 – Get all users without a user profile photo using PnP PowerShell](https://sharepains.com/2016/11/25/office-365-get-all-users-without-a-user-profile-photo-using-pnp-powershell/): Today, I looked at how to retrieve a list of users that don't have a user profile photo using PowerShell. - [Creating Office 365 Groups using PnP PowerShell](https://sharepains.com/2016/11/24/creating-office-365-groups-using-pnp-powershell/): Using the latest version of PnP PowerShell some new Cmdlets have been introduced. - [SharePoint – Implement DocuSign electronic signatures with Nintex workflow](https://sharepains.com/2016/11/15/sharepoint-docusign-how-to-implement-electronic-signatures-within-a-nintex-workflow-with-docusign/): I've been using SharePoint 2013 to digitally sign documents with DocuSign. In this article I'm describing how DocuSign works and how to implement a Nintex workflow in SharePoint to get your documents digitally signed. - [Web parts in new team sites in Office 365 – Part 1](https://sharepains.com/2016/11/11/new-team-sites-in-office-365/): Recently Microsoft have started rolling out the new team sites. - [Office 365 – App Launcher images](https://sharepains.com/2016/11/09/office-365-app-launcher-images/): Today on the Tech Community site an interesting question was asked. - [SharePoint 2013 – Nintex – How to update tasks with document details](https://sharepains.com/2016/11/09/sharepoint-2013-nintex-how-to-update-tasks-with-document-details/): Today I've got a document library with an approval workflow on it. For the approval I've used a Request data task. - [SharePoint 2013 – Nintex – How to include the workflow link in display templates](https://sharepains.com/2016/11/08/sharepoint-2013-nintex-how-to-include-workflow-link-in-display-templates/): Today, I've build a nice Nintex list workflow to manage the approval of incoming requests. On the SharePoint list I've got a Manage requests column that gives me a link to the workflow. - [Default values on site columns in SharePoint](https://sharepains.com/2016/11/07/default-values-site-columns-sharepoint/): I'm hoping that someone will tell me that I'm doing something wrong. I've tried setting default values of site columns both in an on-premises SharePoint 2013 and Office 365 environment. - [Implement drag and drop for list items in SharePoint Online](https://sharepains.com/2016/11/01/office-365-sharepoint-implementing-drag-and-drop-for-list-items/): Last week one of my customers wanted me to implement drag and drop to update a status field for one of their lists. So I found the Andrew Burgess' article on how to implement drag and drop. - [Office 365 – SharePoint Online – Running out of resources, can’t create new site collections](https://sharepains.com/2016/10/21/office-365-sharepoint-online-running-out-of-resources-cant-create-new-site-collections/): For a long time Office 365 as shown thee overviews: - [Office 365 Groups – An overview](https://sharepains.com/2016/10/13/office-365-groups-an-overview-of-the-main-features/): The one thing I hadn't looked into very much is the new Office 365 groups. - [Office 365 – How do debug PnP PowerShell commands](https://sharepains.com/2016/10/11/office-365-how-do-debug-pnp-powershell-commands/): Further to my one of my previous posts How to debug PnP Provisioning Engine in which I explained how to use the Set-SPOTraceLog Cmdlet to get more information from your PnP PowerShell commands. In this article I'm going to describe how to debug the PowerShell source code itself. - [Use Metadata on your OneDrive for Business documents?](https://sharepains.com/2016/10/07/office-365-onedrive-for-business-how-to-use-metadata-on-your-documents/): I'm looking at creating metadata fields on my documents stored in OneDrive for Business and I notices that there isn't a list settings in my settings menu. - [Office 365 – Customizations too risky? Go for more development!](https://sharepains.com/2016/09/20/office-365-customizations-too-risky-go-for-more-development/): On the techcommunity site a question was asked about how to reduce the risk of updates breaking your Office 365 SharePoint solutions - [Add-PnPFile – format-default : The collection has not been initialized](https://sharepains.com/2016/09/20/add-pnpile-format-default-the-collection/): Today I tried to upload a document to SharePoint Online using the Add-PnPFile command from the PnP PowerShell. - [Office 365 – SharePoint – Are workflows important?](https://sharepains.com/2016/09/19/office-365-sharepoint-are-workflows-important/): Back to my initial question in this article. Are workflows important? - [SharePoint Online PnP – The object is used in the context different from the one associated with the object.](https://sharepains.com/2016/09/16/office-365-sharepoint-pnp-the-object-is-used-in-the-context-different-from-the-one-associated-with-the-object/): Today  one of my colleagues was trying to create a list item in SharePoint Online using the PnP PowerShell. - [Office 365 – SharePoint Online – Creating list items using Microsoft Flow](https://sharepains.com/2016/09/15/office-365-sharepoint-online-creating-list-items-using-microsoft-flow/): As SharePoint Designer 2016 isn't going to exist I thought better look into the new Microsoft Flow. - [Office 365 – SharePoint Online – Creating counters in your refinement panels.](https://sharepains.com/2016/09/13/creating-counters-in-your-refinement-panels/): Office 365 - SharePoint Online - Creating counters in your refinement panels.today I found this article in which Microsoft describes how to create refinement panels with counters - [Office 365 – SharePoint – Who has accepted your sharing invitation?](https://sharepains.com/2016/08/25/office-365-sharepoint-who-has-accepted-your-sharing-invitation/): Have you  ever wanted to receive an alert when the person you are sharing with has accepted your invitation? - [Office 365 – Outlook is now helping you being more focused and rude](https://sharepains.com/2016/08/25/office-365-outlook-is-now-helping-you-being-more-focused-and-rude/): Well Microsoft is now improving the Clutter feature. First of all they are now talking about Focused Inbox. - [How healthy is your Office 365 tenant?](https://sharepains.com/2016/08/23/office-365-how-healthy-is-your-tenant/): Ok, so my tenant is healthy. - [Get Started with PnP PowerShell and SharePoint](https://sharepains.com/2016/08/19/office-365-sharepoint-getting-started-with-pnp-powershell/): In recent weeks I've given quite a few of my colleagues in introduction into PnP PowerShell. - [Office 365 – Message Center Translations](https://sharepains.com/2016/08/17/office-365-message-center-translations/): Last week I noticed this announcement in my message center: - [Office 365 – SharePoint – The new List look and feel – A complete overview](https://sharepains.com/2016/08/15/office-365-sharepoint-the-new-list-look-and-feel-a-complete-overview/): A lot of changes have been happening in Office 365/SharePoint Online recently. Followers of my blog will already have read the articles: - [Office 365 – SharePoint – How to debug PnP Provisioning Engine](https://sharepains.com/2016/07/29/office-365-sharepoint-how-to-debug-pnp-provisioning-engine/): Quite often I run into issues with PnP templates where something is going wrong but it is unclear what is going wrong. The xml file isn't generated when I run: - [Office 365 – Get started with team sites](https://sharepains.com/2016/07/29/office-365-get-started-with-team-sites/): Also now that we are looking at the site contents overview, have you  noticed the Power BI app?  It looks like the Power BI app is now directly enabled on the team sites. Something for my next post. - [Nintex – Coercion failed: Unable to transform the input lookup into the requested type](https://sharepains.com/2016/07/18/nintex-coercion-failed-unable-to-transform-the-input-lookup-into-the-requested-type/): Coercion failed: Unable to transform the input lookup into the requested type - [Yammer – How the Office 365 Network will change the way we work with SharePoint](https://sharepains.com/2016/07/18/yammer-how-the-office-365-network-will-change-the-way-we-work-with-sharepoint/): Further to my recent post Yammer – How Yammer has changed the way we work with SharePoint, Microsoft has now opened a new discussion platform. - [WPC16 – The end of …](https://sharepains.com/2016/07/11/wpc16-the-end-of/): Today at the World Partner Conference of Microsoft there was a demo of the HoloLens. Is this a new beginning of something nice or is this the end of a lot? - [How Yammer has changed the way we work with SharePoint](https://sharepains.com/2016/07/07/yammer-how-yammer-has-changed-the-way-we-work-with-sharepoint/): When you visit Yammer in your browser  (yammer.com) click on the cog menu and select Browse External Networks and you can find all your external networks. - [SharePoint 2016 – All new PowerShell Cmdlets](https://sharepains.com/2016/07/07/sharepoint-2016-all-new-powershell-cmdlets/): With SharePoint 2016 quite a few new PowerShell cmdlets have arrived. In this post I've included a quick overview of all the new commands. - [Office 365 – Delve – The Windows 10 Delve App – A complete overview](https://sharepains.com/2016/07/06/office-365-delve-the-windows-10-delve-app-a-complete-overview/): Today I found the new Delve App for Windows 10. In this post a complete overview of Delve. - [Windows Server 2012 – Windows update error code 8024401C](https://sharepains.com/2016/07/05/windows-server-2012-windows-update-error-code-8024401c/): Today, I build a new Windows Server 2012 machine on Hyper-V and I found that my Windows Updates were not working. All I got was an annoying 8024401C code. - [SharePoint 2016 – Key board Shortcuts](https://sharepains.com/2016/07/04/sharepoint-2016-key-board-shortcuts/): SharePoint 2016 has a few new key board short cuts. Previous versions of SharePoint already had some as well but now the options have been extended - [Make the title field sortable in search web parts](https://sharepains.com/2016/06/30/office-365-making-the-title-field-sortable-in-content-search-and-search-results-web-parts/): When you want to make a title field sortable in SharePoint you will hit some issues. - [Useful Microsoft sites – A complete overview](https://sharepains.com/2016/06/18/useful-microsoft-sites/): Microsoft has many useful sites. On this page I'm listing the most important ones. If I missed any site then please feel free leave a comment below. I'm updating this post on a regular basis as I find more Microsoft sites. So keep coming back. - [Office 365 – SharePoint – The New Site Contents – A Complete Overview](https://sharepains.com/2016/06/16/office-365-the-new-site-contents-a-complete-overview/): So the new Site Contents page has arrived. In this post I'm going through the options. - [Office 365 – SharePoint – Update list items using PowerShell](https://sharepains.com/2016/06/13/office-365-sharepoint-update-list-items-using-powershell/): The PowerShell commands of the PnP Framework have many useful commands that help you manage SharePoint online. One of these commands is the Set-SPOListItem Command. - [Office 365 – SharePoint – Team Site or Team Site – SharePoint Online Configuration](https://sharepains.com/2016/06/10/office-365-sharepoint-team-site-or-team-site-sharepoint-online-configuration/): This article will go through the two team site templates that I found in Office 365. - [Office 365 – SharePoint – Manage the Record Center](https://sharepains.com/2016/06/09/office-365-sharepoint-manage-the-record-center/): In my previous post I mentioned how to create the record center. Then I  looked at the different elements in the record center. Now the final part of this series will look at how to manage the record center itself. - [Office 365 – SharePoint – Views in the new document libraries and quite a bit more](https://sharepains.com/2016/06/09/office-365-sharepoint-views-in-the-new-document-libraries-and-quite-a-bit-more/): Today I had a play with the new document libraries. I had a look at the different options within the views. The following options are available: - [Office 365 – SharePoint – The Records Center – All the different elements](https://sharepains.com/2016/06/09/office-365-sharepoint-the-records-center-all-the-different-elements/): In my previous post I mentioned how to create the records centre. Now I will look at the different elements in the record center. - [Office 365 – SharePoint – Creating the Records Center](https://sharepains.com/2016/06/08/office-365-sharepoint-creating-the-records-center/): To create a records centre in Office 365 there are a number of steps that you need to go through - [Keep up to date with your Office 2016 for Office 365 updates](https://sharepains.com/2016/06/07/office-365-keep-up-to-date-with-your-office-265-updates/): Now there is a way to keep up to date with all the updates. Simply visit the Office 365 client update channel release page. And suddenly the magic trick is less magical. - [Office 365 – SharePoint – Content Search web part not displaying any data on E1 plan](https://sharepains.com/2016/06/02/office-365-sharepoint-content-search-web-part-not-displaying-any-data-on-e1-plan/): Today a bit of a strange issue. - [Office 365 – Sharing just got easier](https://sharepains.com/2016/05/31/office-365-sharing-just-got-easier/): Have these issue been resolved? No. But did my Sharing just get easier? Yes. - [Office 365 – How to find all your active/external users?](https://sharepains.com/2016/05/25/office-365-how-to-find-all-your-external-users/): Today I wanted to have a look if I could find all my external users in Office 365. And I'm especially interested in the active users. - [Office 365 – What’s New: April 2016](https://sharepains.com/2016/05/25/office-365-whats-new-april-2016/): Click Additional Information below to learn more about the new features and improvements released for Office 365 during April. - [Office 365 – SharePoint – Creating a publishing portal site collection](https://sharepains.com/2016/05/17/office-365-sharepoint-creating-a-publishing-portal-site-collection/): I've created a new tenant today and when I look at my site I've got a team site at my https:/ /mytenant.sharepoint.com url. I would like this to be a publishing portal. - [Office 365 – SharePoint creating sites with the name ‘teams’](https://sharepains.com/2016/05/13/office-365-sharepoint-creating-sites-with-the-name-teams/): Today I tried to create a new site. That's easy! No blog needed for that. - [Office 365 – Microsoft Support and Recovery Assistant for Office 365](https://sharepains.com/2016/05/12/office-365-microsoft-support-and-recovery-assistant-for-office-365/): Well the name is a bit unfortunate Microsoft Support and Recovery Assistant (MSRA). Hmm, isn't this a super bug that hospitals struggle with? - [Office 365 – SharePoint – The new SharePoint Home](https://sharepains.com/2016/05/12/office-365-sharepoint-the-new-sharepoint-home/): Today the new SharePoint Home has arrived. Well at least for me it has. The link Sites the top of page has now turned into SharePoint - [SharePoint – important JavaScript frameworks overview](https://sharepains.com/2016/05/11/sharepoint-important-javascript-frameworks-overview/): With the new SharePoint on the way there are a lot of new JavaScript frameworks that SharePoint developers need to learn. This is an overview of the major ones: - [Office 365 – Custom theming is back in the new admin center](https://sharepains.com/2016/05/10/office-365-custom-theming-is-back-in-the-new-admin-center/): Recently I wrote an article about the missing custom theming in the new admin center. - [Office 365 – SharePoint – Display Error: The display template had an error.](https://sharepains.com/2016/05/09/office-365-sharepoint-display-error-the-display-template-had-an-error/): var has_uEmail = !$isEmptyString(ctx.CurrentItem.WorkEmail); - [SharePoint pages not appearing in search web parts](https://sharepains.com/2016/05/05/pages-not-appearing-search-webparts/): I have found quite often pages not appear in search result web parts. In this post some help on how to sort this out. - [The Future of SharePoint](https://sharepains.com/2016/05/04/the-future-of-sharepoint/): Today Microsoft are organising their The Future of SharePoint event. - [Office 365 – Yammer External groups](https://sharepains.com/2016/04/29/office-365-yammer-external-groups/): Recently Microsoft have added to Yammer, external groups. Within Yammer you might have seen the following message: - [Office 365 – SharePoint – Sharing sites, lists or documents with external people](https://sharepains.com/2016/04/28/office-365-sharepoint-sharing-sites-lists-or-documents-with-external-people/): Sharing sites, lists or documents with external people is easy in office 365. A couple of tick boxes to click and off you go. - [Office 365 – Refresh your alerts](https://sharepains.com/2016/04/26/office-365-refresh-your-alerts/): Ever seen a Refresh your alerts message in Office 365? - [Connect-PnPOnline, Common error messages](https://sharepains.com/2016/04/22/connect-pnponline-common-error-messages/): Note: Recently the Connect-SPOnline command was replaced with Connect-PnPOnline. - [Office 365 – SharePoint – Set-SPOSite : Property set method not found.](https://sharepains.com/2016/04/22/office-365-sharepoint-set-sposite-property-set-method-not-found/): Set-SPOSite : Property set method not found. - [Office 365 – SharePoint – User profile property settings](https://sharepains.com/2016/04/21/office-365-sharepoint-user-profile-property-settings/): The user profiles in SharePoint have a number of configurable settings for the each of user profile properties. I've created a few custom properties and now I'm looking into the Privacy settings. - [Collecting all user profile properties using PnP PowerShell](https://sharepains.com/2016/04/20/office-365-sharepoint-online-collecting-all-user-profile-properties-using-pnp-powershell/): Then I'm using the Get-SPOUserProfileProperty command to collect all the user profile properties: - [Office 365 – Crawling User Profiles in SharePoint Online](https://sharepains.com/2016/04/19/office-365-crawling-user-profiles-in-sharepoint-online/): Looking at articles like Chris O'Brien's and the answers from Microsoft I'm worrying about any search queries related to user profiles in SharePoint Online. Of course changes might take a while to come through but after 15 minutes continuous crawls should pick up changes in my data. - [Get all views of SharePoint lists using PnP PowerShell](https://sharepains.com/2016/04/18/office-365-sharepoint-online-get-all-views-of-all-lists-using-pnp-powershell/): In my client's SharePoint site there are a number of lists where multiple views with similar names have been created. (e.g. All Items and AllItems"). Rather than going through every list and checking where the double views have been created I used the PowerShell commands from the PnP framework to list all the views in all the sites. - [Office 365 – SharePoint Online – Out of the box is good but sometimes not – OWS_URL](https://sharepains.com/2016/04/13/office-365-sharepoint-online-out-of-the-box-is-good-but-sometimes-not-ows_url/): Today I created a list with URLs and I used the out of the box field URL. SharePoint created a Managed Property for me called OWS_URL. - [SharePoint 2013 – Display the first 100 characters of a Publishing Page Content field using Display Templates](https://sharepains.com/2016/04/13/sharepoint-2013-display-first-100-characters-of-publishing-page-content-field-using-display-templates/): How do you display the first set of characters of a Publishing Page in a display template? - [Office 365 – New Admin Center – Where are Custom Theming, Tiles and Help desk gone to?](https://sharepains.com/2016/03/31/office-365-new-admin-center-where-are-custom-theming-custom-tiles-and-custom-help-desk-gone-to/): The options for Custom Theming, Custom Tiles and Custom Helpdesk have now disappeared. - [Office 365 – SharePoint – My Membership Web Part not working after joining a community site](https://sharepains.com/2016/03/31/office-365-sharepoint-my-membership-web-part-not-working-after-joining-a-community-site/): Then I went to the web part maintenance page as suggested in the above error message and I removed one web part at the time and I found that the My membership web part isn't working and causing the page failing to load. - [Search Results vs Search Content web part](https://sharepains.com/2016/03/30/office-365-sharepoint-search-results-web-part-vs-search-content-web-part/): Today I came across a difference between the search results and search content web part. - [OfficeDev/PnP – How to use GitHub?](https://sharepains.com/2016/03/17/officedevpnp-how-to-use-github/): I've been using GitHub now for a while for  a number of projects. The OfficeDev/PnP is quite well organised however it is not always clear how to use GitHub. On a regular basis people contributing to the project submit changes to the master branch. - [Office – Interesting 3rd party products](https://sharepains.com/2016/03/08/office-interesting-3rd-party-products/): In the many years that I worked with Microsoft products I have liked using 3rd party add-ons. - [Office 365 – SharePoint – How responsive is your site?](https://sharepains.com/2016/03/04/how-responsive-is-your-site/): Today I found the youresponsive site. Showing me exactly how responsive my blog is: - [Office 365 – Office 365 Admin App – a quick overview](https://sharepains.com/2016/02/29/office-365-office-365-admin-app-a-quick-overview/): Recently I have started using the Office 365 Admin app on my mobile. It is a great tool to find out what is happening in my office 365 tenants and also keep an eye on my customer's tenants. - [The HTTP request has timed out after 200000 milliseconds](https://sharepains.com/2016/02/26/the-http-request-has-timed-out/): Apply-SPOProvisioningTemplate : System.TimeoutException: The HTTP request has timed out after 200000 milliseconds. ---> System.Net.WebException: The request was aborted: The request was canceled. at System.Net.HttpWebRequest.EndGetResponse(IAsyncResult asyncResult) at Microsoft.Workflow.Client.HttpGetResponseAsyncResult`1.OnGotResponse(IAsyncResult - [Office 365 – Nintex delete items reporting: Unable to find list item to delete.](https://sharepains.com/2016/02/08/office-365-nintex-delete-items-reporting-unable-to-find-list-item-to-delete/): Today I created a workflow that needs to delete items, of more specifically all documents matching certain criteria in my SharePoint Online based document library. - [Start a Project Online trial with Office 365](https://sharepains.com/2016/02/01/start-a-project-online-trial-with-office-365/): Ok so I've got an Office 365 tenant available nd I want to get a trial of Project Online up and running. - [Office 365 – The Push Notifications feature is not activated on the site](https://sharepains.com/2016/01/27/office-365-the-push-notifications-feature-is-not-activated-on-the-site/): The Push Notifications feature is not activated on the site. - [#WordPress for windows app on my way to Glasgow](https://sharepains.com/2016/01/19/wordpress-for-windows-app-on-my-way-to-glasgow/): via WordPress for Windows app. - [Nintex Workflow for Office 365: Exchange Online create calendar item](https://sharepains.com/2016/01/15/nintex-workflow-for-office-365-exchange-online-create-calendar-item/): Today I tried to create an item in calendars using Nintex on Office 365. I configured a service account and an user account to impersonate. But my workflow kept giving me: - [SharePoint 2016 – Installing SP2016 on-premises in the cloud](https://sharepains.com/2015/12/22/sharepoint-2016-installing-sp2016-on-premises-in-the-cloud/): Today I finally got around creating a SharePoint 2016  server using the Beta 2 installer. As I have been running my virtual machines with SharePoint 2007, 2010 and on my laptop 2013 I thought I'll try and install it in Azure. In the past I've always been battling with disk space on my laptop so Azure is a great option. - [Office 365 – Content type hub – No valid proxy can be found to do this operation](https://sharepains.com/2015/12/21/office-365-content-type-hub-no-valid-proxy-can-be-found-to-do-this-operation/): Recently I picked up a project on Office 365 with a content type hub. I got some deployment scripts that were developed before by someone else. All the easy work left for me. - [PowerShell – Setting User name Get-Credential to log into Office 365](https://sharepains.com/2015/12/14/powershell-setting-user-name-get-credentials-to-log-into-office-365/): The PowerShell command Get-Credential is used to collect user credentials. - [Office 365/SharePoint 2013 – Enable Intellisense of OfficeDev PnP](https://sharepains.com/2015/12/10/office-365sharepoint-2013-enable-intellisense-of-officedevpnp/): In recent months I've really started to like the OfficeDev\PnP initiative on Github. - [Office 365/SharePoint 2013 – Add a search result web part to a page layout](https://sharepains.com/2015/11/24/office-365sharepoint-2013-adding-a-search-result-web-part-to-a-page-layout/): Today I tried to add a search result web part to a page layout. Initially I thought to do this the same way as I would with an content editor web part. - [Office 365/SharePoint 2013 – Dropdown refinement panels display templates in 5 minutes.](https://sharepains.com/2015/10/23/office-365sharepoint-2013-dropdown-refinement-panels-display-templates-in-5-minutes/): One of my requirements today was to implement dropdowns which filter content in a search results web part. So something that looks like this: - [Office 365/SharePoint 2013 – Search Result Query Builder with {Site.Url}](https://sharepains.com/2015/10/14/office-365sharepoint-2013-search-result-query-builder-with-site-url/): Including Path:{Site.Url}/MyList doesn't seem to do the job. When I' ve got sub sites which also include lists called MyList then I'm simply getting results from all sub sites as well. - [SharePoint 2013 – Task services has failed with an unknown exception](https://sharepains.com/2015/08/18/sharepoint-2013-task-services-has-failed-with-an-unknown-exception/): Today I upgraded my development SharePoint 2013 farm and things didn't go as they should. The installation of the update all worked fine, but when I ran the SharePoint Products Configuration Wizard things went a bit belly up. - [Patterns and Practices samples overview.](https://sharepains.com/2015/07/22/sharepoint-2013-office-365-patterns-and-practices-samples-overview/): Recently I've been looking into the Office Development Patterns and Practices samples (OfficeDev/PnP). Lead by Vesa Juvonen OfficeDev/PnP is an initiative by many SharePoint developers picking up all those development tasks that keep coming back. - [SharePoint 2013 – Office 365 – Creating a Custom list from a Provider-Hosted App programmatically](https://sharepains.com/2015/07/08/sharepoint-2013-office-365-creating-a-custom-list-from-a-provider-hosted-app-programmatically/): I'm adding the following code (the bits in bold are new the rest of the code I've included to show the right location.) I'm only going to create a simple custom list. - [Monitoring SharePoint’s ULS Logs](https://sharepains.com/2015/06/26/sharepoint-2013-monitoring-sharepoints-uls-logs/): SharePoint reports all it's errors in the SharePoint ULS Logs. These logs are sometimes difficult to read as there is so much information logged. - [SharePoint 2013 – Nintex – Store Task ID in Collect Data Task, Request Approval and Request Review](https://sharepains.com/2015/06/22/sharepoint-2013-nintex-store-task-id-in-collect-data-task-request-approval-and-request-review/): All of these actions have the Store Task IDs in setting. - [SharePoint 2013 – Hover Panel Display Templates not showing Custom Columns](https://sharepains.com/2015/06/10/sharepoint-2013-hover-panel-display-templates-not-showing-custom-columns/): Today I created a custom hover panel. I took the default item_Default_HoverPanel.html from my Display Templates Gallery and added a copy as item_custom_hoverpanel to the Display Template Gallery. - [SharePoint – Developing Error free workflows in Nintex](https://sharepains.com/2015/06/09/developing-error-free-workflows-in-nintex/): Error handling is important and can be difficult. Ideally I would like to enable the error handling option for each activity (if it only existed).However with the above ideas I'm getting close to error free workflows. - [Developing Top-Down Code Free Workflows using SharePoint 2013 and Nintex Workflow](https://sharepains.com/2015/06/02/developing-top-down-code-free-workflows-using-sharepoint-2013-and-nintex-workflow/): I’m fortunate to be part of the platinum business partnership with Nintex. Over the last few years Vantage 365 has made no code workflows using Nintex Workflow one of their focus points. Of course when we needed to, we would also do the hard core development but if it is possible to avoid then Nintex Workflow is often a nice solution, giving the end user a chance to automate things. - [Silverlight – REST API – Security Error](https://sharepains.com/2015/05/08/silverlight-rest-api-security-error/): Today I tried to access a SharePoint REST API from my Silverlight Web Part and I got a Security Error. I quite quickly got a great article describing all about the clientaccesspolicy.xml, but it was still not working. - [Padding is invalid and cannot be removed](https://sharepains.com/2015/04/28/padding-is-invalid-and-cannot-be-removed/): In this post I'm looking at the Padding is invalid and cannot be removed error - [Uninstall-SPUserSolution : Feature ‘7436371b-c242-440d-b7c3-d2bff6661c77’ is not activated at this scope](https://sharepains.com/2015/04/15/uninstall-spusersolution/): I'm using the following cmdlet Uninstall-SPUserSolution - [Managed Properties for User fields in SharePoint 2013](https://sharepains.com/2015/04/09/sharepoint-2013-managed-properties-for-user-fields/): In this post I will look at managed properties for people fields in SharePoint - [SharePoint 2013 – Remove, Add and Update List View Web Parts on publishing pages programmatically](https://sharepains.com/2015/03/30/sharepoint-2013-remove-add-and-update-list-view-web-parts-on-publishing-pages-programmatically/): Sergei Sergeev's post about changing default views helped a bit here - [SharePoint 2013 – The specified view is invalid in call to LimitedWebPartManager.AddWebPart](https://sharepains.com/2015/03/27/sharepoint-2013-the-specified-view-is-invalid-in-call-to-limitedwebpartmanager-addwebpart/): The specified view is invalid in call to LimitedWebPartManager.AddWebPart - [SharePoint 2013 – Update Features](https://sharepains.com/2015/03/25/sharepoint-2013-update-features/): Today I needed to add some additional fields to content types. I heard about upgrade features before, but I never tried using this. - [SharePoint 2010 – A content type failed to be syndicated: Microsoft.SharePoint.SPContentTypeReadOnlyException:](https://sharepains.com/2015/03/25/a-content-type-failed-to-be-syndicated/): Yesterday I copied my content database from production to my test environment using a database detach/attach method. All easy stuff, and I've done that many times before. What could possibly go wrong? - [SharePoint 2013 – An unhandled exception occurred during the execution of the workflow instance](https://sharepains.com/2015/03/12/sharepoint-2013-an-unhandled-exception-occurred-during-the-execution-of-the-workflow-instance/): Details: An unhandled exception occurred during the execution of the workflow instance. Exception details: System.ApplicationException: HTTP 401 {"error":{"code":"-2147024891, System.UnauthorizedAccessException","message":{"lang":"en-US","value":"Access denied. You do not have permission to perform this action or access this resource - [SharePoint 2013 – Deploying a publishing page in Sandbox vs Farm Solution](https://sharepains.com/2015/03/06/sharepoint-2013-deploying-a-publishing-page-in-sandbox-vs-farm-solution/): Today I deployed a publishing page through a Sandbox solution - [Working with PowerShell Modules](https://sharepains.com/2015/03/03/powershell-modules/): In my earlier post I explained about function in SharePoint. to take this a step forward I'm now looking at modules. - [SharePoint 2013 – Visual Studio – Remote SharePoint site connections are not supported.](https://sharepains.com/2015/03/03/sharepoint-2013-visual-studio-remote-sharepoint-site-connections-are-not-supported/): Remote SharePoint site connections are not supported. - [Operation is not valid due to the current state of the object](https://sharepains.com/2015/02/26/operation-is-not-valid-due-to-the-current-state-of-the-object/): Yesterday I had an issue reconfiguring the User Profiles Service Application where got "Operation is not valid due to the current state of the object" - [PowerShell functions and parameters](https://sharepains.com/2015/02/24/powershell-functions/): As always there are different ways of doing things. PowerShell is no different. - [CRM 2011 – An error occurred when attempting to set the SQLSERVERAGENT service to AutoStart](https://sharepains.com/2015/02/23/crm-2011-an-error-occurred-when-attempting-to-set-the-sqlserveragent-service-to-autostart/): An error occurred when attempting to set the SQLSERVERAGENT service to AutoStart: System.ComponentModel.Win32Exception (0x80004005): The specified service does not exist as an installed service - [SharePoint 2013 – Email alerts: Cannot connect to SMTP host](https://sharepains.com/2015/02/19/sharepoint-2013-email-alerts-cannot-connect-to-smtp-host/): Cannot connect to SMTP host mysmtp.mycorp.com - [SharePoint 2013 – How to deploy and redeploy Display Templates](https://sharepains.com/2015/02/17/sharepoint-2013-how-to-deploy-and-redeploy-display-templates/): I've been struggling for a while to redeploy display templates. - [SharePoint 2013 – Creating a custom Staff Directory in 7 Steps](https://sharepains.com/2015/02/17/sharepoint-2013-creating-a-staff-directory-in-7-steps/): Recently quite a few of my customer asked me to build a staff directory. There are some variations but the general story is utilise the information stored in SharePoint’s user profiles. - [SharePoint 2013 – Error messages that should really be updated](https://sharepains.com/2015/02/09/sharepoint-2013-error-messages-that-should-really-be-updated/): While I looked through error messages in the SharePoint ULS logs I found the following weird, typos and other unnecessary rubbish messages: - [SharePoint 2013 – The server was unable to save the form at this time. Please try again.](https://sharepains.com/2015/02/06/sharepoint-2013-the-server-was-unable-to-save-the-form-at-this-time-please-try-again/): The server was unable to save the form at this time. Please try again. - [Custom list templates do not appear on the “Create List” page of a SharePoint site](https://sharepains.com/2015/01/27/sharepoint-2010-custom-list-templates-do-not-appear-on-the-create-list-page-of-a-sharepoint-site/): Today I tried to copy lists including their data from my customer's environment to my development environment. I needed to include the data so what is easier than using the save list as template in SharePoint. - [There is a compatibility range mismatch between the web server and database](https://sharepains.com/2015/01/22/sharepoint-2013-powershell-there-is-a-compatibility-range-mismatch-between-the-web-server-and-database/): There is a compatibility range mismatch between the Web server and database "WSS_Content", and connections to the data have been blocked to due to this incompatibility. This can happen when a content database has not been upgraded to be within the compatibility range of the Web server, or if the database has been upgraded to a higher level than the web server. The Web server and the database must be upgraded to the same version and build level to return to compatibility range. - [The local farm is not accessible](https://sharepains.com/2015/01/22/the-local-farm-is-not-accessible/): The local farm is not accessible. Cmdlets with FeatureDependencyId are not registered. - [SharePoint 2013 – Pages are loading very slowly](https://sharepains.com/2015/01/22/sharepoint-2013-pages-are-loading-very-slowly/): One of my customers has been complaining that pages are loading very slowly in SharePoint 2013 site. Today I investigated this and I found the following Critical error in my ULS logs: - [Faulting application name: IEXPLORE.EXE, 0x5452eed9](https://sharepains.com/2015/01/16/faulting-application-name-iexplore-exe-version-0x5452eed9/): Faulting application name: IEXPLORE.EXE, version: 11.0.9600.17416, time stamp: 0x5452eed9 Faulting module name: OLEAUT32.dll, version: 6.3.9600.17415, time stamp: 0x54503d59 Exception code: 0xc0000005 Fault offset: 0x0000a95b Faulting process id: 0x201c Faulting application start time: 0x01d031c6e264cd66 Faulting application path: C:\Program Files (x86)\Internet Explorer\IEXPLORE.EXE Faulting module path: C:\Windows\SYSTEM32\OLEAUT32.dll Report Id: 23131afc-9dba-11e4-82dd-f4b7e2ddbc9a Faulting package full name: Faulting package-relative application ID: - [SharePoint 2013 – Leaked record detected with address … , name (unknown), and thread local refcount …](https://sharepains.com/2015/01/12/sharepoint-2013-leaked-record-detected-with-address-000000001d5ed488-name-unknown-and-thread-local-refcount-73-to-see-addrefrelease-callstacks-for-this-leak-run-stsadm-o-setproperty-pn-refc/): Leaked record detected with address 000000001D5ED488, name (unknown), and thread local refcount 73. To see AddRef/Release callstacks for this leak, run stsadm -o setproperty -pn refcountcallstacktrackingenabled -pv true. - [SharePoint 2013 – Failed to persist workflow instance](https://sharepains.com/2015/01/06/failed-to-persist-workflow-instance/): Today I noticed the following Unexpected Failed to persist workflow instance messages in my ULS logs: - [SharePoint 2013 – One or more field types are not installed properly](https://sharepains.com/2014/12/19/sharepoint-2013-one-or-more-field-types-are-not-installed-properly-go-to-the-list-settings-page-to-delete-these-fields/): Microsoft.SharePoint.SPException: One or more field types are not installed properly. Go to the list settings page to delete these fields. ---> System.Runtime.InteropServices.COMException: One or more field types are not installed properly. Go to the list settings page to delete these fields.0x81020014 at Microsoft.SharePoint.Library.SPRequestInternalClass.GetListItemDataWithCallback2(IListItemSqlClient pSqlClient, String bstrUrl, String bstrListName, String bstrViewName, String bstrViewXml, SAFEARRAYFLAGS fSafeArrayFlags, ISP2DSafeArrayWriter pSACallback, ISPDataCallback pPagingCallback, ISPDataCallback pPagingPrevCallback, ISPDataCallback pFilterLinkCallback, ISPDataCallback pSchemaCallback, ISPDataCallback pRowCountCallback, Boolean& pbMaximalView) at Microsoft.SharePoint.Library.SPRequest.GetListItemDataWithCallback2(IListItemSqlClient pSqlClient, String bstrUrl, String bstrListName, String bstrViewName, String bstrViewXml, SAFEARRAYFLAGS fSafeArrayFlags, ISP2DSafeArrayWriter pSACallback, ISPDataCallback pPagingCallback, ISPDataCallback pPagingPrevCallback, ISPDataCallback pFilterLinkCallback, ISPDataCallback pSchemaCallback, ISPDataCallback pRowCountCallback, Boolean& pbMaximalView) --- End of inner exception stack trace --- at Microsoft.SharePoint.SPGlobal.HandleComException(COMException comEx) at Microsoft.SharePoint.Library.SPRequest.GetListItemDataWithCallback2(IListItemSqlClient pSqlClient, String bstrUrl, String bstrListName, String bstrViewName, String bstrViewXml, SAFEARRAYFLAGS fSafeArrayFlags, ISP2DSafeArrayWriter pSACallback, ISPDataCallback pPagingCallback, ISPDataCallback pPagingPrevCallback, ISPDataCallback pFilterLinkCallback, ISPDataCallback pSchemaCallback, ISPDataCallback pRowCountCallback, Boolean& pbMaximalView) at Microsoft.SharePoint.SPListItemCollection.EnsureListItemsData() at Microsoft.SharePoint.SPListItemCollection.get_Count() at MyCorp.SharePoint.Branding.LinksControl.Page_Load(Object sender, EventArgs e) - [Branding on variation sites in SharePoint 2013](https://sharepains.com/2014/12/18/branding-on-variations-sites/): Recently I was asked to include branding on variation sites. - [The file or folder name “_catalogs” contains invalid characters in SharePoint 2013](https://sharepains.com/2014/12/16/sharepoint-2013-the-file-or-folder-name-_catalogs-contains-invalid-characters-please-use-a-different-name-common-invalid-characters-include-the-following/): The file or folder name "_catalogs" contains invalid characters - [SharePoint 2013 – CopyIntoItemsLocal is not returning any results](https://sharepains.com/2014/12/02/sharepoint-2013-copyintoitemslocal-is-not-returning-any-results/): I am using the /_vti_bin/Copy.asmx service to copy a file from one location to another location. My destination includes a number of folders ( yes I know folders is a bad idea). - [SharePoint 2013 – SPReaderWriteLock](https://sharepains.com/2014/11/26/sharepoint-2013-spreaderwritelock/): Recently I've been looking at the ULS in a bit more detail.  In short I've been focussing on anything in the following categories: - [Add-PSSnapin Microsoft.SharePoint.PowerShell](https://sharepains.com/2014/11/25/add-pssnapin-microsoft-sharepoint-powershell/): I have seen quite a few articles mentioning Add-PSSnapin Microsoft.SharePoint.PowerShell lately. But what is the best way to load this snapin? - [SharePoint 2013 – GetListByName vs SPWeb.GetList vs SPListCollection.GetList vs SPListCollection.TryGetList](https://sharepains.com/2014/11/24/3260/): 8ca3ea94-3288-49cd-99fd-1b6eab6cb52d Stack trace: at Microsoft.SharePoint.SPListCollection.GetListByName(String strListName, Boolean bThrowException) at CallSite.Target(Closure , CallSite , Object , Object ) at System.Dynamic.UpdateDelegates.UpdateAndExecute2(CallSite site, T0 arg0, T1 arg1) at System.Management.Automation.Interpreter.DynamicInstruction`3.Run(InterpretedFrame frame) at System.Management.Automation.Interpreter.EnterTryCatchFinallyInstruction.Run(InterpretedFrame frame) at System.Management.Automation.Interpreter.EnterTryCatchFinallyInstruction.Run(InterpretedFrame frame) at System.Management.Automation.Interpreter.Interpreter.Run(InterpretedFrame frame) at System.Management.Automation.Interpreter.LightLambda.RunVoid1(T0 arg0) - [Critical, Unexpected, Warnings and Monitorable errors in the SharePoint 2013 ULS logs](https://sharepains.com/2014/11/20/sharepoint-2013-critical-unexpected-and-monitorable-errors-in-the-sharepoint-uls-logs/): Recently I wrote a PowerShell script to collect all Critical, Unexpected and Monitorable messages in the ULS logs. - [Get AD Group members in SharePoint using PowerShell](https://sharepains.com/2014/11/19/sharepoint-2013-get-ad-group-members-using-powershell/): To get AD Group Members from a SharePoint group can be quite a task. - [SharePoint 2013 – Office Web apps are working only in Chrome](https://sharepains.com/2014/10/23/sharepoint-2013-office-web-apps-not-working-in-chrome/): Today I found Office Web apps are working only in Chrome. Initially I was getting the following error (to start previews, please log on by opening the document) - [SharePoint 2013 – Start/Cancel/Restart workflows from PowerShell](https://sharepains.com/2014/10/09/sharepoint-2013-startcancelrestart-workflows-from-powershell/): Using the SharePoint 2010 workflow engine, I have a list with many list items. Some of my workflows have failed and many workflows are showing an error status. This is a workflow in development so this could happen.  I now fixed my workflow and I need to restart the workflows. - [SharePoint – object cache user accounts, Superuser and Superreader](https://sharepains.com/2014/09/30/object-cache-user-superuser-superreader/): The object cache loads every document and page twice so that the published version and the latest version (not published) is readily available for the next time the same object needs loading. - [SharePoint 2013 – System.IO.FileNotFoundException: Could not load file or assembly](https://sharepains.com/2014/09/26/sharepoint-2013-system-io-filenotfoundexception-could-not-load-file-or-assembly-microsoft-sharepoint-client-workflowservices-version15-0-0-0-cultureneutral-publickeytoken71e9bce111e9429c/): System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft.SharePoint.Client.WorkflowServices, Version=15.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c' or one of its dependencies. The system cannot find the file specified. - [SharePoint 2013 – Exception calling “StartWorkflow” with “4” argument(s): “”](https://sharepains.com/2014/09/25/sharepoint-2013-exception-calling-startworkflow-with-4-arguments/): Exception calling "StartWorkflow" with "4" argument(s): "" - [SharePoint 2013 – Failed to do column assignments for list](https://sharepains.com/2014/09/23/failed-to-do-column-assignments-for-list/): I got the Failed to do column assignments for list error in my SharePoint logs today. - [Connecting SharePoint 2013 to AS400 using iSeries drivers and the Business Connectivity Service](https://sharepains.com/2014/09/13/connecting-sharepoint-2013-to-as400-using-iseries-drivers-and-the-business-connectivity-service/): Two System DSNs must be configured on the SQL Server to be used by the application. These DSN will reference an ODBC driver supplied by IBM for the iSeries servers. - [SharePoint 2013 – Memory gates checking failed because of the free memory](https://sharepains.com/2014/09/12/sharepoint-2013-rest-api-application-error-when-access-_vti_binclient-svc/): Today I tried to access a list through the REST API. - [SharePoint 2013 – Never Ending Continuous Crawl](https://sharepains.com/2014/07/11/sharepoint-2013-never-ending-continuous-crawl/): Today I had an issue where a full crawl would take forever. I enabled continuous crawls after I first thought of adding an extra Search Server and to split Query and Crawling components. - [SharePoint 2013 – Exception calling “SystemUpdate” with “0” argument(s)](https://sharepains.com/2014/06/30/exception-calling-systemupdate-with-0-arguments-the-file-has-been-modified-by-domainusername-on/): Exception calling "SystemUpdate" with "0" argument(s): "The file <filename> has been modified by DOMAIN\Username on <date>" - [Update an External Data field in SharePoint using PowerShell](https://sharepains.com/2014/06/03/sharepoint-2013-update-an-external-data-field-using-powershell/): The situation is as follows. I have created an external list (using BDC/BCS in SharePoint 2013). - [The shim execution failed unexpectedly in SharePoint 2013](https://sharepains.com/2014/06/03/sharepoint-2013-an-error-occurred-while-enumerating-through-a-collection-the-shim-execution-failed-unexpectedly-could-not/): An error occurred while enumerating through a collection: The shim execution failed unexpectedly - Could not load file or assembly 'System.Data.OracleClient, Version=4.0.0.0, Culture=neutral,PublicKeyToken=b77a5c561934e089' or one of its dependencies. Either a required impersonation level was notprovided, or the provided impersonation level is invalid. (Exception from HRESULT: 0x80070542).. - [SharePoint 2013 – PowerShell – Taxonomy through Client Object Model](https://sharepains.com/2014/05/15/sharepoint-2013-powershell-taxonomy-through-client-object-model/): I tried to get to the my Taxonomy session through the client object model. Well if you Bing (I actually used google. But I'm Microsoft focussed so I thought I better mention Bing here) and go to the Microsoft pages documentation the there isn't much available. All I found is some empty pages. - [SharePoint 2013 – Display templates](https://sharepains.com/2014/05/07/sharepoint-2013-display-templates/): Recently I have done a lot of work with SharePoint 2013. one of the new features in SharePoint 2013 is Display Templates. At first I had to get used to it but I'm starting to really like the idea of them. - [SharePoint 2013 – Refinement Panel showing string;# for calculated text fields](https://sharepains.com/2014/04/29/refinement-panel-showing-string-for-calculated-text-fields/): So first I looked into how the refinement panel works. - [SharePoint 2013 – Hiding Recent from the Navigation](https://sharepains.com/2014/04/25/sharepoint-2013-hiding-recent-from-the-navigation/): In SharePoint 2013 there is a new feature. Every list that is added to the Current Navigation appears under a heading Recent. - [Project Server 2013 – avoiding the login window](https://sharepains.com/2014/04/24/project-server-2013-avoiding-the-login-window/): When you start open a project file it's possible that you get the following window presented to you. - [Get TemplateID for starting a workflow from the ribbon in SharePoint 2013 workflow](https://sharepains.com/2014/04/17/get-templateid-for-starting-a-workflow-from-the-ribbon-in-sharepoint-2013-workflow/): Today I tried to get the TemplateID for starting a workflow from the ribbon in SharePoint 2013 workflow. - [Unexpected errors from search in SharePoint](https://sharepains.com/2014/04/14/sharepoint-2013-unexpected-errors-from-search/): Today I had some issues with my SharePoint installation. So I had a look at the SharePoint ULS logs. Quite  a few Unexpected errors that can be ignored: - [SharePoint 2013 – SPFieldType Invalid](https://sharepains.com/2014/04/08/spfieldtype-invalid/): use SPFieldType.TaxonomyFieldType .... - [SharePoint 2013 – The SPListItem being updated was not retrieved with all taxonomy fields.](https://sharepains.com/2014/04/02/sharepoint-2013-the-splistitem-being-updated-was-not-retrieved-with-all-taxonomy-fields/): The SPListItem being updated was not retrieved with all taxonomy fields. - [Update the time zone with PowerShell in SharePoint](https://sharepains.com/2014/04/01/update-the-time-zone-sharepoint/): Today I have a customer with users all over the world. Initially the time for everybody was the server time but now they needed to update the time zone. - [SharePoint 2013 – Workflow Manager 1.0 – How to publish a list workflow programmatically](https://sharepains.com/2014/03/24/share-point-2013-workflow-manager-1-0-how-to-publish-a-list-workflow-programmatically/): So I had a reusable SharePoint Designer list workflow deployed in SharePoint 2013. The process that I'm implementing is creating project sites using web templates created in Visual Studio 2013. - [Unexpected error occurred in method ‘GetObject’ in SharePoint 2013](https://sharepains.com/2014/03/21/unexpected-error-occurred-in-method-getobject-usage-distributed-logon-token-cache-exception-microsoft-applicationserver-caching-datacacheexception-errorcodesubstatusthe-request-timed/): I'm using Workflow Manager 1.0 and SharePoint 2013 with SharePoint Designer workflows and I got an Unexpected error occurred in method. - [SharePoint 2013 – Update Related Items in SharePoint 2013 using SharePoint Designer Workflow](https://sharepains.com/2014/03/17/update-related-items-in-sharepoint-2013-using-sharepoint-designer-workflow/): Today I wanted to update a list item's related Items (I renamed the Related Items to Secured Comments in my list)  field. - [Code Free Workflows in SharePoint 2013](https://sharepains.com/2014/03/17/code-free-workflows-in-sharepoint-2013/): In SharePoint 2013 it is now possible to create code free workflows. There are quite a few articles about how to install workflow manager 1.0. For a step by step guide see this article about how to Configure Worfklow Manager - [SharePoint 2013 – Accessing workflows in PowerShell](https://sharepains.com/2014/02/27/accessing-workflows-in-powershell/): SharePoint 2013 has a new workflow engine. I'm assuming that that is no news any more. - [SharePoint 2013 Workflow: Microsoft.SharePoint.SPException: App Management Shared Service Proxy is not installed.](https://sharepains.com/2014/02/17/sharepoint-2013-workflow-microsoft-sharepoint-spexception-app-management-shared-service-proxy-is-not-installed/): SharePoint 2013 Workflow: Microsoft.SharePoint.SPException: App Management Shared Service Proxy is not installed. - [Hyper-V – Degraded (Integration Services upgrade required).](https://sharepains.com/2014/01/09/hyper-v-degraded-integration-services-upgrade-required/): Degraded (Integration Services upgrade required). - [SharePoint 2013 – PowerShell – New-SPSite : User cannot be found.](https://sharepains.com/2013/11/27/sharepoint-2013-powershell-new-spsite-user-cannot-be-found/): An annoying error today when I tried to run New-SPSite. It had worked all day and then suddenly I got this: - [MS Project 2013 – Access and Update Enterprise Project Columns](https://sharepains.com/2013/11/08/ms-project-2013-access-and-update-enterprise-project-columns/): Today I tried to access and update Enterprise project columns through a VBA Macro. - [Project Server 2013 – Disable Local Resources – Part 2](https://sharepains.com/2013/11/01/project-server-2013-disable-local-resources-part-2/): Earlier in part 1 of disable local resources I described the aim of disabling the use of local resources. Today I will show you how to implement this. - [Project Server Enterprise Global Macro not saved](https://sharepains.com/2013/10/30/project-server-2013-enterprise-global-macro-not-saved/): Today I tried to update Enterprise Global Macros using Project Professional 2013. However the Macros didn't want to save. Whenever I closed and reopened my Microsoft Project my Macros would disappear. - [Project Server 2013 – Disable local resources](https://sharepains.com/2013/10/28/project-server-2013-disable-local-resources/): I've found the option to disable local calendars, but the option to disable local resources  isn't there. - [Managing Apps for SharePoint Server 2013 – Creating and Configuring a Corporate App Catalog](https://sharepains.com/2013/10/04/managing-apps-for-sharepoint-server-2013-creating-and-configuring-a-corporate-app-catalog/): In part 1 of this article we setup the infrastructure that is required by an App Catalog. In part 2 we’re going through the steps of creating the App Catalog itself: - [Configuring a SharePoint 2013 Farm to Support Apps](https://sharepains.com/2013/10/04/configuring-a-sharepoint-farm-to-support-apps/): So everything that you deploy in SharePoint 2013 should be an app. Why do I then see so often that the basic infrastructure to install an app hasn’t been enabled? - [SharePoint Exception 0x8107026E When Activating Web Template Feature](https://sharepains.com/2013/09/17/sharepoint-exception-0x8107026e-when-activating-web-template-feature/): In my Visual Studio 203 project I created a onext.xml in a folder MyGeneralTemplate and now I'm getting a deployment exception 0x8107026E. - [Making a required lookup and setting the default value in SharePoint 2013](https://sharepains.com/2013/08/21/required-lookup-setting-default-value/): Today I had a requirement to make a lookup field required and set the default value. For a lookup field this isn't possible within the SharePoint 2010 interface. - [Project Server 2013 – Active Directory Synchronization Fails](https://sharepains.com/2013/08/19/project-server-active-directory-synchronization-fails/): I've played quite a bit with the Active Directory Synchronization as this seems to be something that keeps failing. The annoying thing is that when it fails it fails badly. All you get within the user interface is: - [Install-SPSolution : This solution contains no resources scoped for a Web application](https://sharepains.com/2013/06/28/install-spsolution-this-solution-contains-no-resources-scoped-for-a-web-application-and-cannot-be-deployed-to-a-particular-web-application/): Install-SPSolution : This solution contains no resources scoped for a Web application and cannot be deployed to a particular Web application. - [Custom development in SharePoint’s sql database](https://sharepains.com/2013/06/25/custom-development-in-sharepoints-sql-database/): Recently I visited a customer to do a SharePoint 2007 to 2013 upgrade and then I found some custom development in the databases. - [Project Server 2013 – Export Project Server tasks](https://sharepains.com/2013/05/16/export-project-server-tasks/): Today I tried to export my project tasks as a csv file using PowerShell. I couldn't find any helpful documentation on how to do this. A few articles that did almost what I wanted but just not the right thing. - [The content of the data feed is not valid for an Atom feed](https://sharepains.com/2013/05/10/the-content-of-the-data-feed-is-not-valid-for-an-atom-feed/): In this post I will look at the error "The content of the data feed is not valid for an Atom feed" - [Project Server 2013 – Active Directory Sync](https://sharepains.com/2013/03/28/project-server-2013-active-directory-sync/): I was getting no errors in my Active Directory Sync and only when I turned on Verbose logging I got the following in my ULS logs. - [Content type ‘0x01010007FF3E057FA8AB4AA42FCB67B453FFC100E214EEE741181F4E9F7ACC43278EE811’ not found](https://sharepains.com/2012/10/03/content-type-0x01010007ff3e057fa8ab4aa42fcb67b453ffc100e214eee741181f4e9f7acc43278ee811-not-found/): Content type '0x01010007FF3E057FA8AB4AA42FCB67B453FFC100E214EEE741181F4E9F7ACC43278EE811' not found - [ADFS Blocks access to CRM services](https://sharepains.com/2012/05/02/adfs-blocks-acces-to-crm-services/): In the last couple of weeks I spent quite a lot of time making an integration with SharePoint 2010 and CRM 2011 work. - [Search on anonymous SharePoint site](https://sharepains.com/2012/04/04/search-on-anonymous-sharepoint-site/): This should be quite an easy requirement. Enable search on a website in SharePoint. Well once you know what to do ... - [Search box not accessible in FireFox, Chrome etc](https://sharepains.com/2012/04/03/search-box-not-accessible-in-firefox-chrome-etc/): In IE my search box was working fine I was able to enter search queries without any problems. - [What to do when you start with SharePoint](https://sharepains.com/2012/03/30/start-with-sharepoint/): Are you about to start with SharePoint? - [XSLTListViewWebPart returns: WebPartPageUserException](https://sharepains.com/2012/01/26/xsltlistviewwebpart-returns-webpartpageuserexception-guid-should-contain-32-digits-with-4-dashes-xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx/): Today I added a XSLTListViewWebPart to my Site Definition and I receivede the following error: - [SharePoint 2010 and CRM 2011 – Create a contact us form in SharePoint](https://sharepains.com/2012/01/11/sharepoint-2010-and-crm-2011/): I'm trying to create a contact us form in SharePoint ( Easy, I  know how to do that!) - [ListId vs ListName; use sometimes ListDisplayName instead](https://sharepains.com/2011/12/21/listid-vs-listname-use-sometimes-listdisplayname-instead/): Ai, it's that same old problem where SharePoint Designer uses the ListId instead of the ListName. So I sorted this out my replacing all (in total 5)the ListId with ListName and ... Next error. I was sure that this worked before so what happened? - [Enabling the export option for a web part](https://sharepains.com/2011/12/21/enabling-the-export-option-for-a-web-part/): Today I tried enabling the export option on a custom web part. - [How do you organise your SharePoint Projects?](https://sharepains.com/2011/12/20/how-do-you-organise-your-sharepoint-projects/): There is so much more about setting up SharePoint projects and deployment but I leave that for a next time. - [SharePoint – Site Definition failed to deploy](https://sharepains.com/2011/12/15/site-definitions-fails-to-deploy/): There are many articles about site definitions. The trend seems to go towards using less site definitions or at least smaller site definitions and adding features to do all the work. Having said that, I still like to use site definitions for an initial deployment (read deployments before the customer has gone into production) as it's easy to make small changes the main structure of the site and redeploy the solution. - [SharePoint 2010 – Updating custom forms on an existing list](https://sharepains.com/2011/12/09/updating-custom-forms-on-an-existing-list/): What do you do when you have a list with custom forms (editform.aspx, dispform.aspx and newform.aspx) and you want to add some extra fields on that form. - [MSDN Forum Assistant, TechNet Forum Assistant](https://sharepains.com/2011/12/09/msdn-forum-assistant-technet-forum-assistant/): Every now and then you find some of these tools. A bit like elves during Christmas. They are useful little helpers but you need a bit of luck to find them. - [Rich Text Field Definition](https://sharepains.com/2011/12/07/91/): How to create a rich text field in SharePoint exported it using SPM (see codeplex) - [SharePoint 2007 – Deploying a custom survey as a list definition feature](https://sharepains.com/2011/12/07/deploying-a-custom-survey-as-a-list-definition-feature/): Have you ever tried to deploy a custom survey as a list definition in SharePoint 2007? - [Failed to completely create the top-level Web site](https://sharepains.com/2011/11/23/failed-to-completely-create-the-top-level-web-site-exception-was-microsoft-sharepoint-spexception-failed-to-instantiate-file-default-master-from-module-defaultmasterpage-source-path/): Event log message was: 'Failed to completely create the top-level Web site.'. Exception was: 'Microsoft.SharePoint.SPException: Failed to instantiate file "default.master" from module "DefaultMasterPage": Source path "default.master" not found - [SharePoint 2010 – Access a list in Central Admin](https://sharepains.com/2011/11/03/access-a-list-in-cenrtral-admin/): I tried many different option to access a list in Central Administration from a web part in my application. Of course the problem is that the application pool account cannot access the list and there are many variations of access denied that I found on my way.... - [Content types in SharePoint](https://sharepains.com/2011/08/09/content-types-in-sharepoint/): Content types in SharePoint can be extended by creating a new feature which deploys an element file with the following content: - [Name in activating SharePoint features in onet.xml](https://sharepains.com/2011/07/28/name-in-activating-features-in-onet-xml/): Some basic information about activating features in the onet.xml can be found on the MSDN site. - [SharePoint deployment timing out in Visual Studio 2010](https://sharepains.com/2011/07/25/sharepoint-2010-deployment-timing-out-in-visual-studio-2010/): A SharePoint deployment timing out can be quite annoying. - [Custom system master page not being picked up](https://sharepains.com/2011/07/19/custom-system-master-page-not-being-picked-up/): Check that the masterpages are there and that they are used by the site created using my template template ... Only the default master page is set but the system master page isn't set. - [Word 2010 – Crashes with .doc or .docx file format](https://sharepains.com/2011/06/30/word-2010-crashes-doc-docx-file-format/): Word crashes can be very annoying when you try to open that important document. - [SharePoint 2010 – Content Query Web Part](https://sharepains.com/2011/01/24/content-query-web-part-in-sharepoint-2010/): Unable to display this Web Part. To troubleshoot the problem, open this Web page in a Microsoft SharePoint Foundation-compatible HTML editor such as Microsoft SharePoint Designer. If the problem persists, contact your Web server administrator. - [Exporting reusable workflows from SharePoint Designer 2010 to Visual Studio 2010](https://sharepains.com/2011/01/18/exporting-reusable-workflows-from-sharepoint-designer-2010-to-visual-studio-2010/): There are a couple of blogs out there about exporting reusable workflows but none of them really cover the problems that I ran into recently. - [Form Fields in SharePoint Designer workflow](https://sharepains.com/2011/01/12/form-fields-in-sharepoint-designer-workflow/): I created a SharePoint Designer workflow which handles the approval of list items. Now I would like to have some extra site columns added to my approval form's form fields. - [Item fields on a SharePoint Designer workflow form](https://sharepains.com/2011/01/11/sharepoint-item-fields-designer-workflow/): By default SharePoint gives you a link to the list item in a SharePoint item field. - [Workflow, event handler and AfterProperties](https://sharepains.com/2010/12/14/workflow-event-handler-and-afterproperties/): I used AfterProperties to collect the site request details and the record the result of the site creation and all worked in one go. Going well so far!