SharePoint Power Hour: Modern Conditional Formatting

[Music] hello and welcome i'm laura rogers and we have joelle jobson here as well on the call this is sharepoint power hour this is our live show we do on wednesdays at 11 we just demo things in sharepoint and office 365 and things that you can do out of the box with sharepoint um randomly demo different things each week and um sometimes they're corresponding to a blog post and sometimes they're just things we make up as we go but um let's see this topic this week is going to be a drumroll this is huge so this is something they announced at ignite a couple weeks ago and it's something that people have been screaming for ever since sharepoint designer design view got yanked away in sharepoint 2013 and so it's been you know four or five years we have conditional formatting in our listen libraries now what do y'all think are you all excited about this i when i tweeted about this i know um during the conference and i tweeted out a screenshot of uh what they were showing with this conditional formatting i the tweet got like 14 000 impressions or something and it just insanely got retweeted and people responded to me going no that can't be right or that must be custom code or that must be a third party tool and what is that and how did you do that it's out of it's quote out of the box say out of the box so um this is something that is not in production yet but we're going to demo and figure out as we go today and it's coming soon so it's coming like this month i believe um but they did announce it's one of those things that i think i mentioned when i did the ignite recap a couple weeks ago one of the things that they announced um that is coming i think i think they said officially sometime in october you know how things those things roll out they take uh a while they roll out to all the first release and then they um you know so whatever release your tenant is on who knows when exactly you're gonna get it everybody's not gonna get it at the exact same time so all right with no further ado i'll go ahead and paste the link here um because you guys can help me figure this out because it is no i'm just kidding it's not too bad now this is i'll put the link in the general channel and we're having our chat in the power hour channel in our slack channel idabementer.slack.com and so this is i'm i'm not a dev okay i am not a programmer i think most of you know that i'm um i sort of can delve into things that i try and tweak with code but i don't i don't write code i don't write any programming languages so this is sort of bordering on devi because it's got a little bit of syntax and uh formulas sort of that kind of thing but microsoft at least for now in this blog post i showed you and you guys let me know what you think about that it's they're giving a ton of examples a ton of examples in that post and i think that people are going to go nuts with just blogging and and teaching different examples and and you know we're all just going to figure it out and um it'll it'll be good so i think it's huge and i think it's definitely better than nothing and definitely better than what we're having to do with sharepoint designer so here we go i'll go ahead and share my screen all right this is my little test site and um so the first one that i'm going to show you is i've got a couple of things going on in this list can i get like a golf clap or something like that everybody and joelle and i have been figuring this out together so dwell is in this test site of mine as well and um we've both been just in the last within the la under 24 hours been putting some things in here and trying a few things and getting like a few good examples to show you guys in here so um they're being awfully quiet i mean i don't think they're interested i don't think they want to see it they're not really saying anything so well somebody somebody over on youtube said they needed to check their underpants so i think they're pretty excited no way yeah okay that's good all right okay so here we go um i'm gonna show this one this customer status thing first um the way you get to this and again you're not going to have this yet it's not in production yet is you go to list settings and customer status so see custom formatter so this is a new setting in a columns settings page so i just went to list settings went to the column just clicked on the name of the column like you always do and custom formatter so this is where i did the formatting so basically this one says if it equals inactive show it with this um basically it's this sp field severity warning but basically it makes it orange um so that's a very very simple example just for this one field of how that one was done so i'll show you now they have this whole office ui fabric thing that i don't believe is functioning yet which is fine um but i'll show you this particular example this one so this is the custom the conditional formatting example with these colors and icons so supposedly they're going to be these icons sort of that you can refer to sort of built in with these like sp field severity warning things so that's where um in this case right now they're not showing icons they're showing colors but that's fine so um i've got basically you've got a reference to the current field and i'm showing the code on this page because it's kind of hard in that little tiny little text box in on the sharepoint in the sharepoint settings but you've got the current field and you're saying that um if it in this case it says if it was less than 70 then show a warning well i don't want to do less than 70 so i'll do i'll show you mine let's see i'll show you how i tweaked it a little bit i think this is considered json let me see in my notepad plus plus let's see i said kind of okay um so what i did is this equals sign so if it equals inactive then i show this warning color or icon so let's go see what a couple of those other little icons are going to be so i've got inactive i'm going to do instead of it showing this field severity warning i'm going to show this field severity block and that will be the red one so now if it's inactive it's going to be red so as you can see this is a pretty simple example of just if it is a certain thing then show it a certain color but as you can see it's code it's it it's a syntax that you have to dig into and um kind of oh you can't see my you can't see my screen what the oh okay let me see let me change my resolution sorry thanks for tony for letting me know okay sorry about that hopefully on that screen i just um shared on that with the code it at least showed that much okay okay there we go so i'll go back to list settings and i'm in my um customer status field and it's this custom formatter all right that help thank you yeah so it's yeah it's it's better than jslink i think i think it's less complicated than jslink um in response to daniel there but yeah it's code but okay so we have this reference to a current field here that you're going to see in a lot of these and you're going to have this question mark is that's the condition that's the if concept so if it basically equals inactive then show it as this so i would not be able to write this from scratch so again let me click ok and we'll look at my list again i would not be able to write this from scratch but as you can see we can at least for now have something to start with and be able to start figuring out how to tweak it and start understanding the syntax right so here's this other one that joelle did the number of tickets logged so we've got this nice little bar graph that is really cool so it's just a number field right joel and then you've got a maximum of 20 that's typed into the code right yep okay so let's go look at this code and i'll show you um this code's pretty much the same as um their their example right let's see i believe yeah okay so here's their example oops where'd it go it's scrolled randomly there you go format a number column as a data bar this is advanced because i have not i've been able to figure out some of it but this formula is pretty complicated um jonas says you can show the formatting only and hide the text and numbers probably um i put the link in in the general channel dion oh flip over to the general channel in slack and you can click on that link um and it's also on my blog wonderlaura.com click go to resources and click power hour schedule and there's a hyperlink next to this particular power hour with the hyperlink to this uh thing that we're talking about also this page that we're on okay um so yeah you could probably that's a great question because you hide the text in numbers you could probably do that you could also you could either maybe hide the number or make the number be the same color as the background so that it just doesn't show or you could just do this in a completely different field maybe so yeah you could just create a whole new just blank text field and only put the formula in there and not have any value and it would still you could still make it reference these other fields so you've got this um what it's doing is saying um i'm not even going to try to translate this complicated one but it's basically using 20 as a basis and it's using 20 as a basis and using that as um whatever your number of tickets logged is as a percentage out of 20. so that's how it's showing this bar as a certain width so that's pretty powerful um so and some of this is going to be like um understanding some css type of things like divs and styles right joelle yeah because it's the div attributes like for this one this whole div that the word is in is what i formatted i didn't format the text so let's go to a different example where i formatted the text okay so here's one where what i did with the text formatting of the project name is it is looking to see if the project end is either doesn't exist or is in the past and it's showing them as red so like this project doesn't this contoso prepaid support project doesn't end yet so it's not red but a lot of these are red because they're in the past are empty so um and then these are not so that's pretty cool so let's go look at how i um [Music] that's a great valerie says microsoft has a weird concept of what is no code so this is uh how to format the text so we'll go into list settings and so i'm not formatting so i'm formatting the project name field that's the actual field that i'm doing the formatting on but the data that i'm looking at isn't in the project name field it's looking at other data so let's go look at c let me copy all that and see how i did that let me go replace that so it's easier to just look at it in here so the text the content that we're on the field that we're on is the current field but what it's looking at is the condition that's the question mark technically json has no code right um i can kind of figure it out so i think all the people a lot of you are at that level where you're able to kind of understand logic right joelle and kind of just poke around in it yeah so um this do you guys see this because i want to point this out right now because this is something that's on my screen i'm gonna i'm gonna do my little white board i'm gonna uh see color red now so this is comparing a date in the list to now those of you have been using sharepoint for many years um like me and joelle probably have a greater appreciation for what this is but this is huge right um this is comparing a date field to now it's not comparing it you're not having to compare it to another date field this is something that in view filtering we've kind of been able to do you compare compare like the date in a list item to today and like filter it out of a view but this is something that has people have been struggling with and wanting to do in sharepoint for years this is huge this now thing so um i'll clear out my my whiteboard but so this is saying if it is less than or equal to if the opera operator is less than or equal to comparing the project end field to now so this is oh that's what i got wrong joelle supposed to be a dollar sign so project end is another field in the list so it's got this current field thing this at current field you'll see in a lot of places but this project end is where you get the name of the actual other uh field that you're pointing to so how did i get project end like this weird looking thing is i went in here and we go just in my settings and when i go hover over project end you can i don't know if you can see in the bottom of the screen but the hyperlink says uh field equals project underscore x002 or underscore n that's what happens when you create a field with a space in it but that's what project end is that is that's how you know what syntax to use when you're typing the name of that field in things that need code and sharepoint um let's see daniel says what about the time part of now so yeah that's the column's sharepoint like system name so this is comparing the project in i don't have a time in the project end it's just a date but it's still comparing it to now like right now so in sharepoint technically when you have a date time field it is still storing the date and time even though it's not displaying it so like i can change this to date and time like this so now i changed project end to date and time so now it's displaying it as date and time and it's just showing them all as midnight so i mean we can go change one of them to have a specific time in it but the at now is right now like this minute comparing it so that's not the same as like just today right so the now is good um let's see yeah dion just kind of verified what i just said where you look at uh where you go to click on the column name and you can see the name of it at the end of the url yep okay so that's how you can get those system names so as far as this color how did i do the color this is this color now i wonder if i put like just the name of a color if i just put blue in there if that'll work so i can't type it in here and it's not going to do any good so project name instead of having to do these like css uh i don't know what that syntax is called i'm not a dev i don't know what that's even called let's see if i can do just blue because in powerapps you can do the rgb code or you can just type the name of just the name of a color and it'll work oh look at that it works we're learning new things every day so you can just type the name of color pretty cool joelle what else kind of stood out in there for you in that uh and the things that we were kind of poking around in um so the i know we were trying to figure out like the icon thing um but i think that could be really cool like the one where um the email where it has like you can add the little icon next to it or you click the icon and then you can like generate an email um it's kind of like the quick actions kind of thing but just right on the column instead of having to go to sharepoint designer which is kind of neat yeah huge yeah so um fausto made a good point um can you click can you just click edit the custom formatting directly from the column without going to the list settings that's a good question i didn't even get a chance to try to do that i don't think you can uh column settings yeah so instead of like i tried right clicking on it that doesn't work so but it's column settings format column yep there it is thank you fausto you're genius that's a lot faster you get a lot better like the concept of what you're doing more immediately right so i can go um change this to purple and then preview it oh yeah huge thank you see we're all just figuring this out as a team right um yeah hey dan yep we we mentioned powerapps we did a whole bunch on powerapps last week um but i switched kind of switched gears this time because this just came out and it was so exciting to me okay so if it's um basically less than or equal to now then it's showing us purple so let's look at some other different examples i'll go ahead and just save that and close that um and let's see we did what else did we do on the projects list we did the hours use thing i don't know if i even want to delve into that but this project project status is got several different statuses and you can see that i've got it showing them quote sent doesn't show as a color but the active and complete show is colors um so we can go tweak those and like if i go quick edit one of these and this is just a text field but i can change one of them to test company project to active and then done and then now when i go look at i hate the way these just columns get so wide in here right there we go and i don't know oh it went to the top and it is showing as active and it's showing as that certain color so let's go look at that code i'm gonna take that whole thing and just um put it in notepad plus plus that is a long one okay so if it equals complete then it's doing this thing how about i just change it to if i just write blue here what is that going to do so it's so first of all look at this elm type that says div that's not the same thing as formatting the text right so let's go look at what the difference in that was let's go see let me go back over to this other one so to format the text so the div is that whole background part right so let me cancel out of this one and go here and elm type is div oh why is it style color okay let me go grab that too so we gotta we gotta understand fundamentally how do you know the difference between if the background of something is gonna get formatted versus the text right joel help me out here you're a deaf right no wait a minute neither of us are okay so this one is the text this one is style so div style color and it doesn't necessarily say that it's the just the text and that's div class okay so it's a class yeah so yeah you're right dion the style is like seeing style in html but this other one with these sp field severity special things that's class that's like a special microsoft built-in class what was that i was just going to say at the bottom of the article it kind of details those a little bit too which is for the devs those classes okay yeah so there's the field name and me and now by the way and it's even got like i love all the examples they have in here by the way because it's even got specifics like how to deal with lookup fields like lookup id versus lookup value all the operators like equals less than all that stuff and then yeah so a lot of this is kind of dev terminology but at least it's a good reference for like like you're saying like this class so um let me go back i'm going backwards through here wow that's a lot that's a lot of just kind of a css reference right of what all the styles could be um okay so back to here so this one is right now it's showing that class of sp field severity good if it's complete so if um current field equals complete then it's showing as this class so let's say attributes are going to be um instead of class do you like the other one where it's got style color see don't type div style and color okay so instead of attributes class style color i'm just going to do this and i'm sure it's not going to work but because we got to know how to you know for us non-devs we got to know how to be able to just tweak this stuff right so if it's complete i want it to be green so this is kind of like like dionne mentioned it's like style in html so style is how you define just the like the way you want things to look uh in your table in your table cell your paragraph your divs your um text eight you know um urls and things like that so the style is we're defining the color of this thing basically so let's see if i can so style color is green otherwise if it is quote sense then the color is going to be like blue otherwise if the current field says active then the color is going to be purple this should work right otherwise equals blocked i don't think i have blocked is whatever and then this is the else so all those were the ifs and this is the else and i'm gonna put um just black for that otherwise um so blocked is a word that i don't have in mind but i can add it let's see um what other color green green blue purple pink there and then it's got this whole children thing inline block padding attributes so it's even doing some so this is where it's doing some of the things where it's going to go find that specific check mark using those microsoft those classes that are built in and show like a check mark or a warning or an error badge and that stuff's not functioning yet okay so let's go back to this is my project status field and preview oh my gosh it worked i totally knew it was gonna work okay so did you all understand what i did you want to show you that again okay so that is awesome so blocked let's try blocked that was one of them i'll go edit this item and put blocked as the status that's one of the like five different ways to edit items right i wish there was a way to do the column widths and then save it that way and make it stick okay look there's the pink so i set it to pink so you can't really see it that well but it was pink if it was blocked cool all right and the else was black so let's change one of these to instead of quote sent this is just going to be like nothing nothing it's not going to have any of the conditions that i put in here and it's black cool that was my else statement so if i'm a dev now oh no that's what fausto says i'm officially a dev well i think the cool thing is that i'm not a dev so it i can explain things like in just normal terminology that's not dev terminology because i i don't know what the terminology is but um but i can understand concepts like logic and conditions like we they've told us that this question mark that is the if so if and you gotta say what the equals what the operator is first so instead of like two plus two equals four it's plus 2 2 and then you get a result you know what i mean so you just say what the operator is first up here and then um so it equals complete yeah all right well so let's look at what other examples that we have in here um do we have one in the ch i started to do the thing with the fancy um little icon for the the email thing yeah but i didn't do that um departments let me see i'm going to go look at a couple of their other examples and i'm sorry guys that i'm kind of winging it in this one i kind of knew that i would because this stuff is just so brand brand new um so let's go back over to our time sheets and maybe if somebody uh worked over eight hours in a day then we can have it like that's like a red flag right i wish i wonder if there's a way to do the entire i guess you could do the whole row by formatting each individual column to with the same setting let's try that so if somebody worked over eight hours in like one timesheet entry we'll try and we'll make the whole row red so we'll start with the first row and we'll go to um format this column and then that's going to be the i guess the background right okay so now that i know so much about this stuff now let me see what i can figure out okay so this is going to be the div attributes class is [Music] last time we changed it we wanted to do the text we did um um style color and if we want to do the background maybe style background let me just change it to style background on the other one before i try that how about that that's my good way of troubleshooting so for this one over here that we have the text being a certain color let's just change the word to background and see if that does that no it's not background let's put color still don't know joelle how it knows because usually when you're doing css and you're doing a color like it's text color or background color or you're you know what i mean you're saying exactly what the thing is yeah so maybe if i do like instead of div it's like td i think that would not that's an i like that immediate response there just it just errors out yeah um and i and i it would be nice if everyone else in the chat window could like try it oh um dion says what does it say for hours used um dion the hours use thing i'll go ahead and show you what we were trying to do with that one um so what we were doing is this where is it it's the one and you'll see it's pretty obvious in here where did it go it's the one with the little bars going across and it's similar to the one that joelle did that had the bars based on just out of 20 so what i was trying to do here it is is this and i wanted the hours used um so the project has a certain number of hours that like the customer has purchased that you can spend in the project and then you have the hours that you've used so far so i wanted the bar to be like 100 would be the hours used in the whole project or the hours that exist potentially in the whole project and then um oh yeah oh background color well let's see we'll go look let's see sp field data bars so that is a class so yeah we could use that um sp field data bars style width style width where does it say the color though let's see that one was complicated like it's very short it's not very long but it was pretty complicated to try and figure out if you wanted to compare it to another field um [Music] yeah see it doesn't say like it just says style width but it doesn't say the color anywhere because the color is part of the class you know what i mean yeah can you joel can you just skim through that well i'm going to go back over to what i was doing but skim through here and see if you can see like how you'd actually set a background color that's not like one of their built-in classes cause that'd be good to know all right okay so i'm gonna go back over to um so the time sheet the idea is that that number field is gonna be um we're gonna make it so that it's a certain color if they go over eight yeah ryan says the class on the row looks to be ms list cell wow that's pretty uh it's pretty good i don't know what that means to me though all right so div color okay that's the one i was looking at and then i'm going over to [Music] i'm gonna go grab this code here see everything we do in here is copying code right i do see something for the background color in the article okay um here we go let's see style color whatever okay i'm going to use this example right here format this column okay so the number is going to be 8 because over 8 hours you're overtime right so this is gonna be a red red and it's just gonna be equals or no so if it's greater than or equal to eight right greater than or equal to and then we're comparing the current field to um we're comparing the current field to eight so in this case um we're going to do we're not doing this plus thing so what's the syntax for current field at current field at no it's not at current field because it's another field it's the dollar sign right hours now i need to go double check and make sure when i'm typing hours here that i actually called the field hours when i first created it right because it's got to be that exact name of that system name of your column in here so i'm doing hours i'm not doing an operator plus uh equals see this is nice and simple right here brands equals current field is equal to complete so i'm just going to use that so i only have one condition right but it's definitely easier if you use notepad plus plus equals so greater than or equal to current field and then eight and go oh oh it's because i don't have anything after it i don't have like the end part okay let me do the end because i have to do the else right else so green otherwise nothing just empty quotes and then close out everything i'm doing and if i was using notepad plus plus for this then i'd be able to like see better see the syntax of what is going on in here of you know kind of what i might be missing in my syntax okay let's go grab that i'm not doing very good am i i just want to show the field a certain color based on ours i'm going to go back and look at what i did with the uh with the other one because this one over here this project name was pretty simple that's a good sort of basis are you seeing what they're posting about the background color thing oh no yeah it was in the at the very bottom of the article it kind of talked about putting that in there and there they were posting about yeah okay i'm going to try that next after i get if i can get the as long as i get the text to work just the text color and then i'm going to with the logic so i can get the logic correct and then i'll go ahead and do switch it to background okay so this is style color less than or equal to and then what i'm comparing is the hours and i'm comparing them to eight okay that worked does that look like it worked um yeah so see it changed the text to purple if it's so i did it backwards though see it's doing greater than so i'll just do i'll just change this to a greater there there we go that's faster see so now this is over eight hours so it's purple so at least okay so now i know the logic is working so the next thing is instead of formatting it text formatting it as background color so we've got style and i'm going to do what fausto said in here because fausto are you a device okay background hyphen color i bet you you all can't wait to get your hands on this and start putting it in your projects like put in the chat windows some examples of projects and like lists where you need to be able to see conditional formatting you all kind of be brainstorming and sharing ideas with each other while i type this in here so background color width is greater than 20 let's say background hyphen color and then purple ah it did the background color okay so um instead of purple i'm just gonna do yellow so it won't be so harsh thank you fausto and then you could probably do additional things like padding and and just like really customize you could customize the way the whole thing looks so now that i've got this in this one field and i'm saving it what i'm going to do is i want the whole row to look like that so i'm going to go ahead and go to my column settings of my next row most likely if you removed i'm not sure we'll have to check and see what happens when you remove a column from your view because well i guess the formatting of the column is just connected to the column it's not connected to the view right so so we'll go to workdates column settings format the column so that's kind of nice because with sharepoint designer with the data view web part it was just that one thing it was just that one view or whatever whatever you did so this can just be connected to the field that's pretty huge too of course now people are gonna say like well wait a minute what if i wanted to show this way over here and that way over there and i get oh then it kind of makes me wonder if you're going to have a um [Music] a setting that lets you decide like what page you're on and show it a different way that's gonna be more advanced okay so column settings that one doesn't that project one doesn't have like that column formatting thing on it let me just move on and to this one so all the code is exactly the same but i'm just going in and tweaking each one of these and they're all pointing to that hours field so it's not really doing the whole row so i'm not sure if that's one of the limitations since technically you're formatting just the column and that's where the column ends you know so that'll be something to delve into but so now you can see that because the project went over see any of the ones that are greater than or equal to eight so i can change it to be let's see greater than eight instead then i'd have to go do that in every column right save oh i only did that i only changed that in one of them like this one see so yeah you definitely have to kind of go back through them all every if you wanted if you had a whole bunch of columns like this that you were doing like similar like this then you'd have to go through a bunch of them to be able to change something now you're also going to have stuff like just kind of the way the columns look just out of the box that i know people want to tweak a lot of the times right so it'll be interesting to see what people start doing with just you know making the text bigger in a certain column or making a certain column bold um we definitely do do you guys remember with dataview webparts where you would just go build a particular um [Music] if you wanted a field to to link to something else if you didn't want the end user to have to go click to select the row and go click a custom action to go run a custom action or take them somewhere well now one of the things we can do on here is instead of having to go build a hyperlink field and go like set the hyperlink via workflow or something crazy like that we can just um put like build what the hyperlink is directly in here um so let's go see if i can uh let me think if i have one of those um like okay so i've got 10 minutes i'm going to make something up all right so when i am on my list of customers and i want to go to my list of projects now keep in mind that i already built this whole customers projects thing as a power app as well which has got all the filtering and all the fun stuff built into it but if i click on a if i'm on a customer and i want to quickly go see that customer's projects i want to just go to a filtered list maybe of the projects for that customer so here now this might actually be trickier because it's um a look up field so that probably might make it not something i can figure out in 10 minutes but this is an interesting trick so i can go filter like i'll just say filter this customer look up by contoso and go look i didn't build any kind of custom you know parameter being passed or custom you know query filter web part or anything like this i'm just going to go grab this code and i'm going to go put it in another and we we built something similar to this just recently with a customer right joel see take a look at this this is out of the box just clicking on the name of a field and filtering it so filter value one is just the name of the field i filtered and then filter value filter field one sorry filter field one and then filter value one is and that's the actual name of the field so contoso right here filter type one equals lookup so if i can build a hyperlink on my customer that just says filter value one equals and then customer name right here and they could click on it and just go to the list of projects so let's do that all right so i'm going to build a new i'm going to go to my customers list and i'm just going to create a new column in here and really quickly and i'm not going to put a value in the column i'm just going to call it um projects okay so it's just gonna be called projects and the this thing scrolling to the right is driving me nuts i'm gonna remove some of these fields there i'm just gonna narrow that down okay so now projects needs to be a hyperlink to that actual project so this new syntax is actually gonna give us the ability to create a hyper a clickable action in our uh in our field so i'm gonna go i did this current field thing column settings and this is in the add an action button section in that reference so this is i just copied and pasted it so with the type a that a means it's a hyperlink i'm not a dev but i know that much and then target's blank so it's going to open it in a new window you don't have to open it in a new window you can get rid of this and then this is the url and see it's taking this concatenating it onto the current field so what we need to do is go grab that hyperlink and [Music] this whole thing filter field one equals customer lookup that's not changing and filter filter value ones custom and filter field value one equals so we need that whole thing right because this word contoso right here is the only thing that's different okay so i'm gonna replace that in here now i didn't put the part at the end where it said like uh field filter type one equals lookup so we'll see if that affects anything now it's not you don't see anything on here so let's just i'm gonna save this and see if it actually made it clickable oh it did okay so projects empty so customer look up i want equals so it didn't put the name of a customer on there so let's try that at least it was clickable it just didn't look like anything right so you'd have to like make it so that it has an icon or so you'd have to put additional code in there to make it show like a colored box or show some text using sort of css styling type stuff or just have this one field just or just use the customer name field and you're clicking on that or have some text here like click to open projects and just have that be the default value you could do any of those things so let's just go see real quick um go back into the code does this make sense guys um i'm looking at the questions here the release date is sometime this month yeah y'all will be a one step ahead of the curve when it comes out so wow there are a lot of comments i got to catch up on if you have multiple formatting per column yes stacy you can have a bunch of or condition like if else conditions but it's just free form json so um just like in that one that we looked at that had uh the where i did the projects like active versus completed and quote sent and those those all had multiple things going on with them yep okay so um yes so let's see who was saying that eric was saying different column formatting for different views that would be yeah that would be maybe something that might be needed in the future all right so i don't need i don't need to do target is blank i'm just going to leave it like that but um we're concatenating this with the current field oh okay so that's what i did wrong right it's not supposed to be current field it's supposed to be this other field the customer name okay so the customer name i think is my title field so i'm just going to guess at that so it's dollar sign title and preview that i'm just going to go ahead and see if that works what customers don't have oh it worked did y'all see that i mean that was pretty huge you want to do it again i'll go ahead and close this so um this is it doesn't look like anything cause i didn't put any actual value or anything visual in this column yet but when i click on the on this second column here that i just created and put this formatting on so this is the contoso row right it pulls up my projects list just filtered by contoso do you like that that's pretty cool so um the next thing we've only got five minutes left but we could try to make it look like an actual box like a button to click on um so let's see how would i do that just put like a rectangle in it or something trying to think i mean it could just be you know just formatting the background of that box to make it kind of look like a button but yeah i don't know what's css for pretty little rectangle oh we could do images we could do an image let's see yeah i don't know enough about the syntax to know what it would what that would need to look like to make it show an image there so let me go show you what i did one more time see this is the field column settings format this column okay so i copied the the uh code on here having to do with custom buttons um custom action buttons and i just copied that code and tweaked it to instead of looking at the current field to concatenate that onto this url i just put the title field of whatever this item is this particular item is cool and then um it as far as what those are gonna look like you wouldn't necessarily need to have a condition that could just be like it's always blue or something right um so let's see i don't know see the thing is i don't know enough about code to know like where exactly to put the other thing in the code so i'd probably just have to play around with that so we've only got three minutes left but that's pretty cool that i got that work and i'm pretty excited um so i'll go ahead and flip back over what do you think joel promising yeah i definitely think it is it's just neat that it's built right into the column settings instead of you know another tool you have to use to manage it and stuff like that like that's a that's a big i mean even though we could do some of this stuff in the past it's a big win for that i think yeah i think it's huge so oh we'll get we got like the applause icons and uh in power hour you guys check out the blog post i wrote the other day on some flow stuff how to make a um you're assigning a task to someone that's external and you don't necessarily want them to have to go to sharepoint you create a sharepoint list item add an attachment to it in this case it's like a change request which is just like a small screenshot for this particular customer that we had it actually sends the list item attachment as an email attachment to the person and assigns them a task and all they have to do when they get that email is hit reply and then type some kind of response and then their response goes into their task and the task gets automatically medically completed so that one wonderlora.com that one was pretty fun one to figure out go check that out also you guys check out iwmentor.com joelle and i have been spending months putting this together and uh you can log in for free with your just your linkedin credentials i encourage you all to go ahead and create an account in there i think i'm probably going to start doing power hours in there just i mean still free but just to kind of drive traffic to it so check that out we got some free basic training like beginner stuff in there and subscription based training and just all kinds of stuff that we've built um and next week i was trying to get my dad in here to like demo you know teaching my dad powerapps my dad was doing punch cards back in the 70s programming so he kind of you know these are concepts he's going to understand all right well i guess that wraps it up and you guys um i guess i will see see you next week and we'll um just look out for you know if you go to go to wonderlaura.com and look on the power the resources and power hour schedule that's where i say when i decide what i'm doing next that's where i put that and i also put it on my the iw mentor facebook page in case you're ever kind of wondering what's coming up and i will see you all next time i'll go ahead and sign out

Channel: Laura Rogers, Microsoft MVP

Views: 20,419

Keywords: SharePoint, Office 365

Id: 5_eghVReCO0

Length: 59min 13sec (3553 seconds)

Published: Wed Oct 18 2017