Introduction to Microsoft Dataverse in Power Apps | Build Tables & Relationships | Beginners Guide

Getting started with Microsoft Dataverse? Then this Introduction video on Microsoft Dataverse has you covered.
You will learn how to create Dataverse Tables & Relationships, connect Tables to Canvas Power Apps, Add/Update Relational Data & more.
Video will provide an Overview of Dataverse for Beginners, cover Data Model, Dataverse Tables & Relationships and we will build a Power App from Dataverse data.
We will cover all types of relationships - Many-to-one, One-to-many, and Many-to-many (N:1, 1:N & N: N), define our data model, leverage Lookup columns & use both the Form Control & Patch function to add/update data in our Tables.
#Dataverse #PowerApps #Microsoft #PowerPlatform
We will learn the following:
✅ What is Microsoft Dataverse?
✅ Connectors Vs Dataverse
✅ Dataverse features Overview
✅ Data Model - Tables & Relational Data Structure
✅ Creating Dataverse Tables, Columns, Relationships, Choices, etc.
✅ Demo of Dataverse Tables & Relationships in Power Apps
✅ Build a Power App from Dataverse data for Beginners
Microsoft Dataverse Overview & Architecture:
• Microsoft Dataverse Ov...
Microsoft Dataverse Playlist
• Microsoft Dataverse
Microsoft Dataverse for Teams Playlist
• Microsoft Dataverse fo...
Table of Contents:
00:00 - Introduction
00:29 - Working with your data in Power Platform
01:34 - Introduction to Microsoft Dataverse
02:40 - Dataverse Overview - Security, Logic, Data, Storage & Integration
04:26 - Power Platform Connectors Vs Dataverse
05:20 - Data Model - Dataverse Tables & Relationships
06:00 - Many-to-one, One-to-many, and Many-to-many Relationships
06:41 - Demo of Power App connected to Microsoft Dataverse
10:02 - Build Tables in Microsoft Dataverse
12:11 - Build Relationships between Tables in Microsoft Dataverse (lookup Columns & Many:many)
15:20 - Create a Canvas Power App & Connect to Dataverse Tables
16:15 - Add/Update data in Dataverse Tables using Form Control
19:31 - Patch Dataverse Table Lookup Column
21:23 - Add One-to-many Relationship Data in PowerApps
25:07 - Add Many-to-many Relationship Data in PowerApps using Relate function
27:25 - Remove Many-to-many Relationship Data in PowerApps using Unrelate function
28:15 - Power Apps working with Dataverse Tables & Relationships
30:05 - Subscribe to Reza Dorrani channel
🤝 Let’s connect on social:
🔗 Reza Dorrani LinkedIn: / rezadorrani
🐦 Reza Dorrani Twitter: / rezadorrani

Пікірлер: 530

  • @jamesnadua2738
    @jamesnadua2738 Жыл бұрын

    I have just started with Power Apps a week ago and out of all the KZread videos, you have the most detailed, and most logical guides so far. Thank you so much for these videos! I have only watched two 30min videos and I have learned so much in such a short time! Detailed, compact, digestible, and easy to follow tutorials WITH AMAZING EXAMPLES. Thank you so much for these videos, Reza! I've subscribed and can't wait to learn more!

  • @RezaDorrani

    @RezaDorrani

    Жыл бұрын

    Thank You so much for the amazing feedback 🙏

  • @flibitboat

    @flibitboat

    Жыл бұрын

    100% agreed! Whenever it is a Reza video, I know it will be worthwhile! Thank you Reza!

  • @ma.ninasaygo9923

    @ma.ninasaygo9923

    5 ай бұрын

    Agree! thank you! New Subscriber here :)

  • @qoryhanisagal

    @qoryhanisagal

    4 ай бұрын

    I have learned more with his Live Q & A and PowePlatform Training

  • @InvestingwithJYK

    @InvestingwithJYK

    3 ай бұрын

    @@qoryhanisagal have you tried other no-code platforms?

  • @Gabo135790
    @Gabo13579010 ай бұрын

    This is the most excellent tutorial I have found, and I have searched for a tutorial for months already! Thanks for this guide; it helped me a lot! You save a soul! I´m genuinely thankful to found you!

  • @RezaDorrani

    @RezaDorrani

    10 ай бұрын

    You're very welcome and thanks so much for watching and liking the video

  • @jonathansmith31
    @jonathansmith312 жыл бұрын

    Hi Reza, great video as always. Having read alot of the MS docs and watch many videos in prep for moving from sharepoint to DV, this was by far the most helplful, clear and easy to follow. I now need to go back to my ERD and remove most of the autonumber id columns (for use as FK). Keep the videos coming!

  • @RezaDorrani

    @RezaDorrani

    2 жыл бұрын

    Awesome! Thank You for the amazing feedback.

  • @chrisbean7851
    @chrisbean7851 Жыл бұрын

    Perfect intro video for relationships for where I'm at currently with Powerapps/Dataverse. Thank you!

  • @RezaDorrani

    @RezaDorrani

    Жыл бұрын

    Most welcome

  • @lesiac95b
    @lesiac95b Жыл бұрын

    This tutorial allows you to understand in a simple and detailed way how Dataverse works in relation to the main objects used for a Power Apps application. It offers a true performance. Thank you very much

  • @RezaDorrani

    @RezaDorrani

    Жыл бұрын

    You're very welcome!

  • @alternatingdevelopment7206
    @alternatingdevelopment7206 Жыл бұрын

    Much appreciated to have such complex dilemma as a training dummy. This helps a lot in understanding complexity of the process strucutre.

  • @RezaDorrani

    @RezaDorrani

    Жыл бұрын

    Happy to hear that! Thanks for watching

  • @Learnpowerplatform
    @Learnpowerplatform2 жыл бұрын

    Perfect video to cover all concepts of dataverse with practical scenario. Thanks a lot for sharing these concepts in one video

  • @RezaDorrani

    @RezaDorrani

    2 жыл бұрын

    So happy to hear that. Thanks for watching and liking the video.

  • @harjitsamra
    @harjitsamra2 жыл бұрын

    Great video. It showcases Dataverse and Power Apps, and how quickly apps can be built, really well. Thanks Reza :)

  • @RezaDorrani

    @RezaDorrani

    2 жыл бұрын

    Awesome! Glad to hear that.

  • @vincentitpro6066
    @vincentitpro60662 жыл бұрын

    Thanks Reza! The video was very clear and helpful! Hopefully more tutorials on Dataverse. I get stuck with the Model-driven apps. Are you going to make video tutorials about Model-driven apps in the future? Thanks again.

  • @RezaDorrani

    @RezaDorrani

    2 жыл бұрын

    Model-driven Apps is in my backlog.

  • @majettetv
    @majettetv Жыл бұрын

    Reza, you are fantastic! I have learned so much by watching and mimicking your videos that I am gaining more confidence in creating a usable app for my organization, daily. Thank you so much for sharing your expertise in such a user-friendly way.

  • @RezaDorrani

    @RezaDorrani

    Жыл бұрын

    You are so welcome and thanks for watching and learning from the videos.

  • @jjpp1970
    @jjpp19702 жыл бұрын

    This video has wide opened my mind to dataverse & Power Apps. I will try to build the POwer app as an exercise. Thank you.

  • @RezaDorrani

    @RezaDorrani

    2 жыл бұрын

    Exactly the reason why I made this video. Thank You for the awesome feedback.

  • @PabloMoricz
    @PabloMoricz2 жыл бұрын

    Reza, once again, this video has given me lots of new ideas for future apps I'm gonna develop for my company using Dataverse for Teams. I can't thank you enough for your great work and contribution.

  • @RezaDorrani

    @RezaDorrani

    2 жыл бұрын

    Great to hear! You are most welcome and thanks for watching.

  • @dougydoe
    @dougydoe Жыл бұрын

    Was looking to refresh my skills on relationships in Dataverse to help me in an upcoming project so came searching in your channel and this video has done just that. Thanks again sharing.

  • @RezaDorrani

    @RezaDorrani

    Жыл бұрын

    Glad to hear that! Thanks so much for watching.

  • @tazrianibneamin2374
    @tazrianibneamin237417 күн бұрын

    Learning a lot about Power Apps from you. Can't thank you more!

  • @RezaDorrani

    @RezaDorrani

    17 күн бұрын

    Most welcome and keep learning

  • @rembautimes8808
    @rembautimes8808 Жыл бұрын

    Wow! This changes everything on how the most efficient way to build powerful apps . Thanks Reza - you explained this concept really well.

  • @RezaDorrani

    @RezaDorrani

    Жыл бұрын

    Thanks so much

  • @jeffeNuts
    @jeffeNuts Жыл бұрын

    Thanks, this video helped me a lot with understanding relationships in Dataverse! Great quality video once again Reza :)

  • @RezaDorrani

    @RezaDorrani

    Жыл бұрын

    Most welcome

  • @anthonyleduc
    @anthonyleduc2 жыл бұрын

    Wow. What i have to said about this. It's just amazing. It's loud and clear. Easy to follow. I'm not afraid anymore about Dataverse...I' still afraid about the cost of the licencing that is why I prefer to use Dataverse for teams for the moment. Thanks a lot reza

  • @RezaDorrani

    @RezaDorrani

    2 жыл бұрын

    Glad it was helpful!

  • @pardhasaradhivasamsetty7693
    @pardhasaradhivasamsetty76937 ай бұрын

    Thank you. Very well explained. They are near to real time applications and helping a lot.

  • @RezaDorrani

    @RezaDorrani

    7 ай бұрын

    Glad it was helpful!

  • @FranciscoRodriguez16
    @FranciscoRodriguez16 Жыл бұрын

    Excellent Video. Thanks! Very clear presentation on the logic and workflow.

  • @RezaDorrani

    @RezaDorrani

    Жыл бұрын

    Glad to hear that! Thanks for watching.

  • @dipteshbosedb
    @dipteshbosedb2 жыл бұрын

    Thank you Reza. Your video has made it look so easy. Super helpful as always.

  • @RezaDorrani

    @RezaDorrani

    2 жыл бұрын

    Happy to hear that!

  • @imanesennaria3264
    @imanesennaria32642 жыл бұрын

    Very Helpful Tutorials. Thank you so much. may God Protect You!

  • @RezaDorrani

    @RezaDorrani

    2 жыл бұрын

    Thank You so much

  • @akvideos0909
    @akvideos09094 ай бұрын

    Reza. You are my goto for all of my PowerApps challenges and education. Thank you! 🙏

  • @RezaDorrani

    @RezaDorrani

    4 ай бұрын

    Thanks Andrew

  • @oluwatobiyusuf
    @oluwatobiyusuf2 жыл бұрын

    Thanks once again for this video. Advising clients to leverage dataverse is no longer an issue for me

  • @RezaDorrani

    @RezaDorrani

    2 жыл бұрын

    Great to hear that!

  • @juansimon8737
    @juansimon87372 жыл бұрын

    Great episode! The basics are super important when designing solutions. and thinking about a problem.

  • @RezaDorrani

    @RezaDorrani

    2 жыл бұрын

    Absolutely!

  • @PettakaTechnologies
    @PettakaTechnologies Жыл бұрын

    Fantastic. I really appreciate your knowledge and way of teaching.😀

  • @RezaDorrani

    @RezaDorrani

    Жыл бұрын

    Thank You

  • @simbim
    @simbim2 жыл бұрын

    Many thanks for these helpful guides!

  • @RezaDorrani

    @RezaDorrani

    2 жыл бұрын

    My pleasure!

  • @nishachaware1044
    @nishachaware1044 Жыл бұрын

    Brilliant work, Reza. Thanks much!

  • @RezaDorrani

    @RezaDorrani

    Жыл бұрын

    Thanks Nisha

  • @mahmoudnaguib2837
    @mahmoudnaguib2837 Жыл бұрын

    Thanks Reza! It was very clear and helpful, I appreciate your efforts

  • @RezaDorrani

    @RezaDorrani

    Жыл бұрын

    You are most welcome!

  • @mahalakshmidevarajan6656
    @mahalakshmidevarajan66562 жыл бұрын

    One of the great video. First time watched dataverse concept.. thanks Reza 🙂

  • @RezaDorrani

    @RezaDorrani

    2 жыл бұрын

    You're most welcome

  • @gideon17you
    @gideon17you Жыл бұрын

    Excellent! Very Excellent! Thank you Reza!

  • @RezaDorrani

    @RezaDorrani

    Жыл бұрын

    Thanks so much

  • @anandkrish1000
    @anandkrish10002 жыл бұрын

    Awesome !! Thanks for the video on Datavese , eagerly waiting for your video on security model video on Dataverse.

  • @RezaDorrani

    @RezaDorrani

    2 жыл бұрын

    Thanks Anand

  • @kaushar.
    @kaushar.11 ай бұрын

    Thank you Reza. I was looking for this stuff.

  • @RezaDorrani

    @RezaDorrani

    11 ай бұрын

    Most welcome

  • @georgegualda4262
    @georgegualda42622 жыл бұрын

    Excellent, much better than "Milestone" with less code. Next you can add Power Bi Tiles as a dashboard.

  • @RezaDorrani

    @RezaDorrani

    2 жыл бұрын

    Thank You George! I was actually surprised how simple it was to build it as I was preparing for the video.

  • @GPZ_Biker
    @GPZ_Biker8 ай бұрын

    I spent days and hours trying to find a tutorial video showing exactly what you have. This is genuinely a brilliant video. Thank you.

  • @RezaDorrani

    @RezaDorrani

    8 ай бұрын

    Glad it helped! Thanks so much for watching

  • @GPZ_Biker

    @GPZ_Biker

    8 ай бұрын

    Walking through it again with Powerapps open on the other screen. 😊 Do you have a recommendation which video I should watch next to work on aesthetics when I get it built?

  • @RezaDorrani

    @RezaDorrani

    8 ай бұрын

    @@GPZ_Biker Check my videos on designing apps. I have done 2-3 videos.

  • @GPZ_Biker

    @GPZ_Biker

    8 ай бұрын

    ​@RezaDorrani thank you. I have a query please. I set my tables up with unique identification fields (Primary keys). When I am pulling the data into the Dropdowns, it is showing the ID field instead of the project name. Can I display the name field, or must I delete the ID field. I know you mentioned that Dataverse/power apps creates the master and foreign and builds the relationship itself, but when I did this sort of thing many years ago in access, I could create a relationship on the key field and display another field in the related table.

  • @RezaDorrani

    @RezaDorrani

    8 ай бұрын

    @@GPZ_Biker You can always change whats displayed in dropdowns and combo boxes. Check properties on the right. I would recommend posting your query with screenshots as well - powerusers.microsoft.com

  • @GilbertYatesPhotography
    @GilbertYatesPhotography2 жыл бұрын

    Really great introduction, thank you!

  • @RezaDorrani

    @RezaDorrani

    2 жыл бұрын

    Thanks Gilbert

  • @mustafahussainmohsin320
    @mustafahussainmohsin3202 жыл бұрын

    Thanks Mr Reza, I was literally waiting for this kind of guide... Thanks a ton!!!.. Well can you please make more videos on Dataverse and Power Automate, (Business process flow, and RPA)..

  • @RezaDorrani

    @RezaDorrani

    2 жыл бұрын

    Most welcome! I will plan more videos around Dataverse. BPF and RPA would be later.

  • @RodrigoMartinsSilva44
    @RodrigoMartinsSilva442 жыл бұрын

    Great journey starting... lets go

  • @RezaDorrani

    @RezaDorrani

    2 жыл бұрын

    Thanks

  • @robinjamesnjarlely
    @robinjamesnjarlely2 жыл бұрын

    Loved the content Reza, really hope see more similar videos. Great Work

  • @RezaDorrani

    @RezaDorrani

    2 жыл бұрын

    Thanks Robin

  • @johnbeynon3385
    @johnbeynon33852 жыл бұрын

    Excellent video Reza, many thanks.

  • @RezaDorrani

    @RezaDorrani

    2 жыл бұрын

    Most welcome. Thanks for watching.

  • @surafel6771
    @surafel67712 жыл бұрын

    thank you reza for your helpful videos. am learning to be a power platform and sharepoint developer. hopefully i will get an offer soon.

  • @RezaDorrani

    @RezaDorrani

    2 жыл бұрын

    Awesome! Best of luck to you!

  • @juandavila4035
    @juandavila40352 жыл бұрын

    Perfect video, thanks Reza! I loved it. I am working with dataverse and this video will be very useful for me

  • @RezaDorrani

    @RezaDorrani

    2 жыл бұрын

    Glad it was helpful! Thanks for watching.

  • @juandavila4035

    @juandavila4035

    2 жыл бұрын

    @@RezaDorrani I want to create a approval system with dataverse table, for example in your video, after the user has created a project his or her manager should give the okey. Is it easy or not?

  • @RezaDorrani

    @RezaDorrani

    2 жыл бұрын

    @@juandavila4035 Easy! Similar to all my approval videos :) I did multiple videos with flows and DV4T approvals. It may help. Check kzread.info/head/PLTyFh-qDKAiFG_FxWr-ACSmP39_84IUWl

  • @pranavkahol5925
    @pranavkahol59252 жыл бұрын

    Thank You Reza!!! This video is very helpful. Especially the relationships between the dataverse tables and the Relate and Unrelate functions. I request you to please upload videos on the Power Automate Desktop tool. You are the best!!! 💯👌

  • @RezaDorrani

    @RezaDorrani

    2 жыл бұрын

    Thanks Pranav. I have not received a lot of requests for PAD videos. If I do get a lot of requests, I will plan videos on PAD. I have 1 introductory video on PAD - kzread.info/dash/bejne/rGVtpaOQoZTae5s.html

  • @rpavanshetty

    @rpavanshetty

    2 жыл бұрын

    True that. Please make more videos on PAD as the resources available on the internet is way less and uneasy to follow

  • @pranavkahol5925

    @pranavkahol5925

    2 жыл бұрын

    @@RezaDorrani Yes I saw this video of yours 🙂 Thank You!!!

  • @Qeris
    @Qeris Жыл бұрын

    Brilliant stuff as always!

  • @RezaDorrani

    @RezaDorrani

    Жыл бұрын

    Thank You

  • @vinaymistry8664
    @vinaymistry86642 жыл бұрын

    Great Video, Thank you Rezza

  • @RezaDorrani

    @RezaDorrani

    2 жыл бұрын

    Glad you enjoyed it

  • @SHAli1474
    @SHAli14742 жыл бұрын

    Thanks Reza Brilliant video

  • @RezaDorrani

    @RezaDorrani

    2 жыл бұрын

    👍

  • @helenaconlon704
    @helenaconlon704 Жыл бұрын

    Great Video! I have so many ideas/solutions now

  • @RezaDorrani

    @RezaDorrani

    Жыл бұрын

    Great!

  • @nilangikapade1657
    @nilangikapade16572 жыл бұрын

    Great content Reza. I learnt a lot from you. I would request you to also make videos on PowerApps Portals.

  • @RezaDorrani

    @RezaDorrani

    2 жыл бұрын

    There will be a LIVE Power Apps Portals session on my channel in 2 weeks time.

  • @softlion84
    @softlion84 Жыл бұрын

    I made a POS System only with your introduction dataverse video thank you reza

  • @RezaDorrani

    @RezaDorrani

    Жыл бұрын

    Awesome!

  • @zixuanfu2309
    @zixuanfu23092 жыл бұрын

    The video is very helpful!

  • @RezaDorrani

    @RezaDorrani

    2 жыл бұрын

    Glad to hear that

  • @parawalterguatemala
    @parawalterguatemala Жыл бұрын

    Awesome, thank you Reza.

  • @RezaDorrani

    @RezaDorrani

    Жыл бұрын

    You’re most welcome

  • @DutchNorthAtlanticAlliance
    @DutchNorthAtlanticAlliance Жыл бұрын

    Bro you thought of everything - except - a timeline, love the video though, awesome work!

  • @RezaDorrani

    @RezaDorrani

    Жыл бұрын

    Thanks so much.

  • @shekharshinde8647
    @shekharshinde86472 жыл бұрын

    Awesome Video, really helpful.

  • @RezaDorrani

    @RezaDorrani

    2 жыл бұрын

    Glad it was helpful!

  • @forbudt4u2
    @forbudt4u2 Жыл бұрын

    Every time I watch one of your videos, I'm very thankful for how clear and detailed you present the information in such bite-sized chunks that can be easily digested by my brain. Thank you for that. I'm going to be migrating our company from SharePoint to Dataverse and I need some graphics that relay the benefits, which, in turn, justify the added expense for licensing. Is there any way to get the introductory 5 minutess of this video in slideshow/presentation format so I can present it with my other slides that are specific to our company needs? I would just show your video, but I'm positive that it will be difficult to keep people engaged for 5 min, and I just need the graphics so they have it on paper.

  • @forbudt4u2

    @forbudt4u2

    Жыл бұрын

    Please disregard my request, Reza. I went to your blog and found the presentation link in it. I absolutely love the way you openly share your knowledge with the rest of the world!!!

  • @RezaDorrani

    @RezaDorrani

    Жыл бұрын

    Thank You

  • @user-ku2fl6kn9x
    @user-ku2fl6kn9x3 ай бұрын

    Best Use of Power App Concept which i have used in My live projects in this Sort video . DataVerse, Creating Table ,Relationship , Using Canvas app , Form, Gallery, Patch ,Relate(function)

  • @RezaDorrani

    @RezaDorrani

    3 ай бұрын

    Thanks

  • @izidorrojs4838
    @izidorrojs4838 Жыл бұрын

    Reza. I love your content!!! Tell me how can i support you? You solved all my power apps issues so far. Love from Slovenia

  • @RezaDorrani

    @RezaDorrani

    Жыл бұрын

    Your comments, likes & sharing videos with others is your support.

  • @itubeHirschberg
    @itubeHirschberg2 жыл бұрын

    Sehr gut - danke

  • @RezaDorrani

    @RezaDorrani

    2 жыл бұрын

    Sie sind herzlich willkommen

  • @user-fz4ec6fg1o
    @user-fz4ec6fg1o7 ай бұрын

    Amazing video! I was wondering if you have made a video that shows how to make the other screens such as the Accounts screen and Client screen.

  • @RezaDorrani

    @RezaDorrani

    7 ай бұрын

    Thanks! I do not have a video on those specific screens

  • @davidrico8755
    @davidrico87552 жыл бұрын

    Thank you!!

  • @RezaDorrani

    @RezaDorrani

    2 жыл бұрын

    Your most welcome

  • @dvillaret74
    @dvillaret742 жыл бұрын

    Hi Reza, another great video. I have watched and learnt from many of your videos, and implemented what I have learnt. The next step on my journey is into Dataverse for Teams. I am looking to create an asset management tool where I can assign users to particular assets, such as laptops or phones. However, I need to be able to record the assignment history. So I can check who has been assigned a particular device since it's purchase, or what devices have been assigned a particular user since they joined us. Do you have a video or guidance on how to create such a history log table in Dataverse? Thanks... and looking forward to the next videos :)

  • @RezaDorrani

    @RezaDorrani

    2 жыл бұрын

    Dataverse for Teams playlist - kzread.info/head/PLTyFh-qDKAiFG_FxWr-ACSmP39_84IUWl I do not have your scenario based video though.

  • @premsai9908
    @premsai9908 Жыл бұрын

    Thanks!

  • @RezaDorrani

    @RezaDorrani

    Жыл бұрын

    Welcome

  • @rarun0080
    @rarun00802 жыл бұрын

    Thank you Raza. Your video is very useful, and helps me to learn different platforms much easier. While working in sharepoint and Power Apps the value for ID column upon add, edit and delete operations, we have to add more logics. Also at the SP list side the value for ID column was in incremental order so there was no way for me to reset before going live(after development). In dataverse after watching your video, I get a feeling its not a problem. I also noticed the update operations are very quick.

  • @RezaDorrani

    @RezaDorrani

    2 жыл бұрын

    Dataverse >>>>>>>> SharePoint

  • @rarun0080

    @rarun0080

    Жыл бұрын

    @@RezaDorrani I do have an question.. i created a table(say Masterdata) in Dataverse the values in it gets refreshed daily from a sharepoint list and I do have another table(transactiondata) in Dataverse I am having one column(proj name) where it uses values from master table. The problem is every day when I refresh the data from sharepoint list into my master table(masterdata), the data existing column(project name)in transaction data table gets whipped out. Have you encountered this situation? If yes could you pls share some information how to mitigate it. Thank you

  • @RezaDorrani

    @RezaDorrani

    Жыл бұрын

    @@rarun0080 I have not encountered this scenario. I will recommend checking on forums at powerusers.microsoft.com/

  • @rajapriyan123
    @rajapriyan123 Жыл бұрын

    Very very helpful for me Thanks Reza Could you please Explain Multiple Attachment with the SharePoint document library and Project table

  • @RezaDorrani

    @RezaDorrani

    Жыл бұрын

    I do not have a video on that and no plans to make one. Check on forums in case someone has done something similar powerusers.microsoft.com

  • @perwatusipusatindonesia2826
    @perwatusipusatindonesia2826 Жыл бұрын

    Thank you sir

  • @RezaDorrani

    @RezaDorrani

    Жыл бұрын

    Most welcome

  • @ashimishra23
    @ashimishra23 Жыл бұрын

    Thanks a lot Reza! I always learn something new & tricky from your videos. Your videos are always very helpful and are the reason that I have been able to develop a working app for my team. I have almost similar scenario for which I am developing an App but looks like I am missing something and not able to move forward. Here is the scenario : We have #50 customers and #25 Tools and multiple implementation state for each tool. For each customer we want to know the status of every tool. Example, For customer A, Tool-1 is implemented but Tool-2 is in POC state whereas Tool-3 - POC Cancelled. So this way, For each customer, we will have #25 entries (#25 tools) and every entry will capture implementation status of respective tool for that customer. That means, total 50*25 = 1250 entries which will be stored in either sharepoint or excel or dataverse for teams. I want to build a Power App using which I can retrieve data from datasource-->Filter data for each customer so on a single page I am able to see tool name & implementation status of all the tools for Customer A ---> Edit those records and then save back to the datasource. Your guidance on this will be helpful. Thanks, Ashish.

  • @RezaDorrani

    @RezaDorrani

    Жыл бұрын

    Thanks for watching and liking the videos. SharePoint and Dataverse support delegation. Both should work for your scenario.

  • @ashimishra23

    @ashimishra23

    Жыл бұрын

    @@RezaDorrani : Thanks for the response! Actually the issue is - I am unable to fetch all records for a customer in editable. I used table but that fetches all the records and if I try to filter it based on customer then nothing shows.

  • @RezaDorrani

    @RezaDorrani

    Жыл бұрын

    @@ashimishra23 I would recommend posting your issue with screenshots on the forums powerusers.microsoft.com

  • @michelelomonaco5118
    @michelelomonaco5118 Жыл бұрын

    Hello Reza and congratulations for the tutorial. It is really suitable for beginners.

  • @RezaDorrani

    @RezaDorrani

    Жыл бұрын

    Glad to hear that! Thank You.

  • @michelelomonaco5118

    @michelelomonaco5118

    Жыл бұрын

    @@RezaDorrani The formula Items = Filter(Users, 'User Synced' = Yes ) applied to ComboBox1 gives me an error: Issue Incompatible type for comparison. Thes types can't be compared: OptionSetValue(User Synced(Users)), Error. Can you give me a suggestion? Thank you. Michele.

  • @RezaDorrani

    @RezaDorrani

    Жыл бұрын

    @@michelelomonaco5118 Yes cannot be text. You will need to compare it with the Choice type Enum.

  • @michelelomonaco5118

    @michelelomonaco5118

    Жыл бұрын

    @@RezaDorrani Sorry Reza I fixed it by selecting : Filter(Users, 'User Synced' = 'User Synced (Users)'.Yes )

  • @kajalsharma5889
    @kajalsharma58896 ай бұрын

    I was struggling understanding how we can work with form its amazing video i will work on it but again i would like to know how we can work with functions

  • @RezaDorrani

    @RezaDorrani

    6 ай бұрын

    Thanks! Check my playlist on Dataverse.

  • @qoryhanisagal
    @qoryhanisagal4 ай бұрын

    Perfect Timing!!! Is this solution available to channel members?

  • @RezaDorrani

    @RezaDorrani

    4 ай бұрын

    Most welcome! The solution is not available

  • @mrmurari5121
    @mrmurari5121 Жыл бұрын

    Hi Reza, Thanks for the video and explaining it very clearly. Although it is an example I have a question related to relation between tasks and users, the users should be visible from projects table instead of directly from Users table.

  • @RezaDorrani

    @RezaDorrani

    Жыл бұрын

    Possible by adding another gallery to show that info.

  • @raslaankhan5146
    @raslaankhan51462 жыл бұрын

    Hi Reza, Great demo. Loved it. Though I come from SharePoint background, I can build this completely with Lists. Users can view all the data easily as well from those lists. What advantage do we get with Dataverse? To view row wise data, users would have to go to Dataverse?

  • @RezaDorrani

    @RezaDorrani

    2 жыл бұрын

    docs.microsoft.com/en-us/power-apps/teams/compare-data-sources

  • @SmartLearningAI
    @SmartLearningAI6 ай бұрын

    Hey Reza, love this one. Why don't you follow up with your version of "The new Microsoft Planner" App using modern controls and the key features of the upcoming The new Microsoft Planner?

  • @RezaDorrani

    @RezaDorrani

    6 ай бұрын

    Thanks! New MS planner app? I have not done any work on it.

  • @nishikantrath2712
    @nishikantrath27122 жыл бұрын

    awesome video Reza!!! Clearly the one I was looking for. I have a question, I tried to do the same, created couple of tables and linked them through lookup columns but when I patch the data, in the dataverse table it's not visible however if I use a gallery to pull up the data it's coming visible. What could be the reason for it that I can't see the lookup column filled data in Dataverse table?

  • @RezaDorrani

    @RezaDorrani

    2 жыл бұрын

    I will have to look at your App in action to provide guidance. My guess is something is not right in the way you are setting the default value of lookup column. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com

  • @richardclowes6166
    @richardclowes6166 Жыл бұрын

    the best part is that you business scenario is very realistic

  • @RezaDorrani

    @RezaDorrani

    Жыл бұрын

    Glad to hear that! Thanks for watching.

  • @boyangxing5860
    @boyangxing5860 Жыл бұрын

    Thanks Reza! The video was so so helpful. Could you share the slides you used in this video?

  • @RezaDorrani

    @RezaDorrani

    Жыл бұрын

    Its not a presentation 😊 It is a Power App that has screens which look like a presentation. Anyways, here is the inspiration ppt link rezadorrani.com/index.php/2021/09/11/introduction-to-microsoft-dataverse/

  • @sam-dw3hk
    @sam-dw3hk Жыл бұрын

    Hello Reza, , Thank you for posting the videos on Power Apps topics. you are helping a lot to improve the skills. if i may ask a question on this particular topic, i am in the process of building similar with two tables A&B(1:N), let's say in your scenario project & project tasks, but in my case i will not be having a project to select in the lookup drop down while entering the project tasks. both tables data will be entered one after another at the same time and save it. so in this case what should i do to display table A data & Table B data that is related to table A. i posted this question in power community but no help. Thanks again for taking time.

  • @RezaDorrani

    @RezaDorrani

    Жыл бұрын

    Here is my guess: You would need the first item created in order for the relationship to come into effect. I think I may have shown something similar in this video - kzread.info/dash/bejne/anaJ2seSkpC5iJM.html

  • @minocat23
    @minocat232 жыл бұрын

    Interesting video - I guess primary and foreign keys are no longer needed to be declared in Dataverse. Normally I would use an autonumber ID column

  • @RezaDorrani

    @RezaDorrani

    2 жыл бұрын

    Power of Dataverse!

  • @powermykola
    @powermykola2 жыл бұрын

    Great video, are you planning any more videos about the security model and access to records in tables, using tables businessunit & systemuser ?

  • @RezaDorrani

    @RezaDorrani

    2 жыл бұрын

    Depends on the response to this one :)

  • @powermykola

    @powermykola

    2 жыл бұрын

    @@RezaDorrani where to write, like :)

  • @RezaDorrani

    @RezaDorrani

    2 жыл бұрын

    ​@@powermykola :) Video is getting a good response. I will plan for a security model video on Dataverse but I have plenty of other video ideas lined up!

  • @RicksterLuna
    @RicksterLuna4 ай бұрын

    Thank you for this awesome video! I do have a question, for the N:N relationship where you assigned multiple team members, where is the data being written to? I have done something similar but I can't find the supporting data for up. Thanks

  • @RezaDorrani

    @RezaDorrani

    4 ай бұрын

    All data is stored in Dataverse. I recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com

  • @rinretgamaliel5961
    @rinretgamaliel5961 Жыл бұрын

    yu built your slide in power apps, interesting!

  • @RezaDorrani

    @RezaDorrani

    Жыл бұрын

    Yes

  • @mohammednizamuddin1348
    @mohammednizamuddin13483 ай бұрын

    Thanks Reza for another informative tutorial. Quick Question - Is it possible to patch to a specific row instead of a column?

  • @RezaDorrani

    @RezaDorrani

    3 ай бұрын

    Most welcome. We patch to rows only but provide it column values.

  • @mohammednizamuddin1348

    @mohammednizamuddin1348

    3 ай бұрын

    @@RezaDorrani thanks for the swift reply. Can you please recommend me your tutorial where we go over the patching aspect as well? I’m watching a few rn :)

  • @RezaDorrani

    @RezaDorrani

    3 ай бұрын

    @@mohammednizamuddin1348 I have done 3-4 videos on Patch function. Search for patch reza dorrani on KZread

  • @GOV221
    @GOV2216 ай бұрын

    Hey Rez- great video. Throughly enjoyed it. Was wondering though: how did you insert the icons into the respective galleries. I really like that look and was wondering.

  • @RezaDorrani

    @RezaDorrani

    6 ай бұрын

    Thanks! What time in video are they shown?

  • @GOV221

    @GOV221

    6 ай бұрын

    @@RezaDorrani near the end.

  • @RezaDorrani

    @RezaDorrani

    6 ай бұрын

    @@GOV221 Those are emojis

  • @GOV221

    @GOV221

    6 ай бұрын

    29:40

  • @sundrapillay6668
    @sundrapillay66682 жыл бұрын

    Thanks Reza

  • @RezaDorrani

    @RezaDorrani

    2 жыл бұрын

    You are most welcome!

  • @pkns_cad
    @pkns_cad5 ай бұрын

    Hi Reza, great tutorial as always!! I am using SQL tables as source with PK and FK constraints set. When I create forms, only the source table columns are showing up but not the Lookup columns associated with Foreign keys from other table. Appreciate your suggestions

  • @RezaDorrani

    @RezaDorrani

    5 ай бұрын

    I have done no work with sql hence not sure. I recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com

  • @pkns_cad

    @pkns_cad

    5 ай бұрын

    @@RezaDorrani Thanks Reza !!

  • @flaviaaa
    @flaviaaa8 ай бұрын

    Hi! Thank you for sharing the info by being so clear! I have a question: I work in a company where they want to use Power Apps to keep track of each worker's activities throughout the day, meaning that each worker needs to access to Power Apps to register their working day. Is it possible to store it in Dataverse? Do we need to buy licenses for each account?🤔🤔

  • @RezaDorrani

    @RezaDorrani

    8 ай бұрын

    Most welcome! To use Dataverse, every user of the App will require a premium license.

  • @nduagubadev
    @nduagubadev2 жыл бұрын

    ❤ u reza

  • @RezaDorrani

    @RezaDorrani

    2 жыл бұрын

    Thank You!!!

  • @JasonAngWeiLung
    @JasonAngWeiLung2 жыл бұрын

    Hi Reza! Thanks for continue to impart ur impactful knowledge! Btw,As you know it is costly to store images (files) in Dataverse storage. Do you mind to make a video or explain how to link multiple SharePoint Images links to Dataverse column? Please note that preferably, the app can show image previews or thumbnails of the sharepoint images in Dataverse app.

  • @RezaDorrani

    @RezaDorrani

    2 жыл бұрын

    I make videos when I get multiple requests on a particular topic. Every quarter I ask subscribers for topic suggestions on the Community Tab of my KZread channel. Subscribers vote for topics and the highest voted topics get added to my backlog. Make sure you post this in the next topic suggestion post. If it gets a lot of votes, I will add it to my backlog.

  • @JasonAngWeiLung

    @JasonAngWeiLung

    2 жыл бұрын

    @@RezaDorrani Just posted in your community tab :) Wish to get some votes

  • @RezaDorrani

    @RezaDorrani

    2 жыл бұрын

    @@JasonAngWeiLung That would be when I ask folks to vote :) Currently, I am working on a backlog of videos. Wait for next round of topic suggestions which would be 1-2 months from now.

  • @JasonAngWeiLung

    @JasonAngWeiLung

    2 жыл бұрын

    @@RezaDorrani oops.. seems like I have no luck for this round

  • @RezaDorrani

    @RezaDorrani

    2 жыл бұрын

    @@JasonAngWeiLung times up for this round :)

  • @jonathansmith6047
    @jonathansmith60472 жыл бұрын

    Reza, quick follow up question if I may. When you do a lookup column it gives you the value that is in the primary name colmn in the table you are looking up. Thats ok but what if that table were a user table where names are not unique, if I give it an autonumber as the primary name column it then makes it impossible to know which record I am looking up. I have tried to change the display in a drop down to show the name rather than the ID but no luck. Is there a way around this or is it just one of those things?? Many thanks in advance

  • @RezaDorrani

    @RezaDorrani

    2 жыл бұрын

    I have not tried that scenario so not 100% sure. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.

  • @paolovr1970
    @paolovr1970 Жыл бұрын

    Thanks Reza, do you think that if we have SQL server database as ERP software we can synchronize data true the 2 system?

  • @RezaDorrani

    @RezaDorrani

    Жыл бұрын

    Probably but not something I have tried

  • @ganeshdasari3786
    @ganeshdasari37862 жыл бұрын

    Thanks for making such a Nice Video on Dataverse @Reza Dorrani. Its really helpfu,. I have a doubt/requirement: What if I need to upload More than 5000 records to my Dataverse using canvas app instead of importing excel data in dataverse. Is that possible?

  • @RezaDorrani

    @RezaDorrani

    2 жыл бұрын

    Possible using bulk data addition techniques. kzread.info/dash/bejne/iK6mw9ScfZy9Zc4.html

  • @a1android222
    @a1android222 Жыл бұрын

    Thanks Reza for all your content on Power apps. I am developing a similar screen but with my own tables. I have used collection as a datasource for the main gallery. On adding or removing items to my relationship table by Relate/Unrelate my main gallery and neither the names list gallery gets updated. Although I call Referesh(mytable) and ClearCollect after relate/unrelate. Any ideas pls. Thanks

  • @RezaDorrani

    @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

  • @SauloOliveira
    @SauloOliveira Жыл бұрын

    Thank you Reza. One question about security. Which Dataverse feature should I use to achieve the same effect as breaking inheritance by row in SharePoint and choosing which people or groups can access that row?

  • @RezaDorrani

    @RezaDorrani

    Жыл бұрын

    Look into Ownership of records. There are various security constructs in Dataverse. This is a good video -> kzread.info/dash/bejne/enx20baHfb3ao7Q.html

  • @SauloOliveira

    @SauloOliveira

    Жыл бұрын

    @@RezaDorrani thanks Reza, I watched the video and I need to use the feature sharing.

  • @RezaDorrani

    @RezaDorrani

    Жыл бұрын

    @@SauloOliveira 👍

  • @mikhailprudecarcaustozea7044
    @mikhailprudecarcaustozea70442 жыл бұрын

    Hi Reza! Please let deep in Power BI - new power automate feature (inside PBI). Common cases please

  • @RezaDorrani

    @RezaDorrani

    2 жыл бұрын

    Did you see this one 👉 kzread.info/dash/bejne/o3tkk7l9nZjFd9I.html

  • @mohdahmed-ze6uz
    @mohdahmed-ze6uz Жыл бұрын

    nice explaination. sir, how much time you took to create this app in real time?

  • @RezaDorrani

    @RezaDorrani

    Жыл бұрын

    Probably around 4-6 hours

  • @Jac0bd3luxe
    @Jac0bd3luxe7 ай бұрын

    Hi Reza, Again, great video. I am working on an app where i can relate the same tables, but instead of adding 'tasks' i need to add weekly allocated hours for each employee on projects. So each employee can see and edit their allocations for each project 12 weeks ahead or something. Do you have a video for building something like this or an idea how this could be build in a smart way? BR Jacob

  • @RezaDorrani

    @RezaDorrani

    7 ай бұрын

    Thanks! I do not have a video reference on the mentioned scenario.

  • @DominikSZiems
    @DominikSZiems Жыл бұрын

    Hi REZA awesoe video -where do you explain how to build the full app?

  • @RezaDorrani

    @RezaDorrani

    Жыл бұрын

    Not the full app

  • @BrunoSantos-jk6xu
    @BrunoSantos-jk6xu2 жыл бұрын

    Hi Reza, as always your contents are amazing. I am trying to setup a column in dataverse where I can choose multiple names, but when I submit it only appears last name chosen in combobox, do you know what can be happening?

  • @RezaDorrani

    @RezaDorrani

    2 жыл бұрын

    I do not have a video reference on this scenario and would have to try it out to provide guidance. 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

  • @andrew260z
    @andrew260z Жыл бұрын

    Thanks for this tutorial - i've setup a similar app where i have a gallery on screen 1 and on screen 2 i have the edit form and a gallery to the related table, and a form for the related table. However when adding a record to the related table i seem to have to trigger refresh statements to get the related table gallery to show the new item but in your demo you seem to not have that problem ?

  • @RezaDorrani

    @RezaDorrani

    Жыл бұрын

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

  • @chetanHkhanapure
    @chetanHkhanapure11 ай бұрын

    Hi Reza, Thanks for valuable information on Dataverse and it’s relationship, I have one question if I developed powerapps with “Per User Plan” license and use Dataverse or premium connector, so after publishing on Production can business user who have office E1, E3 or E5 license holder can access and perform data modification activities?

  • @RezaDorrani

    @RezaDorrani

    11 ай бұрын

    All App users will need premium licenses.

  • @chetanHkhanapure

    @chetanHkhanapure

    11 ай бұрын

    Thanks you so much Reza

  • @DouglasHenrique-vn8uw
    @DouglasHenrique-vn8uw2 жыл бұрын

    Nice vídeo! What software did you use to build the data models?

  • @RezaDorrani

    @RezaDorrani

    2 жыл бұрын

    I used Lucidchart

  • @DouglasHenrique-vn8uw

    @DouglasHenrique-vn8uw

    2 жыл бұрын

    @@RezaDorrani Thanks

  • @sathya2870
    @sathya28702 жыл бұрын

    thanks, Reza how do I deploy the flow with premium connectors in power automate when a client wants to be running the flow in their systems, what is a suitable license I should prefer/suggest to them (client)... can you please explain it

  • @RezaDorrani

    @RezaDorrani

    2 жыл бұрын

    Im not sure about this.

  • @viniciusalvim8496
    @viniciusalvim8496 Жыл бұрын

    Thanks Reza. At company that I work environment space is available with restrictions, so I can't create new tables as your example. Do you know if it is possible to do something similar using tables available ?

  • @RezaDorrani

    @RezaDorrani

    Жыл бұрын

    No access, no tables. You could do this with existing tables but you would not be able to update the schema.