Microsoft 365 Community Development, 5 Apr 2018

Previous Meeting Next Meeting

⏯

youtube image

►

From YouTube: General SharePoint Dev (CSOM, Provisioning, PnP) SIG - April 5th 2018

Description

Recording of the SIG from April 5th. Detailed agenda and covered topics are available via the MS Tech Community (https://techcommunity.microsoft.com/t5/SharePoint-Developer/SharePoint-Patterns-amp-Practices-General-SP-Dev-SIG-recording/m-p/180089).

Download recurrent invite from http://aka.ms/spdev-sig-call.

A

B

Welcome everybody: this is Chevron Patterson practices, general SharePoint development, special interest group. So the seek me in a special interest group- and this is the by weak link. We do have a few different of these special interest groups which are meeting bi-weekly, so every single Thursday. At the same time, we actually have a SharePoint community call and everybody by weekly, it's around SharePoint framework and BMP chairs and client-side development, and then bi-weekly it's around to SharePoint General dev, and what does that actually mean? Well?

B

This is actually originally meant to be and kind of office hours for SharePoint BMP. But then we started having so many things to actually talk about those, so many new things getting ready. Then we started having SharePoint framework and all that. So this has been more and more evolving to be the special interest group around intern solution, designs, provisioning, automation, PowerShell kind of none JavaScript development topics, even though obviously today will will touch some of the client-side development topics, as well as part of the christian's presentation.

B

But this is really around more on if we want to go through and deep dive on the hop sides. This would be the special interest group for that one and then the other one is more for SharePoint framework and clients, our development now AKMs SP, PNP, community tech, community and you'll find stuff from there again as SP dev dogs, that's the official documentation and location, but this is really around intern solution and it more and more in the future.

B

Probably our direction with this special interest group is to take up one topic and then let's say, go that true from a development perspective. We've done that for hub sites in the past. Now today we're going to talk about column, four matters and what does it actually mean from a development perspective and I ain't user perspective and then in the future? We'll talk about other topics as well kind of a more deep dive on a specific area rather than having a ten minute demo on something which you don't necessarily sure.

B

What are we actually going through now so opportunities to participate with the community, so this is mainly for we're reaching out or seeing if there's any other people who wants to actually do a live, MVP's or non MVPs on this course, and there are different opportunities for you to join the SharePoint deaf community.

B

So you can absolutely demo a solution or a technical pattern in this course or reach out to us and say: hey I would like to have a 10 15 minute spot to go through some cool stuff it and it doesn't necessarily have to be super cool. The whole point is actually covering different patterns and different solutions, and then we can even talk about those solutions in this course. So we'll learn from each other and that's really really important.

B

You can absolutely contribute in a key table by doing pour requests and modifications and under stuff what we were having across the SharePoint github organization, which is really really popular. The numbers are actually surprisingly increasing. The visitor numbers and github are increasing quite fast, and then you can provide feedback and with feedback we mean social media. We main issue list. We need whatever channels to giving us feedback around the SharePoint development. If something isn't right, please let us know we will try to fix that. How fast we can fix that that's debatable, but we try.

B

The key point is that we in a SharePoint engineering we'd know about the things which we start, plugging your let's say work or you to be successful in the SharePoint site, so we can at least put it in our backlog and that's really really important. Now, today, before we go there actually there's a good question from Raymond, because this is pretty pretty important thing. So there is a customized or even issue related ownership and framework on the modern pages, and that is we're getting fixed and it should be actually already getting fixed pretty soon.

B

So we estimate us now within a matter of days, they will say II miss around importance of that particular issue. Unfortunately, in our internal process, but people are now understanding the impact of that one, and now that you asked for that, I will absolutely follow up on the on the status of that one good.

B

Yes, really good comment now. Today's topic I actually have quite a few slides on on going through our announcements and updates on a shape on development. So we have quite a lot of new stuff actually which has gone live. But since two weeks or one week ago, when we had a previous, a special or community call and then we'll cover the : formatting and that's done by Chris and Chris is a some sort of a share point late from a DM I.

B

He will do the his interest in a second but he's an MVP as well, and he has built really really cool stuff for the column, formatting, so I'll. Let Christie really demonstrate that one now before we go there and before we go to the actual column, formatting topic a few things and few areas which is wanted to go through. So obviously the one thing which I promise to keep in all of these slides is the documentation and guidance.

B

So please please, please, if you're looking into latest in latest documentation on the SharePoint documentation, Co, AKMs, SP, dev, Dukes or door strut, my stuff that comes last ship, one you'll find the SharePoint documentation from here. This is evolving on daily basis and there's new stuff and new content. Getting there all the time. You will see a lot of changes in here in the future kind of a I.

B

Don't know if it's sad thing, but as an example, all of our schema documentation from ownit, xml's and feature XML and everything else will be moved in here as well, because that still also valid now and for the past month, we had eight hundred and thirty thousand views on on the things now. Other topics which has happened- and this was announced last week in the twitter and in facebook.

B

So if you're interested on accessing the SharePoint documentation- and you don't have and you're not online all the time, so you need to have something I'll take it offline with you. You can always download a version in the PDF, so this is always up to date on the on the documentation what's available. In the docs that Microsoft has been speak now, so that's kind of a cool for those who are not online. Some people might be wondering.

B

Well, why would you have a PDF download version, but it's a global world and there's quite a lot of people who are working with a not that fast internet connectivity and that option is a great for that now running into issues and just a reminder on that. One, please please, please let us know so: okay, MSS bit of issues, that's the issue list in the Rockstar microsoft.com, which we also use for comments in the docs that myself calm, but you can come here, submit an issue.

B

Let us know if something isn't working properly and then you can absolutely use this community cause. For example, following up on hey the events issue, have we already fixed that what's what's what's what's the holdup and that those are good reminders for us and shape on the engineering to make sure that we understand the importance of your issue and we can then follow up on on making those fixes happen. Now some other topics on March so March was closed.

B

Last weekend we crew actually from a community perspective quite a lot, so we had a 162,000 watch time minutes in YouTube. It is absolutely a period that we can sell at for that. That would be a pretty nice number. Those two 26,000 I've used in the in youtube as well. We had 37 thousand unique visitors and github that is actually growing all the time as well with the script. So people are finding the samples what we have in the github in the sharepoint organization, because that's really the whole point you as a community member.

B

You can contribute those samples we facilitate the and contain and keep them in the repos, and then other people can actually find the samples from the github as well on the doors of microsoft. At home we had eight hundred and thirty-one thousand views. That's growing quite rapidly, as well will probably break the 1 million views in the door. Stop myself from chip on dev dogs by end of may is currently my estimate and on the BMP classic reusable components, usage.

B

We broke 11,000 tenants with in march, and we will pray to ten thousand ten billion requests in march. Sorry in april, which is pretty cool, so the usage of those components is growing all the time, and this includes a BMP CM core being a powershell and BMP jeaious, so open source community initiatives which we kind of attract their usage, you and then a HTTP hitter trackers.

B

So we know how be how much people are using them on the SharePoint framework or shipment add-ins I do not have a permissions to share those numbers, but she opens framework. Usage is really crowing through rapidly, if you're interested on and considering should I actually move to the modern development topics. Transfers absolutely SharePoint framework is more than double on shipment. Adding model, so SharePoint framework is used really really or the adaption is growing all the time, which is great now when other topics are just a quick reminders from last week from social media as well.

B

We do have a new ship on developer portal now available, where we have latest videos and samples and news right now. There is actually, unfortunately, some sort of a clich on the category. So if you go again mrs. PDF samples, you can find the samples you can do a search on the samples every now and then you actually find something which shouldn't be there.

B

That should have been fixed already last night, but unfortunately, that fixed was delayed, so that should be fixed in the portal later today now, but you can find there's like 350 samples on a SharePoint development. If you go to the AKMs s, PDF samples or a game, SSP dev and then samples from that link, you can easily find those samples to be available now. Other topics we released, a new version of client-side object, model still absolutely 100% supported and will be in the future as well, because this is well.

B

This is for managed code for dotnet shriven development, for example, inertia. So there's a new version of the client side of check model which was released in last Thursday. Yesterday, Friday was a public holiday for me and that didn't contain actually that much new and let's say, capabilities, every few things here and there, but nothing dramatical.

B

The same actually happened for the powershell, and so, if you followed up on how do we release these in the in the monthly basis, the both season and sharepoint online powershell is getting released on the same day, and that is the last Friday of the month. Typically, it might be one day flipping here enter if, if needed, but because the SharePoint Online is using season, the client-side object model shipment client-side object model, we are releasing them at the same time, so they are in sync and there's no problems for anybody who's using them.

B

The last thing, or almost last thing before we get the the column formatting and those things we have few more things and quick look on the on the road man. We can talk about the road map as well, but this is something new which went live earlier this week. This is actually pretty cool, so the AKMs SP BMPs or our classic community pages are now in the docs at microsoft.com, and you can actually know much more easily find community core information. Social media resources are open-source projects and the contribution, opportunities and other resources.

B

So we're listing all of the repositories and their usage and what they contain, for example, in these community pages, and what's really great about this one is that these are in the key table. So this is these betas are served from a kid hub, so anybody can submit modifications or suggestions. Or let's say, if we're missing something from these pages, you can absolutely do a pull request and such as an edit on the pages as well cute, one more thing kind of a-- from a newest perspective.

B

Just we mentioned this quite a few times in these community calls in the sharepoint development community doors cause because there has been people who've been highly concerned on the impact of the retirement of the acs, which is dasha access control.

B

So earlier this week I published a blog post in the dev turtlecom, where we actually reference the updated guidance in the asha, a design which is then explicitly telling the impact for the rares acs retirement and the answer for anything related on sharepoint, add-ins or provided hosted, are in shape on how students is that there's no impact.

B

So, even though, as your access control will be retired, it doesn't actually include the in those areas of acs which the shipment adding model is actually using, which is slightly kind of a let's say confusing, because if we're retiring acs, how can one part of a sister? But that is now the official statement from Asha ad guys and I shall side, and this blog post is now referencing the latest status and in the latest article there is an explicitly called out. What does it mean for the shipment headings and other areas of variance as well?

B

But that's really really cute. So this is finally terrified and we have an official documentation which is going to refer if somebody's asking around the SS retirement and what is the impact for that? One for SharePoint development, cool, the fun final thing before I, let Krista to delight demo a quick look on the roadmap. So obviously we've seen the slides so many times, probably in the past months after Dave night, but we've done quite a lot of shaping after the Ignite right now, the next things which will go live.

B

Obviously it's Krupa Phi API, and we promise to do that in this quarter. We're now on the q2 of 2018 that might be happening in SPC, we'll see when we're it's actually going to be announced. The next big announcements will happen in shape and conference at 2018 in Las Vegas on the 21st of May. If I remember correctly and but before the SBC, we should actually have at least preview version, and this should be actually available. Pretty soon, additional capability is available for the site designs, so the native site design capability.

B

So we will have, for example, support for deploying SharePoint framework solutions to the sites of reducing the site, design capability, adding site columns and content types or creating a site, columns and content types and associating tend to the lists and sites and that's going to be available. Regional settings is going to be available and few other things will absolutely make a big fuss out of these acts, actions whenever they will be officially available for you to take advantage within the SharePoint Online good.

B

Now, that's it for the roadmap, no questions and don't window, which I, probably I, probably missed something already, but let's actually move into the actual topic of the day or the to feature coverage of the day which we promised to do and we'll have Chris Kent, who is from MD I. Do this one and Chris is an MVP on sharepoint server, or are you an office staff and we'll be which one is it actually? Oh?

B

Okay, so because the shipment is kind of weird, we have SharePoint developers in both sites in the office, Dave and and also in the office server, and they play a sign. But anyway, so Chris is ready to go. Probably Chris. You can absolutely start sharing your screen and Chris is going to cover basically column formatting the capability and also the different resources.

B

What we have available Chris has also built and super super super cool web part SP FX webparts, which we don't deep dive on the code of that one, but you can actually find where is it available how to use that? And what's the advantages of doing that and using that within your work? What Chris we can see a screen. You are still the mood it. You should unmute yourself and I think you're good to go. I really like the picture. By the way it does.

B

Okay, I'll, let you do the presentation now, if there's any questions which I missed in during the intro on the I window. Please repeat your questions. I will get back that back to Tim, but let's concentrate on Chris's presentation, so Chris take it away all.

A

Right so Ken, my name is crystal Kent. You can reach me on Twitter or there's my blog. All that stuff feel free to follow up with questions about. You know, call them formatting itself, but also about the column kilometer, which we're going to talk about or anything else. I guess you want to talk about if you're lonely all right. So what is oh, three sixty five column formatting. So as you might guess, it is just an office. 365 thing: it's called declarative, modern ListView customization.

A

What does that really mean right? What are we really doing with that? Right so say, you've got the modern ListView right here. It is in all its glory. It's responsive! You know it's fancy, but it's boring right. There's, no more XSLT! For some of us. That's a huge celebration right. We don't have to get in there, but then what are we replace that with right? How do we make just simple customizations? You have turned something red. You add a little icon. Whatever we need to do there. You know, there's no calculated column, trickery anymore.

A

They close that loophole quite a bit ago. Right. You can! No longer that HTML shove it into a number column, you know it's very sad, but what are we doing right? So? What do we need? We don't need a modernist view. We need a dapper ListView, all right, all right. So that's where column formatting comes in so column format allows you to do declarative Jason. You know schema stuff right there.

A

Whatever those words are right, you put it in here and you make it look all pretty almost most things, so you can quickly take what's just a standard list view or at little almost like Excel, you know and make it so it fits contextually for the user or for the sides of the team they're in and really make stuff make sense, no what they need to pay attention to when all that stuff. Okay, all right so like I said it is Jason starts with a JavaScript object, notation.

A

You can apply it directly to the list fields or psych homes so inside when you edit your fields right. If you go into the list, settings go to your field, you get this nice little box. That shows up right above column, validation and you can paste.

B

It right there.

A

Even easier, there's this format, this column menu right on the list view. If you click that all right, it's going to open up the exact same box, but in a little dialog and you can preview it- you can save it very exciting. So, let's take a look. What that looks like okay, so.

A

You got your site here right, so you've got your modern communication site and on here maybe you've got a list right, and so here we got this exciting list, pretty standard kind of to-do list right things we have to take care of, but I'd like to make this get a little more obvious.

A

What's going on here, so I can grab some formats, which I've got over here envious code, all right so kind of the most simple one right here is I just want to change the color of the text to orange right go back over here and so for the title I come in here and I go to column, settings format, this column and I can paste it. If I save that everything's orange, it's very exciting right, you know we can do a little further than that, and so we come back here.

A

We've got you know, say: I want to say every time this tasks were assigned to me. I really want to know about that. So we can use this nice at me, operator. I can compare that and I can easily highlight just the ones that matter to me. All right so I chord is assigned to home settings and I can format this column again. I just paste that jason in there and say even every time, it's pink and again. That is not just you know.

A

Everyone will see the chris kentis pink right when Kermit the Frog shows up his interest will be pink and so on. Okay, now, let's say I want to do something a little further than that, even right, so I mean all of this. Is nice but say I want to do something where it's a little more visual with the checkboxes here, I, don't want to make the complete the yes/no field, its checkboxes I want to use some fancy icons right from UI fabric. You can easily do that with this icon.

A

Name attribute so I'm going to grab that. But the thing is with this one: I'm actually using this column, both on things and other.

B

A

All right so I've got it in two spots here because that's a sight column before, if I go up the side, columns I can edit that sight column here.

A

All right so spooky sound right there, all right here we go so I just paste that here and that same will call them for money, box, I'm, gonna, hit OK and because I'm updating all this columns, it's gonna go ahead and go out there and do all that so I could have done that individually. But by doing this now, when I refresh this page make some fancy checkboxes right and other things also has fancy check boxes. So it's a pretty powerful way to manage some of those formats all right now. What about something?

A

That's a little more visual that looks a little better right. We could take that progress feel the show there's a progress bar using kind of the out of the box data by data bars, so I'm gonna grab that and then I'm going to paste item of this progress field.

A

So here in there and there we go so we've got a nice visualization right. It matches the theme automatically right. If this were one of those awful pink sites right, it would be a nice pink right here, but what about so I've got this other thing right, so I want to notify someone they all want to nag them right, like you need to really install these horse. Lasers right so I've got a flow, it's associated with the list, supposedly all right refresh that page, but the idea here is generally right.

A

You grab an item, select it and your flow should show up here there. It is so send edema about the selected item, but that's not super obvious to a lot of people right unless you've explicitly told them how to go. Do that and how do I do that right? So one of the nice things you can do is you can just set those called a row action so I come in here. I can just create a dummy column right, we'll call it action and I'll go grab another format over here.

A

So I've got this other format called force flow, and here all I've done is about custom row. Action or I've got these action parameters, which is really just that flow ID, which I've just copied out of the URL, the details page of that flow and then I've done some other stuff to make it look exciting that icon and some text content right. So if I grab that, though, even though I don't have anything in this field, I come in here and I could format. This column paste that save and close. That now.

B

A

Action button so right so now, I would have to select and then go up to the menu and selectively I can just directly say, neigh right. It's going to open up that run flow dialog for me right over here and the kind of the standard stuff happens here. I run the flow and it's going to go up. So it's going to notify, whoever that you know it needs to notify. So again, you can see pretty quick.

A

It's really easy to apply a lot of really fancy formatting right and get kind of crazy with it without having to ever deploy anything I didn't have to reach out to any admins right. I, don't have to put anything in the App Catalog at the site. Catalog I! Don't have to maintain that code. When you know SharePoint framework updates, I don't have to run any kind of you know it updates any of that kind of stuff right. It's all just here, all sorted stored directly with the fields which is really really powerful.

A

So let's take a look at what that actually means all right. So let's look back to the slides here, all right. So again, the idea is this is totally not the custom code right.

A

Take that with a big big grain of salt right, because we've got anything, that's got syntax and operations right, I, don't know you call that idea. I call it code right, but the idea here is you get a pretty good set of elements you could apply. You know put out of the page, you can do your content directly with the text. Content. You've got a series of attributes again these are fairly limited, but you can do a lot with them, especially to get creative.

A

We'll show you a little more than a second all right, so there are 124 different style properties, which sounds like a whole lot. But of course we are counting like border and then border left and then border right and so on. But overall it has very good coverage. There's a few things it doesn't have. But again you can find all about the documentation, that's linked down here and in fact, when they grab that link yeah as I'll paste.

A

That in here, this is for the documentation all of that okay and then within that you can nest as many children. So that's I give more elements that you need to. So you can get really complex stuff or you can say pretty simple.

A

Just really depends on your needs and then there's a series of operators and operands right, which is going to cover basic math, all your comparison, stuff, there's some conversion for dates to strings and so on, some logical stuff, like your hands and your oars and there's a nice conditional operator, which is the one you're gonna use all the time. So the question mark operator, but again there are some limits here as well right. So there's not the the idea of like some of the string operations.

A

You might expect right where you can do a left or a right or a substring or any that kind of stuff. But overall you get pretty far with a lot of this.

A

All right so supported Collin pipes, they're on the left, the ones on the right are not yet supported. I will tell you you can work around the file name and document libraries by building yourself of an example of that on the issues list. If you're interested in that you can just reach out, that's something you're really wanting to do. But for the most part this is pretty good coverage. I will say: there's a couple of issues with a few of these fields. Right so hyperlink.

A

One of the issues there is, you can only get the URL. You cannot get that description property as of yet, but there is an issue submitted on that. Basically, anything with a dot property outside of people and lookups is just not accessible to okay, all right but again huge coverage. Here you can do a lot with it and again you can reference, not just your field. You can reference other fields within that same role will show you in a minute. So how do you do all that? All right?

A

So that's where this kind of special text or magic strings, we're gonna call come in the first one. Is this at current field, whenever you type that I'm just going to take the actual value, whether that's text or number or choice or any of those kinds of things and put it right in there. However, you want to use it right, so the obvious example is with the text all right, but the type is respected. So if it's a number and.

B

You want to do addition and you want to.

A

Do division or already there's other kind of math operators you totally can. One thing to note is that there are several operations for dates to get that string. Looking correctly, you'll want to wrap those in that alright, now slightly different what the person feels. So when you've got a person field, you can't use current field directly, but you can access all of these different properties, which is really awesome in a lot of ways right, so you can grab the title, which is really their name. All writing that email address.

A

You can compare that against that me operator or even their picture if you want to use it in an image element as the source attribute. So again, you can do a lot with that. The same is going to be true for lookup fields, we're gonna have a lookup value or a lookup ID generally you're only gonna want to lookup value, but I guess if you were really interested in that lookup ID go for it right, alright, so other fields. How do you reference something outside of the individual field? Retin right?

A

So all you're, working with is the individual field of a column on a row by row basis right, so you don't have access to other rows, but you do have access to other values within that same row and the way you do that is, you've specified the internal name of the field inside two brackets with a dollar sign in the front alright. So this is how I write access the title and another field.

A

You know the same thing is going to be true for any of those person fields with a look of fields: you're just going to do the same kind of dot notation right inside there, so I can do author, dot email or whatever look at this dot, lookup value, okay, Iraq!

A

So then we've got this powerful little thing called at me. So this is one of our context, values and that now is the other context value. And so what will happen without me is every time use that it resolves to your current users email address, so that's how we did that current user. You know kind of highlight it before so. If we took a look at that, you can see we're doing this.

A

Is that conditional operator, which is this is basically an if and if it's true right is the first thing and if it's false, you know, choose the second thing right. So in this case, if, if me is equal to the current fields that email all right, I'm gonna make a pink, otherwise just keep the same color as it was before all right. So you can quickly see. We could use that at me to do some pretty dynamic stuff and now works very similar, the results to the date and time at the time of a render.

A

So that's that's important right. So don't expect that you know as the time changes and someone keeps this up on their desktop all day that it's going to ever update right. So it is the date and time at render, but.

B

Again, you do a lot.

A

Of cool stuff, with that with due dates, you know comparing against progress all that stuff so give you can get pretty fancy and the kind of things you're showing and how you want to get get in there and do that. Okay, all right which again calculator fields and everybody able to do that right. So this is a huge advantage over that all right. So this gives us into. Why would you use column formatting versus like a field customizer right? We have this whole idea of SharePoint framework extensions. They are awesome right.

A

One of them is a field customizer, and you can do amazing stuff with that right and you could do pretty much everything I've just shown you with a filled customizer. So why on earth would you do column formatting right? So here we go. So the idea is that you can do both conditional formatting hey. If you want to do that, you can do it in either one right. One of the limitations of column formatting is it's statically, so there's no scripts right! You.

B

Want to create a little white box right, so this does.

A

A little light box, that's left out, that's a field customizer right! You do any kind of what link including script, links visualizations.

B

A

Can get really really create column formatting, but it is still limited right. It's a limited subset of elements, a limited subset of attributes, but if you'll customize do it any lot right? Okay, page context, all you get is those at now and at me. Obviously, the field customers, you're gonna, get that full context right, you're not going able to get. You know anything about the list or the page. So if you're trying to build some pretty dynamic URLs, that's not going to happen. It's in column formatting!

A

You want to include a JavaScript library. You wanna include something like font. Awesome directly include those fonts or special style sheets, or do your own custom, CSS classes, nope, nope and nope right in terms of call the formatting fill customizer. Do whatever you want right, obviously, within reason in interactivity, right, you've got a link and that's it. You don't even get hover, Styles or hover properties here, okay, but here's the key right so I really like call format. None of you guys picked up on that.

A

The first thing is developer part, I'm, going to say no with quotes, because, hopefully we give you something that may excite a little bit more true, but really the key is the solution deployment. The idea of having to have you know an admin deploy solution. You have to maintain that the technical debt of a solution- you better make it worth it right doing all that stuff, there's a whole lot more to it.

A

So my recommendation is used called informative whenever possible, which honestly for me it's going to cover 90% of your your visualization needs it's when you want to go fancier, you want to really trigger stuff. You want to build. You know a piece of an application on the fast one, you're gonna go feel customizer and it's very important to know its limits. Those are kind of the design limits. There are a few other limits right now, but a lot of strengths too right.

A

So some of the strengths I mentioned is the no packets that there's no flashing little to no efforts. You don't have to have extreme permissions on this stuff. To do any of that really easy to include the UI fabric icon and their pre.

B

Sorry for giving you afterafter of the flow one one thing to mention in here also will be just thought about you. This is an awesome list of things. Why why the conform thing? What does it provide and why feel, customized and now one additional thing is that the column formatting can be modified by the end-user field, customer and basically disabled, so somebody can go and remove the column formatting from a field accidentally or intentionally, but we'd feel customized that they can't so because the field customizer is a API based modification, I. Think.

A

It's a great point, so this is definitely designed more for your site owners, yep writer, obviously like end-users. They would be able to do it because they wouldn't have access to edit the field right if they're just read access yeah but yeah, if you're trying to really send something out there- and this is something we always want all right on a list. This is not the way to go totally agree. Okay, all right! We'll continue with this. So then some of the stuff is I'd, say that's actually easier to approach.

A

The J's link ever was now say it's easier, but it's also again more limited, which again is both good and bad, depending on what you want to hand to end users right. Some of the existing limitations outside of this kind of list that are kind of planned. Just some issues right now are that you can't use CSS properties with parentheses.

A

So if you want to do a linear gradient to undo a background image with the URL and the RGB, a colors that kind of stuff that's out, SVG is pretty limited right now, really just get paths right, so you can't do stroke or view box or circle or that kind of stuff. Again, you can work around that like crazy and do a lot of cool stuff, but that's one of those frustrations. There's a user voice out there for that go check it out.

A

I don't have a link, and this is the biggest limitation by far right now. Is it it's not supported in the list web part? So if you, it's really just that list view, so you put that list web part on there. None of these things are showing up. I assume! That's coming. You know one more comment: here's the date: okay, alright and then against some limited operations, I've just on the missing field, type things like with the hyperlink description and one of the other frustrating things that again, you can work around pretty easily.

A

Is the idea of the individual property conditions only so what I mean by that is so setting a color? It's pretty straightforward right, based on the condition say you want to set a color and you want to make it bold. So you have to repeat that condition each time and you could say the quickly spiral out right. You want to apply an icon as well, then you got to repeat that condition, and so on and so forth.

A

So from that perspective, it's a little frustrating but again really powerful, because you could just do it right there. Okay, all right! So a couple of tips with us is I mentioned. This idea was conditional operator that question mark alright. If we take a look at that again right, you can easily string this together to make basically a switch statement.

A

So by doing the question mark here, right and I've got my two values here right here, I'm saying like what it's true duty pink, but if I want to compare against something else, all I do is I repeat this operator and operands again right here and I. Just keep going on and on down we'll see it another example that I hear in a little bit I'll make it a little more obvious, but you're gonna see that pattern repeated over and over alright there's another option called debug mode.

A

I recommend you leave it off unless you're actually having an issue, because it can cause you problems, especially if you've got like blank values right where it wasn't a required field. Someone didn't fill it out. The actual you'll actually fill that up with an error message, and it's very confusing so just leave the debug mode out altogether, but when you want to turn it on it's just debug mode and the value is true.

A

All right, colors, as you can see, colors can be referenced both by their hex values, but also by the HTML standard names and those are not case-sensitive icons. However, our Kay sensitive, so just watch that so just go to the UI fat website, copy it exactly what it's supposed to be and or use a tool. I'll show you in a minute right: okay, alright, so that was very exciting stuff and that's great right. That's really powerful stuff, but what is this supposed to be targeted right so.

B

A

Got fuel customizers for developers and if this is really for more that owner that kind of power user person what's going on with it right so say, I'm someone, maybe my name is Todd right, so I'm, Todd and I get this idea right. That I've got a due date column on my task list, and you know it would be awesome and everyone loved me if I made it when the due date is past. Its read like oh right I will be a hero. Everyone's gonna celebrate me.

A

You know probably get promoted to CIO, you know whatever right and that's just like I could probably do that. I used to do it before, so it does a little bit of pinging right and when he finds out clicking around the interface he finds. Finally, that for my column right, he clicks on this blue link. Here it takes him to that exciting document right. He opens that up.

A

It says 18 minutes to read sure right, 18 minutes to read, but not to understand, so he spends a lot of time he's really looking in there he's getting in there. This is pretty much the only document that exists, an official officially he's supposed to go to Visual Studio code right so again, if he is, he is different than 99% of all users and he's actually installed an IDE and he's gone that far right.

A

Somehow we have not lost him yet all right, so he writes it in there and then what he does just a copy it. He has to paste it up here and he hits preview. It's not quite right, so he goes back and he edits whatever Visual Studio code and he copies and pastes it back and forth back forth, back and forth and now Todd is sad. Alright, this turned out to be way more work way harder and even if he somehow magically gets it working, you can bet he's not gonna.

A

Try that again for anything more complicated than just setting the color right. So what's he supposed to do? How can we help Todd right? So there's this awesome repository out there, all right so SP, dev column, formatting samples, I'll paste. The link over here.

A

Yeah, so it has 25 plus different samples in there all, just in JSON formats, they're easy to update, there's instructions for each one of them, along with screenshots, along with tips on how you might want to customize that further, and that is a great spot to go to start learning some of this stuff there. One of the nice.

B

Things is you don't.

A

Need to, unlike some of our other sample, repos right, where you've got to clone it and bring it down and stand all that you can go directly to get hub, open up the Jason and just copy and paste that right in there and you start using it all right. So that's one really great resource I, also highly encourage you to contribute back to this. So it's really easy again. This is probably the lowest entry point. If you want to contribute sample. This is the easiest one to do so.

A

Please do I, forget, there's a bunch in there for every different column type, that's supported, but there's a lot more room for growth. Okay, all right! What about this? This thing I've presented before on this, talked a little bit about what's new and what you can do with it. So this column formatter, is a web part. Again, you can get this in the SP dev solution, so it's fully open source and we're not gonna talk about the code today, but if you're interested in the code, you can obviously go poking around in it.

A

You can use whatever you want reach out with questions all that kind of stuff. It is a react based web part using redux and all that stuff and, if you're really interested in what some Newton's last time presented it. Here's that as well okay. So let's take a look at this thing.

A

Maybe here we go so we go back and we want to do this in an easier way right.

A

Link or yes, it is in fact so here oh look at that. It was doing anyone already here and your I'll show you then just a minute AC. Alright, so I have this idea here: I've got a column for matter. So when you first open this webpart excuse the size here, I've got to zoom quite a bit, so we can see it, but you have a lot of options.

A

So I put this in a full width column here, which gives me a little more space but ideas when I get in here, I hit a new and I picked my column type for this case. I'm just gonna do text right, I'm gonna start from scratch right, which is a little bit of the harder but I'm gonna go in here, and the idea is I get this screen here where I've got my preview. What's going on here, I've got some data, and here is my JSON that I'm actually writing right now.

A

The nice thing is I can actually write this stuff directly. Here you see, there's some intellisense going on so I can quickly write this code, so I really wanted to write that orange-red. You know the thing we saw before again pretty straightforward. You can see it preview in real time over here. If you need to change these value to match something that makes sense right.

A

Tony sounds great right. You do what everyone you can also have additional rows. If you need to reference those other columns right, you can come over here and you can grab this and you can add all sorts of different things here. I'm so gonna any of those column, types right, so they're going to add a date time, and you get a nice little picker here and pick all that stuff get those details in there or a person where you want to set their email address all that stuff.

A

So the idea here is, you should be able to quickly replicate the kind of data you're working with I'm gonna go and remove that you know get the different views here very exciting and that's that's really powerful and that's great, but what's even more powerful as a series of templates and wizards right.

A

So if we come in here and I hit new I have this idea that I can come in here and let's pick a number- and this is a list- a template here, I saw I've got a trending, so what a template does is it gives you a preset of data right and it gives you the code and that way you can go ahead and start editing that as needed right so templates really a big leg up, it's a nice starting point or you can see we're referencing those other columns here.

A

You can start to edit this and do everybody need a wizard. On the other hand, there's a little more elaborate so for the wizard we can come in here. A wizard makes it so you don't even need to see code at all. You could totally can. If you want to right so you can come in here, you can turn that on. You can sit in the code, but.

B

A

Is you can easily pick just your values right, so I could say: sighs pretty dynamic, my colors right Bona, except the primary or purple, or you know whatever it is I want here. If you get the idea here that that's pretty straightforward and say what I really like this now and I've got my column over here right. So this data bar it's okay and it's not not exciting. There's not sexy enough for I, don't know your CIO, you know if it doesn't pop right, so I've got this.

A

I have a number of save options right number one I can download it. So this is a great way to write a sample. This is what I do when I write a sample. I literally hit the download button. It's going to create a JSON file and just download right here, get your downloads folder.

A

You can copy to your clipboard. You just want to copy it in place that everywhere directly in those things you're not quite comfortable with saving it. Here you want to paste it. You know you can do that. You can also save with the local library. That's just gonna save your JSON file to a library. You can apply it to a psych hold. So when you click that you're gonna be able to pick those columns right. So if I want to pick that horse stuff, you can see I've got my complete, yes or no.

A

I can even push it down to change lists, see and then you can also hit this apply. The local list field all right. So this is where I can pick that things list and now I can pick my progress. I can hit save all right, and if we go back to that, if I refresh on this there, it is, of course, I picked extremely low values. If we look at that, what's going on, there is I did haha sorry about the screen here: okay, so special range, but I used to save again nodes.

A

You can specify your own custom range. It doesn't have to be 0 to 100. It can be, you know, 10 to 50 or I. Just if you're just shoot you for certain budget amounts, you can do whatever you need there and I'm just going to apply that for you. So again, I did not have to write code. We were looking at the code, but there is no reason if you have to do that in fact, I can't even edit this code to screw myself up unless I hit this customize and turn off the wizard.

A

Now back to a C's question. Alright, is there a wizard to correctly, but that's yes, absolutely hate to leave that out right. So we've got this male to wizard here and in fact that's how it starts. You guys can see right for you, so you can go right for it. You're welcome! You know, I heard you scale, so it should be fine.

A

The other thing you could do here so, if you're really editing that stuff right you've created one, maybe someone else did right and they're like you know, it's great that I can see who this is designed to, but pink really like why? Why would you do that to me? You can go and you can open that directly from that local list. You can also upload or drag and drop these things right on here, but I'm just going from the local list and again all I do is I choose my list.

A

I, don't know what I call the signs? Okay and you can see it's gonna load it right up here. I set a date paint again. I can change that to orange right. I'll. Just do that and then we'll hit save if we go back cross our fingers and we hope- and then it's orange, so you get the idea here. Is it's pretty straightforward? There's a ton of these out there in terms of wizards and templates, it's pretty integrated with that repo.

A

So if something children that repo we try and move it here is either just a template, hopefully a wizard. So you can do some of that stuff. It's also really easy to set up so and get installed, so you don't even need to build it. You can just go directly to this link right here and what that will do is it'll. Tell you how to set this up. It'll provide you.

A

The asset package or the SharePoint framework package directly grab that your app catalog of site catalog, with all the instructions and you're good to go and then there's also full documentation on all of these wizards and everything you need to know at this.look also by the way that is totally not my chair, I, don't know. What's going on with that, creepy noise, so.

A

Alright, so that's I mean that's the bulk of it. Please reach out. So this is available in French it's available in German, it's available in English. Obviously you can get kinda crazy again. I had to zoom out to show it to here, but you can see that there are a bunch of properties here you can make. This thing is full screen as you need to. In fact, if you edit, that you can see, there's additional properties as well so we'll come over here, go ahead and get it inside there. That's great.

A

You can turn on turn on or off line numbers you're in dem guides. You can turn on the mini-map, which I'm a tiny one like this doesn't make a lot of sense, but it allows you to quickly zoom or scroll through that you've also got a bunch of theming options. You can change that height as needed.

A

Let me know if there's something that's missing, that you're looking for or if you wanted to build it yourself again. Contributions are I, think that's about all. I got I.

B

Think we need to guess thought up a a some sort of a saving thing for getting you a new chair, because.

B

It's always Patrick, so that's cool, so I I have to say that this this webpart, obviously the the whole column format thing yeah. It's absolutely great capability and, like noted on the I am window I'm just going to recycle certain things. So right now the list view web part does not support column formatting. It will support that in the future. It is absolutely in our pipeline to make it work right now. The column formatting only works within the lists, so in the future.

B

Obviously it will be working in the list list back part as well, the same actually related on field customizers and lists web porn or the editing pane. Please use the use of a century which we listed on the on the ion window or there's the use of force entry. So we can get additional boats on that one. The votes always impact on our sharepoint engineering, prioritization, so more votes means that people want to have certain things and that embeds no, the other stuff here just the Chris Chris's web part is absolutely brilliant.

B

So it clearly helps you to do the configurations and, unlike said Chris Chris was it a week ago when he stopped me that you submitted like 10 different new contributions that the : formatting reaper with and another one and another one and another which basically was he is using the you were using your own, wet part right or designing.

A

B

Yeah cool and we'll keep on having additional capabilities on the column formatting as well. Now we are potentially looking into having a native UI for column, formatting thing. On the other hand, now that Chris has this. The question is: how do we, hmm what is the right option to go forward in the into engineering and we'll we'll figure it out, but absolutely I create demo and absolutely create create presentation, I'm, gonna, flip back on the slides, maybe one more thing to mention.

B

While we're flipping on the slides and the Q&A section, you can absolutely set the column formatting programmatically as well. So if you wanna provision a site collection with the lists or, let's say a site collection fields or site fields and set the column formatting into that one, you can absolutely do that using API. So there is a season and a rest api properties for setting the column, formatting definition for the field itself, so absolutely possible and in well. Then there was a discussion with plenty of discussion around the content type hub.

B

We let some that actually touched that topic right now and this this call will have further news on that one Orbis latest on sharepoint conference. Potentially, I can't disclose all of the stuff, but I know for sure maybe one thing to mention here: ac-actually noted this one already so AC and rancor, so Voigt, honest and rancor to be precise, Boyd honest is a company where AC actually works or well.

B

How do I wanna put that are actually running this date of sharepoint development survey, so I'm going to put time window note on that there as well. Please go and fill this up because that actually helps us in the sharepoint engineering as well, because we, then we get a much slightly more detailed insights on what are you building with environments are using. Where are you using what is important on all of that and sure?

B

This is not a Microsoft driven survey, but it is a community Tremont survey and then, but we can use the information in this survey as well as part of our own internal planning.

B

Yes, AC works for Donna's, but he also knows that so yeah any other questions. We have five minutes. This is like the first time ever when we are on time. Within this year at least, you can feel free to extract and custom-built that I did yep.

B

There is a on the site, design studio, so Yannick will do a live demo on the monthly community call which is actually on next Tuesday. We and I know we have quite a lot of these community calls, but Yannick will do a live demo on the site, design designer on the web part on next Tuesday, and we get that one recorded in the in the video as well.

B

Yes, thanks for telling Chris any other questions have moremore we'll, definitely not have a more a SharePoint deaf community cost more than this, but I think that the most and something what we actually chatted in the in the BMP team as well. It's brilliant to see how active the I am window is and that people are answering between each other and helping each other, because that that really shows how we are helping the community as well and and how active the github is, an issue lists are and community are so cute.

B

Any other questions, orchid jokes.

B

Chris, you got any good jokes.

B

Okay, so no burning questions at this point. Let's we will have the next monthly community called action in x2 slate. That is, the monthly community call, which is the April monthly community called SharePoint will talk about. The use of warriors will talk about what has happened within the last month. What was released within the last month and all of that stuff.

B

The next SharePoint in worship, on deaf special interest group call is on April 19th and we'll probably have again one specific topic or a design and with kind of a deep dive on that topic on that call, as well or two topics we'll see. The next checkpoint framework special interest group is on week from now Thursday on 12 of April, and there we actually deep dive again on the SharePoint framework in this core.

B

We intentionally I asked Chris can not to deep dive on the web part implementation, but we can actually deep dive on the implementation topics of that web part at some of the SPF X calls if they're say a demand phone on.

B

This nothing burning on the ion window on the power apps forms I'm, unfortunately, a wrong person to answer that, but it's good to see that other people are helping on that one, but I think that's it. We we will close two minutes early today, which is great the first time. Probably since four months sharing is caring. Please contribute back on the on on the community. If you can, if you have Vale ability, that's more than a welcome. This is how the community works.

B

We are highly dependent on what you contribute for the others in a SharePoint, deaf community and thank you for all of the contributions or MVPs and community members. What you've done in the past as well, and thank you Chris for a great demo today, but thank you, everybody and the video will be recorded and the video will be available in the YouTube channel within 24 hours. Thank you. Everybody Cheers, oh boy,.