Today I was asked how to implement a booking availability solution in Power Apps. The booking availability app So I’m looking to create an app that will ask the user for some booking details, a start date and an end date for the booking period. Once you user has supplied those details we need to know if the slot is available or not. You could sue this for calendar management in for example a room booking solution. I’ve created an app in Power Apps that looks like this: On the right I’m listing all the existing bookings and on the right I’m asking for the details and checking for the availabi ..read more

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! Creating Content Types You might have noticed that when you try to update content types or add new content types that the look and feel of the pages have changed a bit. The new SharePoint content type gallery is a whole new look to an existing methodology to manage your content types in SharePoint Online. The warning at the top points towards an article that explains s ..read more

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. Banner image So I created a Power App and added an image control that shows my banner. If I was to add this to a sharePoint page then I would end up with a lot of unused space on my page. So how do we resize the app so that we don’t have the white space appear. One important factor here is that my image control is only 100px high! Resize the app Reszing the app is easy, although… After selecting Custom as a size, I ..read more

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. ApplySiteDesign This is going to be a quick post. But hopefully this will help someone else spend too much time on this issue. Normally the ApplySiteDesign endpoint will apply a site design to a SharePoint site however I found that when you have larger site scripts assigned to your site design then this might just silently fail. The limit is 30 actions in your site script, so this must be quite an easy problem to find. So how do we make this work ..read more

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. Failed attempts I’m going to include my failed attempts first. In my situation I would like to take a file in SharePoint, get its content and then upload it to Azure Blob Storage. Attempt 1 – Get file content failure I configured a get file content action in my flow by selecting my site and then my file. When I run my flow I will find that I get the following error: The solution to this pr ..read more

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? SharePoint is not a database!? I often hear that SharePoint is not a database. Our friends from Oracle use the following definition of a database: A database is an organized collection of structured information, or data, typically stored electronically in a computer system. A database is usually controlled by a database management system (DBMS). Well SharePoint can be a collection of structure ..read more

Have you ever wondered how to organize your documents in a Microsoft Teams Channel just like views in SharePoint? Views in Microsoft Teams Recently I discovered Views in Microsoft Teams. … Read More ..read more

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. Background When you … Read More ..read more

Recently the Get changes for an item or file action was added to SharePoint. Here a full overview Get changes for an item or file action The Get Changes for … Read More ..read more

When you add dynamic content to actions you will get those unwanted apply to each actions added by Power Automate. Wanted Apply to Each How do you avoid these unwanted … Read More ..read more