Since I am not a developer… especially not an X++ developer I am ususlly not entrusted with access to Visual Studio (this statement was more for dramatic effect but the truth is that I am trying to avoid it to not mess things up).
The main reason for this work around is that in some environments Visual Studio is not set up and to do that would require setting up the correct account, mapping workspaces and a whole lot more. This way is simpler:
Today when writing release notes for my customers latest release I bumped into an issue. I have a query that returns all item in the current Iteration Path with their release notes. The release notes are written in Microsoft Word so I thought that if I could just get the query into Excel it would be an easy “Copy and Past” operation into word.
Fortunately Azure DevOps have just this feature. You simply go to queries, click the three dots negt to the query and select Open in Excel
Last week Microsoft finally released the complete PDFs with new features of Dynamics 365 and PowerPlatform Wave 1 2020. I browsed through them (all 405 pages of them 🙂 ) to to try to understand where we are going… here are my top 10 12.
Mass deployment of the Warehouse App This gives an organization the ability to use Microsoft Intune (or your favorite MDM solution) to deploy the warehouse app to mobile devices.
The UI will start adapting to the license the user has assigned in order to make the UI “less complex”. This means that there is no longer a possibility to get by under licensed”.
The new grid now allows you to group rows based on a column and also to easily rearrange the columns.
Tables, Entities and Aggregate measurements can be stored in Data Lagke Storage Gen 2. Prior to this release we were only able to store Aggregate Measurements in Data Lakes.
The ability to embed a Power Automate Flow directly in the UI in Dynamics. This flow can be triggered by the end user. This feature is even cooler since it was suggested on the Dynamics Ideas site.
Azure AD sign-in in the POS client. This could previously only be done using a worker ID
The ability to create a PowerApp directly in Microsoft Teams.
Great improvements for running model-driven apps offline. Really cool since this is geared towards mobile front line workers.
Monitor and get insight into usage of your canvas apps using Azure Application Insights.
Power Apps Test Studio is available in General Availability. This gives you the possibility to automate testing and integrate it into Azure DevOps release and Build Pipelines
Simplified expressions in Power Automate. Instead of having to write a complex expression for a string operation there are ready-made blocks for this.
Copy and Paste in the Power Automate designer (Yay)
As you can see this selection of features are quite tech/IT heavy… There are a LOT more app related features in the Wave 2 release. Look through the PDFs linked below to get a grasp on these.
One thing to note is that this is Wave 1… Not everything in Wave 1 is general available or in some cases even in preview… but it is coming. Something to look forward to.
I work as a consultant and I often help different customers and since all of them insist on me using their Azure AD (and my employer has their own) I am often getting logged in with the wrong account… or rather I was.
My old solution to this issue was to use Incognito/InPrivate mode which means that all Single SignOn cookies are getting erased when you restart the browser. The problem is that if you have multiple browser windows in InPrivate mode then “leak” data. They are not isolated from each other.
The solution is to use Chrome/Edges profile feature to have different personas. Lets get started. I am doing this in Chromium based Edge but it works basically the same in Google Chrome.
In the upper right corner of your browser click your user profile icon.
Click Manage Profile Settings
In the top right corner click “Add Profile”
A couple of good things to know here: As I said each profile is separate which mean that you can add Chrome Adding separately to each one. If you are using Chrome you can even install different themes in each of them to make it more intuitive to find the correct window. If you, like me, use Chromium Edge each profile can be logged in with a different Microsoft/Azure AD account which means that if you set up the same account profile on a different computer it will sync settings between computers. If you use Chrome you can have different Google accounts.
Using this method means that you will never be logged in using the wrong account (as long as you are good at separating them).
Finally back for Flow Friday after some much needed rest over the holidays. This week is sort of a proof of concept. There are times when you need to just get a random value. This could be for a lottery or get a random name for the person that should take out the trash this week.
Create an Excel Sheet in OneDrive with a table containing all of the names you need to randomize
Go to Microsoft Power Automate and create a new flow
Since I want it to run automatically I set it on a schedule
Next we read the Excel file and figure out the number of rows
We then create a variable that is a random number between 0 and [number of rows in the table]
Then we get the name column form the row with the random number
Finally I sent the name in a notification
That is all… I will now get a notification with the name of the person that will take out the trash 🙂
I had an issue today with one of my testcases in RSAT. When running it manyally from the RSAT UI it worked but when trying to run it from a PowerShell script I got this error:
Failed to download or overwrite attachment files – Some files maybe in use.
For some reason the test case uploaded duplicate files to Azure DevOps. When I ran the test in RSAT it uses the local file generated from RSAT and everything worked but when I ran it from the console it downloaded the files from DevOps, got the duplicates and for some reason failed.
The solution was to permanently delete the test case from DevOps and resync it from BPM.
Beware that that will give it another ID which will change the order of the tests.
I am a developer… in the same was as I am a gamer and a harmonica player… I really, really really want to be one… I am not good at it, but I really want to be one. I have over the years tried my hand at Powershell, Yaml, BAT- files and even good old kix scripts and much lite an amateur golfer I try to tell my self that if I just have the right tool I will really get good at this… (I really want to believe that 🙂 )
When it comes to PowerShell I have been an avid user of PowerShell ISE but since Microsoft is not doing much of anything with ISE anymore and they are pushing VS Code more and more for everything I thought what the heck… This is my noob guide to getting started with VS Code (for someone that has only used ISE).
In this post I will show you how I set it up and I will probably follow up wit other posts on how I got started.
First you need to download and install VS Code itself:
I checked the options Add “Open with Code” action to Windows Explorer file context meny Add “Open with Code” action to Windows Explorer directory context meny Register Code as an editor for supported file types
Finish the install and Launch VS Code
When you start VS Code for the first time it will look like this. To get started with PowerShell there is at least one plugin you will need… PowerShell (unexpected right). This is used for providing snippets and high lighting code
4. Click the small cubes at the bottom of the toolbar on the left
5. Type PowerShell in the search bar, select it and press the small green install
The plugin even makes VS Code look a bit like ISE. I usually set it back to Dark (that is what coders do 🙂 )
That is it for today. I will continue with more tips and tricks for getting started with VS Code.
Most organizations today are using Azure AD and the absolute recommendation is to use 2FA in as many scenarios as possible… in some that is not possible… then there is an option to use an application password (this should be uses in special cases and you should never use it on an Admin Account). To create an App Password you do the following:
Log in to https://portal.office.com
In the upper right corner click your profile picture and select “My Account”
Go to “Security and Privacy” and click “Create and manage app passwords”
There used to be this app by default in Windows 10 called Connect… this was a brilliant app for all of us presenting things once in a while. The app enabled you to show your phone screen on your PC screen to be able to show it on a projector.
Today one of my colleagues asked me how to do this and I thought I would write a short decription… and low and behold… I could not find Connect!!
After some fiddeling I found that it is now an optional feature. To install it go to Settings and search for Projecton Settings. Click the “Optional Features” link.
Click Add a feature, search for wireless display, check it and click Install
Now the Connect app exists in the start menu, you can start it and connect to tour PC.