Dynamics 365 – Teams Configuration

The configuration of the client is pretty straight forward. A typical office product, and that is a good thing:) FYI, it does not install a solution file within Dynamics, and I like that a lot… Never been a fan of the overcrowding of solution files (Hint hint portals.. hehe).

Start på opening the system settings from Dynamics and locating the “Enable Dynamics and Teams integration”.

NB! Before starting, I would create a new Team and a new channel just for the sake of simplicity. Also create a new record in CRM that you want to connect to.

It took me about 3 minutes before I received my complete message, so be patient!

Open teams and locate the App Store within teams and search Dynamics. You will find it on the “…” menu on the left side.

Add to the team you created. In my case “Tilbud” and then click Open

Next step is connecting it to the channel in the team, and hit “Set up”.

Now it will ask you for an entity to connect to, so I am going to choose the Opportunity I created before I started the configuration “Teams Opportunity”.

If it all went well, you will now see a new tab in your channel with the name of the record. You also see a message that the record is connected.

The result

Dynamics and Teams working together

Dynamics 365 + SharePoint. Why is this still an problem?

Microsoft has used words like “seamlessly” integrated when speaking about Dynamics 365 and SharePoint, and I have hated it since day one. CRM and SharePoint never seemed to get it right, and after a while I feel they just gave up. The current state of the integration is in most cases utterly useless.

Larger companies

The larger companies will require scalability and security. The integration has none of these in combination. The standard integration has absolutely no idea what security is, and therefore opens all documents for everyone with site access. In larger organizations they might want to separate the BU’s or even more granular access like team access in CRM. This is where you have to use 3rd party tools like Connecting Software. The second you start adding security to folders, you will hit the cap of 50k something unique permissions in a DocLib.

Result: Fail

Smaller companies

The smaller companies have the highest requirements in regards to simplicity. They expect it to be easy to drag/drop files, navigate a simple folder structure, merge documents from CRM that end up in the SP folder etc. In general the smaller companies are always benchmarking the CRM system against smaller collaboration solutions, and therefore expect simple usage. Again the standard isn’t enough.

Result: Fail

Microsoft Teams, the new hope

So with the introduction of Teams + Dynamics integration, we might be somewhat closer to a solution for collaboration that could work. For the first time it makes sense to include others outside of Dynamics 365 to collaborate on the documents. A salesperson could now easily work together with others in the organization that don’t have the Dynamics license. I will show you how in a later blogpost.

Does this mean that we can use the word “seamless” in regards to integration? NOPE, but we are one step closer. My biggest concern is still that the product teams working on this seem to be forgetting to solve the simple features. When you merge a document out of Dynamics, it should be easy to put it back in to Dynamics (SP folder) where it belongs! We should need to have solutions like Documents Core Pack or Xperido for the simple templates.

Anyway. Stay tuned for the next blog when I show how cool the new integration with Teams is:)


CDS vs Dynamics Connector Power Platform

There are several discussions regarding the use of CDS connector VS the Dynamics connector in the Power Platform. Recently I have been updating my knowledge a lot on PowerApps, PowerBI and Flow. The odd thing is that these environments behave quite different even thought they are so closely connected in regards to connectors.

how much longer will they co exist, and why are they even different?

So here are my thoughts about the current state April 2019 (this might be outdated in one month 😂)

Flow CDS vs Dynamics 1 – 0

https://crmtipoftheday.com/1177/use-the-cds-connector-when-you-go-with-the-flow/
When using Flow, the CDS connector seems to be the correct choice. I personally feel that the action advanced settings is the most important reason why the CDS would be the correct choice.

CDS connector will only run the flow if country is changed saving you the flow, and the Dynamics connector will run no mater what costing you 1 flow.

PowerBI CDS vs Dynamics 2 – 0


https://www.inogic.com/blog/2018/10/connect-to-the-power-bi-using-common-data-service-cds/
There are maybe many reasons why you would choose the CDS connector over the Dynamics connector for API reasons, but the most important one I like to focus on is the Option Set (Pick List) from Dynamics.

Look at the Yellow columns. They show the display name of the Options Set, so no more need for hacks to convert the fetch from numbers to names. Obviously a huge benefit that this solution will update when the Option Set values update also!

PowerApps CDS vs Dynamics 2 – 1

But wait… It might not be over yet. While tampering with lookup controls for PowerApps I found out that CDS simply doesn’t have the lookup fields in the data!

CDS connector (Simply doesn’t have any lookups):

Dynamics Connector (With lookups):

Data presented is still in a GUID state, but there is a workaround for that:)

https://www.inogic.com/blog/2018/07/working-on-lookup-field-of-dynamics-365-in-powerapps/ <– How to fix GUID in PowerApps

The art of creating relevant demo data

If it is one thing I have learned throughout the years, it has been to produce relevant demo data. Whatever you do, NEVER use data with the name “test”. The second a potential customer doesn’t relate to your presentation, they will loose focus.

Try to understand your customer before demo, and ask them to give some names of companies and products they sell. In the beginning your demo might only bee within a group of people that actually want your product, but eventually you might have to present to the people who hate change. It takes a little more time, but can be worth it in the long run.

A sample list you could as for in regards to sales demo could be:
1. List of 2-3 sales people
2. Short list of customers
3. Customers contacts (names only)
4. List of typical products/services they sell
5. A sample report of sales activity – Only if you have the time

It might sound stupid, but you have to remember that you are the person about to introduce change to the organization. Not many people are happy about change, and therefore you need to pay attention to the small details to keep their interrest.

1-4 are fair pieces of data that you easily can enter. Nr 5 is something I would do only if you had the time. A sales report might reveal a lot of fields/categories/processes they currently use. This can have a lot of value to include in your Oppty, but it might also take to much time to configure.

This blog is a part of a series of “Demo Sales – Simple Sales“, so I will only show simple examples. The demo I will be showing is based on sample data from MS.

Day 3 Amsterdam 2019

Ryan Maclean – Workflow Booster Packs

Ryan is from Scotland, and I couldn’t stop thinking about Breavheart while he was presenting early Friday morning..

Jokes aside, Ryan delivered a great session in the world of a functional consultant. One problem we always have is that we want to solve plugin related issues, but we can’t code. That is why we have these WF tools that give us plugin like features. He is one of the first consultants I have meet that also loves the North52 tool.. hehe.

Ryan showcased workflows from 6 different solutions. I think we all agreed after the session that we would gladly pay a lump sum to gather all of these awesome people in one room, and make one single tool 😉 Thnx to Ryan, and all of the people behind the free tools!!! Remember to donate if you use the tools.

Marco Amoedo, Wael Hamze – Dynamics 365 Quiz!

Dynamics 365 quiz, and time to shine. Time to show the world that I am the most awesome person within CRM!!

Well, it didn’t quite end like I expected. I was not even in the top 10 list.. haha. The level of knowledge out there is really high, and it makes me want to learn even more for the next time around. I am what you call a sore looser.

Resco – Doctors Without Borders case

Microsoft Norway challenged us to deliver a Pro Bono case to Doctors Without Borders (MSF). They do so much more than just send doctors to countries in crisis. One very important thing they do is survey companies around the world to find out what the standard incomes are pr country pr role. It is very important for companies like MSF not to overpay when they enter countries. By creating inflation, or overpaying doctors, you can end up stealing doctors from the local hospitals.

The combination of Resco + CDS + Power BI was a great fit here for storing and presenting data live. The event in Amsterdam gave us a great chance to work on the app with Resco to improve the look and feel.

When we are done with the case I will write about it in a blog article explaining why I chose the tech that I did etc.

Scott Durow – Power Platform Demystified

I think we all have more questions as things will change over the next months 🙂

Another Scott session packed with people. This session was about the Dynamics platform moving to the Power Plattform in a sense, and what it means in regards to function and licensing at the moment. I am not saying Dynamics is going away, but it is not NOT going away.. hehe.. It will be interesting to follow that the next year.

In the future we will be thinking more about apps than ever before, and that is actually a good thing. Apps will rule the plattform, and it might even make the integrations even better. The more we isolate the functions, the more “product” some of them can be. The more product they are the easier it is to standardize how to work with them.

Just look at our competitors. They are all products, and customers seem to understand that better than plattform stories. Let’s start with the product and then surprise them with the platform #easteregg 😉

Sarah Critchley – Panel discussion

Panel discussion led by Sarah was about AI, Dynamics and PowerPlatform. In the panel we had a good mixture of knowledge. Representation of knowledge here was quite interesting. The talks were about data consumption and data gathering. All sides open about what challenges they were experiencing with data quality in large organizations, and how mindsets of the employers were important to lead in the right direction.

The short story is that our implementations should be focused around actionable insights. As long as the end users se/understand the result of good data, they would feel more ownership to the data entry.

Day 2 Amsterdam 2019

Malin Martnes – How Talent digitizes HR

So I shouldn’t really write anything here because I am far to bias… hehe. Malin did a great job presenting a new product from Microsoft called Talent. Talent itself originates from Dynamics AX, but has been refurbished and made a lot better.

The main pieces here are Attract, Onboard and Core HR. each plays vital roles in onboarding new talents, and equally important, maintaining the ones you have. We all know how costly it is to lose a good employee, so why not put a little more effort into keeping the ones we have, and help them develop careers with set goals etc.

Malin has her own blog where you can read more about the product. Her idea is to create all content needed for you to pass the exam for Talent. Much like Neil Parkhurst.

I am just way proud of her as you probably understand 😉

Gus Gonzalez – Top 10 Free Tools for Functional Consultants

For those of you who don’t know Gus, get to know Gus. He works with podcasting, blogging and YouTube channel. He speaks to the technical level of Dynamics that I understand well, and therefore he is awesome;)

This session was about XrmToolBox

“If you are not using XrmToolBox, you are working to hard”.

Gus Gonzalez

I have seen Gus before during Microsoft Inspire and he had the same topic, but that was over 1 year ago. Many of the tools being shown were new to me, and if I only had seen the Attribute Manager earlier !! 😉

NEW tool about to go live is BPF editor. You can now bulk update a view of records to a given step in a PBF.

Megan Walker – Create a visual overview of your customers

Megan Walker session was about empowering Dynamics data within Power BI. The whole session was a live demo, really speaking well to the functional consultants. All of the examples were at a level where you feel that you can do it yourself. It is a must watch for consultants that need to “sexy” up their Power BI demo when presenting from a Dynamics perspective. Best of all is that every example was published on her blog!:)

http://powerbi.emojimegs.com – Tnx for posting these out..

BONUS: I got to interview Megan for my first ever Video/Podcast, and it will be out as soon as I learn how to edit sound and video..

Microsoft Roundtable

A big part of these Events is meet and greet with people, companies and of course Microsoft. We attended a round table discussion where Microsoft is opening how they want to increase our sales even more. Anyone working with Dynamics for a while has been a trained in Solution Selling, where you focus on pains that you can quantify. You then try to justify the project by fixing the pain, and therefore reducing the cost.

So Microsoft is working on a new industry specific framework for customers, so they can relate to the problems we can help them with. Once I get more information about this I will write more about the customer stories (given that the customer want’s to participate)..

Fredrik Sætre – Extending Power Apps to Power up Operations

Fredrik is a former MVP (now working for Microsoft). He represents the FinOps part of Dynamics, and therefore quite on the opposite side of what I normally listen to. Over the last few years I have heard him speak a few times, and he really is what I would call a Customer Engagement consultant on an FinOps world 😉

He is really enthusiastic about technology (not something I normally feel about the FinOps community), and great at delivering talks. It is interesting to see how FinOps is approaching the CDS story, and PowerApps. Every time I see him talk, there is something new in FinOps and PowerPlattform.

Even though I don’t understand it all, FinOps and logistics is really impressive. When you combine it with PowerPlattform that can surface data, it all makes sense to a CRM person like me:)

Below was an example from the presentation where he embedded a Canvas app in FinOps.