This makes it easier to compare the numbers about (partial) failures.Excel for the web looks a lot like the Excel desktop app. Now I was able to see all my recent imports and the details about them. We will not find some tables of Dataverse in this user interface… So what if we edit the url of the Model Driven App to show the table by changing the url? url]./main.aspx?appid=617f5b47-9682-ec11-8d20-000d3a648513&pagetype=entitylist&etn=importfile Unfortunately I was not able to find this table using the the Power Apps Maker Portal. This gave me the idea to find the table of the importfile records: Opening up a record from this view opened up a form with its own URL showing me all kind useful information on my import / updates. I really wanted to have a direct link to this overview for example when troubleshooting failed updates using this Excel Online method… I could not find a direct link to this overview, because of the popup. Now I see view of My Imports appearing in the same popup: This is totally fine by me as long as I am able to track the progress. Apparently the data is not saved immediately but is queued the same way an import file is queued for processing: In my case Amsterdam was one of the 12 Locations in the lookup table:ģ) The peculiar thing is that upon saving my changes a popup window appears. Just make sure you match the primary column name of the lookup table using a unique name in that table. I had a source Excel file where I had 9.000 records matching a 4-digit zipcode with a location of preference:Įven lookups to other tables will be able to match. Use the Export to Excel button to select Open in Excel Online:Ģ) This will open up the table in an Excel Online view and here I was able to paste my 9.000 records. Just go to the table you want to import (or bulk edit) a large number of records. And track its progress… 🤓 How?įull up-to-date instructions about the Excel Online option in Model Driven Power Apps of Dataverse can be found here: Open your model-driven app data in Excel Online – Power Apps | Microsoft Docs.ġ) The way of work is pretty self-explanatory looking at the unified interface. This blog post is about my lessons learned on using the option of Excel Online in Model Driven Power Apps to import a large number of records into Dataverse. It is easy to use and we can also use it to bulk edit a big number of already existing records.
I like this option because that is one of the options that a “simple” end user has when using a Model Driven Power App. I wanted to use the Excel Online option of Model Driven Power Apps in Dataverse. Recently I had to import 9.000 records into a Dataverse table.
0 kommentar(er)
