Unanswered

How to Get the output as excel?

(0) Share

Report

Posted on by Sivakumar11777

I am new to power apps, My inputs are few numbers(Date, values). I have one source data excel which already updated with calculations. I need to give input to this excel and get the output as updated excel. How can i get it? Kindly help me on the basic steps

Categories:

Building Power Apps

All responses (3)

Answers (0)

Sort by

young97mk2 17 on at

Like
a
(0)

Report
Copy link

Link copied!

You can use PCF to export your data as excel. Here's the tool: Export to Excel
v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Sivakumar11777 ,

Could you please share more details about your scenario? Are you using an Excel table as data source for the App? What controls (UI) have you used for the App? You'd better provide some screenshots for better understanding.

Further more, functions for Excel cells are not necessary, which will make the data source much more difficult to interact with. You can input values for the Excel table in PowerApps, calculate in the App as well and see the result in that table directly, just the same as using SQL tables as the data source.

Hope this helps.

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

Sivakumar11777

3 on at

Like (0)

Report

Copy link

Link copied!

Hi Jefferni,

Thank for your response.

Let me explain a littile bit on a problem. We are creating the reports weekly once. For that reference template which already they have made the calculations and formulas already. I used to update the failures count there. It will automatically get updated to the other respective fields. Here my question , i have that reference excel, the field which i have to modify, i am thinking to give as input, that should automatically updated to excel,which based on that calculation shoul made and give the final result as updated excel, So that i can repeat this process vice versa for every week.Below is part of sample data:

There if i push the failure data , other data's should get automatically filled.. Few formulas already made in excel

Sl. No	Domains	No. of Servers	Total No. of Instances	Completed	Failed	Partial Completed	Not Backedup	Success %
1	change	929	2861	929	0	0	0	100.0%
2	test	61	377	61	0	0	0	100.0%
3	mark	74	370	74	0	0	0	100.0%
4	server	42	264	42	0	0	0	100.0%
5	admin	8	47	8	0	0	0	100.0%
6	list	11	35	11	0	0	0	100.0%
7	excel	2	23	2	0	0	0	100.0%
8	not	2	9	2	0	0	0	100.0%
	Total	1129	3986	1129	0	0	0	100.0%