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

Поділитися
Вставка
  • Опубліковано 1 лис 2024

КОМЕНТАРІ • 553

  • @jamesnadua2738
    @jamesnadua2738 2 роки тому +30

    I have just started with Power Apps a week ago and out of all the UA-cam 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  2 роки тому +4

      Thank You so much for the amazing feedback 🙏

    • @flibitboat
      @flibitboat Рік тому +2

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

    • @ma.ninasaygo9923
      @ma.ninasaygo9923 9 місяців тому

      Agree! thank you! New Subscriber here :)

    • @qoryhanisagal
      @qoryhanisagal 9 місяців тому +1

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

    • @InvestingwithJYK
      @InvestingwithJYK 7 місяців тому

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

  • @atharvagadiwan5281
    @atharvagadiwan5281 13 днів тому +1

    Reza you are a Legend! I successfully completed my internship projects, all thanks to you 🎉

  • @GPZ_Biker
    @GPZ_Biker Рік тому +4

    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  Рік тому +1

      Glad it helped! Thanks so much for watching

    • @GPZ_Biker
      @GPZ_Biker Рік тому

      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  Рік тому +1

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

    • @GPZ_Biker
      @GPZ_Biker Рік тому

      ​@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  Рік тому +1

      @@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

  • @alternatingdevelopment7206
    @alternatingdevelopment7206 2 роки тому +3

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

    • @RezaDorrani
      @RezaDorrani  2 роки тому

      Happy to hear that! Thanks for watching

  • @lesiac95b
    @lesiac95b Рік тому +1

    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

  • @dougydoe
    @dougydoe Рік тому +1

    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.

  • @chrisbean7851
    @chrisbean7851 Рік тому +1

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

  • @jjpp1970
    @jjpp1970 2 роки тому +1

    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 роки тому +1

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

  • @Gabo135790
    @Gabo135790 Рік тому +1

    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  Рік тому

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

  • @oluwatobiyusuf
    @oluwatobiyusuf 2 роки тому +1

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

  • @anthonyleduc
    @anthonyleduc 2 роки тому +2

    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

  • @vincentitpro6066
    @vincentitpro6066 2 роки тому +15

    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 роки тому +12

      Model-driven Apps is in my backlog.

  • @dannievers5360
    @dannievers5360 2 місяці тому +1

    This is one of the best and easy understandable videos of Dataverse and create app with Dataverse data. Thank you very much!!!
    Seems sooooo simple.. :)

    • @RezaDorrani
      @RezaDorrani  2 місяці тому

      You are most welcome! Thanks so much for watching and learning from the video.

  • @rembautimes8808
    @rembautimes8808 Рік тому +1

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

  • @pardhasaradhivasamsetty7693
    @pardhasaradhivasamsetty7693 11 місяців тому +1

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

  • @imanesennaria3264
    @imanesennaria3264 2 роки тому +2

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

  • @jonathansmith31
    @jonathansmith31 2 роки тому +2

    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 роки тому +1

      Awesome! Thank You for the amazing feedback.

  • @PabloMoricz
    @PabloMoricz 2 роки тому +1

    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.

  • @Learnpowerplatform
    @Learnpowerplatform 2 роки тому +1

    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.

  • @akvideos0909
    @akvideos0909 8 місяців тому

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

  • @softlion84
    @softlion84 2 роки тому +1

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

  • @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.

  • @harjitsamra
    @harjitsamra 2 роки тому +2

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

  • @georgegualda4262
    @georgegualda4262 2 роки тому +3

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

    • @RezaDorrani
      @RezaDorrani  2 роки тому +1

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

  • @SunilChauhan-s9r
    @SunilChauhan-s9r 7 місяців тому +1

    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)

  • @matthewlay4939
    @matthewlay4939 3 місяці тому +1

    This was awesome. Very easy to follow along yet also very insightful and useful. Thank you Reza

  • @tazrianibneamin2374
    @tazrianibneamin2374 4 місяці тому

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

    • @RezaDorrani
      @RezaDorrani  4 місяці тому

      Most welcome and keep learning

  • @surafel6771
    @surafel6771 2 роки тому +1

    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 роки тому +1

      Awesome! Best of luck to you!

  • @forbudt4u2
    @forbudt4u2 2 роки тому +1

    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 2 роки тому +1

      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  2 роки тому

      Thank You

  • @mahalakshmidevarajan6656
    @mahalakshmidevarajan6656 2 роки тому +1

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

  • @dipteshbosedb
    @dipteshbosedb 2 роки тому +1

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

  • @FranciscoRodriguez16
    @FranciscoRodriguez16 2 роки тому +1

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

    • @RezaDorrani
      @RezaDorrani  2 роки тому

      Glad to hear that! Thanks for watching.

  • @mahmoudnaguib2837
    @mahmoudnaguib2837 Рік тому +1

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

  • @PettakaTechnologies
    @PettakaTechnologies Рік тому +1

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

  • @pkns_cad
    @pkns_cad 9 місяців тому +1

    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  9 місяців тому

      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 9 місяців тому

      @@RezaDorrani Thanks Reza !!

  • @pranavkahol5925
    @pranavkahol5925 2 роки тому +1

    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 роки тому +1

      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 - ua-cam.com/video/z19CAWq1tK8/v-deo.html

    • @rpavanshetty
      @rpavanshetty 2 роки тому +1

      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 роки тому +1

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

  • @anandkrish1000
    @anandkrish1000 2 роки тому +1

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

  • @simbim
    @simbim 2 роки тому +1

    Many thanks for these helpful guides!

  • @rarun0080
    @rarun0080 2 роки тому +1

    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 2 роки тому

      @@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  2 роки тому

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

  • @flaviaaa
    @flaviaaa Рік тому +1

    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  Рік тому +1

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

  • @juandavila4035
    @juandavila4035 2 роки тому +1

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

    • @RezaDorrani
      @RezaDorrani  2 роки тому +1

      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 роки тому +1

      @@juandavila4035 Easy! Similar to all my approval videos :)
      I did multiple videos with flows and DV4T approvals. It may help. Check ua-cam.com/play/PLTyFh-qDKAiFG_FxWr-ACSmP39_84IUWl.html

  • @richardclowes6166
    @richardclowes6166 Рік тому

    the best part is that you business scenario is very realistic

    • @RezaDorrani
      @RezaDorrani  Рік тому

      Glad to hear that! Thanks for watching.

  • @MatthewWilson-h4r
    @MatthewWilson-h4r 11 місяців тому +1

    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  11 місяців тому

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

  • @RodrigoMartinsSilva44
    @RodrigoMartinsSilva44 2 роки тому +1

    Great journey starting... lets go

  • @juansimon8737
    @juansimon8737 2 роки тому +1

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

  • @RicksterLuna
    @RicksterLuna 9 місяців тому

    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  9 місяців тому

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

  • @mohammednizamuddin1348
    @mohammednizamuddin1348 7 місяців тому +1

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

    • @RezaDorrani
      @RezaDorrani  7 місяців тому

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

    • @mohammednizamuddin1348
      @mohammednizamuddin1348 7 місяців тому

      @@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  7 місяців тому

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

  • @GSoftagon
    @GSoftagon Рік тому +1

    Excellent! Very Excellent! Thank you Reza!

  • @chetanHkhanapure
    @chetanHkhanapure Рік тому +1

    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?

  • @kajalsharma5889
    @kajalsharma5889 10 місяців тому +1

    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  10 місяців тому

      Thanks!
      Check my playlist on Dataverse.

  • @ashimishra23
    @ashimishra23 2 роки тому

    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  2 роки тому

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

    • @ashimishra23
      @ashimishra23 2 роки тому

      @@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  2 роки тому

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

  • @izidorrojs4838
    @izidorrojs4838 2 роки тому +1

    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  2 роки тому

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

  • @kaushar.
    @kaushar. Рік тому +1

    Thank you Reza. I was looking for this stuff.

  • @nishachaware1044
    @nishachaware1044 2 роки тому +1

    Brilliant work, Reza. Thanks much!

  • @nishikantrath2712
    @nishikantrath2712 2 роки тому +1

    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 роки тому +1

      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

  • @GOV221
    @GOV221 10 місяців тому +1

    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  10 місяців тому

      Thanks!
      What time in video are they shown?

    • @GOV221
      @GOV221 10 місяців тому

      @@RezaDorrani near the end.

    • @RezaDorrani
      @RezaDorrani  10 місяців тому

      @@GOV221 Those are emojis

    • @GOV221
      @GOV221 10 місяців тому

      29:40

  • @mustafahussainmohsin320
    @mustafahussainmohsin320 2 роки тому +1

    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 роки тому +1

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

  • @qoryhanisagal
    @qoryhanisagal 9 місяців тому +1

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

    • @RezaDorrani
      @RezaDorrani  9 місяців тому

      Most welcome!
      The solution is not available

  • @rajapriyan123
    @rajapriyan123 2 роки тому +1

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

    • @RezaDorrani
      @RezaDorrani  2 роки тому

      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

  • @DutchNorthAtlanticAlliance
    @DutchNorthAtlanticAlliance Рік тому +1

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

  • @eizzo67
    @eizzo67 7 місяців тому +1

    Thanks Reza. I really appreciate this video and all the other one I saw. I have just a question about the user table you mention that I didn't find in my dataverse. It is in italian but there are two table: "Utenti (users)" and "Utenti Microsoft (Microsoft users)". When I show their content I didn't find my organization identities. I have found a virtual table called "Microsoft Entra Identity" and it shows the accounts in my domain so I've thinked to use it but it is not allowed to create on that table a many-to-many relationship. I really appreciate a your feedback and again thanks for your job.

    • @RezaDorrani
      @RezaDorrani  7 місяців тому

      Microsoft Entra Identity is a virtual table. You cannot create many-many relationships with a virtual table as the data does not live in table.

    • @eizzo67
      @eizzo67 7 місяців тому

      @@RezaDorrani Thanks for your quick reply. so what is the table i can use for users?

    • @RezaDorrani
      @RezaDorrani  7 місяців тому +1

      @@eizzo67 Il recommend checking documentation on difference between the 2 tables.

  • @bosnianinny
    @bosnianinny 28 днів тому +1

    Thanks a million! You are a 🌟 :)

  • @johnbeynon3385
    @johnbeynon3385 2 роки тому +1

    Excellent video Reza, many thanks.

    • @RezaDorrani
      @RezaDorrani  2 роки тому

      Most welcome. Thanks for watching.

  • @a1android222
    @a1android222 2 роки тому +1

    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  2 роки тому

      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

  • @mohitshah6615
    @mohitshah6615 Рік тому +1

    Thanks Reza for the informative video!!
    I had a query - There is a transformation which I have undertaken in Power BI and Power Query and have published it on Power BI web - Fabric. Ideally since its on Microsoft platform data should be able to flow to Power App. However when trying to fetch data through dataverse in Power Apps, I am not able to see the data set published on Power BI. Will you be able to help with a solution. Many Thanks!

    • @RezaDorrani
      @RezaDorrani  Рік тому

      I have not come across the mentioned issue and hence not sure what the fix for your issue is. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com

    • @mohitshah6615
      @mohitshah6615 Рік тому +1

      @@RezaDorrani Thank you for your quick response!

  • @Jac0bd3luxe
    @Jac0bd3luxe 11 місяців тому +1

    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  11 місяців тому

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

  • @nilangikapade1657
    @nilangikapade1657 2 роки тому +1

    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.

  • @SauloOliveira
    @SauloOliveira Рік тому +1

    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  Рік тому +1

      Look into Ownership of records.
      There are various security constructs in Dataverse.
      This is a good video -> ua-cam.com/video/HHBoTNMZtsQ/v-deo.html

    • @SauloOliveira
      @SauloOliveira Рік тому +1

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

    • @RezaDorrani
      @RezaDorrani  Рік тому

      @@SauloOliveira 👍

  • @vicentedelgado3001
    @vicentedelgado3001 Рік тому +1

    hey REza! great video! Hey I'm having issues where users are not having access to the read/write the dataverse from the powerapp. Any idea?

    • @RezaDorrani
      @RezaDorrani  Рік тому +1

      Thanks. You need to grant them a security role which has privileges on the Table. Check Dataverse security documentation.

    • @vicentedelgado3001
      @vicentedelgado3001 Рік тому +1

      @@RezaDorrani thanks! Very few information about it.. i found in an article that didn't had the word PowerApps nor Dataverse anywhere hahaha appreciated your guidance! Thanks so much!

  • @GilbertYatesPhotography
    @GilbertYatesPhotography 2 роки тому +1

    Really great introduction, thank you!

  • @boyangxing5860
    @boyangxing5860 Рік тому +1

    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/

  • @Qeris
    @Qeris Рік тому +1

    Brilliant stuff as always!

  • @davidd7175
    @davidd7175 2 роки тому +1

    Thank you Reza! Late comment here, wanted to know...assuming the app maker needs a premium license to create tables in DV, do the end-users of a PA that's connected to DV require a premium license as well? They would need to CRUD data to the tables.

    • @RezaDorrani
      @RezaDorrani  2 роки тому

      End users will also need the premium license.

    • @davidd7175
      @davidd7175 2 роки тому +1

      @@RezaDorrani Figured..I'm trying to leverage DV for Teams but apparently some of the customers do not like Teams so they wanted a full fledged PA..oh well. Also, can I just say, it's awesome that you respond to questions posted to a video from months ago! Amazing

    • @RezaDorrani
      @RezaDorrani  2 роки тому

      @@davidd7175 I try my best to respond to every comment. Thanks for appreciating it :)

  • @gfonteles94
    @gfonteles94 2 роки тому +1

    Thank you for your video, very informative. But I have one question:
    I have created an app connected to a database table but when I share this app, it is requiring a premium powerapps license from my users, all my user need a premium license?

    • @RezaDorrani
      @RezaDorrani  2 роки тому

      Dataverse is a premium connector. Every user running the App will need a premium license.

  • @SHAli1474
    @SHAli1474 2 роки тому +1

    Thanks Reza
    Brilliant video

  • @SmartLearningAI
    @SmartLearningAI 11 місяців тому +1

    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  11 місяців тому

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

  • @vinaymistry8664
    @vinaymistry8664 2 роки тому +1

    Great Video, Thank you Rezza

  • @joelancaster203
    @joelancaster203 2 роки тому +1

    Brilliant Reza, I'm always learning from your content. Currently I'm trying to import tables, which are Stored procs and Views from SQL Server Database. I'm finding it tricky to build the relationships between the Tables once Imported. Is there a right procedure when importing tables using this method? Should I Create a table first and then populate it with the Stored Procedure data? Any hekp and guidance is greatly appreciated.

    • @RezaDorrani
      @RezaDorrani  2 роки тому

      I have not tried importing so not sure about this.
      I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.

    • @joelancaster203
      @joelancaster203 2 роки тому

      @@RezaDorrani thanks. It seems its a very rare process I'm not finding anyone covering it which surprises me. I'll check out your link. Maybe you could do a video of connecting and relating tables from Sql and Azure :)

    • @RezaDorrani
      @RezaDorrani  2 роки тому

      @@joelancaster203
      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 UA-cam 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.

    • @joelancaster203
      @joelancaster203 2 роки тому

      @@RezaDorrani Will do.
      I'm working through your example. At 10:30 where you are leveraging the Accounts table, when i go to add the data, Account name & Email are find but it has the Primary Contact column as a Lookup and won't let me add data in here. Do i add another column called Primary Contact and add the data in here? Is it basically showing me that Primary Contact is the Lookup value but i need to add the values in another Primary Contact Column.

    • @RezaDorrani
      @RezaDorrani  2 роки тому

      @@joelancaster203 Sorry, but I did not understand the question.

  • @zixuanfu2309
    @zixuanfu2309 2 роки тому +1

    The video is very helpful!

  • @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

  • @helenaconlon704
    @helenaconlon704 2 роки тому +1

    Great Video! I have so many ideas/solutions now

  • @michelelomonaco5118
    @michelelomonaco5118 Рік тому +1

    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 Рік тому +1

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

  • @stanTrX
    @stanTrX 3 місяці тому +1

    Powerful stuff 👍

  • @ugoangles7512
    @ugoangles7512 2 роки тому +1

    hey Reza, are this concepts applicable to virtual tables in dataverse, as well ? relate, and parent relationship property navigation?

    • @RezaDorrani
      @RezaDorrani  2 роки тому +1

      Yes, but I believe many:many is not supported with virtual tables.

    • @ugoangles7512
      @ugoangles7512 2 роки тому +1

      @@RezaDorrani thank you very much !

  • @remuslupinhp
    @remuslupinhp 3 місяці тому

    HI thanks for this video, it is superb!
    One question - I want to create a distinct list of users who have been assigned to a project. They may or may not be assigned to a task, but are still a part of the project team. Using that, how can I also create a list of people who haven't been assigned to any projects...
    Thanks

    • @RezaDorrani
      @RezaDorrani  3 місяці тому +1

      Thanks!
      I do not have a video reference on this and would have to try it out to provide guidance. I will recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com

  • @designmycity
    @designmycity 2 роки тому +1

    Amazing job. Are we still not able to save a multi selection comb box that's also a lookup column? It works in SharePoint, but not in Data verse. Thank you very much.

    • @RezaDorrani
      @RezaDorrani  2 роки тому

      There is a column of type Choices in Dataverse. Give that a try!

    • @designmycity
      @designmycity 2 роки тому

      @@RezaDorrani Thanks again for your reply. This answer below was from 2020.(from David Jennaway) "No, this is not possible in CDS. There are a few exceptions for the built-in email and appointment entities, which allow multiple lookup values for certain fields (e.g. 'to', 'requiredattendees'), but you can't do this for custom fields or entities.
      The main workaround is to create a N:N relationship between the entities, rather than a lookup (which is an N:1 relationship)"

    • @RezaDorrani
      @RezaDorrani  2 роки тому

      @@designmycity I would guess that there would be an option. Not sure since I have not tried this out. I will recommend checking on the forums at powerusers.microsoft.com/

    • @designmycity
      @designmycity 2 роки тому +1

      @@RezaDorrani Thanks.

  • @powermykola
    @powermykola 2 роки тому +2

    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 роки тому +1

      Depends on the response to this one :)

    • @powermykola
      @powermykola 2 роки тому +1

      @@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!

  • @dvillaret74
    @dvillaret74 2 роки тому +1

    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 - ua-cam.com/play/PLTyFh-qDKAiFG_FxWr-ACSmP39_84IUWl.html
      I do not have your scenario based video though.

  • @shekharshinde8647
    @shekharshinde8647 2 роки тому +1

    Awesome Video, really helpful.

  • @priyankajaiswal8835
    @priyankajaiswal8835 2 місяці тому

    I have started with Dataverse just now and this is the first video I watched. While it does show some hands on details , I was expecting to see how to first connect dataverse with my applications. Then it would have made more sense to add data manualy which by the way is not practical. You will most likely use some app to collect data and store it in dataverse

    • @RezaDorrani
      @RezaDorrani  2 місяці тому

      Which applications are you planning to connect with Dataverse?
      To bring data into Dataverse, you can use dataflows. That’s a separate topic.

  • @sam-dw3hk
    @sam-dw3hk 2 роки тому +1

    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  2 роки тому

      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 - ua-cam.com/video/8BUxeYb-SX0/v-deo.html

  • @robinjamesnjarlely
    @robinjamesnjarlely 2 роки тому +1

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

  • @sathya2870
    @sathya2870 2 роки тому +1

    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

  • @DrewSolomon
    @DrewSolomon Рік тому +1

    Thank you again for another great video! I've been scouring the internet, but can't find an intelligent way to automate the connection between two different records. My data source (dynamics 365) has a Projects table, and a People table, and there it knows which project each person is assigned to (many people, one job; but that person can also be on multiple jobs, just like your example). In my export (via a dataflow) I create these 2 tables, but it doesn't make sense for me to manually duplicate that linkage downstream. To set the lookup value I've tried looking at business data rules, setting the value via the dataflow, but I'm having no luck. I'm sure it is something stupid simple, but I feel lost.

    • @RezaDorrani
      @RezaDorrani  Рік тому +1

      I have done limited work with dataflows hence I'm not the best person to answer this question.
      I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.

    • @DrewSolomon
      @DrewSolomon Рік тому +1

      @@RezaDorrani thank you for such a speedy reply!!! and of course, for all of your top tier content!

    • @DrewSolomon
      @DrewSolomon Рік тому +1

      for anyone reading the thread, the answer I found was to use a power automate flow that runs when a new line is added to the table to update that line with the link, kind of round-a-bout, but it seems to work. (though it was a convoluted solution to get the system to allow me to set a lookup value).

  • @ganeshdasari3786
    @ganeshdasari3786 2 роки тому +1

    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.
      ua-cam.com/video/VzrarcM9W5k/v-deo.html

  • @jonathansmith6047
    @jonathansmith6047 2 роки тому +1

    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 роки тому +1

      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.

  • @DominikSZiems
    @DominikSZiems 2 роки тому +1

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

  • @minocat23
    @minocat23 2 роки тому +2

    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

  • @송나우도
    @송나우도 2 роки тому +1

    Hello Reza. I always watch videos well and click like to your UA-cam in Korea.
    I have a question. How do I insert an image into the PowerApp dataverse? I've searched and watched a lot of UA-cam videos, but I'm struggling because I haven't solved them yet. Please answer

    • @RezaDorrani
      @RezaDorrani  2 роки тому

      Thank You so much for watching and liking the videos.
      I have not done a video on Image in Dataverse. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.

  • @viniciusalvim8496
    @viniciusalvim8496 2 роки тому

    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  2 роки тому

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