Home| www.burgersandbytes.nl
Create your own word cloud in Power Apps| www.burgersandbytes.nl
End result The end result is an envelop icon in which a counter displays the number of messages for the current logged in contact. Datamodel Simplified view of the datamodel, just to support the understanding of the technical setup. Content snippet To accomplish this, start by creating an HTML content snippet. This snippet will serve as the foundation for counting the number of messages and displaying the envelop icon. In this scenario the name of the snippet is: Message Counter.| Burgers & Bytes
It took me hours to figure this out, so here’s to saving you time! After spending hours trying to figure this out, I figured it’s time to write it down. Hopefully, this post will save you some time and frustration, so you don’t have to go through the same process I did! Designing an Adaptive Card Designing an Adaptive Card using the Adaptive Cards Designer is surprisingly easy. You can create interactive cards with just a few clicks!| Burgers & Bytes
Powerful progress tracking; a flexible progress bar| www.burgersandbytes.nl
Until now, I have avoided writing about the topic of ‘AI’. This was a conscious choice, since I feel that everyone is already writing about this and you almost get ‘AI tired’ by now. Nevertheless, in a short period of time I came across a number of things that inspired me to write down my thoughts on the subject. Think of it as a diary text, nice to read back years later (or in this AI era, after a few months) and then look: ‘wow, that was still old-fashioned, they should have known...| Blog on Burgers & Bytes
How to create the possibility for users to create there own personal view for gallery in Power Apps| www.burgersandbytes.nl
Update OneNote section displayname based on a renamed Microsoft Teams Channel| www.burgersandbytes.nl
Scenario When a new Team is created, a OneNote is automatically generated, and each new channel receives its own section in OneNote, named after the channel. However, if the channel name is changed, the corresponding OneNote section name does not update automatically. This blog explains how to use PowerShell to programmatically synchronize the channel name with the associated OneNote section name. Example The Team contains several channels: Every channel has its own Notes tab with an associat...| Burgers & Bytes
A visually appealing presentation helps in swiftly and clearly grasping information at a glance. Users can capture a lot of information in SharePoint, where you can stick to just capturing it, but by taking a moment to consider the possibilities of view, row and column formatting, users can realize significant benefits. One common data element frequently recorded in a column is the “status”. By using the standard column formatting nowadays you can easily assign a different color to each s...| Burgers & Bytes
Side note: As of writing this blog, Dataverse low-code plugins are still in preview. In the Dataverse Accelerator app, you have the opportunity to create plugins. This blog focuses on the possibilities of automated plugins. After selecting a table, you can choose different types of triggers: when a row is created, updated, or deleted. To get information about existing records, you can’t use ThisItem or ThisRecord, and Set behaves differently compared to Power Apps Canvas.| Burgers & Bytes
Side note: while writing this blog Dataverse low-code plugins are still in preview. Scenario This blog explores a real-world business scenario involving multiple meeting rooms where CO₂ levels are monitored throughout the day. These measurements indicate the presence of people in the rooms. By correlating this data with the meeting room reservations, we can infer the room occupancy. End result The end result is a Power App in which a calender view is available in which you can see whether a...| Burgers & Bytes
Scenario This blogs scenario is regarding a plain multi line text input in which no rich text was allowed. Requirement was just one exception to have the ability to have clickable hyperlinks. In the Dataverse table no html is stored only plain text, so using a markdown syntax notation was the solution. Markdown syntax for a hyperlink is square brackets followed by parentheses. The square brackets hold the text, the parentheses hold the link.| Burgers & Bytes
Dynamics Forms Inspired by Matthey Devaney , a fully dynamic form was created in Power Apps, incorporating various question types like toggles, text inputs, and comboboxes. Everything worked smoothly until the need for tabular questions came along. For these tabular questions, the requirement was to allow flexible setup of the question and definition of table headers, enabling end users to enter their answers in the rows below. This challenge is now ready to be addressed 💪🏻.| Burgers & Bytes
A lot of business processes are supported by data stored in Excel sheets. Working with Power Apps often eliminates the use of an Excel sheet, but in some cases the data needs to be stored into an Excel sheet. In this blog the concept of transposing the data from an Excel table will be described, so you can use this data throughout the app. Scenario As an input there is an Excel table in which there are multiple rows and multiple columns.| Burgers & Bytes
Scenario In a Dataverse table you have a date column of which you want to extract the Year, Month, Day or Weekday using a Formula column. While doing this the following error appears: “cannot be performed on this input without a time zone conversion, which is not supported in formula columns.” Solution Go to the created Date column and check the ‘Time zone adjustment’. It’s probably set to ‘User local’. Switch the Time zone adjustment (Advanced options) to ‘Time zone independe...| Burgers & Bytes
In Excel we are quite familiar with a the functionality to freeze a row and a column. In Power App Canvas this can be more challenging. In this blog serie of two blogs a solution for Power Apps will be explained. The first blog the setup to create a header and nested galleries are explained This (second) blog shows how to create a dynamic horizontal scrolling header. Set up See blog part 1 to have the setup in which the basic of the three galleries are created.| Burgers & Bytes
In Excel we are quite familiar with a the functionality to freeze a row and a column. In Power App Canvas this can be more challenging. In this blog serie of two blogs a solution for Power Apps will be explained. This blog: the setup to create a header and nested galleries The second blog shows how to create a dynamic horizontal scrolling header. Context The academic course catalog offers a timeline that illustrates the availability of courses across multiple years, with the main section disp...| Burgers & Bytes
In today’s rapidly evolving digital landscape, organizations often find themselves relying on outdated Excel-based processes, which pose significant risks. However, with the emergence of the Power Platform, a revolutionary low-code development platform, there is a transformative solution at hand. This blog explores the potential of the Power Platform in streamlining operations, mitigating risks, and empowering employees to become citizen developers. Source https://dilbert.com/strip/2007-08-...| Burgers & Bytes
Scenario In the following scenario there is reservation system of different type of housing. For all housings there is an apartment type registered, which are stored in a different table. In the overview of the reservation you want to be able to filter on apartment type and related capacity. This blog describes how to filter a gallery based on values from related entities. Database model To get a proper insight of the data structure, the database architecture looks like this:| Burgers & Bytes
In this blog a budget allocation formula is introduced to deal with amounts of data of different time periods. Budgets could be daily, monthly or quarterly while registering it once. This creates a mismatch while creating a report. The budget allocation calculation discussed in this blog allows you to solve this mismatch and it also enables you to easily switch between different time contexts. End result The final outcome comprises a form where users can input details and perform calculations...| Burgers & Bytes
Scenario This blog describes the Flow to create a Team and start with a message of type Announcement. The default ‘Post a message in a chat or channel’ isn’t sufficient, because the message type can’t be selected, so it can’t be an Announcement. The end result should be a clear message in a Teams channel: Flow actions to create Team In order to share the full story the Team needs to be created and Team ID and Channel ID needs to be stored in a variable.| Burgers & Bytes
Working with a Rich Text column can be tricky. In a Model Driven App, handling Rich Text columns is easy. In a view the text is shown as plain text; simple and readable. In the Power Pages list view, it’s not great. It ends up showing messy raw HTML instead of the neat content. The view of the list in Model Driven App: The description column is a rich text column in which formatting is applied.| Burgers & Bytes
A progress bar visually communicates the completion status of a process. In a Model Driven App there is the Business Process Flow, in Power Pages there is no default component to visualize this. It is crucial for the progress bar to be flexibility and use the data stored in Dataverse and ensuring readiness for the addition of any extra status in the process without constraints. Challenge accepted 💪! Scenario In this scenario, an application Power Pages site is designed for individual conta...| Burgers & Bytes
Special thanks to Kevin Hendricks and Jan-Frederik Kobus for their support in implementing this scenario. Scenario The scenario of the blog is related to the email entity of a Model Driven app. The goal is to use a shared mailbox to send emails from instead of the personal address of the current user. The case is to automatically change the From address and be able to have a flexible setup for different queue ids.| Burgers & Bytes
The capabilities of SharePoint regarding column and view formatting can enhance the usability of both SharePoint libraries and list. In this blog the explanation using a lookup column and the challenging part regarding the use of special characters. Scenario The SharePoint list has a lookup column to a document library, so a link between the list item and associated document can be made. At first glance, this looked fine: However when you clicked on the file link, the file didn’t open, but ...| Burgers & Bytes
Measuring user engagement is crucial for any SharePoint-based intranet to ensure that the platform is meeting its intended purpose and delivering value to the users. You can already benefit from Viva Connections and Viva Insights to enhance the user engagement measurement capabilities. In the first part of this blog serie , you could read how to use the Power Platform to measure user engagement even more deeply using KPI regarding user engagement.| Burgers & Bytes
Measuring user engagement is crucial for any SharePoint-based intranet to ensure that the platform is meeting its intended purpose and delivering value to the users. You can already benefit from Viva Connections and Viva Insights to enhance the user engagement measurement capabilities. In the first part of this blog serie , you could read how to use the Power Platform to measure user engagement even more deeply using KPI’s regarding user engagement.| Burgers & Bytes
Measuring user engagement is crucial for any SharePoint-based intranet to ensure that the platform is meeting its intended purpose and delivering value to the users. You can already benefit from Viva Connections and Viva Insights to enhance the user engagement measurement capabilities. In the first part of this blog serie, we will explore how to use the Power Platform to measure user engagement even more deeply using KPI’s regarding user engagement.| Burgers & Bytes
This blog is part of the blog series for Microsoft Forms automation to create automatic update of you question of the week on your SharePoint intranet. The first blog explains how to create a custom connector using the undocumented Microsoft Forms API . The second blog describes how to keep your ‘Question of the week’ based on Microsoft Forms up-to-date . The result of the first two parts of this blog series is a nice looking SharePoint list which contains all data from the Question of th...| Burgers & Bytes
Creating a social intranet that fosters collaboration and engagement among employees is essential in today’s digital workplace. One effective component of a social intranet is a “question of the week” or poll functionality. While SharePoint doesn’t have a built-in poll feature, you can use a Microsoft Form with one question to achieve the same effect. However, updating the question weekly can be a manual and time-consuming task. Unfortunately, Microsoft doesn’t provide a standard AP...| Burgers & Bytes
Creating a social intranet that fosters collaboration and engagement among employees is essential in today’s digital workplace. One effective component of a social intranet is a “question of the week” or poll functionality. While SharePoint doesn’t have a built-in poll feature, you can use a Microsoft Form with one question to achieve the same effect. However, updating the question weekly can be a manual and time-consuming task. Unfortunately, Microsoft doesn’t provide a standard AP...| Burgers & Bytes
Situation In the Netherlands, the energy label of houses is indicated by a letter and a corresponding color. Today, we have 11 different labels, ranging from A++++ to G . This label is usually indicated by a pentagonal arrow, containing the letter and corresponding color. An example: Source: https://www.homekeur.nl/energielabel-woning-uitleg/ Scenario In a Canvas Power App, the letter could be selected in the dropdown and icon and its corresponding label should be displayed based on the selec...| Burgers & Bytes
Every question type has is own setup of the body content. Body content The payload of the different question types all have the same parameters: questionInfo type title id order isQuiz required { "questionInfo": "", "type": "", "title": "Question", "id": "", "order": 4000500, "isQuiz": false, "required": false } Parameter type Question Type Choice Question.Choice Text Question.TextField Rating Question.Rating Date Question.DateTime Ranking Question.Ranking Likert Question.Matrix Upload File Q...| Burgers & Bytes
The Challenge There is a lot of information available on how to retrieve all sites related to a SharePoint hub using Powershell. Another option is to use Microsoft Graph and search for all sites. https://graph.microsoft.com/v1.0/sites?search= * The challenge was to get all the sites of a hub in Power Automate without using premium actions like the HTTP request. This blog describes how to achieve this! Needed HTTP requests Initialized a variable to store the URL of the hubsite.| Burgers & Bytes
Scenario Todays scenario is regarding filter options based on Month and Year values in Power Apps. In a Dataverse table named ‘Products’ the information of a Name, Month and Year are stored. The challenging part is the Month column only contains the text value of the short form of the month. The data in the table looks like: Now it needs to be possible to filter the gallery based on a Month Year range filter.| Burgers & Bytes
The Approval functionality is really powerful! A lot of situation requires a response like an approval. The approval action in Power Automate does have some parameters which you can enter data in. Next to required details like the ‘Approval type’, ‘Title’ and ‘Assigned to’, you can enter Details. For Details you can use markdown to design the setup. The challenge In this blog the challenge that’s got resolved is that the approval request contains a table which as multiple rows, ...| Burgers & Bytes
Below a list of my recent and upcoming events: 2024-12-05 - ESPC24 Stockholm - Validation of Naming Conventions in Power Apps (together with Albert-Jan Schot) A session regarding automation of naming convention validation for Canvas Power Apps with PowerShell & Power Platform CLI, enhancing collaboration & error prevention in Azure DevOps pipelines. 2024-10-19 - CollabDays Belgium - Building a dynamic data review system using Power Platform capabilities An inspiring session in which attendees...| Burgers & Bytes
My report from the European Collaboration Summit 2023 It had been in my calendar since last October, on 22 May it was finally there: the European Collaboration Summit! In this blog, I am happy to share my personal top 3. Plenty to choose from, so in addition to a nice top 3, I also added an unmissable encore. Within Power Platform projects, it is necessary to think carefully about the architecture.| Burgers & Bytes
My name is Elianne and I am a Power Platform Consultant at Blis Digital in Barendrecht, The Netherlands. Since 2016 I obtained several Microsoft certifications: full transcript can be found on my Microsoft Learn profile. I love to gain more knowledge and expertise by going to different user groups and conferences myself, but I also like to share knowledge in different ways: by writing blogs, giving presentations, guest lectures at an university of applied science and app-in-a-day workshops.| www.burgersandbytes.nl
A Powershell script to validate naming conventions of controls in Power Apps canvas| www.burgersandbytes.nl