SharePoint Power Hour: Teams Triggers in flows

[Music] hello everyone and welcome i'm laura rogers and this is power hour i have my colleague joelle jobson she's on audio say hello hello everybody and um power hour is our show that we do weekly wednesdays at 11 central most wednesdays and we have been doing this for over six years and we cover it was started off as just sharepoint power hour and it has morphed into office 365 sharepoint teams power apps power automate all those good things the general theme is that it is geared towards people who are not hardcore programmers or server admins it's kind of all the between business users power users things that you can do fairly easily without any kind of code or super technical knowledge in all these products so today and i sent out a newsletter the day before for you all to vote for the topic so today's topic you all voted for is a power automate triggers that are related to teams to microsoft teams so teams triggers inflows and the fun thing about having this at be a live show is that we have a chat going on we use slack for our chat and it is iwmenter.slack.com and wherever you're watching this video there is a link underneath the video to go uh to join the chat and to fill out the form to join the chat for the first time because i have to manually add everyone so hello everyone and uh come on join the chat and ask questions and have joined into our fun conversation hey everybody we've got a lot of great regulars in here i reckon i'll you know recognize all these names every week it's a lot of fun so it's good to see you all roll call everybody say hello valerie stewart larry marie steve just everybody's here all right um okay so i'll go ahead and we're gonna dive right in so joelle and i were talking about this this morning i said joelle they voted on teams triggers but there are only three teams triggers so this is supposed to be power hours supposed to be a whole hour what in the world am i going to talk about about three teams triggers so we came up with some ideas thanks joelle for spur the moment um thinking of stuff and i did even test a couple things since we talked earlier so uh let's let's i'll dive right in and share my screen i feel like i'm losing my voice all right here we go now what i'm going to do i'll just save kind of this thing that i was playing around with before we got started and i'll go create a brand new flow and just kind of show you just what what the show's about today i go to create a new flow and i go to microsoft teams and these are my triggers so these are this is the very specific thing that we're talking about today in power hour is the team's triggers in uh when you're creating a flow so we have one a new channel message is added they all say preview next to them by the way which makes me think that that maybe they'll there will be improvements that will come along and then maybe eventually they won't be in preview anymore and then um we have when i mentioned in a channel message that's very specific to me and then i have when a new team member is added so let just first i'm going to talk about this middle one because this one seems like it would be the most restrictive when i am mentioned in a channel message so this one is really going to be me whoever i'm running the workflow as whoever the trigger is running as that is me so that seems like that would be a very personal one so to me i i don't know if i'm necessarily even gonna go deep into that one because that's it's very specific you have to pick a team and you have to pick a specific channel so you can't just say i want to be notice notified anytime anyone mentions me anywhere in teams you have to go pick a specific team and a specific channel that you want to be notified when you're mentioned in when someone does an at and mentions your name so that's the the the cases for when this would be useful seem to be much narrower than the other two now you all can ponder this and let me know if you think about any um anything that you think might be super useful but basically each individual would have to have their own flow because it'd be running based on me whoever the user is so for this you can't just create a generic one and have it run as everybody it's just me and me means this name here whoever that action is running as all right so i'm going to delete that one so i'm going to move on to the other ones teams now when a new team member is added sounds interesting new team members so you can pick any team in here and you can send them a welcome now there are little out-of-the-box welcome emails that will arrive when just the generic microsoft one when you are added to an office 365 group or a team it says welcome to the team and it has a few just generic links in there well this gives you the ability to create a more customized it you know functionality for something to happen when someone gets added so one thing obviously that you could do would be to have it send an email to that person welcoming them you could have it send an email to someone else letting them know that a new person got added you could have it you know you have hundreds of connectors here and flow you could have it do anything you could have it go create an item in a table in a sql database or post something on facebook so there are again literally hundreds of things you could do but one interesting thing that i thought of was around this concept of the organization-wide team so i have an organization-wide team called all contoso so all contoso is everybody in the company so this means that when a two new team member is added that is basically when a new person is added in your directory that could be the trigger we we had a whole other power hour a few months ago about on hr onboarding where i you know i had a flow that i created that went through a bunch of steps like creating an item in a sharepoint list and creating a welcome email and assigning different things to people for new employees but the trigger that i had was the only way that i just out-of-the-box way without getting into powershell or or any kind of programming was that i had a notification coming from the office 365 reports and the audit log letting me know when there was a new user and i had that email notification as the trigger for all this new hr onboarding stuff happening well look at this so when a new team member is added i have an organization-wide team that is going to be the an easier way to know when you have new people in your company right and it actually works i tested it so what you can do is you could have this trigger be your hr onboarding now we've done lots of other power hours about possible things for hr onboarding i feel like we just did one recently just in the last month or so about um oh i don't was in planner i had when i knew when there's a new person joining your company i had all this these things getting created in planner and i had that one again a few months ago about um it creating an item in a sharepoint list and things like that so this let me show you what it org-wide team is i go into admin well i don't really have to go into admin let me just show you joel and i were kind of digging through admin to look at a couple of things but if you are a team's admin apparently we couldn't find a setting for this to say who is allowed to do this but we couldn't find a setting that said you know who's allowed to create an org wide team because apparently everyone isn't but if you are a teams admin you can create an org-wide team that's what we determine right joel if someone has a role of a are you on mute can you hear me now oh yeah i was but it's very faint okay yeah so joelle couldn't see org wide as an option and then when i made her an admin next time she went in here to create a new team she could see org wide so org light is a type of team that you create and when you create this it's it's not a team that people have to join it's just everybody is automatically in the team so that means that anyone who is a new employee is automatically in the team so my org-wide team is called all contoso so see all contoso and it's got let's go look at manage my team i've got who the owners are and then my company is very small so i don't have that many members but it adds people to this list of members when they're a new employee so here's what i did i tested this out i created a flow so i created a flow called new all contoso member and i said when a new team member is added to all contoso i'm glad thanks valerie i like you i'm glad you like that idea then now what it's going to give me is i don't have their email address yet so i do need to know their email address if i'm going to send them an email so i went ahead and did this get user profile so there's an office 365 users action called get user profile and you just need to tell it which user's profile you need and then because all this action provides me up here is um the unique idea of the user the user that that got added and so i'm gonna go get their profile and then in this one i this is again a demo tenant so the only shared mailbox i have is one called i t department so um you might not want to send an email to your new employee as you the person creating the flow that would be the send an email action would just send it as you you want to probably send it from a shared mailbox now in order to send one from a shared mailbox you um you have to have send as rights so whoever this flow is running as does have to have send as rights on that shared mailbox so it department is my shared mailbox and then i'm sending it to that mail field from whatever person just got created all right and i just did welcome to contoso this is a test but another cool thing that you also have with that get user profile is you have all the information from their profile so you could say welcome to the blank department and then um you could even i have an idea you can even get their manager so the manager is not going to be in here when you get their profile but i can say um get their manager now i just created this user a few minutes ago and i did not give them a manager so you'd also have to accommodate for them not having a manager so i'm going to get the user profile of this just the same person i get the user profile and then get the manager and then if they don't have a manager let's see um composed no manager and if they don't have a manager i can have it go down a completely different path but if they do have a manager i can have it send an email and i can actually cc the manager if i want to probably what i'd want to do if they don't have a manager is have it cc uh just somebody else because if you're if you're see seeing somebody in a flow you have to have um there has to be a value there that it can't be empty so i'm just going to say i want to see see the manager i'm not sure how far down that rabbit hole i want to go right this second but but i did run this and it worked so let me just uh save that and i'll just show you the one that already ran okay so here's what i did i went into office 365 went into users and did a test and i have a dog named rogue and these are all my little fake users here so i just added rogue rogers to office 365. so and i did this ahead of time because i didn't know how long it would take for you know when you add a new user it takes like 15 minutes for it to propagate across everything right so um rogue is now my dog now has an office 365 account so i added rogue rogers and i just waited and i just waited to see what would happen and then i went to my flow and look at that it ran so when a team member is added and then it just gives me this guide of the team member and then i use that guide to go get uh their profile and then it sent rogue a profile from the i.t department saying welcome to contoso rogue buck rogers her middle name is actually louise so anyway so i just wanted to see if it would run and see how long it would kind of take for that to happen but that is a good so that is a good way to do onboarding now someone was asking in the chat um well you might have to let me know what other questions there were but someone was asking at the chat if you could take an existing team and turn it into an org wide team i don't think you can but we can look we can go look in i'll go to teams admin and teams admin is also it's another one that um that's been in the voting for power hour topics for many many times i've had teams admin in there to see if you all wanted to cover that and it was never voted on so um let's just go look at our all contoso team come on teams admin alrighty um so joelle i can't hear you are you talking anybody else ask anything yeah i think i mean but i think we're just answering them so i'll let you know if there's okay all right so here is all contoso that's the one that so when i click on it it doesn't show right here whether it's a org-wide team yeah i was saying it just it says public just like the rest of them yeah it says public but the reason i know just off the top of my head is that this was the description when i created it check here for organization announcements and important info so it uh it's again maybe it's a new enough feature that it doesn't have information about whether it was created as yeah it's just got some settings in here it doesn't have anything about whether it's an org wide so if i go to another team it's not going to have a button that lets me switch it to org wide i'm pretty sure at least right now that's not going to be something that you can just go change let me just double check really quick now it's just got privacy private and public this one's public but yeah i know it doesn't have anything about whether i can switch it to be org-wide i'm pretty sure you just have to create it as org-wide all right so that's that about org what was that i said i bet there's a power shell for it but oh yeah maybe but not now um okay so that's what i did so i created rogue rogers and then rogue rogers it triggered the flow so then think about whatever you know this would just be a good way to of course this in the simplest form of this you could just have it send them an email when they get added to whatever team it is welcoming them to the team and letting them know more specifically what is expected of them in that team what is the team used for and things like that that might not be in the out of the box microsoft welcome email that they get but i think a good little sort of hack for this one is to have it the uh org wide team be the trigger that way for every new user in your company you could have a flow that sends them an email lets them know about orientation goes and creates an item in some database where you're tracking people going to orientation or um registers for them them for something tells p anyway so it's just a lot of a lot of things that you could possibly do with having a new user all right so um all right so i'm going to go ahead and there's another action that go here and close some of this stuff um just as just for fun just to finish kind of what i was showing you with this if you wanted to have it if they don't have a manager and you don't want it to just error out and stop here's what i would do just kind of just kind of throw this in here i'll just do a variable um i have to not set a variable i have to initialize a variable i have time initialize a variable for var manager email and then if they don't so let me go to this i'll make this error out or make this only run if it errors so if it if get manager has failed it's going to go down this path and if get manager has failed it's going to set a variable so if there's no manager i'm just going to set this variable to have i could have someone else's email address but i could just have the email address of that user just so it puts their same name on the 2 and the cc and then i could um i just get rid of this compose but if i get rid of compose i have to redo this i don't i don't have to redo the run after so you used to have to redo that if you got rid of the top one it looks like it's smart now it figured it out okay so then i want to do i could just let's see if i can copy and paste this all right yeah so if it errors out i'm setting myself as a manager if it doesn't error out then i'll put the manager email let me make sure i put the right oh look see that wasn't supposed to be the manager email all these orange ones look the same so there we go user profile email if they don't have a manager manage your email if they do and then this thing needs to go sort of in the middle so when you have a problem like dragging something out of a branch into the middle i'll usually just go add just a compose step just in here as a dummy so i can drag this down here there now i'm sending it to that variable so whatever path it goes down and sets the variable um sorry sending it to the user and i'm c seeing the variable it's trying to go too fast all right make sense so let's go i'll just retrigger it real quick and see what it does because rogue does not rogue the dog does not have a manager okay look at that oh so let me show you what i think let me show you what i did wrong okay so this isn't this is even in my class i just you know didn't do it myself i didn't set the configure run after i don't want both of these to be successful obviously it's not i set it to not go down both paths at the same time i want it to go down let me click done i want it to go down and go to this last step see i had to do a succeeded and skipped on both of these so whether this one succeeds or is skipped i want it to go down here or whether this one succeeds or is skipped i want it to go down here but either way whichever path it goes down whichever one is succeeded or skipped i i want it to do this email no matter what so that's why that last one didn't run and go all right so there is so rogue does not have a manager so it just put rogue in the two and the cc and it successfully send the email you just you just can't have a variable in the cc and have it not have a value in it so that's why i just had to put a different email address in that um cc all right they're all in the chat talking about dogs and cats having middle names and managers and things all right now here's another fun one we'll go back to um flow okay so here's another option so here's what i did i said and joelle came up with this awesome idea you have a help desk and when a new channel message is added in your help desk channel you can basically ask them more questions about their help desk item and ask them give them a choice and just give them a response create an item in your help desk system so i started doing this i didn't want to go too far i want to be able to build more of it live so what i've done so far is i created a team and called it help desk right here and i created it as a team which of course created a sharepoint site so here's my help desk and then here is my help desk down here and i made it a public um it says org up here it means channel content is accessible to everyone in the organization because i made it a public team i didn't make it an org wide team could have done either thing so this is a help desk team and then when so when a new message is added in the general channel let's just say we're telling our users to go here and um if they have a helpdesk question if they want to open a ticket they can just go to the help desk channel and just type whatever their question is so i'm i'm basically making use of that and kind of doing this thing with a bot with the flowbot and the flowbot is going to ask them questions so that's kind of fun right so what i'm going to do is as soon as someone asks a question joelle can you go you can get to that one right in wonderlaura which one can you um it's that help desk uh team in wonderlara and just go type a question in the general channel like you have a computer problem or something yeah let me go check it out so while i'm describing the flow and what it does i'll let joelle go in here and she's gonna go in my little test tenant and type type of question and we'll just after i show you what it does so far then we'll see if it's working because i have not tested it yet i just created it and you all feel free to you know think of other things as i'm doing this other ideas and we can brainstorm together fun little ideas about what you could do with these teams triggers that we're talking about right um okay so when a new message is added it's going to first it's going to acknowledge and tell them that they've written a message it's going to send them an a personal message so instead of cluttering up the main general channel in the help desk i decided to use use these two user actions post a message as the flowbot to a user so it's going to send them an individual message to the person who posted as opposed to just having things all appear in the channel and it could be messy and then everybody's seeing each other's stuff so right it's up to you but i just did post a message as the flowbot to a user so i gave it a headline i just typed helpdesk ticket recipient is going to be basically whoever triggered it so that's the whoever posted the message that's going to be joel then i see i see you're asking about and then i've got this is all the data that i have about whatever they just posted see i have tons of data about whatever message so when a new messed message channel is added i have the body content content type date i have e-tag which is like a version [Music] username user id just message importance just all kinds of stuff about that message so i say i see you're asking about and then i just put the message body and then i immediately say what is the category of your request and the recipient again is that same user and the headline is going to say help category so then in my i created a sharepoint list so i created a sharepoint list called help desk tickets and i've got it's pretty basic it's got a subject it's got a category of software hardware or login and it's got a description product lookup if they're asking about a certain product and whether it's high priority or not and then later on i'm gonna be assigning this to somebody and then it's also got a status and even attachments so that's so what i'm gonna do is uh what i did was i i typed the three options software hardware login i just type those as in here as what the three choices are so it's going to prompt them and ask them what which one of these they'd like to pick and then it's going to create an item in my help desk system now i haven't tested this so i don't know if the selection selected option if whatever value they click this data is going to match what it's expecting here i would hope it would but again i'm not sure yet so it's going to say in my help desk ticket i'm just going to say the title of the help desk item is going to be the person's name and the date just to have something nice and generic in the title and then the description is going to be whatever they typed in the content of their first message it's going to have the category they picked and then we can work on some other other stuff right um any see any questions oh valerie says i can use this for our record of work system oh i'd like to hear more about that that's interesting there was a question earlier from i guess from your other flow where they were just getting an error a specified folder not found when they tried to send an email from a shared mailbox i just didn't know if you knew off the top of your head but that could be i usually get that when when the syndaz permissions aren't correct and it usually it's usually something that wasn't done in exchange or if you added them as a send as an exchange and it hasn't finished propagating across um yeah that sounds more like it's like the permissions on the mailbox i have seen that though and yeah um maybe at the end if we have extra time we can go dig into where that setting is for shared mailboxes um all right so did you you ran it right let's see oh yeah i put two comments in there okay oh it's still running oh interesting so did it ask you the question let me see yes and and so you already did click an option not yet i could okay yeah go ahead and click an option and let's see i just got that i just got it oh okay so it took a minute for it to post the message to you and i can go test it too so um i'll just do one real quick too okay so joelle typed my new team member rogue rogers needs access to sway billy bob needs a laptop and i can say my login isn't working okay so these are joelle's messages to the help desk and then mine and then so what it's supposed to do is send me a chat so when the flow runs that little flobot is going to send me a personal chat so it's like joel said it's going to take a minute let's go look i'm getting when i try to click it i'm getting it unable to reach app please try again oh okay i click the i'll go ahead and replicate that then okay let's see if i can get it to come on flo send my message oh it's not even showing mine run yet i guess it takes a minute just to trigger it oh yeah zac you're right about exchange issues recently or maybe those are just outlook issues we've been having recently but i had had some issues with outlook and it was driving me nuts i kept uninstalling and reinstalling it now it just works it's weird um okay let's see if it it posted the choice of options but then it then you clicked on an option it didn't do anything it just said unable to reach app please try again when i tried to hit i clicked an option hit submit okay oh uh well i wonder if i was gonna say i wonder if you don't have access to that to that sharepoint list but you do right can you go to straight to that sharepoint list i'm pretty sure what's where was that list um that's in that help desk site just okay the same one yeah because you're it's a public group and you're a member of it i'm in the team yeah let's do some live demos rule yeah yeah well um okay stuart says does anyone know any actual triggers return in emails outlook category ooh you'd have to look at the raw data um when you use it what i'd use to try try and figure that out stuart is create a flow that's triggered when an email arrives and then just crack it open when it runs and look at like all this little raw data about it and see if it's got a category see i could have sworn we had already done a power hour with the poster choice of options as the flow bot and yeah i think so we had already covered that so i was just like oh well that that's gonna work because we've already tested it so how hard could that be right okay i did get my message from flo so here's mine it says i see you're asking about my login isn't working what is the category of your crest i'll click login enter comments it wants me did it ask you for comments yes okay this is stuff i didn't even tell it to ask for comments that's weird unable to reach out okay yup i got the same error all right let's troubleshoot that's what the end of power hours for right yep last 20 minutes the 20 the troubleshooting 20. so we're calling it the trouble shooting 20 we always like to whatever it is we're covering we always like to try and break it and mess something up i totally did it on purpose yeah absolutely okay so let's just try um not having it do anything now the way you can sort of comment something out in a flow is by having it um just setting it to something different like if it's skipped then do this and uh just basically it won't it won't go to this okay so i'm going to save that and then i'm going to run i'm going to kill it like cancel my so this one's mine that i posted see here's my raw data there's laura rogers okay so i'm gonna cancel that one that's running when you post a choice of options their flow will be running and running so that's another one of those pet peeves of mine is to have a flow running and running and it it's going to time out after 30 days so flows anytime you have a flow just waiting or running or pending it's going to time out after 30 days so you can't plan for this to just be asking them and waiting forever for them to answer the questions so just kind of know that and plan for that all right so i'll resubmit it so it should ask me again okay see now it's asking me again i think yeah yeah see this is the air i got before i wish i could change it to not say comments but to say something else okay it didn't error out that time so apparently the error is in the um when it was trying to create that help desk item see look at ran fine okay interesting um let's see i can't imagine why creating an item in sharepoint would be causing an error but i'm reading everybody's comments oh that's awesome oh yeah we totally try and break things okay so um it posts that let's just do some more options that it's going to ask them so we post their choice of options to the user it um it's saying message summary is an extra thing that you can add and then is alert so that's going to be whether it will show in the activity feed now when i did this one above i did it as an alert so it didn't do them both as an alert but it's going to alert them and they're going to go over to their messages and they're going to see both of them so and i don't even have to do these as two separate things i just kind of wanted to show you know highlight the two like just different ways that you can communicate back with the team's actions so then i'm going to post a choice of options as the flowbot software hardware or login and then what are some of my other options i've got um the priority i've got is it high priority or not and then i've got now some things that i know about the user too is i know everything in their user profile i know what department they're in i know what uh who their manager is i know their phone number and so all kinds of things that now i know about the user that i could also put in this and incorporate into whatever help desk ticket that i'm creating as well so um let's see if there's anything weird in this i'm wondering if there's just some weird setting that's not allowing that item to be created that is re that is very odd that's an odd error help desk ticket um i could just try that again i'm not sure how much i want to troubleshoot that though let's ask them some more questions so we want to know if it's high priority and if it's high priority they need to get it approved yes there we go okay so if it's is it high priority so teams and i'm going to post a list post a choice of options as the flowbot to a user and i'll say yes it's high priority and no is this a high priority ticket and okay so this is something that we could use the comments for all right so it's going to ask them if it's high priority or not and then if it's high priority so this is a good thing that i can do with uh the condition now if you had several different options and this is something that i kind of kind of covered the concept of last week you have several different choices different paths you need to go down a switch is instead of an if because and if it's just one thing or another really but if you have a whole bunch of different branches sort of that you need to go down a switch is going to be a good action that you'd use instead of a condition so if i had you know if they pick this category go down this path this other category go down this path etc i would use a switch this is just a condition is it high priority or not so um oh you know what joelle that error could have been because of that um that one setting with the selected option because it probably maybe it didn't like what i was trying to put in there it didn't like the value so it couldn't put it in the field gotcha that makes sense that's definitely that's highly likely so remember i was like well i don't know if this is gonna work or not well that's what it was it didn't work so what i can do as a temporary test so i do want this to run and what i can do is a temporary test is in this category field i can allow any value to be written to it therefore i can see what it's putting in there and i can see what values coming from is going to be coming from the flow so first i'm going to run it with no option going to it then i'll put that as the option okay so if it is high priority so selected option is equal to yes oops this is going to be this is going to turn out to be pretty cool if it's yes then i need to get it approved so then i want to get the person's manager and get it approved by their manager yes okay actually i'm just going to put it going to me for now instead of because i just showed you all that whole manager thing and yes no if they have a manager it goes down one branch and all that stuff i'm not going to build all that again for this i'm just going to say it's just going to go to me i'll just be the manager so i can get this done in the next 15 minutes all right start and wait for an approval approval type um [Music] first to respond i'm just sending it to one person and approval for a high priority ticket by and then i put the person's name user display name and then i'm assigning this to i'm just going to put me but again that can be dynamic all right this is do you approve this as a high ticket and then i can put whatever their uh message was message body content and i don't need to send them a link to anything because i'm just putting the content right here and i'm just asking if they approve it so um oh you know what even better i can send it to the manager in teams delete watch this i think we've done this in another power hour too but i just wanna this is since teams is getting to be so huge i want to really highlight the fact that you can do this so i'm going to do this again real quick so high priority ticket for display name assigned to me and details do you move message body see where i'm going with this joelle does that make sense yeah okay so i create an approval and then i um wait for an approve then i post a um let's say wait for an approval but in between there i can do a post to a user so this is where i'd post to their manager post a message as the flowbot to you post an adaptive card as the flowbot to a user and again this is going to be more dynamic this is going to be the person's manager i'm just trying to hurry and show you all how this would work and then what i have when i do um a create an approval i don't have this when i start and wait for an approval i have this when i do a create an approval action because then i can use that adaptive card that's in the approval so i'm posting that adaptive card as my message and it's going to be an alert to the person's manager then i can wait for the approval which approval am i waiting for i'm waiting for the um that i get that id of that approval i created approval id okay and that's only if it's high priority it's going to do all that if not it's just going to go down this other path and either way it's going to create the help desk item y'all ready let's see what happens okay um i'll just re-run no can i rerun it let's see now i don't have a manager so it's going to skip the manager part for mine i think oh wait i do have a manager in my test tenant i have garth fort let's see can't log in okay so then the flow should be moving on let's see oh it didn't ask if it was high priority look at that let's see two not found oh let's see what did i put that was two oh i didn't put a recipient that would help okay so it needs to go to the message from user id and it's all left out let's do it again and in the meantime i'm going to log in as garth fort my manager okay it's posting my question login help me they'll get in the drift any other ideas of what you could do with this uh this whole no it's doing the same thing with unable to reach app oh let's see that is that's that's different see that actually worked the first time we did it when we didn't put anything after it but then as soon as we put something after it it bombs out i'm going to try it i'm going to try starting it completely from from scratch just so i'm not running rerunning it on the same thing over and over so let me do that one more time anybody i'm not looking at the chat but anybody coming up with any other ideas of what you could do with all these teams things to ask questions and create things um problem with outlook given that they all work and you know how to troubleshoot flow right joelle exactly oh my gosh y'all are hilarious marie said are you planning on writing a book on the power platform power platform changes so fast by the time the book would be published uh the product would be all different so no no way nobody's writing books anymore about this stuff i mean did you all hear about the new data flex that they just announced uh yesterday cds is now going to be called dataflex pro and then data flex is going to be a new like lighter version of cds so i'll i mean i'll talk about that more in a second let me see my flow it does take a minute to trigger doesn't it i'll go cancel these other ones so yeah i guess while i'm waiting for it to trigger so did y'all hear about that so yeah cds is being renamed and um it's basically you're going to have in teams you're going to be able to create power apps directly in teams and this data source it's going to use is instead of sharepoint it's going to be this data flex thing and that will be what you're going to be creating your tables and things um in and creating your power app in when you're creating powerapps directly inside of teams and that's going to be a whole new thing that is coming out i tweeted it out yesterday i think a link to that okay let me see this one does take a while to uh to trigger because i just typed a new message in here and it just or does it take like five minutes just for it to yeah it took a good bit of time yeah i typed problem with outlook well let me see if i can find that tweet while uh we're talking about it because i was gonna try and kind of mention that towards the end well it's the end and um um maybe i didn't tweet it out i tweeted i retweeted someone's blog post that they wrote about it so let me just give you all i have a little thing that i buffer my tweets so it's probably just in the buffer so i'll just copy this um blog post about dataflex to the general channel i like the name though i like the name dataflex better than cvs the whole renaming thing um gets kind of annoying but dataflex is a cool i think it's a more catchy name it kind of explains it better than cbs does they were talking about earlier in the chat though that i think that that name might be come under some controversy yeah i guess it was trademarked by another company oh really yeah so if you scroll up in the chat i think valerie posted a link okay where they're kind of chatting about that a little bit it'll be interesting to see what happens with that oh what was it wasn't it one drive that uh or skydrive yeah the sky something i remember that yeah because the sky tv and the in the uk like came after them yeah i remember that oh my gosh um oh yeah here's the i had it i had it buffering to tweet so let me copy that link and put it in the chat too that's the official announcement announcing dataflex a new low code platform for microsoft teams so oh look i finally got my little alert here i'll just click submit without putting a comment okay is this oh so it asked me the next question that's good i'll just say um for now i'll say no it's not high priority oh then it aired out at least it asked me both questions oh my gosh and whenever i whenever i'm building a flow joelle i usually like to set aside like three or four hours for troubleshooting all the troubleshooting yeah so yeah i just got stuck right here and then um okay let's go look at that oh see it doesn't give you the raw data of what your choice of options was but even so even if i had the condition wrong it still would have gone down the no path you know so i wish it would give me the raw data of what the choices were now when i'm troubleshooting and needing to see the raw data of something sometimes it helps to use one of those compose actions if it gives me yeah so there you go it it provides me at least so i could see what the selected option what that data says so then i could run it again i could test it and fire truck i'll say um submit that's weird now it's airing out on the first one oh no it went it went through see yeah that is weird because it's it's like it's uh randomly erroring out it's maybe maybe you know what it does say preview on all these actions so we should probably take this with a grain of salt that it says preview so potentially that's why these are so buggy because they're preview actions and they maybe don't just don't work correctly you notice i just clicked the button again i had just clicked it i just clicked it twice and then it worked the second time so that tells me that maybe i wasn't necessarily doing something wrong that it's just a buggy action um all right so that one went through look at that so it created my help desk item because it was not high priority so i'm going to do i know i've got two minutes left i'm going to do one more because um by the time this triggers it'll be almost time to go so i'm going to do one more and this was this one i'll do as high priority okay so um blue screen of death okay so that's my ticket let's wait till until that gets published now let's go look at the one that just ran that was not high priority so that created my help desk item so we'll go look at my help desk tickets and look at that so it gave me it didn't put the date in here that i had set for it to put up and it also didn't put the category because remember that i had taken that out completely because i wanted to test it and run through the test at least once without the category to just make sure that it was creating the item that's how i like to troubleshoot is by narrowing it down and then you know taking things away and then adding them back slowly that's troubleshooting steps that is what i should call this power hour joelle troubleshooting stuff in office 365 so we're always doing isn't it okay so that created it so that's good now what i want it to do is i'll go run the same i'll go edit it and i'll go actually put the option back in there and then i'll just rerun that same one so my category value is going to be whatever they put as their um that last response to what the category is so this one up here i'll type category in it and there so so these are different so one's asking the category one's asking the priority so then i'll put category value is going to be i've got to put the right one selected option there okay and then i'll let it save it and retest it that was my succeeded test okay and then this other one it has gone ahead and asked me what kind of category it is i'll say who knows that could be hardware and then i'm just going to click it again because maybe that's just what it does since it's buggy and it's a preview oh it's promising it's spinning it's a spinning wheel it's i've got my cooking show going on i've got like one float going over here doing one thing and then i've got another flow kind of doing something slightly different does that hopefully everybody's following i'm barely following so i don't know yeah this is oh see that time it went through ah so that's sketchy all right is it a high priority um this again i'm gonna say no on this one because this one's the one that i just changed the selected option for it to actually create the sharepoint item and do an option and then oh valerie's got to go to a meeting yep everybody's going to go now um then i was asking at about the blue screen of death and then i was asking about the problem with outlook so let me see i guess i can't ask for too many things at the same time huh all right let's just go look at what went correctly if it created it okay so look at that the category did so the category itself remember when i i took away the category because that when i was troubleshooting i thought maybe that was the problem in creating the sharepoint list item but it turns out that creating the sharepoint list item wasn't the problem and anything i was doing in the flow wasn't the problem it was just that action itself was buggy and i had to click the button multiple times and then i then it would just run so unfortunately those are again in preview so that did correctly create my category that's good so it created my item and then so what you could do was i also have a priority field in the help desk ticket so i could take the uh whether they picked high priority or not and i could put that in here when it creates the ticket and i did want to do one where it goes and asks for approval with the manager so i'm going to just re-run one of these real quick so i can see that that functioning and thanks for sticking around you're sticking around i'll go edit it and test it and this time i'm going to say that it is high priority so that it gives my um sends my manager an approval hardware and go high priority yes okay now my manager is garth fort [Music] oh remember i didn't put garth ford in there i put it i sent it to me so i wouldn't have to log in as garth fort so look at that so remember when i said to send it as an adaptive card to send the approval as an adaptive card to who would would be the manager now i got the approval so in the real world you wouldn't be approving your own thing right but um now i'll go ahead and click approve and again you can add comments and submit so that is the that is the adaptive card that's where i said to create an approval then i said to post as the flowbot post an adaptive card to a user that's the adaptive card of the approval and then i approved it and then that workflow finished and went through and then it would have created another yeah and then it created another item in here so cool yay that i i consider that a successful power hour what do you think yeah it was cool so yeah it was a little touch and go there with the buggy team's actions but it turns out it wasn't i wasn't doing anything wrong it's just a buggy action that i had to click twice all right so yeah as i was mentioning there's been a big announcement microsoft dataflex used to be cds so cds is going to be dataflex pro and then this new lighter free i'd say free and quotes version is going to be called dataflex it's going to be built into teams where you can build power apps in teams and we're going to go ahead and incorporate that in our week-long powerapps and power automate training coming up in august september august 17th through 21st at iwmentor.com thanks everybody for coming i know i went five minutes over that was kind of a fun one thanks joelle for helping out with uh figuring out that idea for the help desk tickets and everybody for chiming in and y'all have an awesome afternoon have a good one everybody wednesday bye everybody

Channel: Laura Rogers

Views: 2,039

Rating: 5 out of 5

Keywords: SharePoint, Office 365, Teams, Power Automate, Flow, Microsoft 365

Id: EB6eTDfV7vA

Length: 66min 8sec (3968 seconds)

Published: Wed Jul 22 2020