Microsoft Dataverse for Teams for Beginners | Build your first Power App Tutorial

[@SaniGarba]

You are simply excellent, Reza. Thank you. I declare this video the only reference you need to follow for developing a Power App for Teams, in and outside of the Teams experience.

[@RezaDorrani]

Wow, thank you

[@davediguer]

Thanks Reza - I love your videos - you go thru everything so fast - but i can go thru at my own pace. Your 40 minute video takes me about 4 days to implement. This is better than any PowerApps course out there.

[@RezaDorrani]

Thank You Dave :)

[@DavidPrenticeJr]

This video went from "That is kinda cool" to "Woah" real quick. Dataverse for Teams is awesome!

[@RezaDorrani]

Awesome! This response has made my day. Thank You so much.

[@tyriinaoneil917]

Exactly what i was looking for! Thank you!

[@RezaDorrani]

You are welcome!

[@RyanBond]

Can't wait to watch this tomorrow at work, Reza!

[@RezaDorrani]

Thanks Ryan. Let me know your feedback on the video.

[@RyanBond]

@@RezaDorrani I loved it. Great introduction to creating in Teams. One thing I'd love to see from you when you can is how to get info out of there related tables for reporting purposes.

[@RezaDorrani]

@@RyanBond Thanks Ryan. Getting data out of Dataverse is something for me to explore.

[@AyyyyyyyyyLmao]

This was incredible. Thank you so much!

[@RezaDorrani]

You're so welcome!

[@JC-ht4ro]

Reza, this is an amazing tutorial. I will be following it soon to create a product for my job. Thanks!!!

[@RezaDorrani]

Awesome! Thanks for watching.

[@mapalusilmu]

Thank you for this tutorial, it's really help me with Power Apps

[@RezaDorrani]

Glad to hear that. Thanks for watching.

[@AmmarRamadan]

As usual Reza! Helpful, Amazing, and straight to the point

[@RezaDorrani]

Thanks Ammar

[@oluwatobiyusuf]

Thanks Reza. I learnt a lot especially with your used case scenario

[@RezaDorrani]

Great 👍

[@pierrickdefossez3157]

Hey Reza, thank you very much! Let's say I want to build a power app for team that just shows entry from several existing MS List as tables. Would that be possible? Or all my data have to be created and stored in dataverse fo teams for the app to work?

[@RezaDorrani]

You can connect to any data source from the Power App.

[@blink182joel]

Hi Reza, FYI: you said at 26:14 that icons are not available in the PowerApps Teams studio. However, in your video, you can see the 'Add icon' option in the left pane. When you select this, you can change the Icon type from a dropdown in the Properties of the Icon. :) Joel

[@RezaDorrani]

The Icons are not available in the Insert tab of Teams based Power Apps. The template App has the classic control included. In the video I copy paste that classic control :)

[@blink182joel]

@@RezaDorrani Hi Reza, not sure I understand. I can do this in PowerApps Teams studio, and from your video, I can see the ‘Add icon’ option in the left pane. Go to 26:14, where you can see it. When you select this, it will provide you with a dropdown menu in the properties pane, where you can set the type of icon you want to use.

[@RezaDorrani]

@@blink182joel May be I did not understand your question then :)

[@RezaDorrani]

@@blink182joel Ahhh. I understood now. You are right. I missed that part. They were not available before. Thanks for pointing that out.

[@nagsen21]

Very good one Raza!

[@RezaDorrani]

Thank you! Cheers!

[@mohiuddinadamali7315]

I love your videos so much so helpful so informative thanks for your efforts 🥰🥰

[@RezaDorrani]

Thank You so much

[@lma3996]

Thank you Reza for sharing this wonderful video. Another great way of using Power app with Teams. Thank you again for your hard work

[@RezaDorrani]

My pleasure!

[@augustofilho4220]

Thank you. Very good.

[@RezaDorrani]

Thanks Augusto

[@battle_born]

Simply amazing, Reza! Thank you for this detailed video. It is exactly what I was looking for.

[@RezaDorrani]

Glad it was helpful!

[@Vrk843]

Thank you Reza, what is the formula you have used to group expense status itemcolorset in the piechart?

[@RezaDorrani]

Honestly I do not remember what was the formula. I no longer have access to that App. I probably must have done a group by on status and then countrows.

[@Vrk843]

@@RezaDorrani Thanks for quick response as always. Love your commitment towards the community. Happy holidays..

[@RezaDorrani]

@@Vrk843 Happy Holidays!!!

[@jeffreymartin5944]

Hi Reza! Another outstanding video wish I would have seen it when you first published it. This really helps to bring all the learnings together when you can easily follow a tutorial like this. In just two nights with two of your videos I have learned so many things that would have taken me weeks to read and put into practice, so THANK YOU for efforts in helping to teach the masses...you are a great inspiration. I look forward to more. One quick question that you really didn't elaborate on, when adding the emoji to the Text property of the label, how did you do that and where did you find the icons? Like little tidbit to enhance the screen visuals. Tomorrow night on to the next one!!!

[@RezaDorrani]

Thank You so much for the awesome feedback and appreciation 🙏 To add emojis, use Windows+. (Press windows key and . Key together to launch the emoji keyboard)

[@martinloughman8122]

Excellent video!

[@RezaDorrani]

Thank you very much!

[@georgebujdei7306]

Simply amazing, You are my favorite app maker teacher, just a question why the receipt picture from line items it’s not clear and cuts the image in half after I save the line item form?

[@RezaDorrani]

Thank You so much. The Image control in Dataverse stores images in multiple resolutions. Check powerapps.microsoft.com/en-us/blog/ga-release-of-large-file-and-image-support-in-power-apps-canvas-and-uci/#:~:text=We%20are%20happy%20to%20announce%20GA%20support%20in,and%20images%20and%20scenarios%20supported%20in%20Power%20Apps.

[@paddysheeran]

Amazing video. If we wanted to export the powerapp once built and deploy it within other teams, is that a simple thing to do?

[@RezaDorrani]

You can export the solution and import it to another team.

[@giovanyrodriguez8884]

Thanks! This video is really helpful, you always make a great content. In this example, what code should we use to allow the user to edit a line item in the collection, if the ticket hasn't been created yet?

[@RezaDorrani]

Its been over a year I did this video. I do not remember every aspect of the video.

[@SosoDeSamurai]

Thx again for another great Vid! Will there be a Part 2, where you create an aproval Flow for the Solution? 😇

[@RezaDorrani]

Thanks for watching. I have videos on flow approvals on Dataverse for Teams. I do not plan to add one to this solution.

[@cliftonriley2311]

Your videos are the best tutorials for learning powerapps, hands down… Keep them coming as I cannot wait to learn more! I am tweaking your demo for a purchase order tracking system…A couple of questions… After creating the collection, it appears that the data source for the “expense gallery” changes from “line items” to “colLineItems.” Is this expected? When adding additional line items after the expense has been created, the lines items do not appear in the gallery until after the expense form has been re-submitted. Is it possible for the new line items to appear immediately? I would like the user to be able to delete individual items in the “line Item” gallery whether creating a new expense or editing and existing expense., should the “remove function” use “Line Items” or “colLineItems?” I have been digging through the MS Docs, re-watching your videos and others’, and scouring the web but I have not really found any solutions. Do you have any advice? Many thanks and keep up the great work!

[@RezaDorrani]

Thank You for watching and liking my videos. "Expense Gallery" data source changes? Items property of Gallery is under your control. How about I give the entire solution to you :) Here is the link - github.com/rdorrani/PowerApps/blob/master/Power%20Learn_export.zip *** You need to import this as a solution in Dataverse for Teams

[@cliftonriley2311]

@@RezaDorrani The changes to the data source seemed odd to me. When I add the "If" function to show the colLineItems, the datasource changes in the properties panel. When I edit an existing record an add a line item, the gallery disappears until I re-submit the "expense form". I Rebuilt the entire app and now when I add the filter function, the datasource changes to none. Anyways, the solution would not load: Custom attribute names must start with a valid customization prefix. The prefix for a solution component should match the prefix that is specified for the publisher of the solution. Must be cursed.... Anyways, I appreciate the help and kudos to you for making the time to help/respond to everyone. The effort speaks to passion...

[@RezaDorrani]

@@cliftonriley2311 Try the sample solution I gave. That has all my code and tables in it. Thanks for the appreciation towards my work 🙏

[@adrianboom6879]

At 9:55 the Expense Title is all the way to the left at 9:57 it is to the right of the edit icon. How did it get moved?

[@RezaDorrani]

I did not understand the question. I do not see anything moving.

[@atanutech9342]

What a learning.. Thankyou, thankyou so much

[@RezaDorrani]

Glad it was helpful!

[@lorenzopina3920]

Hi Reza, thank for the information provided, very useful. One question. If I'm creating an expenses App using the template from PowerApps, is there any table template that can be created automatically the tables?, this is too technical for most users. Thanks!

[@RezaDorrani]

It template is a solution it could include Table schema. If export is an App, then the App is all it would be.

[@eyoborelvis8224]

Thanks Raza

[@RezaDorrani]

Most welcome

[@agoetzIES]

Thank you Reza. I uploaded your solution. Is it possible for an admin to enter expenses on behalf of someone else and assign it to that user?

[@RezaDorrani]

Possible but not something I have tried :)

[@harshavardhan1435]

Thanks much! How do you add new line Item after the submission of main Expense form? if User still have some new line item that was not added before and realized to add some more new line items after the submission of the main Expense form?

[@RezaDorrani]

I do not submit the main expense form. Once user submits the main expense form, both the expense and the line items are submitted in one go. Video walks through this entire process. User can always go back to expense item and add additional line items.

[@asifkhawaja]

Wow, thats great Reza as usual. I have been looking in various places for a lot of different things that you have placed in one location. So thank you. One question though, could you highlighted (or maybe you already have and I haven't looked properly) some of the pros/cons of Dataverse for Teams vs Dataverse, e.g. license requirements, data storage limitations with Teams or any other limitations for that matter? What are the things that we can't do with Dataverse for Teams vs Dataverse? Thank you.

[@RezaDorrani]

We had a slide on DV4T Vs Dataverse in the Ignite recap session. Check kzbin.info/www/bejne/gXnJfpp7h86Umck

[@asifkhawaja]

@@RezaDorrani thank you!

[@sam-dw3hk]

Hello Reza, I'm using ID(Auto number) in the look up filed, any short suggestion on how to change the code in the patch function on the "OnSuccess" property?

[@RezaDorrani]

I would have to try it out to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com

[@sam-dw3hk]

@@RezaDorrani Thanks, i posted that question in forums.

[@sam-dw3hk]

Hello Reza, I didn't get any help from power apps forums, just checking if there is anyway that you can help. i can past the question link that i posted in forums.

[@RezaDorrani]

@@sam-dw3hk Forums is a platform where many experts help in their free time only. I also go to forums to assist but in my free time.

[@sam-dw3hk]

@@RezaDorrani of course, Thank you

[@henryalmea6170]

Thank yoy for the video... I wonder, do you have to create the "Lookup Expense" column in the parent as well? Why just in the child? Shouldnt that column be a unique column in the parent? Thank you!

[@RezaDorrani]

Lookup column creates a relationship between 2 tables. Automatically column gets added in both tables.

[@donaldfo1]

Hi Reza, do you know of a way to control the tab order for controls in a gallery/form for Power Apps for Teams? That's the only version I have at my work, and even after I carefully add the controls in the order that I want the tab order to occur, after I start editing the controls, the tab order gets messed up. Help! Thanks.

[@RezaDorrani]

I’m not aware of how to do that.

[@waynejin4873]

Hi Reza, thanks for the sharing, great lesson. I encounter an issue on 32:00, ‘Expense Lookup’ is highlighted in red, the prompt error message read “Name isn’t valid. This identifier isn’t recognized.” Can you give some hints on how to overcome this issue?

[@waynejin4873]

It’s in below statement: UpdateIf(colLineItems, true, (‘Expense Lookup’:Self.lastsubmit));

[@RezaDorrani]

Expense Lookup is the related column. Self.LastSubmit is the last submitted record value of form. It should work if all is configured as per video. I would recommend to post your issue with screenshots on the forums at powerusers.microsoft.com

[@natcongreso2763]

Shooot, Im 90% done with my powerapp canvas, and having problem with the data source trying to switch from SP to dataverse, and here we are its in MS Teams

[@RezaDorrani]

MS Teams based dataverse is limited from standpoint of storage, security etc. Ideally use full Dataverse

[@natcongreso2763]

@@RezaDorrani yah just tried it now. But im on user level access, can't get hold of dataverse, sad to note im using SPL as my database.

[@nandu8598]

Can we export the app created in one channel and upload it in another channel?

[@RezaDorrani]

Yes. You can export and import.

[@side54723]

Thanks reza !!! My app, with 2 buttons takes 20sec to load from teams on phone, any idea why ? Its a huawei p30 so a middle price but performant one Thx

[@RezaDorrani]

That is slow. Might be an issue within the App related to performance. Or it could be a network related issue. Many reasons.

[@danielzajac6921]

Great job great lessons. But I have i question How I can coonetion approval for dedeciation person with area of work. So user select area where need access and flow should knows who is assign to this area to approval. And flow should sent approval for person who was assign to this area

[@RezaDorrani]

I have done videos on various approval scenarios with dynamic approvers. Check kzbin.info/aero/PLTyFh-qDKAiFUGTtwSwFT79Y7_jq_Aipe

[@danielzajac6921]

@@RezaDorrani thank you for information but I can't find solution for user select same multiple option choise and after approval is connected to choise ( different people)

[@RezaDorrani]

@@danielzajac6921 I would recommend to post your issue with screenshots on the forums at powerusers.microsoft.com

[@alexk7837]

What is your approach to dev/wa/prod proses for power apps? Can you create. Test in one tenant before publishing in prod?

[@RezaDorrani]

kzbin.info/www/bejne/jqCQhamQbrNmeK8 kzbin.info/www/bejne/fnLLgJWvodiMndk

[@mukeshkumaryadav3166]

Hi Raza, can you please make tutorial videos on portal app topic.

[@RezaDorrani]

I have not done much work with portals. Chances of video are low.

[@lillyclimant3464]

Thank you so much Reza. Excellent tutorial. Question: When spinning PowerApp from a selected Team do I get to choose dev environment?

[@RezaDorrani]

The environment is specific to the Team you create the App in. You cannot choose the environment.

[@lillyclimant3464]

@@RezaDorrani Thanks heaps Reza.

[@komfortmagnus8194]

Hi Reza, thanks for this share. Unfortunately, I meet a challenge that when I preview the app I created, it doesn't show the whole display. Some features are not displayed in windows screen unless I open canvas screen. What could be the solution to this?

[@RezaDorrani]

I have not faced this issue hence not sure what the reason for the issue is. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com

[@okidipekimbambo]

Amazing Tutorial as always. One question, currently if I create a PowerApps for Teams App to my Company We don't need to pay any extra subscription to run the Application, right? I am Just worried about Microsoft charge it in the future a crazy price and We will have to stop using it.

[@RezaDorrani]

Dataverse for Teams is included as part of Teams license. As long as your App uses standard connectors & Dataverse (for Team), users do not need any additional premium license.

[@ramakrishna76]

great and learning lot from your ideas and knowledge. I have few questions about Power apps. 1. Is this possible to maintain source code into GitHUB or any source controls 2. I have existing power app designed with model-driven type and i need to enable for copilot, is this possible with custom analytics for the same. 3.where can i find the source code of above one(any github name)😉. much appreciate your response.

[@RezaDorrani]

Documentation or Bing search will give you the details 1 - learn.microsoft.com/en-us/power-apps/maker/canvas-apps/git-version-control 2 - learn.microsoft.com/en-us/power-apps/maker/model-driven-apps/add-ai-copilot 3 - same as 1

[@uw1985]

Hey Reza, do you know i there is a way to use own ai builder models in flows of a team environment?

[@RezaDorrani]

AI Builder is currently not supported in Teams environments.

[@natcongreso2763]

Can I still edit my canvass app that was originally created in power apps not in MS Teams?

[@RezaDorrani]

You can edit the app no matter from where it is created as long as you have the access to do so.

[@nagabushanam1371]

It's really amazing..could you please do a video that if the data is having more than 2000 records, how to use filter and search options to get all data from overall records..

[@RezaDorrani]

Already done. Check kzbin.info/www/bejne/sKm9eJSOhtGNp9E

[@robertjiang1796]

Great Video? Do you have a video or guide on creating a help desk app using MS dataverse for Teams similar to what was shown on 39:00?

[@RezaDorrani]

Thanks! I do not have a specific video on that scenario (from what I remember)

[@robertjiang1796]

@@RezaDorrani Thank you for your response and the video. Your video is very informative and with the steps provided we are trying to create a small HelpDesk app within teams with one table and a few fields (Support Issue: Date SubmitterName; Priority; Assigned to; date assigned; status; date completed). I had a couple questions- 1. Is it possible to automate email notifications to the submitter and the assigned party, based on when the issues is assigned and completed? and 2. Does teams show a red dot in activity when changes are made to this app? 2. Is it possible to automate date based on when a field is updated. Eg: Assigned to? 3. Is it possible to use the lookup table User to automate the submitter name in the Submitted by field?

[@RezaDorrani]

@@robertjiang1796 Possible yes but not something I have tried or have a video reference for

[@sundrapillay6668]

Thanks Reza

[@RezaDorrani]

Thanks Sundra

[@RahulPatil-mh4qc]

Hi reza, can we build a model driven app in teams?

[@RezaDorrani]

In Dataverse for Teams - No

[@AlberichRheinmann]

can you export the dataverse tabels to excel ( my app would be a time recording ) ... many thanks for a possible answer 🌺❤️

[@RezaDorrani]

Yes, I believe if you go to table’s there is an export feature (atleast it is available in full Dataverse). Other option is to write a flow to export to excel.

[@AlberichRheinmann]

@@RezaDorrani Thank you sooo much

[@ANDRETHOMPSON]

Thank you so much for this video and all your content, I can't tell you how much it's helped. I've been struggling with one major thing as part of building apps for a Teams space, which is sharing it with colleagues. To my understanding, Power Apps for Teams doesn't require a Power Apps Licence, however, when I share this app in a Teams channel, my colleague keeps getting prompted to 'Start a trial', whether that be within teams or when they try to open in the browser using 'Go to website'. This happens with apps built within Teams with no premium connectors. We use a 'Microsoft 365 A5 for faculty' licence, which includes 'Power Apps for Office 365 (Plan 3)', any feedback would be hugely appreciated.

[@RezaDorrani]

Most welcome! All this requires is a Teams license. I am not aware of the faculty license and its limitations. I would recommend checking on forums in case someone has experienced this licensing limitation powerusers.microsoft.com

[@thesebs89]

I experience small bugs or limitations here and there when I make apps I teams. For example there is a limitation on button border controll. If you shrink your button only one side will have rounded borders and text cannot start from 0 x in button. Is this kind of problems know and will be fixed in the future you think? How often dose MS update power apps for teams?

[@RezaDorrani]

Dataverse for Teams uses fluent UI controls. These are different than standard Canvas App controls. docs.microsoft.com/en-us/powerapps/teams/use-the-fluent-ui-controls

[@reddy876]

@ Reza While i switched the another acoount in teams my power app login account is not switched, it allways loged with first opend account in teams. how can i resolve this case

[@RezaDorrani]

I have not come across the mentioned issue and hence not sure what the cause could be. I recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com

[@reddy876]

@@RezaDorrani thq Reza

[@nishikantrath1905]

Awesome Content Reza. I have a question though could be out of context, Can we use ForAll inside a Filter condition in powerapp. This is required because for one of the requirement the filter left and right value both are collection/table. Does Powerapps allows to perform such actions?

[@RezaDorrani]

I believe you would run into delegation issues though. Possible - Yes but not for large data sets. I would recommend to check on the forums at powerusers.microsoft.com in case someone has done something similar.

[@srinivasprabhu3686]

Hi Reza, Switch(ThisItem. 'Expense Status','Expense Status (Expenses)'.Pending,Orange) I get error as "Name isn't valid. This identifier isn't recognized" while using fill for circle. Please guide.

[@RezaDorrani]

I will have to look at your App in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com

[@nishimodgil1221]

this is amazing ... unleashing the power of power apps and leveraging its usage in teams. Here no worries of sharing the link and managing access. I have a query -- can it be used to send email notifications to approvers using power workflows

[@RezaDorrani]

Yes. I have done videos on approval flows. Check kzbin.info/aero/PLTyFh-qDKAiFG_FxWr-ACSmP39_84IUWl

[@praveenpandey3366]

Hello, I am not getting power apps option in teams, When I search it doesn't shows power apps option. I created an app though from power apps page and when I am trying to share with my team members it says u are in developer environment and this is only for testing, what should I fo to share it with my team members in order for them to acess data and use it for training purpose?

[@RezaDorrani]

May be your admin has disabled that feature

[@AkankshaKumari-z6e]

Can we have one user i/p field for p/w which is * encrypted

[@RezaDorrani]

Not sure if power apps has support for that. Il recommend checking on forums powerusers.microsoft.com

[@raj7sam]

@rezza if possible please create videos on Model Driven app for different use cases, currently there is no proper content around model driven app.

[@RezaDorrani]

Not in my immediate plans

[@rashantha]

Can you launch these apps directly in Powerapps instead of teams and can they run offline?

[@RezaDorrani]

These can only be launched from Teams. Offline - No.

[@rashantha]

@@RezaDorrani thanks for the fast response and the great videos.

[@aarounge]

Do we need any premium subscription or lisence to do this? How will I know what Licenses we have? As I'm using my office laptop.

[@RezaDorrani]

As long as you have a valid Microsoft Teams license, you will have the license to build Apps for Teams.

[@zanrleonardo]

Hey pray, I have an idea for a video... What do you think of making an app with digital recognition?

[@RezaDorrani]

I have not built any scenarios with digital recognition. Interesting idea to explore. However, I would need a lot more folks requesting this topic in order for me to get working on this idea. I will add this to my backlog.

[@michelelomonaco5118]

Hello Reza, I did a test with a small app and published it in a team. I asked a collaborator who is the owner of the team to try to connect and he is also asked to purchase a 30-day Trial license, is this correct? Thank you. Michele.

[@RezaDorrani]

Fact that it is asking for a trial license tells me that folks dont have a license to use this. You would need to check with your license admin as to why users dont have a license.

[@michelelomonaco5118]

@@RezaDorrani Thanks Reza, in fact when I started my experience with PowerApps I asked for a free license which is still active. I ask the user to do the same.

[@michelelomonaco5118]

Sorry Reza for this additional request. We have an app that was not created directly in teams, but from the office 365 portal and is shared with a hundred users who certainly do not have the powerapp license. The link was then placed in a Teams tab like a web app and everything worked. Who knows where the basic difference is. Thank you. Michele.

[@RezaDorrani]

@@michelelomonaco5118 You could but these are valid only for 30 days. Best to get a power apps license.

[@RezaDorrani]

@@michelelomonaco5118 All users need license. I will not recommend trial license as these are valid for 30 days only.

[@venkatpullati1330]

Why powerapps Only use in Teams.

[@RezaDorrani]

You can use it with any service. This video is focused on Teams and Power Apps.

[@Cordycep1]

I just dont understand why setting up the table the default Primary key is TEXT type, I created ID column but does not allowed to specify it is "Primary" column.

[@RezaDorrani]

powerusers.microsoft.com/t5/Microsoft-Dataverse/Change-the-Primary-Key-in-a-Microsoft-Dataverse-table/td-p/1272383

[@venkatpullati1330]

What Is the use Of Sharepoint

[@RezaDorrani]

docs.microsoft.com/en-us/sharepoint/introduction

[@jaimerocha7563]

Has anyone figured out how to pass params or deeplink using D4T?

[@RezaDorrani]

No

[@barunroyghatak4380]

Hi Reza, just checking do you have any paid site where you give tutorial on Power apps. I want to subscribe and be the part of tutorial.

[@RezaDorrani]

I am working on my training portal. It will be out early next year.

[@barunroyghatak4380]

@@RezaDorrani Thanks

[@barunroyghatak4380]

Also please intimate us once it's done. I hope it will be interesting.

[@RezaDorrani]

@@barunroyghatak4380 I will post about it on the Community Tab of my KZbin channel.

[@RezaDorrani]

Check channel memberships. I have gone live with a training tier that you can sign up for now. kzbin.infojoin

[@janesheng7113]

[@RezaDorrani]

Thank You

[@SHAli1474]

Thanks Reza

[@RezaDorrani]

👍