Excel add in for Dataverse for Teams 

Again you saved my day Shane. Good job, as always...

Super helpful! Thank you for sharing.

Bonus Tip: You can do this with multiple users working simultaneously and see what each other is doing in real-time. Everybody doing an entry gets a colored border around their selection with their inits, so you don't step on each other. Great for doing, say, an inventory. Plus you get the opportunity to double- check it all before you publish. Coincidently, I put mine together a matter of hours before I saw this video! That'll probably never happen again - hahahahaha! Thanks, Shane and Co, for all your great work.

Great instruction! Only a day late... Love the items we work through and learn before simpler ways are available. :) Part of being on the Bleeding Edge of new technology.

Thank you for another great video

Had similar issues to you but nice to see the workarounds. Thanks for sharing!

Outstanding! Now just need to get corporate permission to get the Data Connector add-in.

Looks like good replacement option for master data services in sql(excel addin)server, specially when Internet explorer is getting decommissioned this year.

Hi Shane, great video as usual. I have learned everything I know about Dataverse from your channel. Question, can I add a column in Excel and have it update the Dataverse Table?

Thanks

In the managers lookup table you have a full name column. Did you do this with a calculated column? Did you figure out a workaround for calculated columns in dataverse for teams?! Please share if did and thanks for the great content

Thx

Hello teacher, thank you for your content. I have a question: I store a field called 'start' (date time) in Dataverse as 08/05/2024 11:38, but when I query the table where I store that field from Excel, it brings the value like this: 08-05-2024 15:38:52. Do you know what I am doing wrong? I've been searching for a while and can't find the issue. Greetings and thank you.

Got a question about access rights. If I want to allow a user of my app to use this back-door excel function, do I need to enable something in their security profile to allow them to connect? As the app owner it's explicit that I can do this, but what about a 'regular' user? Thanks!

Shane, is it possible to have the data automatically filtered based on the user? For example, display only the rows for which Im manager? Im asking to avoid having to load ALL the table rows in every single update.

Great video! Great Instructor! Quick question here. Would you recomend using Dataverse for Teams instead of SharePoint lists?

How can you update a row in Dataverse using power automate? I'm trying to create or update the data when a form is submitted.

Is there an option to automate the data push from excel to dataverse through VBA. Great video :)

Hello, Great Video!!! Is there a possibility to disconnect Excel file to get just pure imported data? (I know that you can always copy the table to another file but it is just nice to have import option).

Thanks Shane! Is this subject to the 15k Excel row or other limit?

Can we remove unwanted columns in excel like dataowner and created on?

My company has disabled access to the Office Store. Is it possible to get the add-in in another way or even just to find out the name of this add-in?

by the way you digitized your files later in the video but they are all visible early on ;-) #SpasiboComradShane ;-)

Don't tell your friends with access (benefits?) see this otherwise they will bulk access your data behind your back and behind your app ;-) ... Time for a PowerApps Etiquette Class? :p Thank you SHANE! Regards to Boss Chewy