Learn to connect: PowerApps Excel Spreadsheet hosted in OneDrive

[@mugdhashetge-gallagher5797]

Love Shane's tutorials. For someone who has never worked on PowerApps, I was able to quickly understand it and write code. Thanks Shane !

[@ShanesCows]

Awesome 🥰

[@R_Engg]

Thanks lot Shane. I tried creating an app for the last 48 hours, but nothing happened. After watching this video, I have had created an app based on a set of data in spreadsheets and was able to perform all adjustments, design changes etc..Thanks lot..

[@ShanesCows]

👍 Good Job 👍

[@jeenyus9999]

I just got tasked with figuring out PowerApps for my company and came across your video. Love it! Awesome content and great work.

[@ShanesCows]

Thanks John

[@singhharjitgill]

No data was displayed for me initially. I had to give permission on OneDrive admin page > Sharing >"Internal: Only People in your Organization". Created a new app and the data was displayed. Very informative VDO series.

[@ShanesCows]

Glad to help. 😀

[@marcusholden9165]

This may have saved my company thousands!!!!! Thank you.

[@ShanesCows]

Glad to help. 😀

[@martinloeffler2119]

Thank you Shane for taking us into that great world of powerapps

[@ShanesCows]

You are welcome. Glad it helped. :)

[@Divotion100san]

Hi Shane! Great video, however I would've liked to see the implementation of a dropdown list on the edit screen! That would be absolutely wonderful and helpful! Do you have a video which shows that? while using excel as a database?

[@istvanhogye5658]

I also interested about this. From xls sheet get the app with 3 screen, automaticly built connection... so great. If I need to change the text field at edit screen to dropdown list, clear how this write the test to the xls list... but not clear how to get data also from same xls sheet from separated table, where I set the list for dropdown list... so this "litle step" missing how I able to set in the app edit screen this connections... Can You help us? Regards, István

[@acs8820]

thank you very much Shane ! i really like how you encourage the think out of the box spirit when presenting these exciting features. please continue !

[@ShanesCows]

Glad to help. 😀

[@dinaharbi]

Hi Shane, I really feel in good hands watching your video... As a beginner, you have given me the confidence I need to create my own apps. Thanks a bunch!!! You gained a new fan :)

[@ShanesCows]

Thanks Dina 😻

[@adindavanderreydt1577]

This video has been a great help in order to make my first app. I've just to find out now how I can 'activate' phone numbers in order to dial directly if we select the number. Any tip or trick is certainly welcome!

[@ShanesCows]

I have never used it but I think Launch("tel:[phone]") is all it takes :)

[@sujithrajagopal7543]

I love your videos man because you speak our language!

[@ShanesCows]

:)

[@AofInfinity]

2019 My work company start using Power app to build some applications, Your video is very useful. Thanks .

[@ShanesCows]

Awesome!

[@nickrobertson9797]

Shane, new to PowerApps and have been scrolling through videos to figure out how to accomplish what I need. This was a good start. I'm trying to use the app with excel for data collection. I've generated a table, created app from data and all transfers over. How do I create drop down selections only from individual data entry points? They are manual entry only and want to create limited options.

[@ShanesCows]

Look at using a combobox or Dropdown to set the items.

[@moisestatis5418]

Hello Shane, thanks so much for your videos. They are always a great learning experience. In fact, I usually I learn to make something in a better way that I was used to.

[@ShanesCows]

Happy to help

[@nigelcole225]

Superb video - easy to understand, great starting point for learning PowerApps. Thanks !

[@ShanesCows]

Awesome. Thank you

[@JesusChristo]

I always learn something from your videos.

[@ShanesCows]

That is awesome 😎

[@mehueldivecha4483]

absolutely love your content shane! currently using your videos to build a app for 13,000 users! the POC i created using your videos has been approved. Would love to show you more ?

[@ShanesCows]

Hey Mehuel - You can email me screenshots and description shane at PowerApss911.com 🐶 Thanks

[@jlatt100]

I have followed your examples in your video with my own data. I have edited the EditForm1 sheet and changed many of the data cards fields to drop down lists. If functions just fine until you have to Edit the existing record, it doesn't seem to be holding the existing value. I have entered the If(EditForm1.Mode = FormMode.Edit, Parent.Default, " ") as the Default value for the drop down. The data source for that dropdown is an Excel file in one drive. All of the other drop downs hold their value but they are data sources that are static imports from Excel.

[@ShanesCows]

I don’t have it to test right now... that looks right at first glance. Actually you don’t even need the if. Feel free to email me more details or screenshots. Shane at PowerApps911.com

[@briantheteacher]

Hi Shane! Thank you for your very informative videos. I've learned a lot of good skills that I can use to help my school community. Thanks again!

[@ShanesCows]

Great to hear Brian!

[@lisacaldwell261]

Hi Shane. Thanks for your videos they are really helpful. I’m building a flow that links into a cell in excel that stores a meeting agenda. When the scheduled automation run the format is just one paragraph the formatting in the excel doesn’t pull through. Can you point me in the direction of a video that you cover this. Thanks

[@ShanesCows]

Hi Lisa - I don't have any great answer for this. :( Not surprised Excel isn't passing the formatting. Can you store it in SharePoint instead?

[@2bquest]

This has helped me a lot on my first app Shane. The only thing that I cant seem to find is how to code the save button patch a field in excel. Submitting a form creates a whole new record which I don't want to do. I know it may be different in SharePoint but I am using excel.

[@ShanesCows]

My Patch video works the same for any data source, including Excel. kzbin.info/www/bejne/nYmYopKMaLprY9U

[@nelsoncastillozapata]

Thanks a lot Shane. Great. I was looking for some good video to learn power apps but your explanation is the best. Great job

[@ShanesCows]

Thank you, thank you!

[@bzflowerbee]

I love Excel and I have created my first app with Excel as the data source. Everything worked as it supposed to but when I updated the record in Excel, the app did not update, they didn't sync. Now, I hate it! LOL! Thanks for your time Shane!

[@ShanesCows]

Excel isn't the best data source. Watch this video to get my 2 cents. kzbin.info/www/bejne/iKXQi4BpqdJlkNU

[@yoshi_2025]

Thank you for Great video tutorial!! I’ve made mini application to manage test data for project member using excel datasource. It took only 3 hours to make to develop. I felt the company introduced Office 365 has the large potential to improve operation efficiency by learning PowerApps!!

[@RobHerma91]

Amazing Video. Very interesting and helpful. Thanks

[@RicardoFrancoFilms]

Hey Shane, thank you for a great series of PowerApps videos. Really helpful and straight to the point. I´m wondering if you´re available to show us, your best approach on how to save data from different type of controls, Boolean for example, to an OneDrive Excel file. Thanks. Keep on the good work!

[@ShanesCows]

I have a video on Controls. I think quiz is in the title. I think it may help.

[@RicardoFrancoFilms]

@@ShanesCows Yes, you´re right. The video name´s "Build a PowerApps Quiz plus intro to controls", Thanks!

[@asimrehan73]

Thanks for this video Shane. Its sooo useful 👍

[@ShanesCows]

You are welcome.

[@chadpogs7973]

Hi Shane Young! Great video. I have a question, what if I want to change the color of the status and availability of the equipment, like if its available it will turn Green, if In-use will turn Blue. If for calibration it will turn Red. Thank you. Im just figuring out to make inventory of our small company using the Power Apps. Thank you so much.

[@ShanesCows]

Use an If formula on the Color property of the label that shows the value.

[@chadpogs7973]

thank you!!

[@tomphelan7396]

Great video Shane. Really helpful. Thanks.

[@ShanesCows]

You are welcome 🙏

[@tiansmith3505]

Hi Shane, Thanks for your great videos! 3:40 you mentioned a future video using the dropdown menu. If you have a video, can you please direct me to it? Thanks a lot!

[@ShanesCows]

I think this vidoe kzbin.info/www/bejne/nKKrYohmlLmUpKs

[@erwin8335]

Hi Shane. Thanks for all the great tips. Im not sure if this is discussed in another video, but when I share an app which is connected with an excel file in one drive I need to send the excel file (for permissions) to the user as well through one drive. Is there a way to do this without the user being able to see the data from the excel sheet? The user needs to do daily cash-ups but I wouldn't want to disclose every months data to all users? Thanks in advance Erwin

[@ShanesCows]

Best advice? Don’t use Excel. kzbin.info/www/bejne/iKXQi4BpqdJlkNU I would move to SharePoint or Dataverse for the datasource

[@gooddaychannel8347]

That’s great useful knowledge thanks. Do you have any course about dropdown list power app to excel?

[@ShanesCows]

I don’t understand what you are looking for?

[@andersiskov8630]

Thank you for the always clear and concise video material, greatly appreciated! One question @Shane Young ; I am currently in the process of creating an app from a consisting Excel table, however, due to the fact that there are formulas in the tables it cannot connect. Has this not been solved from PowerApps yet?

[@ShanesCows]

Nope. Doesn’t work. Has to be flat data. Sorry

[@almanzaralbert1]

Hi, Shane. Thanks for your VIDEOS. Let's say that you have colmum with images, how do you do it? Gracias.

[@ShanesCows]

Juan I did that years ago and for life of me I can’t remember how. Hmmm. This docs.microsoft.com/en-us/powerapps/maker/canvas-apps/how-to-excel-tips#:~:text=If%20a%20column%20in%20your%20table%20contains%20images%2C,column%20to%20an%20image%20control%20in%20a%20gallery.

[@almanzaralbert1]

@@ShanesCows oops, it didn't work. Thanks for ur time.

[@alexandrederae]

Thanks - covered the material very well - you touched all my questions points in a below 30 mns video. Rare feat - thanks a million!!

[@ShanesCows]

Glad it helped. 😀

[@adrianconnolly8568]

Hi Shane is there any way that we can import CVS datasheet, into an Excel table which updates the Excel table, from PowerApps, and delete data on the Excel spreadsheet on a criteria like a date? Thanks for, the great videos is easy to watch and follow

[@ShanesCows]

Probably Adrian. Did you see this week's video? kzbin.info/www/bejne/g5mpf6qglrdkZqM I think it would get you in the ballpark. Basically, Power Automate flow is going to need to do all of the work for you.

[@chrisnicol3993]

Hey Shane, thanks for making your content. I'm new to PowerApps and think they could be useful in my workplace to give the team more user friendly data entry tools. My test document is a purchase order summary and I'm hoping/thinking there's a way to use a powerapps that will also then create a word or pdf Purchase Order sheet to get signed off by the requester and manager for approval. But it's baby steps for now so perhaps you're next video will take me there. P.S. frustrating that excel files in sharepoint aren't yet compatible with PowerApps. I see that's been in progress for over a year.

[@ShanesCows]

Thanks for watching Chris. Do you know where your idea immediately takes me? To Flow. us.flow.microsoft.com/en-us/connectors/ Imagine having your PowerApp trigger a Flow that sends the info over to DocuSign or something similar. I don't know if that is the type of solution you are thinking of but that was my first thought. I will try to make a PowerApps and Flow getting started video soon-ish. My queue is full at the moment, so next week at the earliest. Thanks. Shane

[@chrisnicol3993]

Thanks Shane, I did think Flow would be involved but you've got me a bit scared by DocuSign too. Eek! In my head it's a very basic thing. Oh, another question. How can I change the format of the fields so that they are dates? It appears greyed out.

[@ShanesCows]

I don't follow the dates thing? Send me an email with a screenshot? Shane.Young at boldzebras.com DocuSign might not be your only solution. Just where my head went knowing almost nothing about your project cause it sounded cool.

[@kasperstergaard5452]

Great video - but do you have a video that shows how to connect to Excel spreadsheet placed in Teams - i am not able to find the proper connector and find the Excel fil on the sharepoint behind the Team...?

[@ShanesCows]

Not possible. Sorry

[@sagarkavishwar7071]

Thanks Shane, Informative Video. I am working on app for Inspection checklist however i am having multiple check points which does not fit in one screen. i am importing this table from excel which is stored in one drive. what is the way out to display checkpoints in multiple screens?

[@ShanesCows]

Maybe tabs? kzbin.info/www/bejne/n5fCnnl_m85ohq8

[@krishnarao6882]

Hi Shane Young, Your videos are providing awesome ideas on learning PA. Could you spare some time in building a video for connecting Document library using PA. Thanks

[@ShanesCows]

Thanks Krishna - What is your goal in connecting to Document Libraries?

[@ladye6359]

Shane this was amazing. Exactly what I needed today as I'm looking for the basics to plug a power app into excel to get my team to provide some quick inputs on a spreadsheet. You know how awful the shared excel experience is, well you've just made life a lot better for a lot of people. and guess what I work at MSFT! :)

[@ShanesCows]

Happy to help

[@nurulnabilah9721]

hi @Shane Young , thank you for the great videos. Btw, do you have any suggestions other than using the Excel? Thank You

[@ShanesCows]

Yes. Lots of videos on using Sql or SharePoint

[@dilipwarrier5199]

Thank you so much, Shane for this great video!

[@ShanesCows]

Very kind. 😎

[@AALHUWIDI]

Hi Shane, thanks for the great videos. I’ve an assessment been build on excel with so many conditions and I want to make this assessment on PowerApps instead of boring excel sheet. The assessment seems like a survey

[@ShanesCows]

I have a video on PowerApps quiz that should give you some ideas.

[@AALHUWIDI]

Shane Young thanks a lot Shane, that video is really helpful, but could you add tutorial about the scoring based on that video

[@abhi739]

this is very helpful. thank you shane

[@ShanesCows]

Glad to help. 😀

[@DimitrisL]

Thank you for the great video Shane! Can we add some extra fields in the app and pass any new info to the original Excel file? ie have two fields in the employee page on the app for example "Promotion Date" and "New Salary post Promotion" that we will fill in manually as inputs in the app and then these will get added as columns in the excel table at One Drive. also, you do mention in your comments that your prefer SharePoint over Excel as a data source. how can we add this file to a sharepoint and get a similar experience?

[@ShanesCows]

Yes you can add additional fields to your form and then write to them. There is also something called patch you should look at. Excel file has to be hosted in OneDrive. What I would recommend is ditch Excel and just use a SharePoint list. Got to training.powerapps911.com and take my free class. I think it will give you a lot of the context you need. 😎

[@DimitrisL]

@@ShanesCows thank you for the reply! only concern to ditch excel is that in some cases i get the source data from daily excel files emailed or exported. is there some automated process to transform them to a better format and then use the data for powerapps and powerbi?

[@ravish7737]

Thanks gr8 stuff. Question : is it possible to have 1 excel file which is shared with different suppliers, and all 3 suppliers provide same header information and it uploads on this 1 excel file which only i can see ( not all 3 suppliers )

[@ShanesCows]

Probably possible but I haven’t tried. Look at today’s video on Excel and flow

[@thezegui93]

Thank you Shane for this video, How can I connect Powerapps with an Excel file hosted in Sharepoint ? Thank you in advance

[@ShanesCows]

Not possible

[@LPadillaCR]

Shane, thanks. I would like to know how to make a sql power apps and load the data base to somewhere in the cloud. Please. And, keep up the great job and service you are doing here.

[@ShanesCows]

I have a video that does exactly that. azure sql video.

[@guillermogarcia207]

hi shane, greate video, do have anything for Count, Countif/s , CountA for powerapps

[@ShanesCows]

kzbin.info/www/bejne/naWxdIyDmbSCl8k like so 😀

[@ethanwang9178]

Real Helpful video for learning Power Apps!! I am very new in Power apps, and here comes some questions, I have each month sales number for many products in my excel file, after link the file into the powerapps, how do i add a item that can filter and calculate each products' yearly number? Many Thanks!!

[@ShanesCows]

Filter video kzbin.info/www/bejne/pJ3LiISdZZiHgpI Sum video kzbin.info/www/bejne/eneXfItnpLiljKs

[@FM-lu9hu]

Nice work Shane; a lot to learn but looks promising and do-able. Thumbs up

[@shoaibch1234]

@Shane Young, great video, i would like to know is it possible to connect to excel data placed in sharepoint

[@ShanesCows]

It is not. Sorry.

[@br31woodlands69]

Great video Shane. How can I use the data card field to take a photo input from my phone camera. Is there a camera function? How will the image be stored back in excel?

[@ShanesCows]

I replied to your other comment with a link. 😀

[@modh243]

Thanks for video Shane! Is there a way to start with the app in the edit form section instead of starting with the data displayed?

[@ShanesCows]

Check out my video on Form Modes. I cover just this.

[@deannalegare7857]

I am building an app for work to do safety inspections: I have watched a lot of your videos to get me through - THANK YOU!!!! Is there a way to use a drop down input when adding or editing in the form?

[@ShanesCows]

Yes. Maybe look at my video on multiple datasources for an idea?

[@jesuslondonoorozco7447]

​@@ShanesCows ​ Shane thank you so much for your videos. I just discovered PowerApps and I am going through all your videos. I have already checked the video about multiple data sources (and many of all of them) and I still don´t find the way to use a dropdown list to fill a form. I have an excel where I have the values that could have every single question. I would like to use a dropdown list, date picker, and radio to fill a form. I am trying to create an app for my sales team to fill every day regarding their location and the biosecurity measures because of the COVID. We need to track that information down and check where are they and how is the situation where they are. Is there any way to get the dropdown list from an excel and the results that the sales team is going to put there on a record excel file (we need to be able to use that data later). Thanks in advance Shane and again, thanks for your help. (Sorry if I misstalk, my mother language is Spanish)

[@bestofoutland5947]

Great Video . Is there a way how to attach a picture or two for each data (Employee in your case ) . Same to be saved accordingly in the excel sheet . Thanks 🙏

[@ShanesCows]

I think this thread explains it well powerusers.microsoft.com/t5/Building-Power-Apps/Excel-and-Pictures/td-p/14946

[@bestofoutland5947]

Thx Shane

[@shanmithasekar3812]

Great can i have a video on validating excel like checking blank rows and column on uploading the Excel file in powerapps form

[@ShanesCows]

Interesting idea 💡

[@alanramsay9734]

Really enjoyed the video Shane, great job introducing the technology. Can you tell me how we set up the data in Excel such that we can use an option button in Powerapps as the interface?

[@ShanesCows]

I don’t think Options will work with Excel directly. You can make a text column in excel and then patch it with an option set value.

[@365assistdarrenlutchner9]

Hey Shane, I came across this video to try and send to someone. As usual a great video from you. However its a little dated. Any chance you can replace (Probably even remove this one) with a new shiny one that has more up to date functionality.

[@ShanesCows]

This one is on my list of videos to remake. :) Just not sure the timeline but I agree with you it needs remade. Lots of them do at this point. 😐

[@MrBijusammathew]

Thanks Shane. Shane you make Great Video for Education and also have a lot of ideas that you share and ask us explore. Keep up the good work. I have a quick question. I have a Employee Sharepoint list which has a field called Date Of Joining. Is there a way you can help with to show a dot on a Powerapps Calendar screen and when clicked shows the data of the person. Any help or work around appreciated. Also If you have tutorial video on this please share the link.

[@ShanesCows]

Sam this sounds like a great idea for an app but not something I can quickly produce an answer for.Sorry. 😐

[@MrBijusammathew]

@@ShanesCows Thanks for the reply Shane. You take your time. The is very simple. The user will put schedule on the calendar a note, schedule or anything. I don't wany the data from the user's 365 outlook calendar to be displayed. This app should work independently. I can do it without a calendar but looks great with a calendar feature. Thanks once again for your great job.

[@AliA-fd9il]

Hi Shane, great video. I have a question, I created a PowerApps to capture a person's name, date, time, and signature (kind of like a check-in for your appointment), but I can't get the data to push to the excel file I created in my OneDrive. Can you provide some steps on how to connect the excel file to the PowerApp then have my submit button right the data to the table in excel? Thanks in advance.

[@ShanesCows]

Getting pen input to Anything other than an email is hard. Sorry. No quick answer here.

[@hemanthkumar3812]

Hello Shane, Can you please tell, how powerapps handles multiple users editing and submitting the data at the same time affecting storage of users data in any data source?

[@ShanesCows]

Excel doesn’t allow for multiple editors. Other datasource like SharePoint shouldn’t be a problem

[@AlbertWeijers]

Hi Shane, you really helped me to make some cool apps for my colleagues! One annoying thing is: On my Samsung the Back button closes the app instead of going back to the previous screen. Is there a way to assign the back button this way? Thanks!

[@ShanesCows]

Never seen that. I usually don’t use back though. I use navigate to the screen I want.

[@MohammadAli-ts2ev]

Great video...it's, indeed, very informative.. @Shane -. Can you plz make a video on the issue we experience while picking up DATE to edit form from Excel online (for business). The date picker simply goes blank and it doesn't pick up date from Excel table (date column) while other details from the table appear correctly. Any get around will help many of the people. I got the same issue posted by someone on powerplatform community but none of the answers fixed the issue..

[@kyoungminbae9978]

Your video is great!!! Bty, I want to know how make a excel file inculing image, and load a image from excel file in onedrive. If you have a video, please let me have your advice!!!

[@ShanesCows]

It is possible but I haven't done it in 3 years so I don't remember how it worked. :( Somethng aoubt an [Image] column. It is kind of covered in this old doc. docs.microsoft.com/en-us/powerapps/maker/canvas-apps/add-images-pictures-audio-video

[@kyoungminbae9978]

@@ShanesCows Thanks a lot!!! I will try it as your advice!!

[@aharshaa1]

Hi Shane, this is brilliant and I have been following your videos, thank you. I have a question, can we open a file that will be password protected. let us assume the password never changes and we need to provide that to open then create the table and move it to the SP list appropriately. Please advise if this is possible and it will be great if you can make a video for that.

[@ShanesCows]

I have never tried so I don't know. :(

[@aharshaa1]

Thanks Shane, looks like it is not quite possible from the deep dive I have done since morning. Let me know if that cracks your brain anytime over the weekend. have a good one my friend !

[@ikochen1255]

Hi @shane, thank you for you app videos, there is a question from me, how do we know when someone is open the excel(because we can't do any updating if someone open the excel)

[@ShanesCows]

I don't have a good answer. I would recommned using SharePoint instead of Excel as your data soource to avoid this issue.

[@jllepape]

Hi Shane, thank you for the video, very useful. any chance to use a Sharepoint rather than OneDrive ?

[@ShanesCows]

Nope. Also Excel is kind of a terrible datasource. I would prefer you used a SharePoint list and not use Excel at all

[@charmainelindique8536]

Hi Shane, I need to record water usage data on various operations. I have set up my Excel Workbook, however need to calculate consumption between two meter readings which may where the site can specify what the consumption was used for and they may need to split the consumption eg. Domestic 2 cubic meters versus Livestock at 4 cubic meters. Any advise on how best to do this? Thanks

[@ShanesCows]

I would recommend a better data source. SharePoint, sql, cds for example. You can build this. Excel just isn’t awesome

[@ahowl7mx]

Keep up the great work! Any idea how to change a column from text to a value? Powerapps thinks my Excel column is a text or "custom" but its really a number field. Any way to fix that?

[@ShanesCows]

It is tough you can just wrap the column in Value function if you want to use it as a number

[@garygrunson9764]

Great video, I am trying to use PowerApps to create a Word document. My PowerApps application contains a couple of rich text fields, which I would like to use in the Word document. The Power Automate connector does not support rich text. Do you know a better approach to create a Word document using the rich text fields from PowerApps application to convert to a Word document? Thanks

[@ShanesCows]

Rich text control outputs text but it adds the html tags to show the formatting. Maybe that will help you get it to work?

[@garygrunson9764]

The connector only accepts plan text as input, so if the rich text field is converted to HTML, getting the HTML back to Rich Text in Word is main problem. It does not render the HTML within the Word document, just displays it. In the past, InfoPath's rich text field provided us a way to use SSRS to export it to a Word document and it supported rich text. We are not allowed to use InfoPath going forward. Sort of lost, unless MS adds some support for rich text or HTML in the connector.

[@alangrady9825]

Hi shane. Great video. Maybe a silly question but is this a 2 way sync?

[@ShanesCows]

Yes, it is a live connection to the datasource.

[@2bquest]

Hey Shane, One question I have been wondering about is that when sharing an app, you are reminded to make sure that the users also have access to the data source. For example, when I have excel in one drive as a data source, I have not seen any video as to how to provide access to this data source. Do you have a video, or resource that shows that? Thanks

[@ShanesCows]

I don't Benben because every data source is different. 😐

[@mahmoudabozaid1301]

this video is very useful and important but i have some question can we make a table selection and export data to excel file and The opposite ? i have some problem with dealing with it . and thank you for you videos .

[@ShanesCows]

You can but I haven't done it in a video yet. :(

[@mahmoudabozaid1301]

@@ShanesCows can you give me a hint to do this to help me and thanks for your reply

[@notonurnelly]

Excellent video Shane, What is the delegation limit for Excel. I'm keen to link a sharepoint list to powerbi through an app. I have managed to embed my app in powerbi and add to the Sharepoint List through The app in powerbi. However when I link the list to PowerBi I'm struggling to get the list which I have displayed in a table to refresh or update. Basically I want the table in PowerBi to update once I add to the SP list in the embedded app. Would you be able to put together a video on this perhaps. Regards Jamie

[@ShanesCows]

Will you send me an email/screenshots of what you are thinking about? Happy to ponder it for a bit.

[@annieli1305]

Thanks for the video, can you explain how to add a blank text input in the dropdown list. In case i need to add other information that is not available from the list options.

[@ShanesCows]

Do you want people to be able to choose a blank line? Or to be able to add to the list of choices?

[@Anisayuni96]

Hi Shane! Thank you for the videos. It was very informative. However, I realized in your video, you made the Excel file and using the Excel to make the apps but my question is how do I display the Excel data stored in OneDrive back to Excel on my existing apps? I managed to do the list but I'm not sure how to do the Detail Screen. Another thing, my apps is connected to Outlook. I would like each users to be able to see the data that they submitted. The Excel that I have is a consolidation of every information submitted by all employees. Quick example, if Shane Young is from IT department, he can only see the data that was submitted from IT department and not other department. Same goes for other employees. So, how do I customized that? Thank you so much!

[@ShanesCows]

The gallery will show all records from the excel by default. If you want you can filter the data by data such as creator or department. Look to my videos on filter gallery for an example.

[@Anisayuni96]

@@ShanesCows Thanks Shane! That video solved my query perfectly.

[@ConfidencePoint1]

Hi Shane. I'm a fan of your video lectures and teaching style. I wanna build your quiz app but wanna use excel as a datasource. I created 2 tables: one containing questions & options and another containing details of people attemting quiz. Please tell me how to work with them in Powerapps ?

[@ShanesCows]

Upload the file to OneDrive and then add the file and tables as a datasource

[@minocat23]

Nice video, but if others want to input data to the Excel doc, would you need to share out your OneDrive to them?

[@ShanesCows]

Yes. Excel ain’t a great data source. 😐

[@IQAura]

Hi Shane!! great video (as allways). My app is showing frecuently an error when try to connect with Excel, saying that the file is locked. I'm not sure why. Any suggestions? thanks!

[@ShanesCows]

Excel is such a hard data source because of that exact problem. :( Building your app with a SharePoint data source is your best solution. Sorry

[@estherlopeznavarro6100]

Hi Shane, awesome videos! I was wondering if it is possible to have calendar view in Powerapps, maybe display dates in one of the views? Do you have a video to explain that? Thanks a lot for the good videos you publish!

[@ShanesCows]

You can but I haven't done a video on it yet. :( If you look under the new Screen button you will see a template you could check out.

[@luigimurci7653]

Hi Shane, great video, thanks for post it. Is there any way to connect an excel spreadsheet hosted in Sharepoint? I can't find anything...

[@ShanesCows]

There is not. Sorry. On the bright side Excel isn't a great data source and you are better off using a SharePoint list instead.

[@gord4truth]

Great intro. However, my app (same as yours) would only display the first couple hundred records in the file. Is there a file size limit? Ignore my question. I just saw below that someone else had asked. However, the link to "delegation" was as clears as mud!

[@ShanesCows]

Excel is a terrible data source. Use SharePoint or SQL

[@gord4truth]

@@ShanesCows Thanks Shane. That's really unfortunate because many small businesses only have Excel outside their dedicated systems.

[@sancforer]

Thanks for your videos, they are so helpful when you are learnig to use this great tool. I was wondering, is there any way to conect to a excel file which is located in a document library in sharepoint?

[@ShanesCows]

There is not. Sorry

[@isugirl2001]

Love your videos, they have helped me get started in powerapps quickly! Is there a way to manage a customer excel file of 13K lines? I'm working on a proof of concept, Each customer is assigned a branch and I have made a branch gallery that filters a customer gallery to only show customers of that branch, but I am still running into a limit of the number of customers I can search? Thanks!

[@ShanesCows]

Long story short Excel probably isn't the best solution for that many records. I would recommend moving to either a SQL database or CDS. Is that an option for you?

[@isugirl2001]

Thanks, I have filtered the list to get a proof of concept and then will bug my IT for database access to connect to PowerApps.

[@eulama1]

Hello, I am following your channel, I am doing the powers apps course, I am from Spain and I have a question, the formula only works "ColorValue (ThisItem.Color)" if the color field is in English. It is true?

[@ShanesCows]

Maybe. I have never tried Rojo but I am guessing color has to be in English

[@kanishkaroychowdhury4050]

excellent explanation... just one question... if i share my powerapp with my colleagues do i have to share the data sheet also? bcoz they are not able to view details unless i share the concern excel with them

[@ShanesCows]

Correct

[@chubbydawme]

Hi @ShaneYoung! For the app to run correctly, does the user need permission to BOTH the PowerApp and the datasource (the Excel file in OneDrive)?

[@ShanesCows]

Yes. That is why I don’t like Excel as a data source. Consider Azure SQL instead.

[@fernandolemos9910]

​@@ShanesCows Hello and thanks for your video. I have a question about PowerApp and Excel. I just made an app and the datasource is Excel on my onedrive for business. On my Onedrive I shared the Excel file to all users but when an user try to access my PowerApp for the first time it ask to allow permission on the onedrive for business. Do you know why it happens? Thanks in advance.

[@jlotica]

Shane thanks to your videos a builted an app to track direct hours for different projects I was the king of the office for a week but suddenly the excel table info lost format and the was damaged I think, the column dates turn into a bunch of ############ characters. Do you know what could have happened?

[@ShanesCows]

Excel is not a good datasource and I don’t use it much. I would recommend you use SharePoint. Not sure why excel would change its behavior but not surprised

[@jan-maxlipp8536]

really great tutorial - thx for learning sth w/o being bored

[@ShanesCows]

Thanks. Happy PowerAppsing! I think that is a thing. 😀

[@biri28]

Question, I have a bounch of textboxes that are collected and then sent to an excel table source with a forall function in a button. Is it possible to sort that source table by column date after the data is sent? Meaning when I open the excel file, is already sort by that column, is it possible? This is important as I'm using a Lookup function in some textboxes and I need to bring the latest data from that table.

[@ShanesCows]

Replied to your other comment.

[@danielmi1905]

Thank you, i have a question, i share my app ( excel in one drive for company) with my collegue but it does not run, app tell him that he has not access to the excel table. What is wrong in my app?

[@ShanesCows]

Your collegue needs access to the Excel file. You will have to share it with them. It is one of the reasons I don't love Excel as a datasource and instead recommend SharePoint.

[@danmorowitz]

I have a question. I think Powerapps can do what I need for inventory but trying to figure out if I can use this to move items from one table to another.

[@ShanesCows]

Look for a video on Patch. You could use that function to create a new record in the second table using values of the current record. Then delete the current record.

[@hablajugador]

Shane, excellent video. I am begineer in Power Apps and your videos help a lot. I have a question for you, I hope you can help me. I began working with Power BI 2 months ago, actually I create my Power BI reports from excel, and it's going very well. But I need a tool (like this app maybe) to add data, like a kind of a Form, so that the Form feeds my excel file. Do you think PowerApps can help me with this? If it does, do you have any samples? If not, please let me know if you know any other App that can feet my needs. Thanks a lot!!

[@ShanesCows]

Yes, PowerApps is perfect for updating your Excel. Did you try this video? It is a great start with working with PowerApps and Excel.

[@sureshgamlath7332]

Really useful tutorial - thanks!

[@ShanesCows]

Glad to help. 😀

[@seadude]

Hi Shane. What software did you use to do the phone demo at the end? That was awesome.

[@ShanesCows]

Thank you. I used iOS 11 built in screen recorder to record the app then Camtasia has the display template for the background.

[@saanisirajulhaque375]

Great Video. It help me a lots Thanks I have one Issue I have created an app using Blank template using Tabular Layout now iam able to add an item after that i am not able to have that Display and Edit form can you help me or share the link were you have create all he three form

[@ShanesCows]

Send me an email with screenshots explaining what issue you are having and I will see if I can help. shane.young at boldzebras.com

[@Jime1306]

Hi Shane, Thank you so much for your videos! Just finished developing an app for my company! However, new users can't write or read data from the excel database while navigating through the app. Not sure what to do since I granted access to view and edit to the excel database and the users actually can manipulate the excel when accessing directly to the link. Help,please !!! not sure what else to do

[@ShanesCows]

Excel is a tough data source. Only one person can have the file open at a time. I would recommend changing to SharePoint or another more scalable data source.

[@mapangasar9473]

Just need a little trick hope this will help. 1. Create a separate query file from the data source and use for viewing only. Dont forget to place a button to refresh it in case there are data that were newly added or modified. 2. Use the raw data source to store the actual information. Excel can be opened simultaneously but cannot save information at the same time. Give it a try.