Button to export data to excel template and email

[radtadBrad]

my company has an excel spreadsheet template that it uses to fill out service work orders.  I was wondering if it were possible to use CDS to create the work order, and then push a button to send the data from CDS to fill in the approporiate line items in the spreadsheet?  

[Anonymous]

You can have PowerApps connect to CDS and an excel sheet stored on cloud. You can set it up that when a button is pressed the excel sheet on the cloud is updated with a row of information (updating Excel from PowerApps is only possible in a table like manner).

At its current verson I do not think it is posible to create Excel sheets from PowerApps, or fill out an Excel in specific cells in a not table like manner. 

[v-monli-msft]

Hi @radtadBrad,

You could post this idea in the PowerApps Ideas forum, so it might be considered for future releases.

https://powerusers.microsoft.com/t5/PowerApps-Ideas/idb-p/PowerAppsIdeas

Regards,

Mona Li

[JHerb]

One way that has worked for me is to first, save you're data in a table format (Collections).

Then add an export button by, Insert>Controls>Export , and place it somewhere on the screen.

Select the Export Button, and under its property, find the one that says "Data". Then type the name of the Collections who want to export . If confused Read Step 6 here.

What this does is exports the Collection as a zip file, and in the zip file will be an xml file with you're information.

So if you have some data you export:

1. extract the files on you're computer. 

2. Open up excel, click Data>GetData>FromFile>FromXML And select the extracted file and hit import.

3. Excel will try to show a preview (might not work), but in the Left Navigator column there should be a table, might be named data. If there is a drop down, click on it and select the table underneath it (might be labeled "Row").  Highlight that and click on Edit.

This should give you a preview of the table that will be inserted to excel. I found that instead of spaces, it added a %20 , so to fix that highlight the whole table, under Transform, select Replace Values > and replace the %20 with a space.

After that, hit "Close and Load", and now there should be a new table in you're excel.

Edit: Clarified Step 3.

[JHerb]

Whoops, I forgot that when you select on "data" in step 3 you need to highlight the table under it labeled "Row", You should see a preview of you're data. Then hit edit and everything shoudl work.

[radtadBrad]

Thanks for the advice...i think i'm going to see what i can come up with using Flow.  But i'm open to any other suggestions.  My setup consists of an app that our service technicians use in the field to view and edit service call tickets.  When they're done, they change the status, input the time they completed the service call, allow the customer to sign off on the completed work, and most importantly they leave notes on what they did.

In a perfect world...they would be able to push a button, and all the info from the service ticket would export to a template of some kind, and be emailed to the customer.

[Anonymous]

I can't tell you how many questions I see posted in the forums where the answer is  "we don't currently support that, please suggest it as a feature".

This would be fine if most of the feature questions were for more obsure, esotartic functionality.

But 70% of the time, the questions relate to functionality that is already baked into more mature Micorsoft development products like Visual Basic .NET,  C#,  ASP.NET, Powershell, Microsoft SQL Server, even Microsoft VBA which PowerApps claims to be losely based upon.

Now I know some of those products are at least 2 decades old,  so you might think I'm being unfair for making that comparison, but I'm not.   They could have had the product development team apply that knowledge to make PowerApps as feature rich as those other platforms.

But instead we are forced to vote for feature enhancements?   

Come on Microsoft,  you can do better.





The reason why I'm not is that Microsoft has the domain knowledge with those other