I am migrating a SQL Server based system to Power Apps, and for this I need to move the data from the SQL Server database to Dataverse. I can’t use any third-party integrators (like Kingwaysoft), I have available Microsoft Office (Excel, Access) and a Power Apps premium licence. I have been able to move the data from SQL Server to Access using Access import tool, and from there to Dataverse using an Excel template. The elusive part has been to recreate the relationship between tables.

I can’t download a file from a Dataverse table with my account from a canvas app.

We have a Power App with a Dropdown that is supposed to show items from a filtered Dataverse list. It’s filtered by a status column – active/inactive. We have the same app in a Development and Production environment and import from one to the other as an unmanaged solution.

I am trying to see the records for the Applications table in Dataverse environment. Even with administrator permissions, when I browse the Applications table in the Power Apps portal, it shows no records, even if the environment does have some applications in it. I do not get the records by any other means either (i.e. via Dataverse connector in Cloud Flow, API call).

I am trying to see the records for the Applications table in Dataverse environment. Even with administrator permissions, when I browse the Applications table in the Power Apps portal, it shows no records, even if the environment does have some applications in it. I do not get the records by any other means either (i.e. via Dataverse connector in Cloud Flow, API call).

Importing an excel file which just has column names into PowerApp solutions. I set the import to use first row as headers which I wanted. After this, I looked into the app’s data section and notice that the columns are ordered alphabetically which is definitely not what I wanted. I don’t see any clear way of keeping the order that I have originally when I imported the column headers. Why is this so difficult?