Connect with me: ☕ Buy me a coffee: www.buymeacoffee.com/lisacrosbie 🦉 Learn more about AI: aka.ms/learnwithlisa 🖇 LinkedIn: www.linkedin.com/in/lisa-crosbie/ 📼 TikTok: www.tiktok.com/@lisa.crosbie 🐦 X (Twitter): twitter.com/LisaCrosbie 📚Take my LinkedIn Learning Course: Microsoft Power Platform Fundamentals (PL-900) Exam: Power Apps www.linkedin.com/learning/microsoft-power-platform-fundamentals-pl-900-cert-prep-power-apps/

Hi Lisa, I have checked multiple MVP's about this particular topic (turning an Excel sheet into PowerApps) and I would like to compliment you on your work. I could 't really understand and get this technique into practice AND understand every step and reasonings, but your extensive way of explaining this concept and every little step taken into account, really helped me to understand everything. You really stand out and I really appreciate it and like it that you take the time to help us understand. Just wanted to give you my sincere compliments I am so happy I dropped by your channel, because it helped me to reproduce it in my own environment AND understand the concept behind it. Thank you for helping us to get better! You rock! You made it look easy for me now (and I was struggling)!

You teach so well and the excitement in your voice makes the learning experience interesting. Thank you.

Oh My. I've struggled for 2 weeks with this. Raised a request with Microsoft...told me that my import was wrong. Contacted old friends at Microsoft that showed me a convoluted method of exporting then merging then reimporting the data to get it to link. Your amazing because spending the time watching this free video resolved it ALL for me. Thank you so much! Learning from Lisa - This is the way!

There's so much happening in the MS stack at the moment, thanks for all your work making it accessible to the rest of us.

When I'm searching for a topic I click on your video first. LOVE all your content.

Amazing content getting to where I want to go with my data transformation but still have to watch more of your content. Thank you!

From one Functional to another; you explain this very well Lisa - whilst avoiding mentioning CRM or ALM explicitly. 😉 As an old timer, who is habitually used to reaching for the legacy CRM designer experience, this is really helpful. Love the idea of having the choice of a canvas or a model-driven app based on the same tables in Dataverse. Incidentally, for readers of Lisa's comments: These apps can be consumed via a web page, a mobile device or a power apps SharePoint web part.

You are a great presenter Lisa. I'm totally new to this universe so I have a lot of learning to do about use cases and how to do things properly. I appreciate your energy and style-thanks very much.

Hello Lisa, Thank you for such a nice tutorial. I had no experience with Powerapps but i have completed a vulnerability tracking app assigned by my organization. Love your work and really really appreciate.

Thank you so much for this training. I've been trying to wrap my mind around this with more real life examples and this helped tremendously. Also, I love your teaching style and your ability to communicate clearly. Thank you for that. I'm looking forward to watching your longer video as soon as I have a chance.

Love the Lego collection in the background!

Thank you so much for this video Lisa. I've done the self paced online training but got really stuck with importing choice columns and specifying the correct column for lookup. This is just what I needed! Really amazing 👏

You are amazing. Thank you

Thank you for the clear explanation Lisa, this was a great video to get some more insight on how this applications work in the back-end side. I work with CRM, and now I have a better idea on how some aspects of the application are developed. Thank you :)

Thanks for the intro...looking to move away from MS Access so this gave me some hope :)

Great explanation Lisa, this will be invaluable for me in my role. I have no hesitation in subscribing to your channel and look forward to exploring more of your presentations. You have a great presentation/training style that's easy to follow. Thank you.

Great video, Lisa! Thanks so much for sharing your knowledge.

This was very helpful and informative. This helps me a lot since I have come from a world of Microsoft Access and InfoPath. I would be interested in seeing how to apply a multi-tiered membership database to these scenarios.

Thank you so much for breaking this down for me!!!!

Very helpful. thank you.

I'm a big fan of your YT courses. You explain them so well..!! One query - I have an excel with more than 200K data rows. And when followed your process to convert the excel to app, I'm not getting all the data. Is their any data/size restriction? If yes, what is the best way to import such a big file to the app and update the same frequently (weekly)??

If you're importing a static CSV does that not mean that you will just end up back in the spreadsheets every time you need to add a new customer? Would it not just be better to link this to a system such as Dynamics presumably allowing it to update live? Apologies for the ignorance this is only the second video I have seen on PowerApps so I am brand new to this whole thing. Up until a week ago Excel was as much as I knew (no Access, Power BI, Automate or Apps but i'm trying to learn fast so I can apply this to the real world). Ps. Thank you for all of the knowledge you provide. Trainers like you will help make the world a more efficient place to live in, so more time for that beverage of choice you referred to! Subscribed :)

I left the corporate world 10 years ago so apologies if I’m missing something. This just seems like an over the top way of making an Access database.

thanks, great explainer/explanation

Thank you for the video. After many errors, I think I have a rough understanding of the process. I am confused about how to send this to my team for them to use the new app.

Awesome content! Just subscribed!

Hi Lisa, First I need to thank you very much for sharing ample of knowledge on dynamic platform. I have one query, can we upload multiple excels with same columns and create canvas app? Early waiting for reply🙄

Hi, thank you for your help on this! I am (trying) to build a workbook that will help small business owners. Once completed, I intend to sell it, but it seems I have no clue on how to correctly protect that workbook, as there are many apps that will crack the code! Would you have any advice on that? Thank you

great work thanks!

Great video Lisa! I created the excel files and followed it all the way through. I ran into a problem when I tried to remove the Customer ID field from the Contract Renewal table. It said I couldn't because it had dependencies. Fair enough. I then tried to delete the dependencies, but these were system created Views, and the system won't allow me to delete them. Any ideas?

is there a way to add multiple filters for the user to use so they can better find customers rather than just search? State, zip code, type.

You are lovely ! thanks

Hi Lisa, Thank you for this detailed and concise tutorial. Love the shortcut feature to create an Dataverse table from an Excel file. However is there a way to specify a publisher so that the column prefixes can be predefined like "lc_" instead of arbitrary?

Hi , I liked watching your video and wanted to share a use case with you where user would like excel like experience in the app when they are editing the records that is bulk edit of multiple records in one screen instead of going into individual form and editing each record one by one .

Great video, but... when you bring your table created from the Excel into the solution, it still has the default solutions prefix (cr36c_), is it possible to use the Excel file to create the table within the solution so it gets your publishers prefix (lc_ in your case) or can you update the publisher some other way. See 20:50 of the video.

Got inspired, so thanks for a great explanation. I have a business critical excel file to keep an eye on Patent renewal and associated cost - Those patents are often liked to Account projects / Opportunities descried in Microsoft Dynamics. Any tutorials on how to link an Excel and Dynamics info into a more useful app?

thanks Lisa, watching many of these and a udemy and pl100 scheduled soon pl900 done last week. unsure i can do in the work place but ill do the odd app for my company. never know on the future. it all helps

Hey, does it only works with first 20 rows? What if we want to add large data?

Hi I'm new to Power apps I'm currently automatting some process in my org. Can u help me with below senario I wanted to collect feedbacks for multiple persons in a single go. Eg. In your video you have name feild but with only 1 input what i wanted is to user can be able to input 8 names at a time and same for other fields. And save each as a seperate records

I want to use an app like this for my insurance business. Currently I use a worksheet with several different tabs- client details, home details, auto details, etc. I also have a sheet that lists all of the client information with a header and one row because I knew eventually I was going to need to step up my game. After watching this, it would seem that instead of trying to import a csv with over 70 columns (or data fields if you will), I need to break out the related information into their own separate csv files, right? If so, what would be the process of adding a new client's information? Start at the contact tab and create button links for the other tables? Is something like that detailed in your longer video?

I've followed along as exactly as I can, but in the final result, I am getting the customer ID showing up linked instead of the customer name. Am I making a common mistake? Is it because I have Customer ID as the primary column for my Contact table? Wondering if there's a quick fix or if you would mind creating a video explaining why this is happening. Thanks for the video, Lisa!

What app would I use if I want to consistently analyze excel reports that have changing values monthly?

You are just amazing Lisa. The way you present, speak and demo is just simply so easy to understand. 🤩

Great - now how do we deploy and share these apps??

Great presentation Lisa as always! Is it necessary to have Power Apps licence plan or you can use it with a simple business premium or basic licence?

Excellent presentation.

Hi Lisa, thanks for the video. How much more complicated is this process if it is scaled up? For example, if there were more tables with more complicated database design? I'm a little confused on how I would use the logic here on 11 related tables. Should I create all the empty tables with the alternate keys and then upload the csv filed in hierarchy?

Lisa… nice video… but can we make apps in microsoft teams, where my team member can input data, using form, store data in excel (only the owner has access to this), but all of member can look at the data. And edit if necesarry. Thank you

Would you recommend moving from Access to Dataverse? If so, how are keys and foreign keys maintained.

I'm new to this, and I'm trying to learn how to create an app to a couple of specific things with my work. It seems that PowerApp creation is like the second (or third) generation from the old Access database. Am I correct? The terminology (keys, relationships, tables etc) are all very similar and even though I'm new to it, it is chiming with me from years and years ago trying to get to grips with Access

What if I want to make the app dynamic because I am adding things to the spreadsheet do i use power automate?

AMerica....we got the dates right!

Off topic but I prefer your accent over my US accent. :)

Hi Lisa, nice to see an Aussie doing a presentation. I have a quick question. When I load my spreadsheet it does not recognize my columns as choice, my column has a lot of entries in the dropdown list, to many to add individually. Is there a fix or work around please?

I want to learn this any guard on how to play with it on my own? Things like to setup account and follow the instructions. Now only watch the video like I am watching Netflix

Tried to insert my Excel, but it is a bit harder than I thought. It does not recognize the time format and it just chooses a column as a primary key which I do not want. A bit annoying.

Hi Lisa, thanks for this video. I tried following these steps, however there are a few columns in my excel file which I want to use as Choices or Dropdowns. However, Dataverse is not recognizing those columns as Choices. How can I resolve this?

Great presentation. Are there any elements of what you have shown here that you don't get with Dataverse for Teams? (=included in E3 license)

That´s a great new feature. Do you know, when this availble for europe/germany. Don´t find any information about.

Hi Lisa. The + New Column is greyed out when trying to add a new column to the imported Contact table. There is a warning stating "One or more commands are unavailable due to your current privileges for this environment.". How do I add privileges to allow me to add a column?

I have a question you can't answer. How did you become a genius? I'm serious. I've used excel all my life atleast 30 years but I'm not even a tenth of your skills and other geniuses. ❤❤❤❤❤

Do I need to establish a relationship between Contact Table and Contract Renewal table?

Great video Lisa, thank you. My issue with the "Start with data" approach is that there does not seem to be a way to control the publisher prefix of the tables that get created - the Default publisher is used. See an example at 20:45 in your video, it is using the cr36c_ prefix. Do you know any way to control the publisher of the object, as when creating a table manually in a solution?

is the app created a canvas app or model-driven app? Thanks.

Hey Lisa, is it possible to monetize a power app I have created? I want to sell it on a subscription basis. I am finding all kinds of information which is quite honestly confusing. Hope you could help.

hey Lisa how can one insert images in that excel colums and get them appear in powerapps

Hi Lisa, how did you get the file Contact.csv? Is it the same predefined Contact table in Dataverse with sample data?

I'm going to use powerapps when it become a free or at least it should be included in MS office solution.

How do I use a new Excel file to replace data?

super

How to create Home Expenses App in Power App

I created 8 tables. Then I established relationships. Ok so far. Then I tried to convert some of the columns into lookup options. The columns didn't let me change them.😢

How is this difficult from MS Access ?

At 31:04, you have that Related Tab which is a like a Menu with some Items and when you click on it you get some options, and if you click on one of these options, you kinda get an extra tab. I am trying an App and in that related tab, I have "Software and Updates" which are related to "Device". One could always click on "Related" and then on the particular menu item to open the new tab; however, I would like to avoid these extra 2 steps and make the related tab of installed "Software and Updates" to be shown by default, besides that "General" tab. Is it possible? If not, is it possible to add the contents of the mentioned related tab on the right side of the form in the General tab? This way I would have the Device entry on the left, and the list of software installed on it on the right -> both on the same page and that would be amazing haha I notice that the "Software and Updates" is a shown as a _relationship_ [between the "Device" and "Software and Update" Tables, linked by "Equipment Number" that I defined as key]; however, I don't know how to add that to my form - I only see other options like 1-column tab, or add a sections, and so on. Thanks in advance.

Can anyone show me how to export the table Contact and save it as .csv?

Can I get the data set used in this video ?

LEGO!!!❤

So far so good. My Excel table is similar to yours except for one of the columns. One of the columns I need to show a calculation. Let's say your Column K was not an input. Rather, it was a number equal to Phone x Type x Category. (I know, those are text fields for you, but they are numeric for me). How can I put in each cell of Column K an equation like: E2 * H2 * I2 for cell K2. E3 * H3 * I3 for cell K3 and so on. If you answer this, will you post it here or do I need to give you my email address?

I thought this was going to be about scripting with VBA in Excel, turning Excel into a mini-program.

Cyber security engineers worst nightmare. This is why data governance is getting harder and harder as self service tools become more accesible. If you have 1 customer who is in Europe in that table, you are now subject to GDPR compliance rules and if you aren't protecting or storing Personally Identifiable Information (PPI) correctly that is a whole new bunch of ways to be sued. I love that these tools are getting easier, but we need to ensure that proper protections are in place, even when its only accesible inside of your company network.

Holy winding road batman!!!!! Are you saying power apps lets you "create a 1:N relationship" between tables with a lookup field.... and that lookup field only defines which tables are related and what type of relationship but not which fields create the relationship..... and power apps hides the process of how to select which specific fields are used to join the tables, except in this insane workaround? Great video, but this makes no sense. There is no other way?

I have a tracker with program descriptions in paragraphs and other smaller details of the program like date, budget, location etc. Can i upload it into power apps? Also, should everyone in an organization have access to powerapps to view it?