How to send SharePoint News post via email
Do you want to send an email with SharePoint news content? Now it’s possible via the new SharePoint News for Email feature. The content is scaled to fit different mail clients and works for mobiles. Let’s go and check what’s inside the feature and how you can use it. Introduction Microsoft released a new feature […] Continue Reading Marcin Siewnicki’s Article on their blog How to send SharePoint News post via email Do you...
Call authenticated external APIs using JavaScript from Power Pages
If you need to call external APIs using JavaScript from Power Pages, you may want to secure the calls to avoid exposing information or application hacking, as all the calls are made from client side. Power Pages sites can have OAuth 2.0 implicit grant flow enabled, so you can obtain an authentication token that has your Portal as the issuer, and you can use this token to do authenticated calls to external APIs. This post is a quick...
SMB Workshop Business Premium Webinar: Stripe OLT X Microsoft – YouTube
SMB Workshop Business Premium Webinar: Stripe OLT X Microsoft In a world where IT Leaders need to manage rapid technology changes, user expectations, security concerns, BYOD policies, software licensing and budget constraints (to name a few), it’s become imperative that businesses are empowered with software that will support all of their requirements. We introduce, the Business Premium License…. This jam-packed session is...
Using SharePoint list formatting and Power Automate to create linked items (via LookUp field) in a related list
Recently I was asked by a community member how to create a linked issue item (via LookUp field) using SharePoint list formatting. Via pure list formatting, it’s not possible to implement such functionality. But we can use List Formatting to create a button that triggers a Power Automate flow and this flow creates a linked issue as below: Check out how to implement this functionality in this post. Create an Issues list Create a...
Quick guide to Viva Pulse
Microsoft released Viva Pulse a few weeks ago as a public preview and now it’s globally available. It’s a tool to send targeted surveys to users and gather feedback. I played with it for a while and in this post, I will show you how to use it and get data from users. Introduction Microsoft […] Continue Reading Marcin Siewnicki’s Article on their blog Quick guide to Viva Pulse Microsoft released Viva Pulse a few weeks ago...
New office vibes 👀✨ – YouTube
New office vibes 👀✨ Come take a trip with us to our new Spinningfields office, located right in the heart of Manchester. Safe to say we already feel very at home here… #manchesterbusiness #manchesterit #newofficevibes Come take a trip with us to our new Spinningfields office, located right in the heart of Manchester. Safe to say we already feel very at home here… #manchesterbusiness #manchesterit #newofficevibes...
Using the HTTP with Azure AD connector in Power Automate to create Planner Plans and add them as Teams tabs
Some people have reported to me that the beloved Send an HTTP request (V1) under Office 365 groups that we used to easily call Microsoft Graph is not available anymore when creating new flows. It turns out it has recently been deprecated, as stated by Microsoft, and we are recommended to use V2 instead: Unfortunately, the V2 action only supports the /groups endpoint and will not allow us to create planner plans. The alternative At the...
Welsh Azure User Group August 2023 Meet Up!
It was the day of our Welsh Azure User Group #WAUG August 2023 meet up and we had yet another two amazing speakers join us. First up we had Johnny Hooyberghs on to discuss Azure Quantum and Q#, then we were joined by Leo Visser to talk Running PowerShell with Azure Deployment Scripts. Huge thank … Continue reading Welsh Azure User Group August 2023 Meet Up! Continue Reading jonnychipz’s Article on their blog Welsh...
Create an Issue Tracker App using Power Apps Copilot (Preview)
Recently I tried out the Power Apps Copilot, which is still in Preview but even though not yet perfect, had actually quite interesting results. I used it to create a basic Issue Tracker app. Here are my first impressions on this post. How can I use Copilot? Currently Copilot is available only for Power Platform environments hosted in the United States. You can try it out even with a Developer environment. Just make sure that when you...
How to monitor SharePoint sites with Microsoft Clarity
Want to monitor your SharePoint site and get advanced data, session recordings, and even heatmaps? Microsoft Clarity is for you. It’s not a new tool but with native support for SharePoint sites, it’s worth a try. Let’s go and check how to configure it and start working with it. Introduction You’ve just created and deployed […] Continue Reading Marcin Siewnicki’s Article on their blog How to monitor SharePoint sites with...
Issue solved: Canvas Apps PDF function – ‘PDF Creation Failed’ when using a gallery and checking conditions before calling the PDF function
Recently a reader reported an issue happening while using the PDF export functionality in Canvas Apps: I have an application with 2 galleries. The first one is populated with items that are users from a group, and the other is a collection that is populated with users from first table. Items with users from first gallery are “moved” to a collection and then, displayed to the secondary gallery. Like in your example, I put a button that...
How to use DocuSign Approvals in Teams
Electronic signatures play a major role in most formal processes. A big process, an agreement signing, NDA documents… it’s everywhere. Teams has a dedicated feature for e-signs and it’s definitely worth checking. Although it’s limited to 2 providers it’s still a great enhancement in many cases. If you use electronic signatures using DocuSign this post […] Continue Reading Marcin Siewnicki’s Article on their blog How to use...
Microsoft Inspire 2023⚡ #microsoft #microsoftupdates #microsoftinspire – YouTube
Microsoft Inspire 2023⚡ #microsoft #microsoftupdates #microsoftinspire Have you caught up with all of the exciting developments announced at Microsoft Inspire 2023? ⚡ For those of you that have yet to find out the fantastic new updates (and those who need a little refresher) UK Sales Manager Matilda is here to give you a quick round up of her favourite announcements 📣 To find out all about Microsoft’s updates from Inspire 2023,...
Filtering Dataverse data by the current user in Cards for Power Apps
While playing around cards for Power Apps, I noted that the User Power Fx function that is used in Canvas Apps to detect the current user and get some information about it is not supported. After some investigation, I found that Cards use a new object called Viewer instead. How to use the Viewer Object The viewer object has 3 properties that potentially we could use to filter data by the Current User : name: it’s the user...
Speaking at ExpertsLive Australia
For a long time, I always thought I wasn't the person to speak at an event or a meetup or whatever. But recently, especially from our Youtube show, the WorkplaceDudes, and my experiences as a Microsoft Certified Trainer, it started to itch a bit. So, I took the plunge, created a Sessionize profile and devised sessions. And then… looking for a event, or a meetup, and then submitting one of my… Continue Reading Jeroen...
Colored Folders – How to use via Power Automate
Microsoft released a new feature called Colored Folders. It’s available both in OneDrive and SharePoint Online. You can use it to apply color to a special folder to categorize manually data based on the content inside. You can also use Power Automate and automate the whole process. In this post, I will show you basic […] Continue Reading Marcin Siewnicki’s Article on their blog Colored Folders – How to use via Power...
Colored Folders – How to apply a color using Power Automate
Microsoft released a new feature called Colored Folders. It’s available both in OneDrive and SharePoint Online. You can use it to apply color to a special folder to categorize manually data based on the content inside. You can also use Power Automate and automate the whole process. In this post, I will show you basic […] Continue Reading Marcin Siewnicki’s Article on their blog Colored Folders – How to apply a color...
Sort an object array by numeric values that are stored as string using Power Automate
Recently I got a question in a previous post about the sort expression in Power Automate: I am attempting to use this expression in a compose box to sort by a numeric ascending value, but it is sorting that value as if it were a word and not a number. How would I amend this expression to sort the array by a number value that is apparently stored as a text string? Let’s have a look at the issue. If we have an array of objects as...
Opening the New form from another list using SharePoint list formatting
If you want to open the new form in another list using SharePoint Lists JSON formatting, it is pretty straightforward. All you need to do is to use the href property in a link object inside of your custom HTML generated by list formatting, and point it to the relative path of the new item form of the list you want to open, for example: /sites/<your site>/Lists/<your list>/NewForm.aspx Imagine you have an issues list in...
Using Power Automate to send cards built with Cards for Power Apps in Teams
If you want to send fancier notifications to Teams and struggle with Adaptive Cards, you can now use (in preview) Cards for Power Apps to generate your cards and send them in Teams chats. Cards for Power Apps provides a straightforward experience to create Adaptive Cards that can easily be used on Teams chats. In this post, we’ll see an example of how you can send use Power Automate to send a Power Apps card in Teams based on...
Recap of the Microsoft Inspire 2023 Conference
Microsoft Inspire 2023 is over and we got many interesting news and announcements. AI was the number one topic (as expected), but it doesn’t mean that others were less important or boring. Let’s go for a quick walk through the most important announcements. Copilot pricing News number 1 – how much money do you need […] Continue Reading Marcin Siewnicki’s Article on their blog Recap of the Microsoft Inspire 2023 Conference...
So, what is the difference between SIEM and SOAR?⚡ – YouTube
So, what is the difference between SIEM and SOAR?⚡ We sat down with Matilda, our UK Sales Manager, to breakdown where these technologies differ and how they enable our SOC team to focus on the alerts that matter… 👨💻 Something else you want to know more about? Just drop your requests in the comments below and we’ll get Matilda to give you a de-brief 👇 #SIEM #SOAR #SOC #cybersecurity We sat down with Matilda, our UK Sales...
Welsh Azure User Group July 2023 Meet Up!
It was the day of our Welsh Azure User Group #WAUG July 2023 meet up and we had yet another two amazing speakers join us with Darren McDonagh on from Nutanix to talk all about Nutanix on Azure with NC”, then the incredible Dean Ellerby joined us to discuss how to not let our Smart … Continue reading Welsh Azure User Group July 2023 Meet Up! Continue Reading jonnychipz’s Article on their blog Welsh Azure User...
My top Power Platform 2023 release wave 2 plan features
The Power Platform 2023 release wave 2 plan was recently released, and as always we get to know what are the upcoming features and updates to the platform. Check out some of the announcements that were my favourites in this post. Use Copilot to build and edit apps in the Power Apps studio New Enhanced copilot capabilities to help build apps with natural language input and run tasks like adding screens, controls, and modifying...
Matilda’s advice for getting a promotion ⚡ – YouTube
Matilda’s advice for getting a promotion ⚡ Matilda, our UK Sales Manager, shares her story on how she earned her previous promotion to Business Development Team Leader, and the key advice she would give to anyone looking to level up in their career ⚡ 🚀 If you don’t ask, you don’t get 🚀 Build a strong case for yourself 🚀 Know your worth Matilda, our UK Sales Manager, shares her story on how she earned her previous promotion to...
LookUp column with a custom icon using SharePoint list formatting
I recently got question from a follower on LinkedIn, which I thoght that the answer can be useful for more people: I am struggling with formatting a SharePoint list lookup column. I want to make it show an icon but when I click it, it should open the lookup column value on that other list (normal lookup hyperlink behavior). I have achieved this before with text fields but never with Lookups. Any help would be appreciated! How to use...
Implement booking availability in Power Apps in less than 5 minutes
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...
Delegation with SharePoint lists Power Apps vs Power Automate
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? Delegation with SharePoint lists warnings in Power Apps In Power Apps there are quite a few delegation warnings that you can get. And when we hover over that blue line we will see that the Not function isn’t delegable within Power Apps. Looking at the SharePoint...
Timing issues in relation to App OnStart, Screen OnVisible, Timers and user interruptions in Power Apps
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. Running code When you create an app there are various places where you can insert code to read data or write data. We can add code in the following places: App OnStart Screen OnVisible Timer ( On Start and On End) User...
We asked Matilda what the biggest challenge of being a leader is – YouTube
We asked Matilda what the biggest challenge of being a leader is Being a leader is one of the most rewarding responsibilities you can have, but it comes with some hefty challenges. In this episode of Sofa Sessions, Matilda discusses the nuances associated with leading a team and following best practice. Being a leader is one of the most rewarding responsibilities you can have, but it comes with some hefty challenges. In this episode...
Implement a 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. The PDF Preview in a Model Driven Apps options Well, I considered the following options: Out of the box previewer Existing custom controls for my Model Driven App Develop a new custom PCF control Embedded Canvas app I looked at the existing controls but there doesn’t seem to be a file preview option available....
Collaborative Notes in Teams – Overview
A new note-taking tool has just arrived in Teams meeting! Collaborative Notes are a brand-new tool that you can use for agenda, notes, tasks, and much more. It uses Microsoft Loop components and integrated both with Teams and other Microsoft 365 services. No more Wiki-based notes! Let’s check what’s inside. Notes in Teams Note-taking is […] Continue Reading Marcin Siewnicki’s Article on their blog Collaborative Notes in...
1st WorkplaceDudes Meetup was a success!
Last Tuesday, June 27, 2023, we held our first WorkplaceDudes Meetup at Campus Delta in Capelle a/d IJssel, near Rotterdam. After several weeks of preparation, arranging location, arranging sponsor and of course arranging the speakers, yesterday was the big day. Around 16:00 we were present. We started by converting the hall so that people could sit on chairs, but also in the stands. From… Continue Reading Jeroen...
Welsh Azure User Group June 2023 Meet Up!
It was the day of our Welsh Azure User Group #WAUG June 2023 meet up and we had yet another two amazing speakers join us with Kay Sauter joining us first to talk about Deploying SQL Server VM’s to Azure using PowerShell, then we had Harun Raseed Basheer on to help us Build our first … Continue reading Welsh Azure User Group June 2023 Meet Up! Continue Reading jonnychipz’s Article on their blog Welsh Azure User...
Performance of the Graph API, REST API and Web Services with SharePoint and Power Automate
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. Graph API, SharePoint REST API and Web Services Before I’m looking at the performance of the Graph API and the other APIs, I first want to have a look at each API. The naming here is already a bit confusing as the Graph API is also an API following the REST...
The BitLocker HAADJ Nightmare
Today a quick blog post about the problem with HAADJ devices and how to turn on BitLocker. Last month I was giving Intune training to 2 different end customers. During the first training, I was asked if I knew a solution to enable BitLocker on HAADJ devices by means of Intune. Because they ran into problems with the message that the recovery key cannot be backed up to (Azure) Active Directory…. Continue Reading Jeroen...
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. Enable the Chatbot component feature In the settings of your app all you have to do is enable the Chatbot component feature and you are up and running. Then of course don’t forget to save your app and restart the Power Apps studio and reopen you app. Adding the Chatbot to your app Now you can...
SharePoint Enterprise Content Types and the 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. Creating an Enterprise Content Type From the SharePoint admin center I have created an Enterprise Content Type as shown below: Then within my Content Type I’ve created an Enterprise Content Type Site Column as shown below. Both my content type...
Culture is king ? Do you agree? – YouTube
Culture is king ? Do you agree? Today Thomas Robbins explores why culture needs to be addressed by leaders in the modern workplace ? Matilda Harding’s opinion up next… #leadership #workplaceculture #sofasessions Today Thomas Robbins explores why culture needs to be addressed by leaders in the modern workplace ? Matilda Harding’s opinion up next… #leadership #workplaceculture #sofasessions...
Ever wondered what happens to your ticket once it’s raised with the helpdesk?? – YouTube
Ever wondered what happens to your ticket once it’s raised with the helpdesk?? We are proud of our ticket management system, led by a team of #ITIL practitioners with a wide range of expertise ⚡ Today, Nathan our Cloud Engineer takes us along the lifecycle of a ticket to give you a bit of an insight of BTS ? #helpdesksupport #ithelpdesk #itilcertified We are proud of our ticket management system, led by a team of #ITIL practitioners...
Intelligent meeting recap in Teams Premium – Quick overview
It’s there – AI notes for your Teams meeting! Microsoft released it a few weeks ago as a Preview feature and it’s available (but not globally). Intelligent meeting recap automatically generates a summary of your meeting with suggested notes. Is it good or is it bad? What’s still missing? Let’s go and test this brand-new […] Continue Reading Marcin Siewnicki’s Article on their blog Intelligent meeting recap in Teams Premium...
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? Reminders in Outlook 15 minutes before a meeting starts reminders will appear (unless you have disabled this) while you work on other things. This can really help you avoid missing meetings. Recently however I noticed that when I ignore reminders and don’t dismiss them that the...
Looking back at Experts Live NL
On Thursday 25 May 2023, it was time for the 11th edition of Experts Live NL. Again, in Congrescentrum 1931 in 's-Hertogenbosch. For me, this adventure started much earlier. Like the previous editions, I was again in the Program Panel this year. Under the leadership of Kenneth van Surksum and Erik Loef, they provide input and shape to the program of Experts Live NL. Then, on April 3, 2023, I… Continue Reading Jeroen...
Top 3 requests a helpdesk team should NEVER ask you – YouTube
Top 3 requests a helpdesk team should NEVER ask you Our 2nd-Line Cloud Engineer Nathan, sits down with Jennifer to go through some of the BASIC requests a helpdesk team should never ask! ? His top 3… ? We will never ask you to click a link via email ? We would never ask for your password ? MFA codes – we will never send a request for this information Want to know more about how your business can adopt a Zero-Trust approach? Find...
Don’t Update or Insert records in Dataverse but Upsert when using Power Automate
A typical pattern for data import processes is that you first check if an item exists before either inserting or updating the found item. Upsert (Update or Insert) the item in one operation is however better. Update or Insert So the base process could look something like this. We first get the flow to check if the item already exists and then when it doesn’t exist we can add the item. However there is a bit of time between those...
How to Migrate Teams Wikis to OneNote
The latest Teams update enabled Wiki migration to Microsoft OneNote. This feature is the next step in Wiki retiring process which should be finalized in the upcoming months. Right now, you can move all your existing Wiki content to OneNote using a built-in migration wizard. Wiki in Teams The Wiki tab was the main note […] Continue Reading Marcin Siewnicki’s Article on their blog How to Migrate Teams Wikis to OneNote The...
Welsh Azure User Group May 2023 Meet Up!
It was the day of our Welsh Azure User Group #WAUG May 2023 meet up and we had yet another two brilliant speakers join us with Ben Pearce from Elevated You helped us with our technical story telling in a superb presentation to help us all with hints and tips for helping us with our … Continue reading Welsh Azure User Group May 2023 Meet Up! Continue Reading jonnychipz’s Article on their blog Welsh Azure User Group May...
Size your Power Apps with Height and Width in SharePoint 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. 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...
Filter null values in Dataverse using Power Automate
Filtering records on empty values can be a real pain as there are many mistakes to make. Null 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. In Power Automate you can have an expression null. You can type the text null (this is just 4 characters, n,u,l,l) And then you can...
Top 8 features from Microsoft 365 Conference
During the Microsoft 365 Conference 2023 in Las Vegas, Microsoft announced many new features for SharePoint, OneDrive, Lists, and other M365 products. SharePoint stole the show with the huge list of upcoming features and changes. Here are my 8 favorite features announces during the conference. 1. Copilot in SharePoint AI is coming to SharePoint (it […] Continue Reading Marcin Siewnicki’s Article on their...