Export from SQL

[szadegan]

Hello,

I have a data table which is populating data based on a connection to Azure SQL database. I tried to Export this by adding the Export control but there is an error like the attached file. I want users be able to export this report.

Any idea if this is possible at all or I am doing something wrong?

[CWesener]

Hi @szadegan - which browser are you using?

The control you mentioned is intended for exporting and importing data between apps - adding @FilipK to confirm if it can be used to export human readable data.

[FilipK]

The import/export functionality is not supported in Internet Explorer.  Try Edge or Chrome, it should work.

[szadegan]

@FilipKI have tried that in Firefpx, chrome and IE. None of them worked, just in Chrom the error is different:

Cannot read Property 'Document' of null

As Data I am using another DataTable which is getting data from SQL

[szadegan]

Hi @CWesener I have tried FireFox, Chrome and IE. None of the worked. My datatable is populating data and the connection seems fine. I just dont know if the Export is really working for datatables or not. Or if there is any other option to export Datatables contents to Excel.

[FilipK]

Adding @jovan to see if there is a known limitation.

[jovan]

Export is currently not supported in web player.  We are looking into changing that.

[v-xida-msft]

Hi @szadegan,

I have made a test within a published app, Currently, Export control functionality is not supported within IE, Edge and Chrome browser. The error message as below:

As an alternative solution, you could consider take a try to install PowerApps Studio for Desktop within your PC (download from Microsoft Store), and then run your app using it.

Best regards,

Kris

[szadegan]

Thanks @v-xida-msft for the ffort, but I want a user to be able to use the app easily. Maybe I try to make it work using Flow but I am not sure if it will work or not.

[szadegan]

Hi @jovan Happy to hear that and look froward for it. Beside all features in Powerapps there are some limitations which dissapointed me everytime I wanted to use it.