Build PowerApps for Teams with Microsoft Dataverse

[@daleyon4065]

Yo Reza!! Amazing video!! Thank you for being on top of this new feature and sharing!!

[@RezaDorrani]

Thank you Dale.

[@smaheen]

Excellent. Covering all aspects of data entries. I love it

[@RezaDorrani]

Glad you liked it!

[@vpavan007]

No words! as always point to point ... steps by step explanation about the brand new concept Project OAKDALE :)

[@RezaDorrani]

More to come!

[@robofski]

I’ve learnt so much about Power Automate from your videos hoping to learn more about Power Apps too!

[@RezaDorrani]

I do have a playlist for Power Apps as well - kzbin.info/aero/PLTyFh-qDKAiEIVlidnhELx5BusnzlDzkR

[@umeshgaur6960]

Hats off Raja, your all videos are very informative..it's seems you're doing lots of efforts to explain small concept.

[@RezaDorrani]

Thank you Umesh. It does take some effort to plan, build and edit the videos. Thanks for the appreciation.

[@ArohShukla]

Super video. Thanks for sharing 👍!

[@RezaDorrani]

Thank you very much!

[@sarankumar3753]

It's really very helpful with great content. Please try to release more videos on powerapps as well

[@RezaDorrani]

Thank you Saran

[@saigonpilots7063]

I watched countless of clips. Very frustrated to the point about to give up. I watched two of yours and my hope comes back. Thanks!!! Subscribed!!! If possible, please make a series of full flesh, relational tables, etc. (in Teams, please) app. I only have access to my school MS Teams and thankfully it provides Power Apps (with table creation!!!) at no extra cost so I was able to follow your tutorial. Thanks!!!

[@RezaDorrani]

You got this! I have a series planned on relational tables in Teams.

[@saigonpilots7063]

@@RezaDorrani Cool! Can't wait! Thanks!!!

[@krishan3515]

Thank you very much. Had a lot of content I wanted to know. can the approvers be defined from a table or another form. Rather than hard coding the emails in the function. Thanks

[@RezaDorrani]

Yes that can be done. I have done many videos on approvals. Check approvals playlist on my channel.

[@ryanbond7144]

Love it, very helpful thanks. Would love to see some more on formatting in Oakdale, as some objects such as radio buttons have very different (and confusing) options for formatting.

[@RezaDorrani]

Great suggestion. Once Oakdale goes into General Availability, I will create more videos to cover the updated controls. Since Oakdale is currently in preview, good chances that certain aspects will change.

[@notonurnelly]

Hi Reza, Another great video :) Do you have any idea why quite a few of the Properties are missing for Labels, Buttons, Date Pickers in PowerApps for teams? For example a Label does not seem to have any of the Padding, Disabled Color, Pressed Color or Tool Tip Properties when added from the side toolbox. I have noticed that some of the labels already built into the Inspection and Employeee Idea's Templates do have the full range of properties. A bit of frustration is the new date picker as it will not allow me to change the background fill, so I am stuck on the Default Teams Background Fill color.

[@RezaDorrani]

I am working on multiple videos. One of them includes formatting tables.

[@munkybutler1]

Hi Jamie, I had this issue with missing properties too. This happened when I added the label from the 'Popular' items. When I added a label from 'Display' it had all the properties. Maybe it's a glitch.

[@notonurnelly]

@@munkybutler1 Hmm cant seem to replicate, did you try it with the date picker? My forms look a bit bobbins with the grey in the background. I would love them to be white with a grey border so I can mount them on a White form. I get they are trying to keep us inline with teams look and feel but my form elements are not bright orange so they would fit nicely in white fill and grey border . .........Frustrating

[@shaikhshoyeb3308]

NICE VIDEO THANKS

[@RezaDorrani]

Welcome!

[@minhaja.1695]

Very nice! Can we use the same app for another team? or we would have to build the same app again for another team?

[@RezaDorrani]

Currently you would have to rebuild. Import/Export options will be coming in future.

[@ihebchafai2780]

thank you, if i create a table in dataverse for a teams channel, can i use this table in another application for another channel ?

[@RezaDorrani]

As long as the channels are within the same Team, then Yes.

[@driesvdc2]

Great intro to Oakdale, thanks @Reza Dorrani! Is there a way to do a repeating table embedded in the main form, like one could do with InfoPath? This would be for an app like an expense report, where you have a main form with fields like name and expense period, and an area containing with an expandable list of expense report line items?

[@RezaDorrani]

Absolutely. Gallery control is your answer in Power Apps. You said expense reporting - Check this out - kzbin.info/www/bejne/Z4mbmpuMlKp6mKc

[@perwide]

Is it possible to export the data to excel or load it into Power BI?

[@RezaDorrani]

Recent update allows exporting to Power BI. Check my friend Daniel’s video here kzbin.info/www/bejne/mJa1qWChl7GSr5Y

[@ketansgandhi]

Excellent video and explanation Reza. Thank you for the video. Few Questions 1. Where is the data [tables] stored? 2.Will these apps be available in Personal Productivity environment? 3.What about DLP policies as these apps are not part of any Environment with power platform? 4.Can these apps be maned from power platform admin center and are they part of the analytics reports? 5. Any possibility to use the data source [tables[ across apps in different teams?

[@RezaDorrani]

1 - Data is stored in oakdale data platform (CDS) environment created for the Team 2 - These Apps are being built in the Teams environment. 3 - DLP policies applied by admins will apply to all Oakdale environments 4 - Yes all these Apps,flows and bots can be manned from the admin center and will show up in analytics. 5 - Currently one can only reference tables for the current Team.

[@yehunlavolontededieu322]

Reza, thank you so much , as usual it's a great tip for this season. Perfect timing. And please, I ditto to others below, can you work on licensing content? Like a video that gives us a very clear insight about the licensing , what are plain free features that come with the base M365 subc? for each PP products.(power plaftrom) , teams? premiums? ..With examples: like Microsoft 365 business standard vs others...Thanks bro.

[@RezaDorrani]

Wow a licensing video. I will give it a try but problem is things change so video might get outdated soon.

[@yehunlavolontededieu322]

@@RezaDorrani Thank you Reza, just short video and at high level (Whenever you can ), it's just hassle sometime to get a clear info from the tenant admins...on what's freee & not... to jump on and build solns. Especially since infopath/SPD was part of SP and free, I believe there should be some sort of free replacement for those tools b/s all companies might not be ready at this point for the Power Platform subscr. Mainly mid&small companies.

[@cristesta1]

Hi Reza, thanks to all your suggestions i made an app to search project documents across different libraries. Because of the delegation issue in SharePoint i could only use the Startswith option in my filter to search by document title. However when searching across tens of thousands of documents, sometimes it is not easy to remember how the title of a document starts, hence the search function would work better. I have transferred all information i need in Dataverse for Teams and now the search function works great, however, is there a way to combine the 2-3 search textbox so that the search can be limited to the selected 2-3 keywords?

[@RezaDorrani]

Happy to hear that! You have a good use case. Try Filter(Table, "keyword1" in column || "keyword2" in column || "keyword3" in column)

[@AF-jc6zl]

Great video as always! Thanks so much! Are the dynamics 365 tables etc. available as in model based apps?

[@RezaDorrani]

I don’t believe so.

[@geojaya]

Question related to dataverse - a feature which became GA today, 03/21/2021 - Does custom API for Dataverse- require premium licensing or is it a standard feature licensed usage

[@RezaDorrani]

From what I know, the custom API option is just for the full Dataverse feature set. Dataverse for Teams is a locked down environment with no access via the custom API.

[@sundrapillay6668]

Thanks Reza great Video

[@RezaDorrani]

Thank you

[@sahilthakur03]

Hi Reza, Amazing video. one quick one can we reuse the table created for an App in a team with other team Apps?

[@RezaDorrani]

Yes, the Tables can be used in Apps built for the same Team.

[@rafiqueonlinetraining1264]

How about licensing for external users....? My Intention is to create an app, where my external contractors can also feed in the progress status. Will I be able to give access to my external contractors to this app.

[@RezaDorrani]

Yes - Guests are covered. The security principal for Oakdale follows the MSFT Teams security OMG - Owners Members and Guests Owners and Members - have access to all data in their Team environment Guests - have access to only their data in the Team environment This is by design. There will be more granular permissions coming soon.

[@RezaDorrani]

I have a video planned for Oakdale - where in I plan to cover licensing and other key aspects. Your questions are all fantastic and I may include them in my upcoming video 😊

[@rafiqueonlinetraining1264]

@@RezaDorrani ... Thanks a ton Brother.... Looking forward for your upcoming video.

[@RezaDorrani]

Rafique Shaikh Next one is on building chat bots 🤖 in Teams with Project Oakdale

[@biliatto]

Is there any way to import data to the Table/Dataflex you have created instead of typing one by one?

[@RezaDorrani]

Copy paste works. Grab data from excel and paste it in there. Or use flow to get data and load it into your entities. My next video will showcase working with flow for Oakdale.

[@biliatto]

@@RezaDorrani Tks Reza! Another thing that you can show is that a table created in one ambient/app can be shared to another ambient/app.

[@RezaDorrani]

Afonso Biliatto That is coming :)

[@NarnawareSunil]

Afonso Biliatto had same question..

[@colby4390]

Are you geolocation features coming to Power Apps for Teams?

[@RezaDorrani]

May be in future. I did not see any particular announcement about this at Ignite though.

[@ChuckSteel]

I'm surprised there isn't a Person column like there is in SharePoint. Any idea if that will be added?

[@RezaDorrani]

Not like SharePoint but there is a Users Table that has list of users in current environment. There is also an Email column type that can be used. In App you can add a combo box and get data from Office365Users connector. Check this link - powerusers.microsoft.com/t5/Microsoft-Dataverse/People-Picker-for-CDS/td-p/161919

[@vidanaweer1662]

Nice video very helpful, thanks. One question, if i want to connect to a Sharepoint list how can i do it, can i do within the Oakdale environment? Thanks .

[@RezaDorrani]

Your App in Oakdale can connect to SharePoint and any of the other connectors. Just go to data sources, select connectors and add the SharePoint connection.

[@vidanaweer1662]

@@RezaDorrani i have added the connection, but it doesn't allow me to select a list, just only a generic sharepoint connection.

[@vidanaweer1662]

Now i can add sharepoint list, i dont know why it wasn't allowed me to add a list before. Thanks.

[@ChuckSteel]

@@vidanaweer1662 I can't see how to connect to a list, only the generic Sharepoint connector. Did you ever figure out why it changed for you?

[@vidanaweer1662]

@@ChuckSteel i have used Teams browser, then i can.😀

[@anandasanyal]

Great post. I got a question, Can external users use these apps as Member? Thank you

[@RezaDorrani]

External users (guests) will have access to these Apps within the Team

[@NaveenKumar-lm7qj]

Hi Reza, If we create an app in teams from scratch, We have to take care responsive or it is responsive in nature?

[@RezaDorrani]

You will have to take care of responsiveness.

[@frankandbrendabarrett39]

Greta video Reza, Can third party colleagues access (co-workers from different companies than the hosting company) and update the CDS by adding/editing the App in Teams. I know 3rd parties can access our team sites but we always seem to struggle retrieving data from colleagues who do not work for us.

[@RezaDorrani]

With Oakdale, Guest users of the Team can access the App. They will only have access to their own records in the Tables in Oakdale for the MS Team.

[@frankandbrendabarrett39]

@@RezaDorrani Thanks for the Reply Reza, That may be all that I need :) so to just confirm a 3rd party can add a new record and then edit any records they might have added and need to change? I think I can make this work with a little help from using the Power Automate approval you did in a later video, could a third party receive an approval email and update the adaptive card with an approval and a comment and that would change the status?

[@RezaDorrani]

@@frankandbrendabarrett39 The third part user would be a guest user for your Microsoft Team. Oakdale allows guest users to add,update and delete their own records. External users can also be included as part of the approval process and interact with adaptive cards in Teams.

[@theturtledave]

Reza, your videos have been very important in my learning curve. Thanks, you've taught me so much. I built an app where I'm restricting users to see only the items they've created and not other user's items (method: if their User().email is not in the manager_access SP list email column, they can only see the items they created). Does Dataverse have a way to hide the database tables from users while still keeping the app functional?

[@RezaDorrani]

Currently, all Team members and owners have full access to the Tables. Guest users can only access their own records. More sophosticated security options are coming soon in Dataverse for Teams.

[@theturtledave]

@@RezaDorrani Thanks so much!

[@isaacrajan]

How is data imported into and exported from the Common Data Service environment that powers Project Oakdale? Could you do a video that covers this process?

[@RezaDorrani]

Currently, flow is the only option to move data in and out of Oakdale. However, there will be more options coming soon. I will wait for those options to be announced before making a video on it :)

[@bradlystewart1156]

Hey Reza, Just started watching your videos and they are really good! Sounds like I'm not the only one who appreciates the time you put into these, they are such a huge help. I am having trouble getting past the "Give us a minute screen". It just keeps loading and loading and I can't seem to get past setting up the new environment. I uninstalled then reinstalled Teams with no luck, have you heard of anyone else having this issue?

[@RezaDorrani]

Try accessing Teams from your web browser. For testing, create a new Team and try building an App for new Team - all from the web browser. If your issue still persists, try grabbing the session details and raise a support ticket. To get your session details, go to the About tab in the Power Apps Teams App. The About Tab is right next to the build Tab.

[@KrishnaRachakonda]

Very nice video. Thank you for posting it. This video gave great start on the oakdale. I have multiple questions: Can we publish the same app to multiple teams or make it available org level? Can we see versioning of the app? Who can edit the app in the team? Does the user need to be Team owner or member to edit?

[@RezaDorrani]

Can we publish the same app to multiple teams or make it available org level? - Yes you can publish same App to multiple Teams. However, the data would be stored in the team where the Tables were created. So you would need to take make sure users have access to the base Team. Org wide Apps - coming soon. Versioning of App - is present. I have an upcoming video on management for Oakdale env - I will cover it there. Can we publish the same app to multiple teams or make it available org level? - Both Owners and Members can edit the App and the Tables associated with their Team

[@rafiqueonlinetraining1264]

Out of context query - If you can Help.... I have one query if you can guide with your great knowledge In power apps.. I have developed an Attendance App. My query is for all the staff to punch in their in and out time we need to give them edit access option to backend Excel file on OneDrive through Power Apps for saving the records. To maintain the integrity of our attendance data, How can we prevent them from going to OneDrive and making any changes to the datasource Excel file. I wish there could be some workaround to prevent the staff members to edit the excel file from onedrive...

[@RezaDorrani]

Power Apps always respects security of your data source. If using an excel file - all users would need access to it and hence can modify the file. Better data source choices are SharePoint, SQL or CDS which will give you more flexibility in terms of security

[@rafiqueonlinetraining1264]

​@@RezaDorrani Great. Thanks mate... for your quick response... Appreciate it...

[@blink182joel]

Hi Reza, your videos are brilliant, thank you. I have a problem, where I would like to utilize PowerApps in Teams, using Dataverse. I need a column that can select multiple directory users for an incident form, which would populate those users into another table, with a reference column to associate the user(s) with an incident. Maybe some use of "add additional user" button after selecting one user... It appears this isn't officially possible. It would be great if you know, or can think of a workaround for this. As I imagine that it will be a popular requirement. Thanks in advance :)

[@RezaDorrani]

You are correct. There is nothing Out of the box that supports that. You would have to store the data in a separate table. Provide user with an option in App to add their option, which you can patch in that same table. I have never tried this. I will recommend you check on the forums at powerusers.microsoft.com/

[@jasonmauldin2035]

Hello Reza, I am building an app along the lines of what you have done here. I am making a request app for supervisors to request computers and folders for new employees. The question is I need two columns that get the user name and time from the person that is logged into their MS account in teams. I want this to auto populate. So glad I found your videos as they have been such a great help..Thank you for what you do!

[@RezaDorrani]

User().FullName will give you the current users name. Today() and Now() will give you the current date and time.

[@Ylotan]

Well explained! Do you know how this is going to be licensed? Per user per app?

[@RezaDorrani]

No premium licensing required. It is covered as part of your base Office 365 subscription. I am working on a video around licensing and management of Project Oakdale.

[@Ylotan]

@@RezaDorrani That would be lovely. Licensing is always confusing topic.

[@vishalganesh123]

How to use the XL file table stored in Teams folder to create the Power App application ?

[@RezaDorrani]

You would have to ensure the excel file contains a Table and then add a data source to your Power App to connect to it. You would need to use the excel online business connector and then connect to the specific team to get the excel table data

[@vishalganesh123]

@@RezaDorrani Yes, thank you. It is working and able to access the file. Thanks a lot

[@rgibson69]

Reza, I'm wondering how the apps you create in Teams relate the the apps you create in make.powerapps.com. I don't see the one I started in Teams on the main Power Apps site. I'm assuming this isn't possible. Is it possible to create an app on the main site and share it in Teams? If I have a main app that works with a large amount of relational SQL data and I only need one of the Teams to work with some of the data in a small part of the app do I create a separate app in Teams and link it to the SQL data?

[@RezaDorrani]

Teams apps built using dataverse for Teams are not accessible from power apps maker portal. You can create a standalone app in power apps maker portal and then publish it to teams as a tab.

[@mohammedsameal-awad1682]

Hi Reza, I tried to add guest account to team to check the guest privileges for Project Oakdale, I found the guest user was unable to see the recored added by any other users, he was able to see the records added by him only, is this the normal behaviour? is there anyway to override it? thank you

[@RezaDorrani]

Yes - Guests have access to their own records Members and Owners - have access to all records

[@zaidkashour]

So this is going to create a new environment for Power Apps inside Teams other than the default environment I am currently using for my Power Apps apps?

[@RezaDorrani]

Yes - each Team will get its own environment with a max 2GB capacity limit

[@alexk7837]

@@RezaDorrani What is your approach for developing in Teams? Is editing/publishing the only approach available, or can you develop in some sandbox/dev environment and then, when ready, publish it to teams?

[@RezaDorrani]

@@alexk7837 Teams environments are not ALM friendly. It has many limitations.

[@ashokpershad]

Hi! Reza, 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?

[@RezaDorrani]

Very interesting observation. They are indeed missing. I will bring this to the notice of the MSFT team.

[@jodiem5869]

It looks great!

[@RezaDorrani]

Agreed

[@awimanu1006]

Hi Reza, is there a way to capture Microsoft Team Meeting Attendance automatically and save it to sharepoint !

[@RezaDorrani]

Currently, Teams meeting information is not available as an API. Only way to do it would be by manually exporting the attendance info after the meeting ends.

[@awimanu1006]

@@RezaDorrani thank you as always !

[@rafiqueonlinetraining1264]

Can I add my existing power apps that I have already created through Power Apps

[@RezaDorrani]

Currently import export is not supported. Will be in future. For now you would have to copy paste controls.

[@rafiqueonlinetraining1264]

​ @Reza Dorrani Great. Thanks mate... for your quick response... Appreciate it...

[@NarnawareSunil]

Hi Reza.. Great Video👍 Thank You. One question is what if I have to implement the same app for another team? How can we deploy/migrate from One team to other Team?

[@RezaDorrani]

Currently, you can push the same App to multiple Teams by clicking on Publish to Teams - however users would need access to the artifacts in the base team (team where the Tables were created). Currently export/import solutions is not supported. There will be an option in future to publish the App to your organization.

[@AhmedBalfaqih]

Can you make it a bit more difficult to understand and follow? :) Thank you Reza.

[@RezaDorrani]

Let me see if I can make it more complex next time 😊

[@akkaradechsrithongchai7766]

Yezzzzz +++

[@RezaDorrani]

👍