In the last 15 years, I’ve nearly written nearly 1000 blogs posts about Microsoft technology. So, it is time for a competition. Why SharePains.com? Since that first blog post I’ve continued writing about the challenges that I had with Microsoft technology. Sometimes I found bugs that needed a workaround. However quite often my posts are […]
In this post I’m going through the steps to update SharePoint Item-level permissions using Power Automate and The SharePoint Rest API. Item-Level Permissions Within the Advanced settings of a SharePoint list, the Item-Level Permissions the default settings are Read all items and Create and edit all items. You might however sometimes want to switch this […]
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. Nested Galleries In the below example you can see how we have two nested galleries. One gallery will show some data and the nested gallery will show data […]
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? The Navigate Function The navigate function can be used when you want a user to click […]
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. Dataverse Views Within Dataverse we can create tables and for Tables we can create views, that […]
The new Power Automate designer is getting a lot of negative attention. There are however a quite a few improvements in new SharePoint Designer. The Do Until step is one of those improvements in the new UI. Do Until In the classic UI, I’ve seen many used the Do Until often in combination with variables […]
Recently Microsoft released the preferred solution feature in Power Apps and Power Automate. But how does the Preferred solution configuration work? Solutions Before we look at preferred solution it is important to understand what solutions are. Where in the past you might have gone to Apps, Flows or Tables in the Power apps or Power […]
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? New Power Automate Designer UI Recently I posted a poll trying to find out how many people actually use the new UI. With only 6% of people actually using […]
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! When a file is created or modified trigger The When a file is create or modified […]
In this post I’m looking at the modern Header control available Within Power Apps Modernizing your apps? How many apps have been developed within Power Apps over the last few years? How often do you review your older apps? Just have a look at the screen templates. Where in the past you might have had […]
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. Safe draft If we update our flow and then save a draft before […]
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. AI functions available in Power Apps The AI options available to use increase every day. AI Builder is just one of the options. Within Power Apps there […]
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. Copy and Paste in the new designer Even though Copy and Paste has been around in the classic editor forever as a preview feature. It does hep a lot […]
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? Retrieve the available storage using PowerShell The PowerShell script to get the storage is actually really simple: This will return […]
Within Power Apps there are various ways to document your app. In this post I’m looking at comments in Power Apps Options to documenting your code in Power Apps As part of my day job at Vantage 365 I do a lot of health checks of apps and flows. This often means that I’m looking […]
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. PnP PowerShell Whatever you want to do to SharePoint, PnP PowerShell is often the quick way of doing things. Especially if you want to undertake the same thing. One of […]
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. Lookups in SharePoint So I created a lookup column and then in the SharePoint Details form. This would look like this: Not too […]