Microsoft 365 Community Development, 18 Apr 2019

Previous Meeting Next Meeting

⏯

youtube image

►

From YouTube: General SharePoint Dev Special Interest Group (SIG) - April 18th 2019

Description

Recording of the SharePoint Dec community call from April 18th. The latest news around PnP CSOM Core, PnP PowerShell and the modernization tooling.

Demo – Chris Kent (DMI) - List formatting tips - Using Custom Row Actions

Demo – Chaks (Microsoft) – Uploading files to SharePoint from PowerApps (using Flow)

Demo – Markus Möller (Avanade) – Using Azure automation for automatic provisioning of your SharePoint and Microsoft Teams structures

Detailed agenda and covered topics are available from SharePoint Dev blog at http://aka.ms/spdev-blog.

Download recurrent invite from http://aka.ms/spdev-sig-call. More details on the SharePoint Dev community from http://aka.ms/sppnp.

A

Welcome everybody, this the sharepoint patterns and practices, general sharepoint and development, special interest groups, the community called foods. We are having a biweekly, and in this call we talk about all of the non client-side development stuff. So we don't kind of. We have a separate call for sharepoint framework and javascript development, and in this one we concentrate or more on the other stuff of the of the game, so meaning season provisioning flow power, apps and all of this stuff, which is related on sharepoint development as well.

A

Now, today, we kind of start with a a classic recap of the three open source projects which we are running or open, source areas which we're running in this none SPF x out of the game and then we'll have three cool demos coming up, so chris will start and then I shuffle to the other. Slightly so don't worry about it. Chris I'll start, as always as a list formatting tips demo. Then we move the checks and then we move to Marcus Miller.

A

So Marcus has a really cool provisioning solution, lined up as well and if we have time for the Q&A, a quick reminder and the mics of teams. Yes, there's no point having this discussion in chat window. We know we know. We know we should be moving in we're still waiting for the attendees last presenter capability in themes and we'll move in right after that's available and the team's broadcasting is not an option either right now, but just to recap that one just a reminder for everybody.

A

If you're interested on participating on the community, you are more than welcome to being us and volunteer for doing like demos or are showing a technical pattern. We obviously want these to be more on samples and guidance and sure if you have a product or a pattern or a solution, if we want to present from a pattern perspective- and that's absolutely fine as well, but we don't want these demos to be- let's say product two demos, because that's not what this community is all about.

A

You can absolutely contributing kids, often a lot of repositories available for you and then you can provide feedback and please provide feedback. So we know if something isn't working for you, so we can fix that three different assets and just a reminder: akms SPF Docs, the documentation, guidance, AKM SSP. Their videos is breaking actually 10,000 subscribers within next week, which is pretty cool and then SP. Dev issues is our issue list for recording anything related on dev topics.

A

So if you're missing a he's dealing an API or you have some other issues relate on development, please let us know a few kind of announcements before go to the recurrent recurrent slides. So it's just a few reminders: provisioning does SharePoint PMT comm is in public preview. I wrote a updated plug post on this one yesterday in the SharePoint Dethklok, not diff, lock the SharePoint log. So please test it out.

A

This is an awesome tool for you to generate SharePoint, leuk, leuk kind of sites as a demo sites or as a starting-point site to any tenant in a well. So, as long as you are a tenant administrator and you can actually provision these templates to your tenant know, some of the templates have pre requirements like you have to have an app catalog in a tenant or you have to have taxonomy administrative permissions. So please check the template and descriptions, so you can match the pre requirements, but a lot of maturity of the loop book.

A

Tenants are mainly there for you. They don't actually have any pre requirements other than you being a tenant administrator, but please give us feedback. It is now in public preview. We refreshed slightly the UI actually yesterday as well. There's also better exception handling in certain scenarios and more descriptive error messaging. We're looking into getting this one. The more reliable will improve.

A

The experience will improve validation and this actually tries a lot of the engine where it will which we'll talk about in a few slides as well, so the provisioning engine work as well and because we are looking into integrating disk to office, 365 developer, tenants automatically and all of that stuff. So, there's a lot of a lot of things happening related on the provisioning now the second thing: what I wanted to kind of a reminder? If you missed this one, even though this is not the SharePoint frameworks, a community called Scioscia pond framework.

A

One point: eight point: one is now available. This one is addressing a few regression: regression switch, we had in the 1.8 release and we have an updated set of training materials available for upon framework.

A

So if you wanna, if you are a client, if you are a generic SharePoint developer, this is say: the training material is a great way of learning how to do ship on framework development as well on top of the season and provisioning, and all of that what you can do in here now, let's actually move into the PMPA, some core library and quick update from there and urban I think you're ready to do a quick update on this one yeah.

B

Yeah, so latest version has been out now for for a while already so what we're doing currently is working like crazy in getting the PPV provisioning engine up to the levels of the schema, so the vision schema has been published in our latest version, but that's just a schema. Now we're doing the implementation and there's all kinds of interesting new goodies coming in the provisioning engine, and our goal is to have that.

B

Actually in a working state before the shared conference in Las Vegas things that we will support, for instance, the provisioning of teams, you will be able to set the kind of a lot of more properties on modern clients, right or client-side pages or modern pages things like section backgrounds and all those kind of things, different headers. You can all set them the provisioning engine now actually already in the deference you've used that one it already supports, setting to side header and the site footer you can enable the mega menu, etc, etc, etc.

B

We actually it took us a while, but finally it is now possible in the provisioning engine to set author and editor fields on based items that you're creating or documents you're uploading. Finally, that support is there, so you can upload documents as being authored by a different user.

B

We that's more of the internal workings because we're calling out to the craft for things some things specifically teams. We there's a bit of a challenge, sort of complexity. There is like okay connected to a SharePoint site. How do we connect that to the graph and make the desimilus possible?

B

We have ways around that from a code perspective, there's an entry point where you can provide your own access token, and then we will use that token throughout also in PowerShell, and that's maybe something if you can flip to the next slide, because I'm sort of moving over automatically to PowerShell here, PNP PowerShell, because they are so connected.

B

So in PowerShell we're working on now a very seamless experience where you do not get an additional authentication problems. You will just connect once to your site with username passwords and then we'll take it from there for you and I connected a graph with the correct scopes, etc, and and do the work for you behind the scenes. The provisioning engine there's a lot of work going on there.

B

So I'm very excited about this new release, a lot of new, really exciting from sanity coming in there and and you'll notice that we're moving more to like tenant level, although we're not forgetting about the site level of provisioning, as I said already, documents list items and their own site level, there's many many many small changes and updates and fixes and additional properties that pop up here and there.

B

So if you haven't looked at the schema already for the provisioning engine, the latest keema, that's the 1903 schema I would have to be advised to check it out if you're interested. What is coming a little marker. What we do is we build our code. We merge it into the dev branch. So if you have the current deference, you use that at your code base- and you will see things for purpose on- that's really a given that it will work.

B

If you compile it, it will probably compile that's when we make sure it will compile, but there will be bugs because it's a dev branch keep that in mind. So when we release it, then the bug should be gum as much as possible. That's.

A

It for me, okay, so yeah and just to recap a few things. What urban said so really big thing here is that the templating the model is now going to reach outside of the SharePoint so and what it means in practice are trying to oversimplify things. Is that you're able to create a definition of a tenant? As are able to say, hey, here's, my definition of a tenant?

A

We will have five site collections, these teams, then these channels and these taps point into these Microsoft SharePoint sites and the indie sites will have these kind of webparts and modern experiences and all of that and then you're able to stamp those definition to any tenor. So that's what it means in practice, so really really cool stuff, so team support, Azhar, aiding user support, looking at the email, inboxes support and all of that stuff. So right.

B

Yeah yeah you've mentioned briefly mentioned- is ready, but we are. We will allow you to actually provision users to the azure ad and yet an assign SP excuse to them.

B

That will come to okay.

A

So really really really cool stuff extended above SharePoint now quickly on a modernization, tooling, Burt Johnson is not joining on this clock. Hopefully, unless you say anonymized his name: here's on vacation and hopefully having a summer working family vacation, quick, are played in here. The main, and the big thing here is that Bert recorded a set of webcasts. So if you're looking into doing a SharePoint page transformation, basically transforming classic SharePoint experiences to the modern experience is there's now a series of webcasts and videos which are explaining how this tooling can be set up.

A

How does it work? How do you configure done and what does it actually contain and all that, so that will be probably highly beneficial for you if you're looking at making this happen? Obviously we want people to move to the modern and, and all of this tooling is helping them people to make a transition from the classic very insisted on so really really cool and, like mentioned on the I on window David. Thank you so participate support is now in preview.

A

There's more updates coming up on all of this stuff later and what we basically want to do more and more in the future is help you to adapt the modern experiences, because that's where the investments are, that's where what we're building together with teams, people and integrating teams and all of that greatness, so making this transition from the classic SharePoint as easy as possible is one of the key objectives. What we have in engineering and also in the community side. So please keep on giving us feedback on that now.

A

I think that's it for the quick updates in less than 15 minutes. Yes, we're getting make making better and progress and ear. So we get to the demos. So we have changed demos coming up today, let Chris start and then we move to checks related, a Chris will talk about list, formatting and customer actions. Checks will talk about uploading files to SharePoint from our apps using Microsoft, Flo super cool stuff, and then Marcus will talk about using Azure automation for automatic provisioning of your SharePoint.

A

My team structure, so super cool stuff, really great demos coming up, but let's jump on Chris's desktop. We are live from where Indiana endemic.

C

Umbro actions today, so we talked a little about these in the past couple of times, specifically around launching flows, but it actually got a lot of questions about these. There's a little bit confusion on how to put these in what they do.

C

Why would you use them and how you doing all that stuff, so we're going to cover that so the way these work is right now, if I have a list with no formats right, if I click on something I get these buttons up here, I got I can edit the share, and all these nice little buttons. I can also, of course, click on the title, and it opens up the the panel over here.

C

You can also double click anywhere in the item that it does the same thing right and that's okay, but just like we've done before, where we wanted to take away that need to come in here and do flow and all that stuff, when you select, if you want to be able to bring those buttons down here or bring some of those actions directly into your list, items there's support for that.

C

So if we come in here we're going to call them settings, we have format this column and we're going to do something like looks like the nelem type and we'll make this a button. So this is very important. Customer actions can only be applied to button. You can put them anywhere, but they will not do anything so if I say, custom row, action- and here this is a guy like this, so we got put in an action inside so we say action in this case. We're just going to do that default click.

C

So we're going to imitate what the title button is doing. Alright and of course we should add some text content.

C

He sounds good.

B

C

A helpful thing to give loaded comma and we preview that right we get this beautiful button here. I'm gonna save that because we a little bit of weirdness, sometimes refresh that now when I hit this Wow, it does the exact same thing: title very.

C

We can go a little further with that right. So maybe you don't want a big gray button on your screen here, which makes total sense to me. So we've got a series of samples now. So if we come over here to our list, formatting repo, alright, we come down here to column samples, you'll, see. There's this brand-new one called generic row actions and then here there is a format for each one of these different types of actions.

C

So you can use these, and these are this fairly simple versions of this, to kind of demonstrate that we're going to apply these, take a look them in action, so you just then cut and paste those preview that so now that's the exact same thing: we, unless it does look like a button anymore, because what we've done in here as we've added children and some styles, so some of the styles that made that weird gradients from 1998 they made that transparent right.

C

We added a child here or we're just adding a nice icon called open paint all right. We can do that for all of these, so it's pretty straightforward with a little lures when we save it so we'll save that one over here to edit action. I'm gonna do exact same things. You guys can see. Some of these here have one thing with the Edit action right with paste that you'll notice up here that the action I'm using is edit props after using something like Visual Studio code.

C

You'll, see that when you use edit props see that right there, it actually says that's not right. You failed because it's a it should be Edit item props. That is a bug in the schema, so ignore that it is edit props. Okay, now the reason it's called any props and not just edits, because it's like the same thing for document libraries right when you go and you edit the properties there, so we hit edit properties.

C

We save that again simple, icon type thing here over here: let's format, this one that's going to share and we'll demonstrate all these, so this one has a custom axe. A share very exciting. Over here we're gonna go to the lead action format that column I'm going to grab this. When you get me getting all of these in the repo, so I've got a little fast on purpose, so we go here. We see action is delete, so let's close these for now, all right.

C

So now we get this edit action which again opens it all the way in edit mode. This is going to work nicely if you've already customized here and list form with power and power apps. All this didn't work exactly the same, so you don't do anything different. The shares and open up this nice.

B

C

Thing so I can send my link to my hello item or whatever I've got here. Alright and delete is going to prompt them to delete it. Alright, so obviously you can't just straight-up delete it, be even prompted for them to delete it now. So this isn't super helpful right necessarily to put these here since they're already up here. It does prevent us from having to come up here. Select an item didn't choose that it. So there is some compliment there.

C

It's even more helpful in a view format, however, so neat over here or something like this. Alright, you can see. This is a view. Format, we've actually wrapped the entire thing in a button. So if I take a look at that for math carnby, you can actually see the entire affair matter is wrapped in a button. Don't necessarily see that, but by doing that, the entire item is now able to open it up. So you can do that as well. We've got some other formats to show individual buttons kind of linked in there.

C

You can do some conditional showing on those which you can't do is the condition for the action and, of course, we've seen this one before right will reformat the flow. So let me grab my execute flow, so this one's slightly different, which we've seen and that what we do this one we'd only have to provide not only the action of execute flowing or ID the ID of the flow associated with this list. We've covered this a number of times or some samples, some guidance on that.

C

So I'm not gonna, go into real details on that, but one of the things I wanted to point out. That's pretty cool! Let me refresh just to make sure I got everything here. There's when I do something like the butter is turned I do my flow action. This flow has already been associated with this list and for selecting items all right, so you come here and I say: run flow now watch what happens to you. This is pretty cool, we'll see, watch this butter is turn. Is it all over that?

C

So we had a live list update right, so the butter has turned suddenly got an exclamation mark, a very useful flow right. So that's what we can do with that emphasize flow, but that's really interesting. The idea that I didn't have to refresh this. So let's take a look at this a little more detail, so this is cool, but what? If? What? If we're the horses? We just saw this presentation right.

C

We come over here to our skander warrior horses site and we want to see this in action, maybe in a little more elaborate way, maybe less useful, put more elaborate so to come into this secret lab where experiments are run on these horses, all right, so we'll zoom that back out, so we got ourselves a nice view format here right. The thing is, we could take advantage of. So we've done. You know an elaborate view. Format, let's refresh make sure I got so we don't lose all my.

B

Connections all.

C

Right, zoomed out too much reset zoom, perfect. Okay, so we've got my experiment here. Going on I've got these nice buttons over here that I can style any way. I want right. I can put images inside here. I can make these just buttons, like put all sorts of elements, icons. Everything else, bribed reports just to open up the list.

C

Item pane, alters into some kind of edit all right, killing the experiments, not the force itself right will delete it and notify, of course, and provides that share list, but here's something else we can do all right. So when we take advantage of say starting or flow here, we can begin the experiments. We run that, but it's one of the cool things here is that we have those live list updates before you'll see that your format actually can respect. Those live list updates themselves.

C

Alright, so, as you think, XQ things in the background, you can keep your list view up, there's almost a dashboard of things right. So this is a little bit of a strange experiment in some of this, but you get the idea that this quickly becomes really powerful. So, as other people are heading things behind the scenes, right or you've got flows, long-running flows or updating things or other things are triggering. You can keep something like this up all the time and keep that going all right and you can even.

B

C

Different flows right so I've got a halt experiment. So you get the idea that this son, that you can't was really really powerful and you can do so much more by integrating some of these things with either flow or these lifes live ListView updates with your view and column format, so whoo all right. Let's review real, quick, so custom row, action only works in a button element, but use those style and children properties go fancy in there all right. There is some weirdness with the data redraw. Let's just saw that was refreshing.

C

So if you apply this and your format and you've just done the preview and it doesn't seem to work hit the Save button refresh and it should work, there's also some interesting stuff going on. When a list item gets updated, there's an open issue for that and again you only need that action frames if you didn't execute flow- and this is an important one. This is the one of the only items and all of this formatting where you can I use an expression and that's in the action property.

C

So if you need to have a different action for your button, you're actually going to need to use our display:none trick and have two different elements for that. So here's those actions again got default. Click Edit, props! You got share, delete and execute flow, very exciting, again ignore the schema.

C

These are magical so take advantage of those the only real sadness right now and I'm, hoping yet work in the listed library webparts. So it's only something: that's live within the ListView itself, so.

B

But take advantage of that I.

C

Think it's really really powerful all right and last but not least, here is where you can find those samples they're going to take a look at some of that code. You can go over to see our reactions. We've also got a little more details on those start flows and.

D

Then, if you want.

E

C

Where we've integrated inside a larger view, you see the contact card format or we wrap the entire view in an action. If you can see in the bulletin board format. Alright, that's it for this week's site. It was for many tips.

A

Awesome or some thank you, Chris really really really great stuff, and it has to be something in the air or water in Indiana related on the demo content like my winter, but yeah really cool stuff, and these are great samples and like set the repo has all of the samples available for even anybody and I know that Chris has done a good job on clarifying. If there's a list dependency, it is defining what kind of list has to exist and what other columns and all of that fatherless but I think that's it from this one.

A

So, let's actually move checks to your screen for a next time, all related on flow and perhaps I.

D

Mean can everyone see my screen now yeah.

A

I got it that typically means that other people in the world got it as well. Yep, there's a confirmation, so thank you, Chuck's just take it away. It was so.

D

Today, I'm gonna be talking about a topic that many MVPs have tried and are still trying to get this working. And yes, the product team is also watching the power apps team to make the scenario even more better. The ability to upload files to a library whether that be images or documents doesn't really matter right. A file is a file a power now this could also be in custom format.

D

If you want you, but basically through power apps now there is no native support, so we need the help of the awesome flow to basically help us get the image from the power app and then put it into a SharePoint library. So there is, some I can freely involve here this like a few months back. This was really a cumbersome thing.

D

The only way the only person in this planet that was able to do this I'm, not joking, is gianlu the MVP, for you know, office and and whatnot like he is really really good in microsoft flow and he is kind of the hardcore developer that has choose and Microsoft flow as his language. You know we all choose. C, sharp and JavaScript and tend to be happy with it. John chose flow to do all of this things that he builds in this time. So he showed us a hazard function, a way to build a magic function.

D

Take the image that you do. You pick in power-ups and then convert that device through an agile function, get the bikes back and start up flow and then push it Bob. That's like really really hard and I do follow this blog and, and you know, on April 9th they actually blocked about how to upload image from power apps to flow using an unused outlook light.

D

This is that kind of kind of like intricate, minion and I went through his blog post and I saw all the things what he was doing and and finally that led to what the problem was. So now we are actually in the product team discussing around hey. Why is this different? But where is it this problem? And things like that, so kudos to you, know, John and several other MVPs that have been helping us understand what is going on and and and take through that, but the good news.

D

You know the unblocked I wanted a solution, something that you can use flow and and not as a function, because that's something you need to write code. So let's look at the demo. What what I'm doing here so here I have a simple power. App app I have a picture control that you add in the power apps and a button upload to SharePoint and here's all of my images from my library.

D

So now what I can do is I can select a picture from my computer and then that's going to basically show me a preview and then I'm going to basically now upload to SharePoint. That's going to do its magic. I have noticed that, since my email is just a really big, like maybe 15 MB or something it's taking a little bit trying, but you can see that there's a progress bar on the top, that's actually showing and the button is disabled, meaning that it's doing something with the flow.

D

So hopefully this will get done in few seconds.

D

Is everyone still with me? Can you see the screen? Can you hear me properly toast at Narrows yep.

A

Noll kid: okay, you're not presenting by yourself. That's always a good sign, excellent.

D

D

Image: flowers, so that's the demo and and that's all with words, so what I'm doing behind the scenes? Let's, let's look at what is happening in the power at first before we go to the flow.

D

D

I'm glad you're not working on it anymore and we are getting things ready.

A

That's by the way, a clever thing.

D

D

D

So if you look at what I'm doing in my button, there's a cool trick, this is how usually you type right. So you come and type expressions here, and this is ok, but for have a background in writing. C, sharp and JavaScript code. You really want a really good formatting in a way that it is similar to how you write code. You can do this format, text and walk. It actually now form hit everything like like a code.

D

So it's pretty cool and an easy to read for me, rather than you know, being in this state to continue like a line so really cool tip, using power-ups and and writing expressions. So what I'm doing here when I click the upload button, is I'm going to set something available file path and then I'm getting the value from a flow.

D

So this is calling a flow of power as file approach, SP, dot, 1, and then it's sending the uploader image that you picked from the control and the name of the file that you picked from the control and that's it and that's going to execute that's going to set something in the file path and I'm.

D

Just if the final part is not blank, then refresh the data source here is a demo day of data source and I use the semicolon to continue that statement, for the condition being true, there's reset the add Media button, which is the control the picture control to true. So this is what happens really really simple thing to call now: let's go look at flow and he was the power apps file upload shape. Why so?

D

This is basically a flow with a trigger power, apps figure, and then that's how it you can relate to the powerup one of the things we found out that the problem.

D

The reason why you're not able to use to create file directly with the power ask is that one of the things you do to get input from the power apps in your flow, because you just go to you know that's a property in any action and then, if you want this to be something that you take a dynamic content from power apps, all you do is you click the seymour, which is the power apps trigger and you can say, ask in power apps, so I'm going to do this now, so it's going to say, ask in power apps and it's going to create, create file, underscore file content, and this is going to be the type of this file content property right.

D

Similarly, I did the same with the outlook. Connector send an email for the attachments content, so it generated the same email address concept. Now, if you go look at this power, apps trigger and peek code, you can see what is it type and what it is getting returned. So you can see attachments. Content is bytes format in a string right.

D

It's a format of by spring type, so you're going to get a bunch of strings with bytes and then the file content which I just added it shows binary, and this is the biggest difference why it works for Outlook and why it does not work for SharePoint. So we are requesting binary but they're, not getting the right things back from share power, so they're working to see what is you know what is going on and even for bite, I get a large spring. Beret I! Actually don't get a bike.

D

You know I have to get an array of bytes, so if they want to really build that image, so we are working to understand what is going on, but right now this is a workaround. So you add an outlook connector you go to that outlook. Connector and you say: ask empower apps that will put the right parameter the right format and then you basically use that parameter as the input to the file content property for the create file, and you make a condition such a way that your flow will never go to this outlook.

D

Send an Gmail condition. Write 1 is equal to 2 and we're going to be or in the world of horses. It could be so be careful when you're there. Otherwise, in this normal world, 1 is never going to be equal to 2, so you're not ever going to go to this condition will always come back here and that's how this whole magic works.

D

So if you go look at our runs that we just did, you can see that now here, I got my schema and output is just you know, click to download and it's going to give you what flows got from power apps and what they store- and you can see here is the string representation of that image. So somehow, if you make the format as byte, it works. If you make the format as binary, which is what SharePoint action you know ask for power apps to send this doesn't work. So it's a it's a simple workaround.

D

Yes, you need to know about this a little bit and it's not native yet, but it's a really really simple: workaround dan Hawley and add your function and and basically trying to do some.

D

You know connecting from flow to Azure and getting all the data back so gianlu blogged about this in detail, so I'm going to paste that in the chat window here, so you can follow the steps from the blog post and and basically build your own power apps that can upload files to SharePoint using hello, which is pretty cool actually now yeah and that's the demo awesome.

A

Thank You Jax, really really cool stuff and really really useful having those resources and the demo available, let's go to Marcus and while Marcus is starting, the sharing just a note as well as generally yes, humongous amount of awesome stuff on his blog posts related on flow and automation, so really really great resource cute. Maybe one thing checks: do you know? Is there a file size limit for the stuff when you're uploading for the files.

D

Something I'm still exploring yeah there's a limit both on like how much bigger file could be in the power axe, and then the limit are how big a file you could upload into the SharePoint. So right now this is using I would say: yeah it's.

A

Fine, it's fine! Okay, okay, thanks jerks, now Marcus we can see your slides, so I can hear you that's already a good sign. Yeah.

E

A

Don't have to do this and as a pantomime presentation that would be fun, but I think it's time we should have a sufficient amount of time for you to do the demo as well. Let's see if we have time for Q&A and oh and take it away. Thank you.

E

Yeah, okay, yeah, hello, yeah, just give me a short, decent, quick introduction, because it's the first time for me to present here in this kind of course, so my name is Max. Mara I'm from Germany I worked there for other, not I, have a Twitter account as well for sure and a personal blog, where I write about things, for instance, about the topic. Also that I'm talking about right now- and this is about provision English with Azure automation, so I think as automation is quite an overt service from Asia.

E

But it's not that popular in use, I think around a SharePoint site and provisioning as well as teams, provisioning, I haven't, read so much about it, but I'm using it for quite awhile now in customers and areas, and so on. So just give me some quick basics why you should also think about using it, so the setup I was to show you in a minute.

E

Is they are quite simple and I think a bit simpler than other comparing technologies, for instance, when you have to set up an area function or a web app also takes a bit longer. I guess PNP PowerShell I think is one of the best tools to work with SharePoint, especially with SharePoint provisioning. You have to need less lines of code for achieving results here.

E

The thing is in the demo: I will show you that you can use the same code base, meaning as around books for administrative reasons, as well as to connect them to your provisioning engine. This can be an lightweight approach with really less lines of code. Rome I show you in the demo, but you can also, of course, scare this up to high end solutions and, unfortunately for user requests, or something like that. Of course, you would need for a specific UI and connect this to your unboxer.

E

This is not my topic today, but I show you on the administrative setup. So the first thing what we need is we need the automation account in Asia. We have some ones here and for today we will use that one in that kind of an automation account. We have, of course, our run box compared to a minute, and we also have some configuration assets, for instance like the powerful modules, where you're explicitly, for instance, have to upload your sharepoint PMP PowerShell module, which is not out-of-the-box available. You can have your credentials here.

E

You have some variables also have certificates. I used this right now for the modern authentication way. We show animal code in a minute and that's all so.

E

Now come to our most Ram box. Indeed, are you in my case or nothing else than PowerShell scripts? We have one parent run book here, which I'll show you next and we have some child ran books which we will call one by one. So first, we we'll use the create team to today, because these are optional. Once in my block, you can see the difference here. What I tell you in a minute, so we will first create a team. In this case.

E

We will then go to provision staff with the provisioning templates and finally, we do some further steps which we cannot achieve with provisioning templates right now. This is roughly the pattern I often use to provision that well. The first thing is our parent handbook. We of course need some parameters here, such as the GI desired, alias a display name, the description or an owner.

E

We get some yeah, so here we can, for instance, get our credentials from the assets dawn, so when we quickly, for instance, would remove this. We can also get this from here directly and add this to the canvas once again I'm getting some I use this it's a bit old-school, maybe but I use an XML parameter for mix and mastering for several parameters in one variable and then here we go and we'll call our first yeah SAP ran book and execute this.

E

Once we have this, we will retrieve our team, which we got and then next with this one, we will check if our site is ready yeah. This is um this is a typical pattern, also in a while string that we check for several times if everything is ready so far during provisioning, because the the speed of obviously is 8/5, of course you know, might differ from day to day and for this is a cool pattern, we will check this for several times now.

E

It's in the side is ready and then we can go on with our second run book. Finally, our our third one. We can test this now.

E

I'm sure you know meant that the rest of the time, but we can already kick this off. I, did this in preparation. We will just change some parameters here, so we have our team and desired Elias. We have a display name our description and also an owner and pick this off and now it will run.

E

Still in the queue but shouldn't they go now, it's already running um you don't have a life output here um this was in the past. It was working like that, but since the why it's not available anymore, but in case you need it in this test pane, you can still use refresh job scream, and here you see that we are already on the way. So what we can see right now we are already connected to our tenant.

E

We created a new team with the desired display, name and alias the team got created so far, but it's not ready yet because under the word still things are going on.

E

Okay, this tank sometime. In the meantime, we can check the RAM book, which is currently on its way, and this is the creation of team, and here we see already what we saw on the output that we connected first against the Microsoft graph with an F ID I have secret and our tenant, which we got from the prof on the variable store. Then we create our header and what we do in this case- and this is my create team, run book tool. This is the currently productive approach to create teams.

E

We first will create a group without we first will check if the alias is available. Sorry and then we are going to create a group here, we build our request for that and then finally, we kick that off and from that group we afterwards create a team request to enhance this group to a team. This is quite that scenario which you might have already seen, for instance, in a video on proud of your lousy, was showing a couple of weeks ago, I increased.

E

This only was desired, alias and also adding owners, because I think creating groups without owners is not the best practice. So this was the first one. We can check by the way back to our test scenario, which quarry is gone through.

E

So let's jump up here, so we saw that our team did not get ready so far, but was one we try. It got ready and then here already our provisioning run box starts this may be. We first have a look into the coke here. The first thing we will do. We define the function here to download the PNP tablet because the PNP template um you know when you run your power using you use from your file system.

E

In that case, running in an azure automation account we will download this from Asia, blob, storage and so I can show you in a minute where you find it for the blob storage. We need our credentials and also for connecting to to SharePoint.

E

This is our credentials we created. This is a bit more complex here, but I love to work with the model of Education. Finally, I will tell you why this all stuff, you could also replace here what we are doing in this lines of code, was just a simple get credential, but modern authentication with an app restoration is much better here. We connect then against a SharePoint, and then here we have our template, which we download. We saw the function above and finally, we only applied this up against the side.

E

So how does it look like in that as a starch? Here's our template and there is downloaded. The final thing is doing some further steps. I can quickly go for the to that which is currently not possible with PMP provisioning. We just decided to create another team tab and therefore, in the final run book once again to make sure we have it. We connect against Microsoft graph. We create another rest request header. We create the request, URL the tap request, where we, finally whence the URL. Here we create a URL against a list.

E

I'll show you in a minute which we created with PNP provisioning, with our template, yeah and the final result in our just list that everything went fine here. We have the download of our XML template, which was done to the local of running environment, of the automation account and then, finally, if the provisioning is done, this was the second round book and here already starts the third run book where we are adding the top against our team and then. Finally, when we switch against our team, we have team number 15 created.

E

This is standard, but this employee is list which we show up here was created by PNP provisioning inside the team side and finally show you. The team is the template that I used for that, so I'm, creating here some fields, creating a content type, creating a list instance and finally creating lots of data rows for a reference list for sorry. First, and here are all our employees, which we just saw, that was my little demo.

E

Finally, some lessons learned from this thing when I have to create a site or team, whatever I used the pattern that first I tried to solve my requirements with a provisioning template. If this doesn't work, then I try to use PNP PowerShell before or after provisioning.

E

Finally, you saw this in that case because does not work creating the tabs so far, I use a rest methods, for instance against graph or SharePoint whatever you can also try to use FIFA methods inside PowerShell and what you can finally do if nothing helps I also did this in southern cases. Is writing your own powershell commandlets?

E

We also made migrations with pet approach. In that case, we do it a bit different. Don't handle one side in all steps, so meaning creation, provisioning doing forever steps. No, then we do just speed up a bit. We would first create maybe, for instance, 400 sites, then go to all 300 sites and provision them and then finally do the additional steps to all hundred sites afterwards in India.

E

Finally, the thing is when, when it comes off indication, what I found out is when you work with the modern app authentication, you saw lots of problems on top, such as multilingual bugs, because you don't have a user service account which might not fit the current language, and then you get issues with PMP provisioning. He also don't have to handle. Even when you update science, you can also use this for administrative tasks. You don't have to handle getting admin, site, collection, admin access once again and remove it afterwards.

E

If you want to do this now, you always have this access when you have to write your installations and so on. Yeah, that's for my site, thanks! So much for visiting.

A

Thanks thanks markers, really really great demo, and actually that's that's a really great explanation- how we are using those different pieces and bits and pieces on the on the UI. So thank you for clarifying and the learnings are always good. Learnings are really good on the demos as well, because they help other people understand what you've gone through and and and then you're sharing your learning, so they don't have to bang their head against the wall, so to say. So. Thank you for that cool.

A

This is quite rare. This is how it should be. Actually we have almost ten minutes of Q&A time in the in the end of the call, it's a really nice space related on the general announcements first and then three demos, and we have eight minutes time for if there's any ad-hoc, Q&A stuff for anybody in the core. Maybe one thing what I wanted to well, while we're waiting for any questions I anybody is interested. I actually recorded a new video earlier today related on the app pages in SharePoint Online.

A

So, if you're interested on having a look on how the SharePoint app pages can be done and how they actually are visible in the modern pates layout picker, there's a video available in the SharePoint dev YouTube channel around that one, so that one shows the the modern page layout picker as an example which is now currently being rolled out to target release, tenants and but also then, if you have any of the existing webparts great a new web part.

A

How do we expose that as a single part at page and what does it actually mean in practice? I, don't I, don't want to steal the the tongue way from Q&A, so I'm not going to do a live demo at 1:00 today, at least, but any other questions.

A

Thank you. Thank you, Julia on always comments. If anybody is wondering, obviously the community calls all are killing recorded and the demos are getting released as an individual videos as well. In the share point of YouTube channel, the recordings of the full code will be out tomorrow and then the individual videos during next week. That's the typical time frame and officially tomorrow is a public holiday. We run currently located, but I'll think I'll find time to push out the blog post and the video. So that should be fine.

A

Is there any documentation on using this sequence: property for SPF, ex extension, sequence, property sequence properties around the order, so that should actually work properly now do we have it documented? That's a fair question: I'm, not sure if we actually shown that, but basically there's a sequence attribute in a custom action, user custom action element.

A

So if you have a look on the classic documentation of use, a custom action element which we generate for you in the solution by default in the client components folder, if I remember to folder correctly, you can add a a sequence attribute there and then say: sequence, 100 or 200 and 300 for this one and then the number one sequence 600 or whatever, and that will then line up the order of the user custom actions for the buttons in the right order.

A

Any plans of splitting the augmentation between SharePoint, Online and chef, Anthony and I think even the whitening cap of capabilities. That's a fair question from Paul related on the documentation challenge. This is a nasty resourcing challenge as well and because and then managing to pieces of documentation is quite hard but I think sooner or later we need to figure out. How do we do this because and I think we're looking into having another on-premises version at some point?

A

Maybe who knows, and then sooner or later, there's going to be an even larger gap between dough on prime versions. So we need to be more explicit. What supported and we're so very to feedback on that one. So you know took me that something the community may need to step on to help them yeah. Looking for a good shipment framework, wrap a story that goes from no framework to react to something else: suggestions the toriel's, also something getting stunning. So we do. You have obviously Eric. We have two tutorials in the documentation.

A

We have also hands-on labs as a reusable SPF X training package from Android kernel, so there's answer labs over there as well, but I I'm, not sure. If we have a int and longer story on how do we start from a no framework and then move to react and then to something else? To be fair? That's a quite rare case that that would happen because and I would say most likely, customers and partners.

A

They settle on a specific framework, so in a certain partner they decide that they will do angular, so important will decide that they will do react and certain partner recently decides no framework. You know, and then they have a standards on that, but no one step at a time, a guidance and dance any timelines for open sourcing. The provisioning was it provisioning service, so I can't actually I. Don't have an exact timeline on that one for the provisioning service, the provisioning engine itself.

A

So all of the the goodies which are actually making on the automation to happen. That is actually open source already and you can open ously use that use and be any powershell, and all of that so getting the the provisioning service released as an open source solution as a reference solution is still pending on my table to say with our legal.

A

That's basically what's supposed to happen, so it is on my table not going to happen before eastern holidays in a scandinavia, there's an Eastern holidays starting actually today and we'll be back on Tuesday, but fair point. I will actually work on that one starting from next week. Good reminder on I'll just try to start again pushing on what is needed actually to make that happen.

A

Webhook discussions Markus is answering those on the on the flow on connector is good, definitely and transitioning. Yeah yeah, fair point, Eric I understand the feedback for flow. Is there a way to script out settings up request for approval? It's probably a discussion with markers I'm, not that I. Don't that question from Paul any cards available, creating custom site provisioning template you can actually extract, but I think we have actually even videos so you're able to extract the templates from the existing sites and also on the provisioning templates.

A

I think the easiest way actually to see this is practice. Is our open source templates which are available in the kit hub as well. So all of the templates which are in the provisioning service are open source in this repository which is available in there now so feel free to have a look on them. There's an XML structures, there's an examples: how to make those things happens. That should be fine, don't net core anyone question Ralph, so there is work being done on that one as crossing fingers. That will have great news on SBC.

A

I can promise that yet and I would want to steal any thunder away from possible announcements so, but we are working on that one. So we absolutely understand that that needs to happen. Any new initiatives you need to community health with there's always so much to do.

A

Chef starter kit is one thing with where we definitely need some assistance on making sure that everything is up to date and that's now actually in one point: 8.0 phase, but no new, actual open source projects as such right now, because we're we're to make the existing stuff- let's say more mature and Hugo related on that one actually, because that reminds me on the on the sample portal discussions, no news for that one either at this point, but that is progressing. There's an internal discussions going on on that one.

A

So if we would get a nice portal external portal where people can expose their open source samples and all of that automatically, that would be really great thing, but I think that's it for now our healing tower. So let's actually close up the call. Thank you, everybody for joining and thank you Marcus. Thank you, Jax. Thank you, Chris for the great demos as well super-super demos and we'll get those out in the youtube channel for next week as well.

A

Happy Easter for those who are celebrating Easter this weekend or having a holidays and yesterday's Europe is having quite a few public holidays depending on a country this at this time of year. But thank you everybody for joining. Thank you for feedback. Keep the feedback coming, let's be active. Let's share sharing is caring. Thank you. Bye, bye,.