PowerApps Import from Excel vs. Excel Online Business

[@iyengar007]

Man.. What would I do without your videos.. I'm forever your student and you are forever Guru for us all. Happy festivities buddy.

[@ShanesCows]

Happy holidays!

[@jennifergrauer6353]

Thanks for this video Shane. Our need to import from Excel is because the sales data in our POS software can only be exported in CSV/XLSX format. There is no connector available to PowerAutomate or even Zapier at this time. Thanks again for all your help.

[@ShanesCows]

Jennifer did you see this video? kzbin.info/www/bejne/h5S6m3SqbLaJpJY I talk about importing when I was a similar scenario. :)

[@richardfrith266]

I'm using static Excel data in a few apps, for the exact reason that you said Shane. It's an enormous list of serial numbers, which the user can search by Bar code to return a customer name/address. I have an agreement with the end user, that they will send me a new version of the file on a yearly basis for re-import. This is manageable! The main advantage of this compared to SharePoint, is speed, reliability and no delegation issues (that I've seen). Dataverse would be ideal of course, but then the premium license cost kicks in.

[@AdiCristea]

Xmas present early!! Thank you, Shane, hope you, family and team have a great Christmas and see you on the other side of New Years!

[@ShanesCows]

Thanks Adi! Merry Christmas to you and your family. 🎅🎄

[@KeyserTheRedBeard]

intense video Shane Young. I broke the thumbs up on your video. Keep on up the excellent work.

[@ShanesCows]

I appreciate it

[@KeyserTheRedBeard]

@@ShanesCows no problem at all. always happy to support my fellow content creators. i am looking forward to improving on my own current video format i have uploaded and, in the future, trying to create content as good as yours in the long term.

[@diegonoliveira]

Thank you Shane for share this content with us. It help’s a lot.

[@sundrapillay6668]

Thanks Shane have a great festive season

[@ShanesCows]

Happy holidays Sundra!

[@antonioverga1541]

Hi Shane. What about creating a APP where the USER can upload an excel file (with a pre-defined structure) that loads the excel data into a PowerApps collection and can later be Patched to a datasource (SharePoint, Dataverse, SQL). This would be useful when migrating data that are currently saved in multiple sparsed Excel files into a centralized Database. The idea is to give the user the ability to upload the file to a SharePOint library (using the method you alaready shared before) and then use Power Automate to suck the data inside the Excel Table and send it back to Power Automate and load into a colleciton.

[@alfredohumberto2222]

Thats what I'm looking for. Did you find something?

[@georgeellis5237]

Great video Shane. Thank you. The reason I want to import from Excel is a start point. I’d want to link to an Excel table, patch to a DataVerse table, and then deprecate the Excel. My company has a lot of detailed Excel file and this seems like an easy way to get my Excel-to-PowerApp conversion started. Or is there a better way to move Excel data to DataVerse?

[@antonioverga1541]

Similar to my proposal below.

[@sergiogomez6865]

​@@antonioverga1541 Hi George, i have the same issue, I tried to follow this video, kzbin.info/www/bejne/ambUhJSurrhsiMk, but it has something wrong, it doesn't work at the end, the formula is wrong, and seems that the person who knows how to create or fix it is @shane , how to Upload Excel file from PowerApps to SharePoint list, this is really useful for teachers

[@cheltonnunes7921]

Thank you for the video, i would like to know how to import using a button

[@ShanesCows]

This video kzbin.info/www/bejne/g5mpf6qglrdkZqM

[@ontheway9383]

I would like to ask for your utmost kindness. Well, I followed the clip and added a topic to an Excel table in OneDrive. At first, I could SubmitForm normally, but after a while, when I pressed SubmitForm, it gave a notification that "Network error when using the Patch function: The requested resource has been blocked." Where do I go to check or how can I fix it? I've been confused for a week now. Please help me, brother.

[@954giggles]

How do you add a button to import an excel file to a collection? I dont see attachments as a field in my form

[@MANUGARRA]

Hey Shane, great video.. I have a question. When we already have data in our App (for example the dog table data), and then we want to import a excel / CSV that also has data similar to dog table data , but we want to make sure we merge the data in the App and flag to user for any mis-matches in common data that already exists in our app. For example, we already have Chewy Young in both our app as well as the CSV we want to upload from, which exists as Chewy Young in App and Chewy Adeline in the App. How can we flag to user that First Name is a mismatch (assuming there is a matching primary key in both app and CSV).

[@latrobe15]

Thanks Shane, I believe there is a limit to the import of 7500. I have this issue so I imported two tables and connected by a collection

[@PauloStecklow]

Is that true? What about delegation? Is there the 2000 limit?

[@latrobe15]

@@PauloStecklow Delegation only relates to server side access. As the data is in the app it it not applicable.

[@koppelekoppelek8758]

Hi Share, could you please create video for Model-Driven Apps: Tutorial for Complete Beginners?

[@ShanesCows]

I promise they are coming sooner than later. I have put them off way too long. 😊

[@fredbarnes196]

There are times when you have lists that need to be maintained by an admin that are 1000+ rows. (for example who is responsible for managing what cities). The list in the app is a dataverse table. It is faster to update the list in excel (5 mins) than via a form (5 hours). Simply update the dataverse table from excel via import data. (Model driven app) Works great in one drive, but you can't seem to import from an excel on a sharepoint site. Is that actually true, no import from an excel file on sharepoint? Would hate to additionally manage who has access to my one drive folder.

[@prateeksrivas89]

I have designed a form that feeds data into an excel file stored on onedrive. But while sharing it I don't want to share the file where raw data is stored. Is there any way?

[@ShanesCows]

Nope, you should use a different data source like SharePoint. Excel is a terrible data source kzbin.info/www/bejne/iKXQi4BpqdJlkNU

[@isabellejuffermans7175]

great as usual ! one question : is it possible to automatise the connection to data and give a variable excel filename ? i've this PA-Apps where user can select multiple excel files - filenames with path is sent to power automat and then, power automate update sharepoint list with values from tables inside the excel files - but if there is a way to do most work - prepare the parse json stuff ... from PA, even better :) thanks

[@benjamincpetersen]

I have started using import Excel to archive entries. I only have SharePoint to work with, and I have some solutions that are approaching 2,000 and no other way around delegation because of searching. I think it's a decent way to keep entries under 2000, although the archiving is very manual, but what can you do

[@joshanglesea9017]

If you were storing an excel file in a SharePoint document library. Is there a way to open the contents of that file in the power app and perform CRUD operations and update the document library?

[@ShanesCows]

No, but if the file is in OneDrive for Business you can edit the Excel file as long as the data is in a table.

[@hephzibahsamuel7]

Hi shane, I am importing excel data into dataverse through power automate flow. And i used Apply to each and inside that add a row action. When i am trying to import more than 500 records, flow is taking much time to import data. Is there any way to import data quickly in less time? Thanks in Advance!!

[@chrysarreola5902]

Is there a way to allow the user to import the data themselves. Say I let them enter the name of an excel file to a text input and hit a button on the app to import the data

[@ShanesCows]

Yup, give this a go. kzbin.info/www/bejne/h5S6m3SqbLaJpJY

[@vanesajerez3829]

@ShaneYoungCloud Thanks for the video! I was looking to connect a table hosted in a Sharepoint Group. I can see the Connection for Excel Online for Business when I do it from a blank app, but if I try the option to Start from an Excel file, the connections list is different and I don't have the Excel Online for Business anymore. Could you please tell me how can I find this connection to start from the excel data (I am doing a form for data entry, that has already data in an Excel spreadsheet on a Sharepoint site, I am part of the admin group for that site)

[@ShanesCows]

Add the Excel Business connector as a datasource not import from Excel and you should see the same options.

[@MrAmalvankar]

Struggling for Email and date field to add / update in excel using excel online business connector. Parent.Default does not show any value at all

[@kathleenfrith4579]

Hi Shane - thanks so much for your tutorials, they are very helpful. I have a pivot table in an excel online file that I would like to connect to a PowerApp, but the option to select that table when connecting does not seem to appear. Is it possible to connect to a pivot table? Or does my data need to be formatted into a regular table in Excel? Thank you!

[@salmasalah3588]

I have same issue

[@yeshua5581]

Hola Shane Young no fui el primer comentario¡¡ >:3 , ¿es muy pronto para pedir mas videos? :3, que te parecen mis videos?,

[@ShanesCows]

😊 Gracias! 🐶 Pero, no hablo espanol muy bien

[@hiram4578]

i think people are watching this faster than Late Night.

[@ShanesCows]

I hope so. 😁

[@fletchergrimlock6885]

Hey Shane, you might be interested in seeing Paulie M's video on how he instantly sums an array of numbers in a Power Automate Cloud Flow : kzbin.info/www/bejne/i5TSkqSjq7mpedE . If only he showed how to sum different objects within that column (i.g. total of apples vs oranges). *hint hint* :)