Microsoft 365 Community Development, 16 Feb 2023

Previous Meeting Next Meeting

⏯

youtube image

►

From YouTube: Microsoft 365 & Power Platform Development Community call – 16th of February, 2023

Description

Microsoft 365 & Power Platform Development community call delivered on February 16th.

Demos: Building Microsoft Teams tabs with Adaptive Cards and Creating an Internal CV (Curriculum Vitae) with List Formatting.

Released: Microsoft Teams Toolkit – v4.2.2 (GA), 10 independent publisher connectors, 3 scripts, 1 Teams sample, 3 Power Platform samples, plus 3 conversations since our last meeting.

Announced: LinkedIn group for discussions and Microsoft Graph & .NET Hack Together in March

Please see the blog post for this call for project updates, news and events details. The host of this call was David Warner II (Microsoft) | @DavidWarnerII. Q&A takes place in chat throughout the call.

Agenda
00:00 – Intro - David Warner II (Microsoft) | @DavidWarnerII
06:18 – PnP .NET library updates - Bert Jansen (Microsoft) @O365bert
08:30 – PnP PowerShell updates - Gautam Sheth (Valo Intranet) | @gautamdsheth
10:40 – yo Teams updates - Rick Van Rousselt (Advantive) | @rickvanrousselt
12:04 – Microsoft Teams Toolkit updates - John Miller (Microsoft) | @jmillerdev
13:36 – Microsoft Graph Toolkit updates - David Warner II (Microsoft) | @DavidWarnerII
14:04 – Independent Publisher Connectors - Jocelyn Panchal (Microsoft) | @JocelynP_PM
15:53 – Microsoft Script Samples - Paul Bullock | @pkbullock
17:49 – Microsoft Teams Samples - Bob German (Microsoft) @Bob1German
19:02 – Microsoft Power Platform Samples - April Dunnam (Microsoft) | @aprildunnam
20:10 – Together mode picture
21:18 – Demo - Building Microsoft Teams tabs with Adaptive Cards – Ramin Ahmadi (Content+Cloud) | @raminahmadi1986
38:09 – Demo - Creating an Internal CV (Curriculum Vitae) with List Formatting – Federico Sapia (ANPAL Servizi) | @X365Fede
53:45 – Closing

Learn more
• See the full blog post for this call in the Microsoft 365 platform community blog - https://aka.ms/community/blog
• Download invite for the Microsoft 365 & Power Platform Development community call: http://aka.ms/spdev-sig-call
• Microsoft 365 Unified Sample gallery - https://aka.ms/community/samples
• Microsoft 365 Platform Community in YouTube - https://aka.ms/community/videos
• Microsoft 365 Platform Community - http://aka.ms//community/home

A

B

With the community, this is the Microsoft 365 and Power Platform development. Bi-Weekly call today is February 16th. We are halfway through February. Where is the time going, but we are so excited to be together today. Let's discuss our agenda, so we've got tons of updates latest updates on the community pnp.net libraries, PNP Powershell, yo teams, Microsoft teams, toolkit graph, toolkit independent publisher, connectors. We got it all talking about samples, script, samples, Microsoft teams, samples, Power, Platform samples, all the samples as Todd would say, a plethora of samples.

B

It means a lot to all of us and then we're going to see picture time with together mode. Then we're going to get to our amazing All-Star presenters of the day ramen's going to cover build Microsoft teams tabs with adaptive cards and Federico, is going to cover creating an internal CV with list formatting. So we've got the boom to drop today we are very, very excited, but let's talk a little bit about what is available to you in this community.

B

There is so much we've got Microsoft 365 and Power Platform Community videos you can subscribe today. As the slide. You just told you, we've also got our LinkedIn group for discussions join today. You've got open source initiatives, we've got sample galleries for the entire community, that includes team samples, spfx samples for web parts and extensions, Power, Platform samples list, formatting samples, the samples go on and on, and we want you to use them, but you don't need to remember all those links. There are so many links.

B

Only one AKA dot, Ms, slash, Community Home is going to give you access to all of these things, and you follow us on Twitter for updates at M365, PNP or LinkedIn and you'll be alerted to all the great stuff. So don't hesitate to do all those things now you may be thinking I like this call I like the presenters on this call, I'd love to actually present on this call. Well, we gotcha. We want you to present a cool demo, a feature, a solution, anything that you feel has value to the community.

B

Don't overthink it doesn't have to be a flux capacitor that makes time travel possible. It can absolutely be something that you found useful and you want to share with the community we enjoy and welcome everyone to present a demo, even if you've never done it we'll help you out. So all you need to do is fill out the form, ak.ms Community, slash, request, slash demo, and we will connect with you and get you scheduled again. Don't overthink it everybody.

B

We would love to even co-present with you if you've never done it before so just reach out to us. Let us know, and we absolutely want to uh to work with you on everything. Okay, now you may say what other community calls are available. Well, we've got lots of those too. uh We've got the Microsoft 365 and Power Platform weekly call. Now this is with Microsoft speakers. That's what makes it unique and special is that you're going to get directly from the mothership, the horse's mouth.

B

If you will the other horse, not that Chris Kent guy, we like him, but not from Microsoft right, so the Microsoft presenters they are going to give you everything that you want to know from within the mothership. So definitely get that on your calendar. Then there's the Power, Platform monthly call that happened yesterday. That's the third Wednesday of every month. We've got the Microsoft identity platform. We've got office, add-ins we've got the bi-weekly calls, so that's the one you're on now: Microsoft 365 and Power Platform, Community, Development and then Viva connections and SharePoint framework.

B

Those are sibling calls they are opposite each other on Thursdays, but you can get access to all of them by going to AKA dot, Ms, slash, Community, slash, calls and they're also published on Meetup. So if you want to learn more about that, go to AKA dot, Ms Community, slash Meetup. Now speaking of that Microsoft speakers call next week, 21st of February we're going to see Dan walline talking about integrating Azure communication Services calling into a react app we're all going to react great to that aren't we then Gary is going to cover teams.

B

Toolkit learn path, build a bot using teams toolkit for visual studio code, so you can get access to that by going to the URL AK dot, Ms, slash, Community, slash, Ms, dash speakers, Dash call Dash invite just rolls off the tongue right. All you have to do is click the link in the chat, we're got. We got you okay. Now all these things may feel a little overwhelming and you may think I want to get involved, but I don't know how well sharing is caring is here to take care of you now.

B

This is a program that we have started that provides Hands-On guidance. What does that mean s? We're gonna join calls with. You live in a safe space, which means they're not recorded and answer and and work together with you on a variety of topics. Things like did.

B

You know you can edit Microsoft documentation and help, keep it updated and curated and you'd even get credit for doing a sample there and contributing, or you may have a sample you want to share, or you may have a sample that you want to share and then show it off on a call all these things we cover. In fact, next week, We've Got, The, Power, Platform samples contributor sharing his caring session on February 23rd, so don't hesitate to sign up. These are absolutely free.

B

There is no cost and you're able to learn and meet with other members that are passionate and like-minded. Just like you are so don't hesitate to go sign up and we hope to see you there now once you do contribute. We want to recognize you for all the amazing work that you're doing and that's where our community recognition program comes in.

B

This is powered by credly yeah, that same credly, you're thinking that gives you those certification badges with these badges given to you by the community at no cost will showcase your contributions, and we understand that we're all working in environments where we need to show that we're making a difference, whether that's to our manager, to our clients or both. This is our way of giving back to you in a formal and official accredited way. There is no cost.

B

We just need you to opt in AK, dot, Ms, slash, Community recognition and we've got even more badges, we're getting ready to drop the spfx web Parts team samples and extension badges this weekend so be on the lookout for that everybody we're excited for those along with all the new ones that came out this formatting PNP Powershell CLI for Microsoft 365 and adaptive card extensions, they're out there you're going to get them and we're excited for that now, there's an upcoming event coming up in March the microsoftgrafin.net hack together.

B

uh We are super excited for this. uh It is coming up in March and it is available for you to uh to connect and work with. So you can go to AKA dot, Ms hack together uh to learn more about that and guess what there's gonna be prizes and maybe a batch so definitely go check that out learn a little bit more about it, so that you can get involved and be ready for it.

B

Aka dot, Ms, slash, hack, Dash, together, all right everybody, let's get into some Project Specific updates, so we're going to start with pnp.net libraries with Bert.

C

All right, thanks, David, uh what's happened on the net side for PP framework. For that Library uh we had a couple of small fixes from uh Miguel Martinez and from Jerome bullet and then uh a slightly bigger update around how we handle graph and and authentication URLs, so uh we're still on on that part to uh fully support any Cloud environment and then any hard code reference to graph the microsoft.com, for example, that will break in some other clouds so uh that work is done more to come, uh mainly integrating settings from corsicated with framework.

C

So ADF was a nice interrupt between both but work in progress there on the core as the gay side, um what days did work on the permission? So we have an option to uh share a file. Now you can also update the sharing link, so you can add a user shared with that with an additional user of remove user from a sharing link, uh Dimitri and uh not here, if I pronounce it correctly, the documentation update.

C

So thanks for that, Patrick Lambert has been working on testability, so he is using a mock as a test framework, and we did some changes to support the kind of fully mocking uh your developments using big car SDK. So that's really cool and finally, some other smaller updates, like a new digest, News Digest page support type. So when you were create such a page, we know uh handle it correctly. We don't fail anymore important to know.

C

Actually it applies to both framework, and course, the case we drop.net 5 for our nasty builds, so total 5 has been uh has been out of sport for a while already and the next major version will not have it anymore. So we already started dropping it from the nightly builds and a few other smaller fixes here and there um and usage is steady. Around 43 billion requests amount, a number of Standards went up, so we are at 134 000, tenants uh in January that you just not the library.

C

So that's pretty good, but uh moving now to Powershell codon up to you.

D

Thanks thanks Bert um over in the PNP Powershell Library, uh we added a bunch of improvements to the existing commandlet, so one of the major things that we added was support for removal of the large list. So what I used to happen is when you have a large list like say, 100, 200, 000 list items, and you try to send that that list to the recycle bin. It used to be a not so good experience.

D

So we added a better experience to move sub move the list to the recycle bin, so it it starts a bit. It starts a job and then once you know that it has been done, you you will know the status of that job, and so we added that support. uh Besides that, the new Viva connections support is rolling out in the Microsoft tenants, so we also added support for that using in the set PNP home site as well as we also try to retrieve the support from for that in the get PNP Homestead command.

D

Let's um another Improvement we did was in the pnpsp rest method and the graph method, so both are both of these method. Both of these commandlets, so you can use to make HTTP request against the SharePoint as well as the graph endpoint. So we improved that to handle complex, Json preloads. uh Besides that what Bert mentioned um yeah Powershell five support has been dropped so going forward in the newer two point x versions: We will be only supporting Powershell, 7.2 or later versions of the Powershell that are going to be there.

D

So the nightly command nightly bills are have already dropped. The support for that. So we would highly encourage you to uh you, know, use the nightly bills and test out your existing scripts, and let us know if you feel, if you have any issues with those comment lets in the newer builds um besides. That would absolutely love to hear from you on the discussion forum as well as in the issues list on the GitHub um usage has been also quite increasing, so uh yeah it has been 37 billion requests a month.

D

That's a monthly figure wow and also around the usage in around 35 000 tenants, so yep, quite good numbers overall uh over you, David thanks a lot.

B

37 billion awesome. Thank you got him all right. Let's go over to Yo teams with Rick, hey.

E

Hey uh so yeah I'll use a chesbian up as well um 49 000 downloads. uh What are we working on? We've been doing some documentation updates, of course, as always needs for good documentation, so also in this community. If somebody wants to help improve the documentation, if you don't want to do it just create an issue if something's wrong, if you want to do it and help out even better, but we need to get our documentation up in order because it's some things we made a little bit too complex.

E

We admit that now, so we have to make some things back to a simpler version, so that yeah everybody can see what's going on.

E

um We also have a preview since the last time which we updated and we'll need doing, I think a new preview release as well soon um because it's just small exchanges, so it can be joined in the last preview release and then what's next, uh once this preview, the new preview release will be tested, we'll do a new, stable release version and we're working still working on the visual studio code, extension and support for single sign-on and stuff. Like that, um our videos, we're still thinking about ideas to produce them.

E

So if somebody wants to help us I, think um they're always welcome to help. um If you want more information, yeah just go to the l, aka.ms, slash your teams and get started with building teams, applications and that's it over to you. John yeah,.

B

John is coming in but hold on everybody. We got an incoming data stream. Oh what? What is that? That's Microsoft teams, toolkit John.

F

Thanks for the sound effects, David got it uh yeah, so a little update on the team's toolkit. uh We have new version released, it's just a point release, so that's 4.2.2 for the vs code extension and that just brings in a little bit of the latest and greatest for note. 18 support, which has been um requested and I was painful before so happy to announce. We at least support the latest of that same with react.

F

Some latest updates for the bot framework stuff that we that we built on top of so we'll use cloud adapter now um which, if you're not familiar with that just latest and greatest there's, avoid some issues and updates to teams.js dependencies and some minor bug fixes. So you can check out the change log on the GitHub page to figure out all the uh nitty-gritty. On that. One thing I wanted to highlight is uh the opportunity we have I've been talking about a couple weeks now in this call. We have a major release coming up.

F

Tomorrow is the plan for the pre-release of that which will be uh for the vs code extension, so you'll be able to install it using the pre-release functionality on vs code. But if you would like to participate in a paid research study on those features, please uh reach out the couple questions on the form really just to make sure that you have previous experience.

F

Building teams apps and that um it'll be useful for your time and ours and um and then we'll compensate you for that time as well, and that just helps us build better products. So uh click that if you want to participate in that or just ping me and I'm, happy to chat more about it.

B

Awesome, thank you. John uh all right, let's go to MGT I, don't think Seb is on the call. So I will cover this. uh We got 2.9.0 out as our latest release. uh We've seen a lot of activity with what's coming next in MGT with Gavin and Seb on those Tuesday Microsoft only calls so definitely tune in I think we're going to see more of them there. Of course, you can always always help out want to get your assistance in improving features and building and help wanted good first issues.

B

uh You can see that at AK to Ms, slash, MGT, slash issues. Now, let's go over to Independent publisher, connectors with Joss.

G

Hello, everyone, as always, we have tons of updates in the world of connectors. Since the last time we spoke two weeks ago, we have grown by more than one connector a day. We are 15 connectors, greater we're not at 948 across the overall ecosystem, spanning power, automate power, apps and Azure logic apps. We are now at 239, independent publisher, connectors 10 more since the last time we spoke, which means there are more Community connectors than there are made by Microsoft. That is so incredible.

G

It really shows the strength of the contributions in the community and how much you all contribute. I would like to thank Troy, as always for his four new connectors and Rel hugging face Lexica dice bear as well as Lucas for IBM Watson text to speech and IBM assistant Zachariah for WhatsApp. This is super exciting.

G

We have been asked for a WhatsApp connector for so long and it's made by independent Publishers ostazi for krozu PM Clement for meaning cloud and Nova GL for Koopa I would also love to call out the fact that we have an open, AI connector, which was just updated with support for Dolly 2 by Robin. Thank you so much for your support on that Robin.

G

If you all love connectors, which I mean I love connectors, that inherently means you have to love Power Platform, because what is Power Platform without connectors next weekend, I believe on Friday and Saturday. There is the global Power Platform boot camp, taking place in many many dozens of cities around the world. I'll I will be presenting live at the Times Square event on Friday. So if you guys are looking to sign up for that or for one near you, please visit powerplatformbootcamp.com. Thank you. As always, I hope everybody has a great day.

B

Thanks Josh, you might even say the connectors are: what connects the Power Platform.

G

If you don't say.

B

And I see Todd, probably shaking his head there, all right. Let's move on to script samples with Paul Bullock thank.

H

You so script samples is a place where you can share your scripts with the community, so these are Powershell scripts see this could be Microsoft graph, SDK, Powershell scripts, PMP, Powershell CLI for M365 and more and these samples do get integrated into this. The Microsoft sample solution gallery, which is super super cool, so they're in in a few places there. So we have a new set of awesome scripts, so we've got uh bulk import data from multiple files and multiple lists from rational, which is super cool.

H

That's in PMP Powershell we've got pinpot items and documents that haven't been indexed yet after an update, so search related by Casper Larson and we've got some new uh General General Powershell scripts, actually, uh which is a bulk, send a CSV file, but using the graph API by siddarth, which is super. Super cool.

H

um We've also done some small visual updates to the site, just to make it a little bit clearer and also links back to the solution sample Gallery. So if you do navigate here and you want to get back, for example, if you did arrive from that experience, then you can. You can see what else and other samples that are available to you if you're looking for that, I've also updated the contribution guidance as well. So again it open to feedback on those.

H

If it's not helpful or you need more information, then absolutely uh reach out to me and make those tweaks um but yeah you can DM me via Twitter or or LinkedIn, so whatever you prefer, and we do have some samples on the on the reaper. If you've got some ideas or you want to contribute to as well um so. But thank you thank you for all for your samples or contributions. You're, absolutely awesome, but remember there is a badge as well for you uh if you do contribute but remember to opt in.

H

It is an opt-in thing, but uh but absolutely will be releasing badges, uh hopefully soon uh on that. Back to you, David awesome.

B

Thank you, Paul did someone say: badges yeah, my head just turned badges. Yes, all right. Let's talk about Microsoft team samples with Bob dearman, hey.

I

Everybody thanks David. How are you everyone? We have a great new sample this week. This is from the Innovative, the inimitable Marcus Muller um and who has made so many great samples for us, and this one is a document generation app. So you can go in in a tab in teams. You can see the picture and actually fill in some information. It will generate an offer document and then there's message, extensions that help with the review of that document.

I

It shows how to generate documents using injection of metadata into a template document, how to use teams SSO to call the SharePoint API and also, of course it. It shows how to you, put all this together into a teams application so that users can use it not only in teams but also in Outlook and office.com. So thanks so much to Marcus and please contribute your favorite team samples at aka.ms, slash, M365 samples back to you, David.

B

Thank you, Bob and yeah. Marcus is one of the best, so thank you Marcus all right so true. Let's turn it over to April for Power Platform samples.

A

Thank you, David. We have three amazing powerapps samples to share here. We have an app login sample from Seth. That shows a good pattern for if you need to have some kind of authentication screen in your powerapps applications and how you would accomplish that we have a search movie samples by Ariana. That shows how you can do a custom connector that connects to the omdb service there and how you can integrate with that to pull and search different movies. And then we have a student application process application from Samia.

A

That shows how you can kind of walk through that student application process. All canvas applications there that we have that you can take advantage of and look at there. Also, if you want to get started, sharing your Power Platform solutions that you built, you build something cool and you want to share it with the community, but you're not sure how to get started. We have a Power, Platform contributor, sharing his caring session on February 23rd next week. There that will walk you through start to finish.

A

David does an amazing job with these sessions that are walking you through how to do your first pull request and get your submissions there into that repo, and if you want to share your submission, there go to AKA Ms forward, slash Power, Platform, Dash samples back to you. David.

B

Awesome, thank you, April all right. It's about that time, picture time, everybody! So, let's crack open those cameras. Vessel will take over and he will show us hopefully real faces, not blurry faces that we had yesterday from teams. Hey look at that real faces. Awesome.

B

And I think that's what might be muted.

J

Here we go now I'm unmuted there we go. Technology is hard. Let's wait a few more seconds. uh We are still I think we still have few seats. We are already recording, but let's wait a while. Let's wait a few more seconds, do we have more people joining in I? Guess we are hitting the limit over there. Let's do some hand faving everybody.

J

Thank you for joining uh once again awesome to have you in a call cool to see so many familiar faces and and thought Behavior excellent I saw what you were doing on the on the back row. Excellent thanks. Everybody thanks for joining it's brilliant to have you on a call awesome back to you. David.

B

Awesome, thank you vessel all right, everybody. It is All-Star time of the day, and so, let's give our attention to Ramen on the topic. Build Microsoft teams tabs with adaptive cards feel free to take on over.

K

Hey, uh let me show my screen looks.

B

K

Perfect uh I'm excited to talk to you today about building tabs with adaptive cards, I'm going to show you how to use Microsoft search API to search through different resources and display them in an Adaptive card tab within Microsoft teams.

K

uh Just a little bit about me. My name is Ramin Ahmadi I work at content cloud based in London I've been a software developer for a really long time. Since SharePoint 2003 came out and I've never stopped learning and trying new things. You can follow me on social media with the links you can see um here uh now, let's focus on adaptive card tabs. As we know, tabs are just web pages embedded in Microsoft teams.

K

They are simple: HTML, iframe tags that point to domains defined in the app manifest and can be added as part of a channel inside the team group chat or personal app for individual users. So there are a couple of ways for developing Microsoft teams, tabs and- and you can have different tools and Frameworks such as a SharePoint framework. You can use human generator for teams or teams toolkit, and you know you can use your favorite library or framework like react, angular.net or anything allowing you create a web page.

K

But you know there are some consideration using this traditional methods to build tabs and sometimes the tabs, and look and feel native to the rest of the teams. Also, some apps aren't responsive. Therefore they won't work easily on mobile.

K

um A slow load times is another problem, sometimes it's because of the fact that it's embedded in an iframe, but that can also open up a host of other constraints depending on how the web page is built and also there are some hidden maintenance and costs that you need to be aware of.

K

But building tabs with adaptive cards on other hand would allow you to build your app with ready-made UI building blocks as simple as drag and drop, and edit UI elements in real time that look and feel native on mobile, desktop and web. Also, you can use a bot as the backend and that what is responsible for accepting requests and responding and sending those adaptive cards back to the tab and render them, and of course you can use a task module, because this is really important if you want to collect some information from the user.

K

So this is a really good way to collect those information. uh There are some prerequisites that you need to be aware of. You need to be familiar with what development, because this is your backend and also adaptive cards and task module in Microsoft teams. You have to register bot as I mentioned. This is your backend and you have to register a part in Azure and, if needed, this is optional.

K

If you need to use a single sign-on, for example, if you want to use a service like a Microsoft graph API, you have to configure single sign-on. That I will show you in a minute in the demo. Also, there are some limitations, uh so at the moment the page load size is limited to 80 kilobytes. So if you have an Adaptive card more than 80 kilobyte, uh it's not going to render. So if you have a complex, complex application or web app.

K

This is not a good approach for you to use adaptive cards tabs and also there are some limitations around the Adaptive card features. Not all of the features are available, for example action.execute or some of the other adaptive card features.

K

You basically cannot get them at the moment, but you know, Microsoft teams and adaptive card team are heavily investing in their future and there are so many exciting features are coming to the Adaptive Card World, such as form, validation, peoplepicare or fellow menu, and so on, actually I'm going to show you one of this feature, which is the people picker in the demo, uh and also there is no Advanced layout controls. So at the moment all of these cards sent to the tab uh are rendered vertically.

K

So, if you want to have you know, multi-column layout, it's not possible at the moment, but I'm sure there will be in the future and also only personal Tabs are supported.

K

um So when you build a bot, you are able to cover a number of teams: capabilities such as Bots messaging extensions. You can show dialogues known as task modules, and now you have the tabs. This is all powered by a bot as backend and adaptive card as front before this, you had to spin up a separate web server to host your app and you had to build the front end using a usual set of web tools.

K

So with a single bot backend an Adaptive card, you can power everything in teams, and this is the unified developer experience the that adaptive card base tabs aims to solve.

K

So there are some changes to the app manifest adaptive card. Tabs are rendered when the content, bot ID property, is provided in the static tab definition. But you need to be aware of that. This is only available from manifest version 1.9 or later, and you can use either a Content byte or bot ID, which is a specifying the Adaptive card tab or a Content URL, which is specifying a typical, hosted web content type experience. You cannot have both at the same time.

K

So here we say instead of rendering a URL send a message to this spot over here and that takes care of everything and send back the the Adaptive cards to to get rendered uh and if you, if you wonder how it works. uh So when you open a a Microsoft teams tab with adaptive cards, um it will send an invoke request to your Bot. So this is uh the payload of that request.

K

It's a tab, fetch a request that is get it gets sent to the board with a bunch of information such as the tab context, conversation some information about the user and the bot receives the request and in return it sends back a bunch of adaptive cars and those adaptive cards get rendered vertically in your tab. uh So this is how it works.

K

I will explain more in the demo, uh so let's go to the uh demo jump into the demo, but before I jump into the demo, as I mentioned in the prerequisite section, uh you need to set up a bot in Azure, so I need to spend a few seconds talking about the configuration, as you can see here, I'm running this spot on a web app hosted in Azure, but because for this demo, I wanted to use Microsoft graph I configured a single sign single sign-on by registering an app here.

K

So this is the app I added some permissions, because I want to search through some resources, such as files, events, messages or some SharePoint list items so that I needed some of these info. Some of these permissions that you can see here- and there are some other steps that you need to take to set up this single sign-on. So this is really a good documentation you can follow. This is really a step-by-step in a guide that can help you configure the single sign-on for your Bot.

K

I will share all of these links with you at studies demo. So back to this. So this is the application registration also, we need a single sign-on connection, so here we have a bunch of service providers that you can use, but for this demo, because I wanted to use Microsoft graph, I used Azure ad V2, so I just set client ID secret. You know token exchange URL and the other properties needed the Scopes that I need for my application. So this is the configuration and everything behind the scene.

K

So if we go to Microsoft teams here, I have the app running, and this is how it looks like when you first go to the tab, but before I select, the sign in button I want to show you something: I'm going to open the developer tools panel and in the network panel. If I just refresh this tab.

K

uh You can see it just sent an invoke request to your Bot, so this is the this is some information about.

K

um You know the context about the tab about the current user and everything and in response the bot is sending back back this object, which is type of us. So it provides you a signing link, so you can use to sign into the app. So if I now select, this button, I can just sign in and it returns to the tab, and you can see it sends another invoke request to your Bot and Bot. In response, we send a bunch of adaptive cards for this sample.

K

uh It's just three adaptive cards, so the first one is this one at the top, which displays some information about the current user. The image the the sign out button, this one, you can search through different resources in Microsoft 365 through this drop down control.

K

So here, for this is a button that, if you click it just invoke a task module which I said this is a just a dialogue and if you see in the developer panel in the network panel, it's basically it's a request of type task fetch. So if I go to the payload you can see here, this is a task fetch is sent to a bot and Bot will return.

K

This adaptive card task, module and user can interact with this and so submit, and if you just you know, send another request to the bot- and here we see some of the results. So if I just close this and if I just search for something like concern, if I just say, okay go through all of the files and select search. This sends another request of type tab submit with some data.

K

So the data here is that the resource type and also the keyword that I just put here and uh the Bots use Microsoft graph API to search through all of the files and find everything contains this keyboard, and you can see the results here and also I can filter it here. So this is a paper picker I was talking about it's one of the features you get from the Adaptive card.

K

Without needing you know, using any library or a framework, and if I select this and just press submit, you can see just filter everything, and these are the files created by Helen. uh Also I can search different resources and the good thing about adaptive card is so you see each time I send this request. It returns a different adaptive card with different UI, with different icon, different set of properties. So if I just search another thing to search the messages, you see different UI with different properties, and this is really easy to create.

K

So you can use adaptive card designer, as you can see here, I use this for building these UI elements and you, after that, you get this Json file and you can use it for sending back to the tab to get rendered here in Microsoft teams. So this is it. This is the uh this is how it works, and after you're done, you can sign out using this button. It will send another request to your Bot and you can sign out and if you refresh the tab, you're back to the signing page.

K

So let's just talk talk a little bit about the code, so this is this is the code, and this is your Bot class. So here we have different type of invoke, so we have tab, Fetch and tab submit which are new before the Adaptive card tabs. We didn't have the same work request before it was just you know, task Fetch and task submit, which is for task modules, and now we have tap Fetch and tap submit.

K

So the first requests we get from the bot is tough Fetch, and here we just we can check the token response and if we configure the single sign-on and if the token response is not available, you can send back an Adaptive card with a signing link asking a user to sign in otherwise you can render the card and the cards and just send another response to to your tab. So here I'm just retaining three adaptive cards and as I said it just did they rendered vertically.

K

So these are the three cards, and also we have the Adaptive cards here on the resources there are a bunch of Json files so that so, for example, this is a this- is the one I use for the filter filters task module, and this is how I use the people pick here. So this is really easy, as you can see here, you can just say: Okay I want this control to render the users and the user can search through the available users in your tenant, also for different uh resources.

K

I have different UI, so this is for Drive item or the files or for events. I use different, you know, icon different properties and under the services we have different services, but this is the one I want to talk about. This is the graph service API.

K

So when we get the token this method, just you know, set the token and it's gonna basically makes this graph client available. So we can use that, and this is the one that get the user profile photo and there's. This is the one I want to talk about, because this is a this is the API that we use for search through different resources. So, if I uh go back to here, this is a really good documentation about Microsoft search API with Microsoft search API.

K

You can search different resources, such as messages, events, people, um a OneDrive and SharePoint, and even you can just comp combine some of these resources together and search, for example, all of the OneDrive SharePoint messages and everything and just return the results which is really really useful. So this is how I get the results and send it back to the tab. I think this is the main key that this is the key features of this bots, so I think that's it from from my side.

K

If you guys have any questions you can- and this is the useful links that you can see and just use them if you want to learn more about adaptive cards or single sign-on or Microsoft search and adaptive card designer I'll put it here, thank you or back to you, David.

B

Awesome very, very cool stuff, uh really appreciate sharing that put the links in the chat. uh Some questions there for you, I think as well, and uh good they'll really appreciate you showing the behind the scenes right, not just that how things work from the code perspective and how it looks in the browser, but really how we understand it's working under uh behind the scenes there backstage so to speak in the code. So really nice work all right. Let's move over to creating an internal CB with list formatting with Federico, so Federico. If.

L

You want to take over hello, David, I'm here and uh now. I share my screen just a moment: okay in presentation mode, okay, I think it's possible. Yes, yep looks great, absolutely.

B

L

It away I introduce myself hello, everyone. My name is Federico sapiya and I work as a digital workplace specialist in a public sector company. Let's build an internal CV with Microsoft list. Today, I would like to talk about a new solution, I created using the new Microsoft List application.

L

This solution will allow us to uncover the most advanced features of Microsoft listed to track and organize information about people in organization through an internal CV template first I want to say: um I want to say that, even though you can take it as an example and customize it based on your needs, this is not necessarily a solution for a real world production, but a demo of some Advanced Microsoft list capabilities and how they can be put together to help user work better and less time, and when it comes to users.

L

Microsoft list is not just about tracking stuff like products, activities and so on, but it could be also focused on people. Therefore, it is, a solution is meant to provide HR managers and Specialists with an example of how it's possible to gather information about the employees and their work, history or a career path, along with the other markers of the crucify Solutions.

L

These solutions could be obviously third-party apps or platformer as well, but the internal CB template and going to share today took inspiration from Microsoft Dell, since it shares part of this in information structure. In other words, we can let other people know more about us what we are good at and what we are working on right now and similarly to Dell. But we are able to add projects, skills and education history to our profile to help others find us when they they are looking for people with ascertain expertise.

L

Furthermore, additionally info are available since Microsoft Microsoft list sample provides a point of access to both the standard, Microsoft tc5 organizational card and a link to our Yammer profile, where knowledge is shared with followers and within communities, but the opportunities result. We need a proper user interface, and here comes the logic used to build this micro list template.

L

We can display different types of information on a card, but what, if we use the discard, if, if it was a mix between a digital paper and a structure profile well, the result that we can see in this preview is a large custom card of a gallery view which allows users to fill out a form composed of multiple sections, as well as further customization option will allow to add a background image in the header too.

L

So the main question are the following: how far can we take a Microsoft release card? What are the features capabilities that we could Implement to make a large car the work as an internal curriculum beta? What are the advantages for user as well as HR in people management processes?

L

Well, here is the good news, because everything we can see here and in a real time demo soon it's fully supported by Microsoft release Json, in other words, no workarounds, no glitches or tricks to get things done, but some Advanced and fully documented features.

L

So we can find this set here so, as mentioned before, the result is an example of how you can put many Advanced features together in a tool to deal with one of the great challenges in our organization that is getting people out of a lot more about themselves than Azure active director knows, and one of these uh Advanced features I would like to highlight today is the usage of the line edit field Json property.

L

According to Microsoft official docs, thanks to the inline editing, we can load field editors to edit field data or an item in a standard list view layout.

L

However, in this example, the Eli editing feature is widely used in a gallery view layout to allow users to edit an internal CB without the need for opening the standard right, Pane and thus making the feeling process quicker and easier, except for the custom images and the attachments or the editing boxes are visually embedded and already for user in a card and among the features I've mentioned, I would like to share a deeper look at the automation of an internal CB attachments.

L

This is an implementation that tries to get the most out of the list attachments to display them as a clickable ties, and this is possible thanks to a dedicated power automate flow in the new Json split operator, recently added my Microsoft for custom formatting in Microsoft list. In other words, each user can upload the attachments through the advanced, editing right pane, while the power automatic flow and the speed operator will execute all the required tasks to.

L

Let other people view these attachments by clicking on corresponding types displayed in the works portfolio section and now all the steps requires to create this automation Service, as well as the Json code that are Illustrated in a step-by-step tutorial available in the sample solution gallery of Microsoft adoption portal, and in addition to this, you can learn more about Json formatting thanks to Microsoft learn official Docs.

L

So this is the end of my presentation, but I would like to share um real-time demo through my screen, so to play the role of an end user and here's what we get everything is uh empty now, but if we we get create a new item and just save it here is what we can see. We have an empty CV card. We can afford their customize by ending, for example, uh um cover image. We click on edit, all, let's add a new image here.

L

Let's choose, for example this one here: okay, we cannot also add a background image and choose another one, for example this one here. Okay- and here we go- you can save this card and everything now is updated with these custom images. But, as I said, we can use the line editing in place on this card, so we can start writing more about us.

L

I have a text standard text, Laura mipson, so if I put this text here, is that this CV card will expand so the more we write, the more it will expand and we can also add more information, for example, about projects through a drop down menu.

L

We can populate here we can write any text that we want, or we can add, more entries and so on, and also this section we drop down will expand up to a certain limit of a pixel. If this limit is exceeded, um a pop-up, a custom overcard that will show us a complete overview of all the information we uh we added here.

L

um The same thing is uh for the other section that reproduce the structure of Microsoft application as I say that we have Awards portfolio and the people picker to show the people we are collaborating with, for example, a current project and with the record, this work, Works portfolio section and I would like to show you what's the magic, because there is a power, automate flow, Behind, These and ready to be trigger.

L

So if we put the attachment, for example, I can add some attachment here from my desktop I cannot is one this one, this one and this one.

L

Okay, everything is saved and a power automate flow within some. Second, uh basically, we'll we'll write some information um in a specific field and the Json split operator, we do the Magic by showing all the the attachment information through clickable tiles. I will try to doing a refresh. Let's see, and here we go- we have our attachments as clickable ties. In fact, if I click on here, we have our portfolio completely available to other users.

L

So, as we can see in this is a basic example and the digital code is uh available in the adoption portal.

L

We have also other button with the specific command, for example, share button so that other people can share our professional profile, and we have also um button that points to our Yammer or Viva engage profile to get more information about house and our expertise. So basically, this is uh everything uh we have here and that's all for today, and thanks for watching.

J

Sorry, sorry to jump in here, um but I'm kind of curious, because I know that you you write code as well right, so you write SP effects and you're familiar with the development techniques. You state that you would not actually use this in production.

J

um Can you can it kind of evaluate a bit on what would you use and why this is magical and you're pushing the limits, but it it's? Is it low code, not really it's Json. It's complex uh well,.

L

It's uh these are uh how many uh one thousand three well a big complex, uh but um you know I think that, even though it's very long as a quarter, but it's pretty redundant because all the sections do basically the same things, so you can think about this solution as uh several sections um repeated many times. So uh if you want to reproduce this template, you can add even more section. I took a inspiration from Microsoft Deb about project skill and the expertise, but obviously you can change every Everything of this code.

L

For example, it's possible also to change these titles here. There's a specific way, fully documented to change the column names and have an app an update here. So that's all and.

J

Then the Frederico, the the next question is so this is list formatting, and this is Jason. Would you recommend in production I'm not sure how much experience you have on this use, this or SharePoint framework or power apps, or what would be kind of your experience on on these kind of things? Is this something what you would do for your customer using list formatting.

L

Well, I will suggest that normally well when it comes to Microsoft police, that I would suggest to start a path of digital transformation, maybe trying this option, because this Microsoft list is included in uh Microsoft 365 subscription. So this could be a solution that could help you uh understand what your needs are and therefore you can keep using this Microsoft list solution, or maybe you can know better what you need, what you, what you need more and therefore you can also choose the other third part party, apps application or paid application.

L

Obviously, but this is a a way to avoid, for example, storing a lot of PDFs or docs document in our organization and providing you with a sort of digital paper that can help you store information through fully documented features and with a free application and so on. So it's just an option it can. It can be obviously used also in production or environment, and a bit of further setup is needed. Obviously, but I think that it's an option to help you choose better with the more awareness what you need, what you don't need, just that.

B

Excellent I think the exciting part of this is there's a wide spectrum right. It's like! Yes, you could implement this in powerapps. You could implement this in spfx or you could implement it in list formatting or you can start a list formatting and then uh perhaps mature to more complex things that grow outside of this formatting. So great great example, absolutely.

J

Thank you, beautiful, beautiful, really, great job.

B

I mean it's: it's like holy cow right. We need to get the sound effects for that awesome. uh Yeah, very good and and I mean, while we're looking at that to vesa's point in in uh Federico. It got to over a thousand lines of Json. That is also broken out, I'm sure, um but don't feel like that's unwieldy, I, put links in the chat around tools from Sergey that you could use SP formatter in vs code in a web extension uh for your browser.

B

So there's a lot of things that can assist you uh with being able to control all of the maybe what might feel like unwieldiness of uh Json within list formatting, so don't feel like it's. uh It's got to be that complex. It is absolutely low code uh opportunities there and to start learning with so take advantage of those and reach out. If you have any questions, uh we have an entire repo dedicated list. Formatting samples and everybody likes to assist with those and there's some amazing things there.

B

So definitely don't hesitate to reach out and ask questions all right. Well, thank you to all of our attendees today, both of our presenters Roman Federico. Great great job, um if you are wanting to discuss more with them about this and or you're watching this on demand through YouTube, we got you covered. We are starting. The community calls conversations. uh These are dedicated spaces with our operators. Standing by our presenters are going to be having dedicated threads to each of their demos.

B

Where you can go and ask questions, continue the conversation if you'd like to collaborate with them or others that are interested and passionate about the samples that we saw. So where can you get to those right here? You can use these QR codes uh or the AKA dot Ms along for each demo, put the links and the information in the chat. These will take you to the Power Platform power users, forums where you can continue that conversation. It is free to set up an account if you do not already have one. Don't worry about that.

B

You can set up an account and or just kind of look and see what everybody else is discussing. So it's our way of being able to continue that conversation and give everyone in the community a opportunity to continue to collaborate and keep that conversation going and we're going to start integrating this into all the other calls as well. So keep an eye on that.

B

Well, you may be wondering I want to just curl up on the couch and start up my movie projector uh and watch this recording again, because it was so awesome right. uh Well, you won't be able to do that right away, but within 24 hours you absolutely will be able to on the Microsoft 365 and Power Platform Community YouTube channel. You can access that by going to AK dot, Ms, slash, Community videos.

B

If it says the video is ready for you to download through teams, unless you're in Microsoft, you won't be able to don't try it'll, just in in uh you know unhappiness, but you can subscribe to our YouTube accounts and that will let you know as soon as they are available, uh almost always within 24 hours.

B

You can also follow us for updates on Twitter at m365pnp uh or see updates on LinkedIn AK dot, Ms, slash, Community, slash, Li, the next M365 and Power Platform bi-weekly call two weeks from today: March 2nd 7, A.M Pacific time next week, of course, is our Viva connections. Sharepoint framework call February 23rd at 7 00 a.m as well. You can access all the community calls that we've talked about and you should aka.ms Community calls to get them on your calendar. Thank you, everybody for joining today.

B

Your conversation, collaboration and demos, are what makes this the best community out there. Thank you have a great rest of your week and a wonderful weekend.