Blog - Recent Posts
Outlook - How to add, edit, delete, and list Outlook calendar events
By integrating apps with Outlook calendars, we can create far more powerful apps, particaularly in the case of scheduling applications. This post describes how to integrate with Outlook through the Office 365 Outlook Connector Including tasks that include adding, editing, deleting, and searching Outlook calendar events.
Apps - Migrating OnStart formula to use App.StartScreen/ Fixing existing apps that implement deep linking
A recent update to Power Apps now prohibits the use of Navigate in App.OnStart. Existing apps that call Navigate in App.OnStart will show the error 'Navigate is not permitted in OnStart. Use the StartScreen property instead.' How do we fix this problem? The post describes some of the possible solutions.
Calculations - What mistakes can happen when we fail to use round brackets correctly in calculations?
What can go wrong when we fail to use brackets correctly in mathematical calculations? This post provides an example.
Walkthrough - Solving maths puzzles with Power Apps
For learning purposes, it can be useful to see a practical example of how to carry out mathematical tasks with Power Apps. This post walks through a demonstration of how to answer a quiz question using Power FX functions that include ForAll, Sequence, and Mod.
Error - Unable to modify Dataverse tables with error message, Language id should not be null
Au unusal problem you may encounter is the inability to modify Dataverse tables. During any attempt to modify or to save a table, the designer shows the error 'Language ID should not be null'. Here's what to do if you experience this problem.
Formula - Transposing/converting rows to columns- an almost impossible task?
A common requirement is to transpose records in Power Apps - in other words, to convert rows to columns or columns to rows. This post discusses this topic and provides an example of how to carry out this task.
Charts - How to create donut charts
A common way to build donut charts is to create an SVG image that represents the chart. This post introduces this technique and describes the formula to set donut chart values.
Settings - The easiest way to find environment id and other settings
Up till now, it hasn't been easy to find the URLs and unique identfiers for environments, and other settings that are required to access Dataverse and Power Apps externally. The good news is that the Maker Portal now displays these key details in a 'developer resources' panel.
Admin - How to quarantine or block all users from running a specific app
There is now a preview feature that enables app builders to block all users from opening and running an app. This post describes how to use this feature.
Learning - Learn Power Apps through the free Microsoft Virtual Training Day events (and receive a free exam)
If you're looking to learn more about Power Apps and the Power Platform, Microsoft offers a set of free Virtual Training Day events. This post describes what's on offer and how to register.
Formula - How to round times to the nearest x minutes
When working with dates and times, a common requirement is to round times up or down to the nearest X minutes. This post describes the formula to carry out this task.
Formulas - Review of how to write formulas using natural language
During the Build conference in May 2021, Microsoft announced an innovative new feature - the ability to write formula using natural English words and sentences. This feature is now in preview, and this post takes an initial look at how this works.
Licensing - Microsoft 365 licensing price set to increase in March 2022
From March 2022, the price of Microsoft 365 licenses will increase. This post describes the upcoming changes.
SharePoint - Filtering lists by User() is now delegable
A common requirement is to filter SharePoint records by the email address of the current user. In the past, this task could be difficult because filtering lists by User().Email was not delegable. The good news is that Microsoft has now improved this behaviour and is post describes what's new.
Dates - How to get the start date from week number
When working with dates, there may be the requirement to derrive the start date of a week based on a week number. This post describes the formula to carry out this task.
Recent Posts
- Email - What to do when sending an email with the Mail connector returns a 401 error
- Power Up Course - How to Display Dataverse Multi-Choice Select Column Description Values in Power BI
- Dynamics 365 and Power Platform User Group Q1 2025 meetup
- Data - How to remove trailing comma all rows in a table
- Power Up Course - How to fix problem with loans not showing in the "Library check-in check-out screen"
- Model Driven App - How to fix can't sign in error whilst logged in
- Power Apps 2025 Release Wave 1- What are the upcoming features for Power App builders?
- Dataverse - How to set yes no values with checkbox- Walkthrough
- Dataverse - Add image column missing when creating table - how to fix
- Data - How to view the progress and status of a Dataverse CSV/Excel Import
- Dataverse - How to fix error - This operation cannot be performed on values of different Date Time Behaviors
- Dataverse - The cheapest way to license a Power Apps Canvas App 2025
- Dynamics 365 and Power Platform User Group Q4 2024 meetup
- Bug - What to do when setting a variable to Form.LastSubmit doesn't work
- Datetime - Preventing user manipulation of the current time - how to retrieve a server date time value
- Controls - How to set the date picker icon size - Workaround
- Low Code No Code Microsoft Power Platform Conference 2024
- Apps - The new easier way to open .msapp files 2024
Blog Author
|
Tim Leung Author, software developer, Power Platform specialist |