New Dataverse Table Options + Virtual Tables
HTML-код
- Опубликовано: 2 авг 2024
- #powerapps #PowerPlatform #CanvasApps #ModelDriven
In this tutorial, you will delve deep into the new interface for Dataverse tables in Power Apps. Shane walks you through the process of creating tables using different methods including using Copilot, from blank, and even creating virtual tables, a topic not discussed before. Learn how to create tables using words with the help of Copilot, and how to manipulate and work with the interface to get the desired results. Shane also touches upon the process of creating tables using Excel files and highlights the new features and functionalities in the updated interface. Whether you are looking to create a standard, activity, virtual, or elastic table, this tutorial guides you on how to set advanced properties and make the most out of the Dataverse tables in Power Apps.
Up your Power Apps Skills Today!
Link: www.powerapps911.com/up-your-...
0:00 Dataverse Tables
1:03 Describe the new table with Copilot
5:14 It is a normal table
6:16 Upload an Excel file
9:40 Start with a blank table
11:12 Create a virtual table
15:36 Advanced Properties and other notes
Need some help on something you are working on, contact us!
www.powerapps911.com/contact
PowerApps911
www.powerapps911.com/
Let's connect on social!
Twitter: / shanescows
Facebook: / powerapps911
Instagram: / shaneyoung911
LinkedIn: / cincyshane Наука
I'd really like an in-depth video on Virtual tables, especially with Sql server, sql views, update strategies, relationships etc
Noted. Thanks 😎
Me: Hey Copilot! Create me neuralnetwork based applicaton for a game called Battleships.
Copilot: Got you! ... processing ... processing ... Loading... Skynet is booting. Neuralnetwork for Battleships ready for combat.
Me: 😦 Oh oh ...no no no no nooo! sh*t! sh*t! sh*t! ☠
hehe :) great video Shane! thank you for all of the effort you putin in those videos. you have no idea how much i am learning from you. especially your powershell videos i'm currently on. keep it up! 🤘
🤣 Thanks
Thank you Shane for the in-depth knowledge shared on dataverse table
Happy to help. New Dataverse video today ruclips.net/video/UJ2jwOC_TkY/видео.html
Thank you so much! I love your videos!! Can you make a video explaining how to make a dataverse table from a sharepoint folder?? So we can add excel files in the folder and it will update the dataverse table by joining the files??
Great suggestion! In the meantime check out this video. ruclips.net/video/MhFNwjaR10A/видео.html I think it should give you most of the mechanics you need. You could skip the step where I upload from Power Apps and then where i update SharePoint, you would update Dataverse.
Dataverse with Canvas app is pretty awesome!!
Agree, I even did Dataverse and Power Apps again today ruclips.net/video/UJ2jwOC_TkY/видео.html
Hi Shane, Thank you for the video, do you have any idea to implement the Dataverse Virtual Table ALM?
excellent video... I had the same problem on virtual table set up of Business Central
Mark I canned some of the more complex columns, in my case the Lookup column, and it finally worked for me.
That’s cool!
Yeah, and they keep adding more. Very fun
Hi Shane. Thanks as always 💥💥. Great Vid. A suggestion for a new video ... We have blocked Co-pilot due to Microsoft "cannot accurately tell us what is processed outside of the UK". This is OK for your Chewy data, but for sensitive company data this is a problem. Are you able to to a video on the "Security" side of Co-pilot? Where is the "intelligence" actually doing the processing? Cheers 🍻🍻
I don't have any of that info but I will ask around at Microsoft and see if they are willing to share it or talk about it. Thanks for the idea.
Hi Shane, Thank you for the video! Did you ever figure out what was causing the error in virtual table? I have the same error but with virtual table from bc
I did not. I don't think I have any "real" apps using Virtual Tables, so I never had to worry about it. I kind of rememeber someone else leaving a comment about the issue but not sure. Might be worth rolling through them and see if anything helps. Sorry I don't have more.
@shane, Did you determine what was breaking the virtual table @ the 15 minute mark "Something..." [purple plug]. I am having the same problem with any SQL virtual table I add to dataverse. SQL and Canvas work just fine. However, virtual table in dataverse is a no go regardless of int, GUID or text primary keys.
I haven't Andrew, I don't have any customers doing virtual SQL tables so I haven't had to fight it yet. :( Sorry
Love your channel! New at PowerApps but familiar with SQL. I just learned that you can create a formula column in Dataverse, and would like to create a ranking column but can't find the equivalent of SQL's row_number() and rank() functions. Do you have a video on this? Is it even doable in any way at the Dataverse table level rather than at the PoweApp level? Cheers
I don't have anything yet, that is a rabbit hole I need to go down but just haven't had time yet. Hopefully soon. I am going to pass this comment on to someone who might be able to help. 😊
Can you help with updating a MySQL table from a check box true in a gallery from clicking a button
What part are you struggling with? I would most likely be using a Patch(datasource, Record, {Column: "They checked Yes"}) Or something like that.
Or is being in the gallery? Check out this video for selecting multiple items. ruclips.net/video/0xZ4fMJbLvk/видео.html I think it will help with the 💡
Hi @shaneCows is it possible to integrate ChatGPT into a Power App Application? If so, a video on how would be great. Thank you.
hey Shane, great video. any idea how to best configure virtual tables between environments? ex. a virtual table that's connected to a DEV SQL DB, moving to a QA environment that's connected to an identical dataverse virtual table that's pointed to a QA SQL DB?
Yikes, I haven't tried that one yet. Sorry
@@ShanesCows no worries, I figured it out! You can edit the virtual data source config in the solution in the classic view. It allows you to change the server and database connection. I broke out my tables into a separate solution so I didn't overwrite it every time I did a new solution push. hopefully MS will update this experience in the future to support ALM with the new virtual tables experience because this wasn't very straight forward/easy.
Hi Shane, could you please help? I’m gettin this error when try to save powerapps: Didn’t save
There was a problem saving to PowerApps
How are you saving? Not enough info to help
Do you know if virtual tables are available in Teams?
I don't know, sorry
Shane, do you know what the refresh rate is with SQL virtual tables❓
I’d love to have a virtual table that performed immediate updates
I think it is pretty instant but not 100% sure.
Can you display the data in a virtual table in a Power Apps Gallery?
Yes, everywhere you use the table, like in a Canvas app, it doesn't know any different that it isn't a normal DV table. :)
Hey Shane, is there a way to adjust the number of rows that can be displayed in a dataverse table? Currently I am only seeing 100 and unable to browse and see all the data.
Where are you only seeing 100 rows?
@@ShanesCows Hey Shane, I am only seeing 100 rows in any of my dataverse tables that have more than 100 rows. I cant scroll past it and I am not seeing any setting to change to increase the row count. Thanks a mil.
Hi there, does anyone use a dataverse tb in a professional project? Apart from my ignorance, it sounds so annoying and burocratic process..
It is becoming a lot more common. It is different for sure but once you get used to it, Dataverse has a lot of cool features.
Everything and nothing! Sorry Shane but it was very basic!
It is very basic, but that was kind of the point. Trying to get people comfortable with the basics. 😊 What is possible.