CDS, Microsoft Teams, Power Apps, Power Platform, Power Virtual Agents, Project Oakdale

The best from both worlds – Office Apps & Services and BizApps combined

One of the things I really like with community is how you come in contact with people who are equally passionate about technology, helping others and learning together as yourself. I have teamed up with Office Apps & Services MVP Amanda Sterner (her blog and Twitter) who specialized in Microsoft Teams, Microsoft 365 and collaboration and we have had a pre Ingite chat. Exciting times sure are ahead of us, with Project Oakdale around the corner and Microsoft Ignite just a few days away. This is the first article we do together and the plan is that more articles are to come!

The Microsoft ecosystem of products is a never ending, constantly evolving story and powerful changes are coming to us whether we want it or not (but of course we want it!). The good thing is that when you collaborate with great people who are willing to share their expertise, we can help each other to keep up with the latest technology and learn together how new technology best is utilized in what situations.

Next week it is time for Microsoft Ignite and as usual cool demos of upcoming new features and exciting announcements can be expected. With the world being a bit different this year and the acronym WFH (work from home) has been seen almost everywhere, a lot of effort has been put into making Microsoft Teams the obvious collaboration platform. When you have a collaboration platform in place and you want to increase productivity, then you can start to look at Power Apps. There are several sessions during Ignite with Microsoft Teams content as well as Power Apps content. The exciting part? Well, that is when we combine these two.

Superpowers are great but even better combined. I had a chat with my community friend Office Apps & Services MVP Amanda Sterner about our different areas of expertise and our respectively expectations prior to Ignite this year. Since our worlds are merging more and more why not combine our respectively superpowers and let us start with some advice for sessions not to be missed at Ignite next week!

SuperPowers are better together!

Background to Project Oakdale and Microsoft Teams ❤ Power Apps

This summer Microsoft announced that the Power Apps Studio and Power Virtual Agents (PVA) Portal will be available from within Microsoft Teams and we will get the possibility to store relational data with what has been given the temporarily name Project Oakdale (Common Data Service/CDS “lite”). Not only will we be able to create Power Apps and PVA bots directly from within Microsoft Teams (and these will then live and run within Microsoft Teams), Microsoft has indicated that all of this will be available at no additional cost, how amazing is that!

If you are from the BizApps part of the world, then you are familiar with CDS. Project Oakdale is the “CDS lite” that you will get for free with Microsoft 365. If you are from the Microsoft 365 part of the world, well, then you will be happy to get a relational data storage alternative with which you can create tables and have as a back-end to your Power Apps in Microsoft Teams. There will be sessions during Ignite where Microsoft Teams and Power Apps are combined, as well as Microsoft Teams and PVA and we can expect Project Oakdale to be a bit more demystified.

Sessions not to miss at Ignite next week!

We had a chat about the upcoming event Ignite, how to plan the days and what sessions we are most excited about. Our most important tip is to pay attention to the key sessions, since big news tend to be announced during keynote sessions. Whatever you do, do not miss the main key session with Satya Nadella Building digital resilience.

“Microsoft Ignite is definitely the highlight of the year, even though I’m sad I can’t be there IRL to meet my friends from around the globe I think it’s a pure luxury that the event is FREE and people previously limited by anything now has the chance to watch. The sessions I look most forward to are of course focused around productivity and modern work, for example Enabling collaboration, communication, and knowledge sharing with Microsoft Teams, SharePoint, Project Cortex, and more and Microsoft Teams Live Q&A with Jeff Teper both with Jeff Teper. Jeff is what us old SharePointies calls the father of SharePoint and I always make sure to watch his sessions! I’m also really looking forward to Jared Spareto and his session on The Future of Work since that’s a topic I find close to my heart”, says Amanda.

Jared Spatero and his session that Amanda is looking forward to is tagged as a key session (it is a key session with a Microsoft 365 focus). There are also other key sessions e.g. one focusing on Power Platform and one on Dynamics 365. As already mentioned, this year Microsoft Teams and Power Apps will become closer friends, which means if you are from either of these two different worlds then the key session focusing on Power Platform Microsoft Power Platform: Fill the app gap and supercharge organizational agility is something for you.

“I’m so much looking forward to Microsoft Ignite this year. I’ll pay attention during the key sessions, main and Power Platform at least and impatiently I’ll be waiting for exciting announcements. I might pick up on Amanda’s advice and listen in on Jared Spatero’s too. Charles Lamanna is leading the engineering team for the Low Code Application Platform (LCAP) in the Business Applications Group. He often presents news in a very cool way and makes great demos. Not only is he one of the speakers for the Power Platform key session, Charles will deliver several other sessions and the one I want to highlight a little extra is where mine and Amanda’s worlds come together, Build Power Apps within Microsoft Teams and get to the next level with Azure APIs and the Power Platform. There are more sessions to be excited about within this same subject. Microsoft Teams and PVA come together Build intelligent bots for your employees using Power Virtual Agents and Teams and this sounds a lot like Project Oakdale stuff to me Build custom apps to drive productivity in the remote work world with Power Apps an Teams. One more that I just can’t miss is Julie Strauss and her session Amplify your pro developer skills with Power Platform”, says Carina.

Another exciting new concept for this digital Ignite is table talks and table topics. Since a lot of us go to conferences to discuss different topics with other engaged people, Microsoft wanted to have something similar – a format where you can discuss both in text and with your voice. Be sure to check out all available topics at the Microsoft Tech Community and promise you don’t miss the table talk I´m/Amanda is one of the hosts for: Running Community Events in an Online World Wednesday 23rd 15.30-16.00 CEST. You can join the conversation now in the Microsoft Tech Community!

We will have a new chat after Ignite and you can expect more combined superpowers as upcoming articles. Enjoy the excitement next week during Ignite!

Read more

Microsoft Ignite 2020
Register for Microsoft Ignite and plan your schedule for the event
Your guide to Microsoft Teams @ Ignite 2020
Your guide to Microsoft Business Applications sessions at Ignite 2020
Power Apps at Microsoft Ignite Virtual Conference
Power Virtual Agents at Microsoft Ignite Virtual Conference

Microsoft Ignite 2019
Recap from Microsoft Ignite 2019 on the Power Apps blog
What’s New in Microsoft Teams | Microsoft Ignite 2019

Project Oakdale
Project Oakdale announcement on the official Microsoft Teams blog
Project Oakdale announcement on the official Power Apps blog
A closer look at data platform capabilities in Project Oakdale

Canvas apps, CDS, Embedded Canvas Apps, Model-Driven Apps, Power Apps, Power Platform, PowerApps

Exploring the ModelDrivenFormIntegration control in embedded Canvas Apps

I have written about the use cases for embedded Canvas Apps before as well as given different examples of how to create an embedded Canvas App. Take a look here for an example of how to implement one of the use cases. In my presentation Deep Space in Power Platform I also have a detailed description about how to create an embedded Canvas App.

There is one part of the app that requires some extra attention though and that is how to make use of the form context, i.e. how to get the information from the record in the Model-Driven App to your embedded Canvas App. In this blog post we will look into the details for just that and I will highlight an issue I ran into when trying to make use of the context.

Continue reading “Exploring the ModelDrivenFormIntegration control in embedded Canvas Apps”
Canvas apps, CDS, Community, Custom Data Provider, Data Integration, Dataflows, Embedded Canvas Apps, Model-Driven Apps, Power Apps, Power Automate, Power Platform, PowerApps, Scottish Summit, Virtual Entities

Scottish Summit 2020 – Deep Space in Power Platform

It has now been almost two weeks since the sound of bagpipes and the sight of kilts. I can still feel the excitement and passion which filled the air at the University of Strathclyde on that Saturday, when we were all united because of the passion for what we do. As usual it gave me so much inspiration and positive energy just to meet with like-minded enthusiasts, all with different experience, viewpoints and great ideas.

In my previous blog post I shared my story – my day – including pieces of what I learned from attending other sessions. In this blog post I will let you in on the session that I held.

Continue reading “Scottish Summit 2020 – Deep Space in Power Platform”
CDS, Data Integration, Model-Driven Apps, Power Platform, Virtual Entities

Virtual Entities – A forgotten feature which is still alive

Virtual Entities have been on my radar since it was released back in July 2017. I have not used it in any customer project yet though and you do not hear so much about it nowadays (as indicated in the title of this blog post). However, last year in October there was a session at eXtreme 365 where Matt Barbour said “Virtual Entities are not dead”. My friend Jonas was there to witness it live. Great to hear that Microsoft are doing investments within this area, i.e. it is not a completely forgotten chapter in the product portfolio.

Continue reading “Virtual Entities – A forgotten feature which is still alive”
Canvas apps, CDS, Embedded Canvas Apps, Model-Driven Apps, Power Apps, Power Platform, PowerApps

Getting started with embedded Canvas Apps

Canvas Apps is one of the two building blocks of Power Apps, the second being Model-Driven Apps. I have written about both these concepts before and I have also mentioned that you can combine the two by embedding a Canvas App on a form in a Model-Driven App. This is the first blog post in a series of two. In this first blog post I will give examples of use cases for embedded Canvas Apps and in my next blog post I will go through the entire process of how to create an embedded Canvas App for one of these use cases.

Continue reading “Getting started with embedded Canvas Apps”
CDS, Flow, Microsoft Flow, Power Automate

How to make use of the response information from an HTTP request the Power Automate way

In my previous blog post I explained how to use Power Automate (previously known as Microsoft Flow) and set up an automated flow which triggers when an Account is created or a certain field is updated and then makes an HTTP request using OAuth 2.0 as authentication method and includes some data from the Account in the request. I also mentioned that you might want to do something with the response from the request, e.g. let the users know how it went. In this blog post I will let you in on an example of just that.

Continue reading “How to make use of the response information from an HTTP request the Power Automate way”
CDS, Flow, Microsoft Flow, Power Automate, Power Platform

Using Power Automate to trigger on Create or Update in the CDS and make HTTP requests with OAuth 2.0 authentication

In my previous blog post I mentioned that Microsoft Flow has been rebranded to Power Automate. We still create flows though and this week I created a flow. Then I thought to myself, why not share it, perhaps someone might benefit from it and the next thing I knew this blog post was written and ready to be published. In this blog post I will let you in on how to make HTTP requests with a flow, using OAuth 2.0 authentication, i.e. a 2-step authentication. Basically, first you make a request in order to get an access token and then you use that token for your other requests.    

Continue reading “Using Power Automate to trigger on Create or Update in the CDS and make HTTP requests with OAuth 2.0 authentication”
CDS, Data Integration, Flow, Microsoft Flow, Model-Driven Apps, Power Platform, PowerApps

Creating CDS records from an open API – Nasa’s Astronomy Picture of the Day – using Microsoft Flow

For about a week ago I had some fun exploring one of Nasa’s Open APIs, Astronomy Picture of the Day. I made a Canvas App which displayed the picture of today (with a Microsoft Flow in the background). As a separate thing I also created a Microsoft Flow which I scheduled to run each day, it gets me the picture of today and saves it as a record in the Common Data Service. Before I set up the flow I created an entity to hold this information. This blog post will let you in on how I set up the flow which creates CDS records and how to display the records in a Model-Driven App.

Continue reading “Creating CDS records from an open API – Nasa’s Astronomy Picture of the Day – using Microsoft Flow”
CDS, Data Integration, Dataflows, Power Platform

Power Platform Saturday Sweden – from a speaker’s point of view – Introduction to Dataflows and Data Integration

This is the second blog post of two about the Power Platform Saturday Sweden event which was held on the 5th of October. In the first one you can read about it from an attendee’s point of view. In this blog post I will let you in on the session that me and my colleague Carl Aspernäs held. Actually, I put in some new tips in here as well, which we did not mention during our session. So even if you did attend our session, you might learn something new from this blog post.

Continue reading “Power Platform Saturday Sweden – from a speaker’s point of view – Introduction to Dataflows and Data Integration”
CDS, Data Integration, Dataflows, Model-Driven Apps, Power Platform, PowerApps

Using Power Platform Dataflows to get data from a Web API into the CDS and a Model-Driven App

October is knocking on the door which means exiting times from a Power Platform point of view. The 2019 release wave 2 is coming to us. Let us not be washed over, instead let us surf it and have some fun. There are a lot of new features and improvements to discover.

This blog post will be dedicated to the new (or rather rebranded) feature Dataflows and how you can set up a Dataflow which gets data from a Web API and writes it to the CDS. We will also create a Model-Driven App in which we can work with this data.

Continue reading “Using Power Platform Dataflows to get data from a Web API into the CDS and a Model-Driven App”