Love this Reza, thank you! I've recently switched to dataverse for security requirement by business owner. Hope you can share more tips and tricks for dataverse in the future!
Unbelievably good timing. I could hardly believe my eyes when I saw this in my feed. I got stuck with those pesky relationship columns but now I can move a business critical app from Sharepoint to Dataverse, as needed for scalability and security roles. Many thanks. 😊
Having imported my tables into Dataverse can I now use a Dataflow to update the Owning Business Unit on different sets of records in various tables? I need this separation for record access control.
Always on point with your tutorial videos and this is yet another one. Handling complex columns within dataflows has been a bit of a challenge so seeing how the keys are set was very refreshing. I know I will come back to this video again for future project but having seen that is done is very refreshing. Had to pause me holidays for about 30 min to watch Reza's video but it was worth it. 🤣🤣
Thank you so much, Reza! This is a superb video, meticulously laid out to explain this important process effectively, highlighting the critical points that other UA-camrs fail to convey clearly. I especially appreciate how you pivoted between the data flow back to the table build to convey the challenging issues of keys. I do have a question: Because of my work environment, I am forced to use Dataverse in Teams. It seems that Dataverse in Teams does not routinely allow the creation of new keys in tables. Is there way to do this that I’m missing?
Thanks so much for the feedback. Very happy to hear the appreciation. Dataverse for Teams is very limited and something that I have not worked on for years. Not sure of what options or limitations are available there.
Thanks Reza! Is there a video that speaks about end to end process of a canvas app or model driven app like creating the app in dev env and then UAT pushing it to production?
Hi Reza! Your tutorials are amazing and I learn a lot from them! Can you please help on how we can transfer to dataverse in below situation 1. If there are multiple users added to SharePoint people picker field. 2. If there are multiple files attached to a SharePoint item.
Most welcome! 1 - there is no multi select field. You will have to create a related table to add users for an item. Not something I have tried. 2 - same as above with file type column
Hi Reza, great work as usual! Can you by chance share a link to that comparison table between Dataverse and SharePoint you presented at the beginning of the video?
Very informative, thanks Reza! Question, if this was a very large SharePoint list (say 900,000+ items), would doing this be beneficial? How long would the import take?
As always a BIG thumbs up 👍👍 You covered most column types, but what about attachments? ie If you have an app which relies on attachments, would you still use Dataverse or stick to SharePoint? If you use Dataverse, but use SharePoint as the location for the attachments, do you then hit the SharePoint limitations? 💥💥
Hi Reza, nice content! I have a little confusion about when to choose a SharePoint list or Dataverse. SharePoint is cost-effective compared to Dataverse, especially when it comes to handling multiple attachments in a large organization. can you explain this please ?
Price is going to be a factor. Dataverse offers a lot more flexibility in various regards. Not something I could list out here. There are 100s of reasons.
Thanks Raza for such a wonderful video it's really helpful for people like us who works on the Powerapp everyday. I m looking for your support to get solution on one instance where I need to check how many answers are submitted in another SP list vs questionnaire list.. I strongly believe that I will get some solution on this from your end
Most welcome! I have not done a video on the question answer scenario mentioned. I recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
Rezza, sorry I haven't watched the video yet but do you cover Multi select choice column in this video? This is a major issue when doing these sorts of migrations from SP lists to dataverse as power query has a challenge with choices columns. Thanks
I have kept this video at beginner - intermediate level. I would call it a major issue. I have not explored multi-select option but I’m sure there would be ways to achieve it. I recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
Although it gets the job done, Microsoft needs to improve the lookup process and migration into a simpler visual wizard. This should be much simpler todo.
Do you know if the "Create with SharePoint List" option is available to Government clients? I do not see that option in my environment and I am not sure if this is a permissions/licensing issue, or if it is unavailable to Government. Thanks in advance for the help!
All my formulas work in sharepoint, now i am experimenting and migrating to dataverse. But have an issue with choice columns showing question mark when trying to create collection. I do not want to explicitly select the value in my formula as there are quite a few choice columns each having multiple values. Where choice column.value works in sharepoint. It doesnt work in dataverse. Any solution or video on it?
Choice col . Value should work in dataverse as well unless your trying to do something specific which I am probably not understanding. I will recommend checking or posting your issue on forums in case someone has experienced something similar community.powerplatform.com/
Hi Reza - fantastic content as always! I tried creating a table with a SharePoint list, in my case only 20 rows got migrated. I tried 2 other tables (the SP lists have like 5000+ rows). Is this how the preview feature works - they have limited the data that is migrated?
I tried it with a large list and it worked fine. I don’t think there is a 20 row limit. 20 rows are only shown in preview screen but when you import, it will bring in all the data. I mentioned it in video as well.
@@RezaDorrani thanks for the response, is there a way we can mention a publisher name (Dataverse solution publisher) for the table and fields while dping the mapping, as right now all are created with cr15e publisher?
@@RezaDorrani Interestingly,I set my solution as preferred solution and from inside this solution itself I clicked on Import data for the table and performed all the steps of selecting the sharepoint site, list, columns, mapping etc. I noticed the dataflow gets created outside the solution and all the table and column schema still has the default publisher.. It looks like the preferred solution publisher is not honoured in this case. :) Thank you for the quick response Reza!!
@@anweshasharma6868 First create your table and schema in Dataverse- those will go to preferred solution. Note: preferred solution and solution by default - both features need to be turned on. I will recommend you check the documentation
This is great, thanks again. Do we still need pro licences to use dataverse tables? I noticed if I create tables within a solution I can use them in a canvas app, with no sign of premium/pro requirements. But I haven't fully tested. Anyway, great content as always. I appreciate it!
Check the comparison deck shown in video. There is a line item on licensing. A premium license is needed. You may be using a developer type environment or may have trial license assigned.
@@RezaDorrani ah cheers man, totally missed that line. Must be a trial licence. I know what to look for now though. At least I know about this when the time comes, where all my groveling comes to fruition and we get pro licences 😂
Hi Reza, In my project i got a situation to update a incident number to 4950 records when a new incident created. How can i update this large count with PowerApps or power automate? can you please let me know or suggest some video of yours?
I do not have a video reference on this scenario. I recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
@RezaDorrani, How to retain meta data column values (Created By, Created, Modified By, Modified) from SharePoint List to Dataverse Table during the import as this data is very important for business. Looking for your quick response. Thanks.
Hi Reza, i am preparing my data in sharepoint list before I can connect data to power app.. some rows were deleted during the test phase. Now i have another list with more accurate data but would like to copy it to existing site where rows were deleted.. using power automate is not updating or adding data as its looking for unique ID whixh has been deleted.. please assist. Thanks
I do not have a video reference on this scenario and would have to try it out to provide guidance. I recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
Thanks Reza, got this working but now i have another issue.. i have a screen for o365 users.. but performance is slow when scrolling through or searching.. so thought of segregate between alphabets and using next and previous buttons.. but next button never works neither i can go beyond a set of users due to limitation onVisible.. 🤔
Hi Rezza, Thank you for the informative video. I would like to request a tutorial on building an API in Power Apps. This API would enable other web applications, built using technologies such as React or Angular, to consume data from Power Apps. Is this possible?
I make videos when I receive multiple requests on a topic. Every 6 months I ask subscribers for topic suggestions on Community Tab of my channel. Most voted idea gets added to my backlog. Make sure to post this idea whenever I post the next topic suggestion post.
We have a popular SharePoint based Enterprise app and we run into the relationship and performance issues and Term Store limitations in canvas apps but the Dataverse app licensing would kill our business if we forced the adoption of dataverse at current prices.
Price is for enterprise grade scalability, performance and security and many other features. The premium license requirement for Dataverse is since day 1.
@@LaurenBolin I do not have a reference or resource for it. I will recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
Please do a tutorial for a simple workplace visitor registration app for a company with multiple site locations. This app provides a simple method for employees to check in quickly and check out visitors/maintenance contractors at their office sites from their phones. The data is collated for the security team and added to a SharePoint list to track/log basic visitor information across all sites and create reports for this. It could be from a power page on a SharePoint portal used on a phone or from a SharePoint page. Home screen registration details, e.g., company employee list of names, site locations, visitor/contractor name, visitor/contractor company name, email, phone, reason for visit, check-in date/time, optional upload doc or photo. A free text comments field, search bar to look up, and check out date/time.
Thanks for sharing the requirements in detail 😊 My rules for making videos is set - “I make videos when I receive multiple requests on a topic. Every 6 months I ask subscribers for topic suggestions on Community Tab of my channel. Most voted idea gets added to my backlog. Make sure to post this idea whenever I post the next topic suggestion post.”
Hello reza, thank you for everything. please can you help me. I have my power apps application which is connected to a sharepoint source. I would likea user who connects to the application having rights to the application but not to the data source to be able to write to this source using another account which has rights to the application and the source of data svp
Great, but why don't you stress right at the start the EACH USER needs a premium license? The cost will explode if you migrate an app used by hundreds/thousands of users...
Fully Informative Reza. Thank You!!
Most welcome
Very helpful video. Bringing those complex columns to dataverse was a long time challenge for me. Thank you for shading the light.
You're very welcome!
Love this Reza, thank you! I've recently switched to dataverse for security requirement by business owner. Hope you can share more tips and tricks for dataverse in the future!
ua-cam.com/play/PLTyFh-qDKAiHr7HwkvlHXpCNf73xNBqj_.html
Unbelievably good timing. I could hardly believe my eyes when I saw this in my feed. I got stuck with those pesky relationship columns but now I can move a business critical app from Sharepoint to Dataverse, as needed for scalability and security roles. Many thanks. 😊
Awesome!!!
Having imported my tables into Dataverse can I now use a Dataflow to update the Owning Business Unit on different sets of records in various tables? I need this separation for record access control.
@@andrewgrant9782 This is something I am investigating and learning about myself. Currently not sure about this.
Great video Reza, the only thing I see, is that the users need a premium license and this would be a challenge for the business, thanks 🙏
All those capabilities is what you get with a premium license. It's a value decision.
Or a per app licence for a small cost per month
Always on point with your tutorial videos and this is yet another one. Handling complex columns within dataflows has been a bit of a challenge so seeing how the keys are set was very refreshing. I know I will come back to this video again for future project but having seen that is done is very refreshing. Had to pause me holidays for about 30 min to watch Reza's video but it was worth it. 🤣🤣
Great to hear!
Thank you so much, Reza! This is a superb video, meticulously laid out to explain this important process effectively, highlighting the critical points that other UA-camrs fail to convey clearly. I especially appreciate how you pivoted between the data flow back to the table build to convey the challenging issues of keys.
I do have a question: Because of my work environment, I am forced to use Dataverse in Teams. It seems that Dataverse in Teams does not routinely allow the creation of new keys in tables. Is there way to do this that I’m missing?
Thanks so much for the feedback. Very happy to hear the appreciation.
Dataverse for Teams is very limited and something that I have not worked on for years. Not sure of what options or limitations are available there.
it tooks my whole day to learn just how to transform splist into dataverse with lookup field
Hope this video helped
Very nice Reza, appreciate sharing the good knowledge always!
My pleasure!
Thank you so much Reza for sharing this wonderful video
Most welcome
Thanks Reza! Is there a video that speaks about end to end process of a canvas app or model driven app like creating the app in dev env and then UAT pushing it to production?
ua-cam.com/video/pp6wBvy9Wgs/v-deo.html + my ALM videos
Hi Reza! Your tutorials are amazing and I learn a lot from them! Can you please help on how we can transfer to dataverse in below situation
1. If there are multiple users added to SharePoint people picker field.
2. If there are multiple files attached to a SharePoint item.
Most welcome!
1 - there is no multi select field. You will have to create a related table to add users for an item. Not something I have tried.
2 - same as above with file type column
Hi Reza, great work as usual! Can you by chance share a link to that comparison table between Dataverse and SharePoint you presented at the beginning of the video?
I shared that with channel members
Very informative, thanks Reza! Question, if this was a very large SharePoint list (say 900,000+ items), would doing this be beneficial? How long would the import take?
I have not tested timing for how long that would take. My guess would be a few hours.
As always a BIG thumbs up 👍👍 You covered most column types, but what about attachments? ie If you have an app which relies on attachments, would you still use Dataverse or stick to SharePoint? If you use Dataverse, but use SharePoint as the location for the attachments, do you then hit the SharePoint limitations? 💥💥
Most welcome!
For attachments, you can create a separate table which includes column of type File and relate it with your main table.
Very helpful video Reza. Is there an option to generate the app as Model Driven or Canvas only?
I show both in the video. You can build either or both.
Hi Reza, nice content! I have a little confusion about when to choose a SharePoint list or Dataverse. SharePoint is cost-effective compared to Dataverse, especially when it comes to handling multiple attachments in a large organization. can you explain this please ?
Price is going to be a factor. Dataverse offers a lot more flexibility in various regards. Not something I could list out here. There are 100s of reasons.
Incredible Thank you Reza🥰
You’re welcome
Thanks Raza for such a wonderful video it's really helpful for people like us who works on the Powerapp everyday. I m looking for your support to get solution on one instance where I need to check how many answers are submitted in another SP list vs questionnaire list.. I strongly believe that I will get some solution on this from your end
Most welcome!
I have not done a video on the question answer scenario mentioned. I recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
Very helpful, thank you!
Glad it was helpful!
Great video, Reza! One question, would this work also with SharePoint libraries?
I don’t think so
Hi Reza. If I add data to sharepoint list after creating table from it, Will the table be updated with new data?
No - unless you run the dataflow again and add additional logic to only map the updated info
Rezza, sorry I haven't watched the video yet but do you cover Multi select choice column in this video? This is a major issue when doing these sorts of migrations from SP lists to dataverse as power query has a challenge with choices columns. Thanks
I have kept this video at beginner - intermediate level.
I would call it a major issue. I have not explored multi-select option but I’m sure there would be ways to achieve it.
I recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
Although it gets the job done, Microsoft needs to improve the lookup process and migration into a simpler visual wizard. This should be much simpler todo.
This is a v1. There is a lot more coming.
Do you know if the "Create with SharePoint List" option is available to Government clients? I do not see that option in my environment and I am not sure if this is a permissions/licensing issue, or if it is unavailable to Government. Thanks in advance for the help!
Im not sure about its availability in Gov tenants.
@@RezaDorrani Thanks for the quick response!
All my formulas work in sharepoint, now i am experimenting and migrating to dataverse. But have an issue with choice columns showing question mark when trying to create collection. I do not want to explicitly select the value in my formula as there are quite a few choice columns each having multiple values. Where choice column.value works in sharepoint. It doesnt work in dataverse. Any solution or video on it?
Choice col . Value should work in dataverse as well unless your trying to do something specific which I am probably not understanding.
I will recommend checking or posting your issue on forums in case someone has experienced something similar
community.powerplatform.com/
Hi Reza - fantastic content as always! I tried creating a table with a SharePoint list, in my case only 20 rows got migrated. I tried 2 other tables (the SP lists have like 5000+ rows). Is this how the preview feature works - they have limited the data that is migrated?
I tried it with a large list and it worked fine. I don’t think there is a 20 row limit.
20 rows are only shown in preview screen but when you import, it will bring in all the data. I mentioned it in video as well.
@@RezaDorrani thanks for the response, is there a way we can mention a publisher name (Dataverse solution publisher) for the table and fields while dping the mapping, as right now all are created with cr15e publisher?
@@anweshasharma6868 If you set a preferred solution, all info will be stored in that solution.
Check
ua-cam.com/video/pp6wBvy9Wgs/v-deo.html
@@RezaDorrani Interestingly,I set my solution as preferred solution and from inside this solution itself I clicked on Import data for the table and performed all the steps of selecting the sharepoint site, list, columns, mapping etc. I noticed the dataflow gets created outside the solution and all the table and column schema still has the default publisher.. It looks like the preferred solution publisher is not honoured in this case. :) Thank you for the quick response Reza!!
@@anweshasharma6868 First create your table and schema in Dataverse- those will go to preferred solution. Note: preferred solution and solution by default - both features need to be turned on. I will recommend you check the documentation
Great 👏👏👏👏
Thanks
This is great, thanks again. Do we still need pro licences to use dataverse tables? I noticed if I create tables within a solution I can use them in a canvas app, with no sign of premium/pro requirements. But I haven't fully tested. Anyway, great content as always. I appreciate it!
Check the comparison deck shown in video.
There is a line item on licensing.
A premium license is needed.
You may be using a developer type environment or may have trial license assigned.
@@RezaDorrani ah cheers man, totally missed that line. Must be a trial licence. I know what to look for now though. At least I know about this when the time comes, where all my groveling comes to fruition and we get pro licences 😂
Hi Reza,
In my project i got a situation to update a incident number to 4950 records when a new incident created.
How can i update this large count with PowerApps or power automate?
can you please let me know or suggest some video of yours?
I do not have a video reference on this scenario. I recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
Hello Reja.. I have a multi choice column,each item have individual approvers how to send approval notification to individual users
ua-cam.com/video/UE2U2NnmBUI/v-deo.htmlsi=aePYjnSJgS3nPnY8
@RezaDorrani, How to retain meta data column values (Created By, Created, Modified By, Modified) from SharePoint List to Dataverse Table during the import as this data is very important for business. Looking for your quick response. Thanks.
Those details will change as data flow runs under a dedicated account. I believe additional work would be needed (not something I have thought about)
Hi Reza, i am preparing my data in sharepoint list before I can connect data to power app.. some rows were deleted during the test phase. Now i have another list with more accurate data but would like to copy it to existing site where rows were deleted.. using power automate is not updating or adding data as its looking for unique ID whixh has been deleted.. please assist. Thanks
I do not have a video reference on this scenario and would have to try it out to provide guidance. I recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
Thanks Reza, got this working but now i have another issue.. i have a screen for o365 users.. but performance is slow when scrolling through or searching.. so thought of segregate between alphabets and using next and previous buttons.. but next button never works neither i can go beyond a set of users due to limitation onVisible.. 🤔
@@sweetfragrance6890 I would suggest posting your issue on forums
What about multi selection of users in table?
Not something I have tried
Hi Rezza, Thank you for the informative video. I would like to request a tutorial on building an API in Power Apps. This API would enable other web applications, built using technologies such as React or Angular, to consume data from Power Apps. Is this possible?
I make videos when I receive multiple requests on a topic. Every 6 months I ask subscribers for topic suggestions on Community Tab of my channel. Most voted idea gets added to my backlog. Make sure to post this idea whenever I post the next topic suggestion post.
We have a popular SharePoint based Enterprise app and we run into the relationship and performance issues and Term Store limitations in canvas apps but the Dataverse app licensing would kill our business if we forced the adoption of dataverse at current prices.
Price is for enterprise grade scalability, performance and security and many other features. The premium license requirement for Dataverse is since day 1.
Thank you Reza
Welcome!
Thanks!
Thank You!
How to move the attachment file to dataverse table either?
You would need to write a flow for that. There is no option out of the box.
Can you do Something like this to transfer over attachments?
Attachments is currently not supported. You could build a flow to get list item attachments and uploaded them to Dataverse.
@@RezaDorrani I have been working on building a flow but have not been successful. Do you know any resources I could look at?
@@LaurenBolin I do not have a reference or resource for it. I will recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
Please do a tutorial for a simple workplace visitor registration app for a company with multiple site locations. This app provides a simple method for employees to check in quickly and check out visitors/maintenance contractors at their office sites from their phones. The data is collated for the security team and added to a SharePoint list to track/log basic visitor information across all sites and create reports for this. It could be from a power page on a SharePoint portal used on a phone or from a SharePoint page. Home screen registration details, e.g., company employee list of names, site locations, visitor/contractor name, visitor/contractor company name, email, phone, reason for visit, check-in date/time, optional upload doc or photo. A free text comments field, search bar to look up, and check out date/time.
Thanks for sharing the requirements in detail 😊
My rules for making videos is set - “I make videos when I receive multiple requests on a topic. Every 6 months I ask subscribers for topic suggestions on Community Tab of my channel. Most voted idea gets added to my backlog. Make sure to post this idea whenever I post the next topic suggestion post.”
Is this same as virtual table?
No because here the data will be imported into Dataverse
Hello reza, thank you for everything. please can you help me. I have my power apps application which is connected to a sharepoint source. I would likea user who connects to the application having rights to the application but not to the data source to be able to write to this source using another account which has rights to the application and the source of data svp
User must have access to list in order to work with data in power apps. Power Apps respects SharePoint security
@@RezaDorrani ok, so i can't create a flow in such a way that person y to write in the list
@@ahoumauricettelaurearmellekoua I did not understand your question
@@RezaDorrani I would like to send a feed to answer my problem
@@RezaDorrani flow of power automate
Great, but why don't you stress right at the start the EACH USER needs a premium license? The cost will explode if you migrate an app used by hundreds/thousands of users...
Dataverse is a premium feature.
I dont have to mention that in every Dataverse video I make. I have done so in my earlier videos.
@@RezaDorrani Thanks, you’re right. And big thanks for all the great videos 🙂
The video quality is a bit poor.
Check your network bandwidth.
No.
?
@@RezaDorrani just responding to the title. I will not be transforming our data to Data verse. 😁
@@JohnHall Title does not say you have to 😆