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.
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.
Jennifer did you see this video? ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-QcWjAt7QVn4.html I talk about importing when I was a similar scenario. :)
@@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.
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.
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.
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 Hi George, i have the same issue, I tried to follow this video, ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-45qSaxyS9Rg.html, 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
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).
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?
Nope, you should use a different data source like SharePoint. Excel is a terrible data source ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-RtmZM3tm2Zs.html
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.
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
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!!
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
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?
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
@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)
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!
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 : ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-UcoaqmvTvCo.html . If only he showed how to sum different objects within that column (i.g. total of apples vs oranges). *hint hint* :)