Answered

possibility to download data?

(0) Share

Report

Posted on by sbossler_079

Hi all,

I have created a powerapp connected to some Azure SQL tables and now I want to add a feature to download filtered data ideallydirectly into an excel file or that the excel file will be sent to the user via an e-mail as an attachment.

I've played already with a flow and was able even to create a csv file and send it via e-mail. But I still have the following challenges:

- instead of a CSV an excel file should be created

- currently, the csv contains all data record based on a created view but I would only include those which are filtered on some dynamic values (like for example only the rows the user is responsible for)

Any Ideas on how I can achieve this?

A basic "download" button inside my powerapp would even fulfill my requirement.

Best Regards,

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

KrishnaV 5,023 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @sbossler_079 ,

To best of my knowledge Power Apps in fact the Power Platform is not capable to dump / export the data to an excel file directly. All it can do is it can export to a .csv file.

I hope this resolved your issue if you see any challenge let me know I am always happy to help.

Regards,
Krishna
If this post helps give a 👍 and if it solved your issue consider Accept it as the solution to help the other members find it more.
Verified answer

eka24 20,925 on at

Like
a
(1)

Report
Copy link

Link copied!

This video deals with a button for download inside Powerapps. But csv. I don't know whether you will be interested
https://youtu.be/QTbVMu6DIfQ
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.
sbossler_079 42 on at

Like
a
(1)

Report
Copy link

Link copied!

Whow, this was exactly what I was looking for. Thanks a lot!