Create your first custom app for Microsoft Teams with Power Apps in 5 minutes - Dataverse for Teams

[@NKBobcat]

I had to create an app during the taping of my interview. I had never done it before but had to look like a pro. The difference between the Canvas app maker and this one was challenging with a camera in your face and another on your screen. I wish I saw this first! This was three weeks ago. I am excited that you are excited about Project Oakdale because I see endless possibilities!

[@ShanesCows]

Camera in your face is challenging for sure Bob! 🤩

[@huntbk]

Thanks, Shane! I watched a couple of similar videos before I saw yours, but wasn't able to get started. After 15 minutes, I not only created a useful app right away - I'm hungry to add more to it!

[@ShanesCows]

Great to hear!

[@stuartduncan2772]

Hi Shane, thanks for all of your videos. I'm just getting into Power Apps and finding out how to do what I can do in Excel, Access etc. I've created an app that, like your one, lives in a Team. It's based on a phone template and it works soo all good. My question is, Is it possible to place an image in the window where my browse screen sits. I'd like the whole window to have our company colours, logos etc with the browse screen in the middle. Is this possible without change the app to be a tablet style with only the gallery's displayed in the middle?. Keep up the great work.

[@ShanesCows]

Not that I can think of Stuart.

[@janvanderwijk3771]

Thanks Shane for you highly informative videos. Big Up!

[@ShanesCows]

Glad to help. 😀

[@jajirshdmeaners9415]

Very helpful. Subscribed!

[@ShanesCows]

Awesome, thank you!

[@wendymason3263]

Thank you Shane and happy anniversary whenever your anniversary is 😊

[@ShanesCows]

Thanks Wendy. 🐶

[@rkc6214]

Thank you so much for the very informative video, instantly subscribed! I just wanted to ask though; if I were to share this app with other users, will they need a Premium license to use it? I followed along to create my own app along with a table, but when I checked the License Designation of the app, it shows it as "Premium" instead of "Standard" (I haven't added any other connectors either). Does using a table made in a Dataverse for Teams environment really require a Premium license, or is there a way to share the app with end users such that they don't need a Premium license?

[@ShanesCows]

RKC the app will not require a premium license. I don't know why Power Apps shows that because it is wrong. :)

[@rkc6214]

@@ShanesCows I see. Hopefully Dataverse for Teams tables really aren't a premium connectors since I'm planning to build something very similar to what you demonstrated, like an employee tracker app using a database to store info like their names, job title, etc. Thanks once again!

[@projectdrew3250]

What if you need the form to scroll because all fields are not on the screen?

[@ShanesCows]

Forms should automatically scroll ifyou have too many fields. Also, here is a video on scrollable screens. kzbin.info/www/bejne/Zp2xfGx4rZmEgac

[@tenisviejos]

This is incredible. I will try it for sure. Posibilities are limitless! Still not available on my teams atm :(

[@ShanesCows]

Boo! Hopefully you get it very soon. It is so cool.

[@tordsonander]

Wasn't available for me either, i thought, but if you press the button on the "old" Power Apps logo it sends you to something that is labled "Power Apps (Preview)"

[@TimMorley]

Fantastic delivery! What I'm confused with the difference between full power apps and teams version is media in tables. Can you save a photo within a teams table? Am I being stupid?

[@ShanesCows]

Yes and I am 96% sure I show it in this video. kzbin.info/www/bejne/pV6TpGaGps1jiqs There is an image column type in Dataverse

[@samosgroup1862]

Hi Shane, can the apps that live in each team talk to each or get data from one another?

[@ShanesCows]

Each team is a bubble, you can't really share the Dataverse data between them without the app becoming premium. If you use SharePoint as a data source you could though.

[@Sofusmikkelsen]

Hi Shane. Pleas can you tell me. in what video you talked about Getting power apps on teams to work on a mobile device.

[@ShanesCows]

I don’t think I have a specific video for that. Something not working for you?

[@jimmidouble8679]

Another Great Video. Can you use this with the Office D365 users connector. I can see it in the list but don't seem to be able to use it.

[@ShanesCows]

I don't know... I haven't tried that one. I don't do much with D365. 😐

[@donaldfo1]

I Shane. I learned, much to my chagrin, that Dataverse (for Teams, at least) creates a metadata column called "Status" for new tables. The problem is, that's a very common business term, and I have a lot of databases that have a column called "Status." I'm worried that Dataverse Is going to eventually write to that column, overwriting my own data. If I need to change my column name, it will involve a whole bunch of work changing tons of references to my Status column. Can you shed any light on this? Is Dataverse going to take over my column, and eventually the world? Thanks!

[@ShanesCows]

No, you should be safe. Even though the display name is the same, the underlying system names will be different. Though you will want to make sure you don't accidently grab the wrong one, I am not too worried they will grab the wrong one.

[@bernardking6478]

Nice tutorial, Shane. I had some problems, though. It seems that formulas separate values with comma but if locale is not English those commas need to be substituted by semicolons, which makes using templates a little hard. Is there a way to get that changed automatically?

[@ShanesCows]

I think they are aware of this issue and working on it. Sorry :(

[@colby4390]

If I have an app I built on the internet and not in Teams can it be transferred?

[@ShanesCows]

Not that I know of. 😑

[@tylermckinna5850]

Shane, Thanks for the helpful tutorial. How did you add the ability to send e-mail from within the app? Also, could you have it set so that when you select the employee email it launches an email to that employee?

[@ShanesCows]

Yes. This video should help you with adding Outlook to the app. kzbin.info/www/bejne/rKG8nIKZmNyhars

[@bruceherz3664]

Great Job - Question. We have used SharePoint as our data source for VISIO. Can VISIO use the CDS as a data source?

[@ShanesCows]

Sorry Bruce I have no idea.

[@RyuzakiF]

Great video! where's the Link you mention to the longer video? And what's the difference between creating an App this way over creating a PowerApp from PowerApp studio and then adding it to a Team or even adding it as an App in teams for the users that need it

[@ShanesCows]

43 minute deep dive training is here kzbin.info/www/bejne/pV6TpGaGps1jiqs The differences are 1 - You get a Teams integration object 2 - you have access to the Project Oakdale datasource (Tables) that is an awesome data source without a license.

[@AliOGUL]

is it possible to add the tab to a chat group?

[@ShanesCows]

Not sure. Sorry

[@AliOGUL]

@@ShanesCows I tried many times. unfortunately not possible. these are only for Team groups. I wish we could create apps for chats too, like Microsoft forms

[@_sai_teja]

Thanks Shane. How about the responsiveness of the PowerApp published in the teams ? Is it responsive ?

[@ShanesCows]

You can customize the sizing to scale to fit. I still wouldn’t call it responsive but would call it okay. True responsiveness is coming sooner or later. 😀

[@stanleym69]

Hey Shane, Interesting to note they don't have Dropdown Inputs in the Teams Powerapps. Bit painful, ill have to work out another way to show stores assigned to a user.

[@ShanesCows]

I hadn't even noticed that Sam. Use a combobox instead. They are almost identical in how they work.

[@coitmorrison1323]

Intriguing - thank you! Can you connect tables to make them relational?

[@ShanesCows]

Yup. kzbin.info/www/bejne/oYeopZ1thsmFj7s

[@tonyedwards8067]

Nice tutorial !! 👍

[@ShanesCows]

Thank you! Cheers!

[@shashank2509]

How do we put the created app in public marketplace?

[@ShanesCows]

Not possible that I know of

[@ramisolipe7001]

Hi, I don't have an option (power apps (preview)), I have just power app. and it takes me to power app website.

[@ShanesCows]

Not sure why. Power Apps should take your to Dataverse

[@DataisKing]

I have created a PowerApp in Teams and added it into a Teams Channel. I have added some users into my Teams Channel as Owners and some users as Members. I have added a tab at the top of the Teams Channel. When some of the users click on the tab, they able to view the app with no issues, but sometimes these same users will receive this message. "This app isn't opening correctly. It looks like you don't have access to this app. Ask its owner to share it with you." Any ideas of what may be causing this? Also, I have the Govt version of Teams and this version does NOT have the option for me to share my App with others.

[@louismartini6983]

Great Video! You mentioned that the default data source was CDS. To do app development in Powerapps using CDS outside of TEAMS you have to have a special license with Microsoft. Do you know if that is true with TEAMS?

[@ShanesCows]

No extra license needed in Teams. 😍

[@HeyTezza]

I was hoping someone asked this question, thank you and thanks for answering Shane, now I’m so excited to give this a try :)

[@gregfyn]

Did they yank the preview? I didn't see it in my search.

[@ShanesCows]

So people are only seeing Power Apps without preview. Try that one and see if you get the new functinality. The joys of preview. Always changing. 😀

[@iamjoshknox]

@@ShanesCows It looks like they removed preview from the title in the app store - but it's still in the header once you open the app...at least for now. Thanks for the video! Previews are fun:)

[@kensleylewis]

what if we want to share it outside of the original team environment, into another team area? Can we publish to multiple locations? If so, how? I usually have a teams development location, then release projects once developed, into other official team locations.

[@ShanesCows]

There is something new called Shared with Colleagues. It is on my list to make a video on soon. It will let you do this but not exactly the way you are thinking.

[@kensleylewis]

@@ShanesCows looking forward to seeing your example. many thanks.

[@pranavp8581]

Thank you so much for this information. I need your help to get answer for some of questions, where I can find this data source? Is it possible to connect the data with a powerbi?

[@ShanesCows]

The data source is not available in PBI yet. I show how to open this data source from Flow in this video. kzbin.info/www/bejne/pWfPeaSJeLWshc0

[@pranavp8581]

@@ShanesCows Thank you so much Shane. It helps me. :)

[@chrisgrubbs6880]

Shane, this is interesting stuff. Are there limitations to the data source used here? I use the platform to have users enter quality reviews. Currently I am using sharepoint lists, but am now running into issues with the list hitting the max 5,000 items. I am trying to determine if this way would be better vs writing straight to an excel file.

[@ShanesCows]

About a million rows is the planned limit. 😀 Some good data here powerapps.microsoft.com/en-us/blog/a-closer-look-at-data-platform-capabilities-in-project-oakdale/

[@edgarabud2721]

why use this and not the application from powerapps directly or use a customized list form from a sharepoint?

[@ShanesCows]

1 Oakdale is better performance than SharePoint as a datasource. 2 if you mostly teams based use Teams. If you are mostly SharePoint based use SharePoint. 😀

[@manojg6226]

Thanks @Shane, This is so cool. We are using Dataflex here right? Where can I get more sample apps to review and study?

[@ShanesCows]

I think I show you in the long version how to load the 3 sample apps they included so you can check them out. kzbin.info/www/bejne/pV6TpGaGps1jiqs

[@ashokpershad]

Shane, I am not able to find "Default" and "Reset" control for Textbox Input box in PowerApps for Team...Is it a bug or its not available?

[@ShanesCows]

THe controls are slightly different. Might have to build you own. Value is the same as Default. Reset you will have to make your own Reset functionality.

[@ashokpershad]

Shane Young ....and how we can make that Reset Functionality. ? :)

[@Bigsby_]

Great video, thanks Shane. Just wondering do you know how to assign objects in the CDS to users, say I had a table with laptops and I want to assign one to you and one to Nicola can i pull that in with the O365 connector?

[@ShanesCows]

In CDS there is an Owner attribute you could assign.

[@Bigsby_]

@@ShanesCows sweet, I will give it a try. Thank you. I wonder what it does if a user is deleted after being set as owner

[@JGNiDK]

Any idea how long it should take before it should come in Teams? Still nothing here in Denmark...

[@ShanesCows]

Supposed to be live already. Not sure why you aren’t seeing it. Maybe your IT found a way to block or delay it?

[@darylt11]

Hey Shane, great content as usual! A quick question, where is the "share" control for these apps? Just did a quick one to show a colleague, for the life of me I cannot find "share" anywhere!

[@ShanesCows]

You publish it to the team and everyone in the Team can see it. No individual sharing with this.

[@debraedelman5656]

I don't have Power Apps Preview.

[@ShanesCows]

It is just Power Apps now. Don’t need the preview now. 😎

[@adsprevention6930]

As a follow-up to my previous comment, can my staff begin to enter data once the PowerApps is created in Teams? It shows as PowerApps (preview). Thank you.

[@ShanesCows]

Yup.

[@tordsonander]

Not related to this vid but is there a way of passing a series of commands to a component? Lets say i have a top-bar with a save-button as a component on several screens. On one screen it should save whatever content is on that screen to a sharepoint-list and on another it should send an email with some other stuff. Today i am placing some icons on top of the component to do this which is kind of opposite of the purpose. It would be great with a datatype of "formula" or something.

[@ShanesCows]

I have seen others ask for this and I get the impression Microsoft is looking into this idea.

[@driesvdc2]

Hi Shane, thank you for this video. This capability will no doubt encourage many non-developers like me to build small apps in teams. Is there a way to do repeating tables in this framework? (Your videos on this topic for canvas apps were very useful)

[@ShanesCows]

Yes. I have a whole series on it kzbin.info/www/bejne/rpjdn55qjdGDedE 😀

[@AlabasterGrim]

Hey Shane, thanks for the great vids, I have been trying to do a calculated column in Project Oakdale while testing things out and it wont open the calculated field editor, opens browser window and after refreshing several times says it cant log me in. Is this a limitation of Project Oakdale, or is it just not working in the preview yet?

[@ShanesCows]

Not sure David. 🤔 Are you on Twitter? If you ping me there I will try to get more info.

[@adsprevention6930]

Thank you for this video! My organization installed Microsoft 365 in Jan. and I am 100% new to PowerApps. I am looking to replace an infopath form and hope that PowerApps within Teams will be the solution. Questions: 1) Where does the data go once entered into the PowerApps form? 2) Can the data be downloaded from Teams? 3) How many columns can be added to the table? 4) If is possible to use Excel to create the PowerApps? I've watched some of your other videos and am subscribing now.

[@ShanesCows]

Try the full training video here kzbin.info/www/bejne/pV6TpGaGps1jiqs 1. Saved to CDS, an under the hood data source. 2. Not yet but will be. 3. Not sure the limit but a lot. 4. Nope.

[@titahaver6290]

Great Shane. Thanks again🤩

[@ShanesCows]

You are welcome. Hope you are as excited as I am.

[@titahaver6290]

I am gone try it straight away. I Was in my way to build a power app so now I will try from here. 😍

[@natipapirovitch5611]

Shane - as this using CDS - does it requires the Permuim Licsencse for PowerApps or it's include in the Office 365 Subscription ?

[@ShanesCows]

No extra license needed in Teams. 😍

[@taglud]

@@ShanesCows it is needed i believe, when i create, it generate some random error. i believe it is the license thing. Or the fact that i am in EUROPE (Belgium)

[@driesvdc2]

@@taglud Did you use an app template when you tried to create an app? I got an error when I tried to create an app off one of the templates, but it worked fine when started one from scratch

[@AlbertoAcero]

Hi Shane. Some time ago you talked about another method (not using gallery.selected) to address a selected record in a Gallery, for example when you want to edit it in another screen. Can you help me find that alternative?

[@ShanesCows]

I think it was this video where I talk about varRecord kzbin.info/www/bejne/i4jcZnyVgtp8nbc

[@versteegrob]

Why can't you choose a people column like in Sharepoint??

[@ShanesCows]

Do A lookup and use the Users table is about as close as you can get.

[@frederickching1142]

Hi Shane, my app is too big when created on teams powerapps. What size is the most optimal if used in teams desktop and browser.

[@primavera919]

What is the difference between power apps & app studio? And what if I don't want to pick a team for the app, can't I make it public?

[@jonneybravo]

Hi Shane. Is this Data Flex? great job by the way.......

[@ShanesCows]

Yes, but they changed the name to Project Oakdale for the time being.

[@itubeHirschberg]

can you call up the teams power apps on the mobile phone?

[@ShanesCows]

Yes though I haven't played with it much yet. You would open Teams onyour phone and go to the App tab.

[@himabindu751]

Can you create a microsoft team custom app which uses a public website ?

[@ShanesCows]

The public website as a data source? Yes.

[@muthuperumalkonar4874]

Superb Video , can you say me when to use Model Driven App?

[@ShanesCows]

I don’t do much with model driven so I am not much help. Sorrey

[@muthuperumalkonar4874]

@@ShanesCows ok . I have one scenario of students attendance where I want to note timing of student joining class and then the button should be disabled ....is it possible?

[@Labrie9243]

Is there any way to move apps created under this environment to another Teams room?, is there any way to make apps editable not only for the creator of the original app? if so, how can this be done? Thanks in adavance!

[@omega3li493]

great work

[@ShanesCows]

Thank you! Cheers!

[@amyclapp8457]

Dumb question...I followed this step by step and the app created perfectly. However, when I go back to PowerApps pinned on the left, it doesn't show Recent Apps like it does for you. I cannot find this app anywhere to be able to edit it. How can I edit it? Is the PowerApps "App" in Teams just late refreshing?

[@ShanesCows]

Amy go to the build tab then I think there is a see more option. Your app is there. 😀

[@musicsensei1793]

great content, it’d be really helpful if timestamps were shown on your vids as it’ll make it easier for your subscribers that wants to search/see certain segments of the vids again. keep up the good work!

[@ShanesCows]

I agree 😀 But that is more work for me that isn't easy to figure out. If I could get someone to give me the timestamps I would be happy to add them to the videos.

[@diegopaz83]

Hello, I have created the template Employee Ideas, but now i am trying to delete it and i have a message "An error has ocurred, please try again" multiple times, and I really don´t know how can i uninstall this app to install it again. Actually i´ve tried reinstall but it´s seems it does not overide it, so i am trying to delete it. Can somebody help me please?

[@ShanesCows]

From the Build tab you should be able to delete the app or tables you previously created. I show a lot more of that in this video kzbin.info/www/bejne/rpjdn55qjdGDedE

[@MizanNet]

We have 12000 staff. How can I share to all a teams app?

[@ShanesCows]

IF they all have access to the Team then you are all set. If you want to share with all Teams Teams that isn't avaiable. Maybe that will change during preview though.

[@sundrapillay6668]

Thanks Shane

[@ShanesCows]

Happy to help.

[@seanhare1822]

Can you move an app to another Team?

[@ShanesCows]

Not that I know of. I think eventually you will be able to export but not sure how that works right now.

[@vanderstraetenmarc]

Thx Shane. Again an amazing video that makes us start dreaming becoming a maker magician... Top interview by "The Intrazone" ;-)

[@ShanesCows]

Marc you are going to make me blush! Thank you.

[@RD-gp1mu]

Help please Shane. How can I restrict staff from adding a distribution group as a member to a Team? I know how to hide groups from Outlook but this is different, I only want to restrict certain groups to be added as members. It could cause a data breach if I can't restrict an Owner from adding a group. So this is an SOS (Your vlogs are awesome btw :)

[@v75tan]

Many thanks for your support .... Please guide me for the info around ALM ~ PowerApp The solution approach

[@ShanesCows]

I haven’t done much with it yet. Sorry

[@v75tan]

@@ShanesCows thanks But you can only do it

[@taglud]

hello, there is anyone here getting VARSTYLE error. i feel like you need to buy some license first

[@ShanesCows]

No extra license required. I haven’t seen that error. Must be a bug 😐

[@Xrusader]

Now I just have to figure out how to connect Power BI to this data source.

[@ShanesCows]

Hey Rick I don’t think they have rolled out the connector for that quite yet. Hopefully soon. 😀

[@moodberry]

I like the way you teach. But I do have a basic question. Since Teams is for communications, why would I want a table like what you made? Actually, the thing that is MOST needing explaining is why we can't easily invite people outside our organization to a Teams meeting. Adding members is a laborious one-by-one task. When you want to meet with many people, it just isn't worth using Teams. Rather use Zoom just because Microsoft makes it so hard to add members from outside the organization. THanks.

[@ShanesCows]

Doug I have teams meetings with people outside my org multiple times a day without issue. Sorry you are having challenges with it. I taught a class this week with 100 people all from outside my org. When you create a meeting it generates a link. You can share that with anyone and they can join the call. I think Zoom is way harder to use and has no functionality like this. 😀

[@moodberry]

@@ShanesCows Shane, it isn't that you can't, it is that you have to add them one by one to the team before you invite them. Why doesn't Microsoft have a way to invite members in bulk?

[@ShanesCows]

You don’t have to add them to the meeting. Get a link for the meeting and send it out. Anyone with the link can join.

[@MrGidianG]

Great video , Thank You. I am very new to the powerapps environment in general, and now I noticed that the Teams interface to powerapps editing is very different(Thank you Microsoft, dumbasses). Could you do a video or two on how to control the field tab order when editing? For the life of me I couldn't find it. Secondly, could you do a video on the search and filte of data withing this environment using the dataverse tables, etc. I have watched your videos on how to do the search and filter in the normal powerapps studio, but it doesn't seem to work here.

[@ShanesCows]

First request noted. Second one Search and Filter should work exactly the same in Dataverse for teams. Can you leave a new comment (not a reply) with what you are seeing that isn't working?

[@khargos7602]

I'm waiting for the time when you accidentally slap the camera while doing your intro bit

[@ShanesCows]

Fun fact in one video I hit the Mic. It hurt like heck and cut my hand pretty good. Ouch!

[@pgtips73]

Dude - I don't have 5 whole minutes, 3 minutes tops!!!

[@ShanesCows]

Technically you can do it in 2 if you hustle. 😂

[@54114142]

Bruh, I get MS Access flashbacks

[@ronarts496]

I don't want to be snarky, but a 15 min video called Create app in 5 mins?

[@ShanesCows]

The app only took 5 minutes. But I believe in giving all of the info and context to help people learn. That takes time.

[@moxaku]

Videos are great. Into is terrible. Videos so good that terrible intro.. doesnt matter.

[@ShanesCows]

Sorry you don't like it. 😪

[@HeyTezza]

I love the intro!