Answered

Output of PowerApps is charts in excel file

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello,

I am new to PowerApps, and I want to have an Excel file as my PowerApps application output. this file must have graphs (Charts).

Can you please help me knowing that the input is an excel file containing a table of Data.

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

@Anonymousunfortunately PowerApps does not really provide this scenario you are looking for.
PowerApps will work very well when dealing with Excel as a DataSource, but you are looking for more of a creation of a document with specific features.
There is a connector for PowerApps that will help you produce Excel and other types of documents. The connector is Plumsail Documents.
I could envision creating an Excel template with the components (charts, graphs, etc) you want and having the connector fill in the data for you.
Of course...if that is all you need, you can do this today directly in Excel by connecting your Excel to external data sources.
Either way could get you where you want, but PowerApps, by itself, will not provide it.

Was this reply helpful? Yes No
iamlee 121 on at

Like (1)

Report
Copy link

Link copied!

@Anonymous ,

You'll start by designing your table in Excel and then use Excel as your storage for your PowerApps. You can have your chart as a separate sheet or create a new file for your chart and link it to your Excel where you storage data. If you choose the earlier, Chart should automatically update. If you create the chart as another Excel, it usually asks whether you want the link updated.

The key is your data model, if you design it correctly your chart is the least of your challenge.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Thanks very much RandyHayes

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Thanks very much iamlee

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Yes, this was the concept I mentioned of connecting your Excel to extrenal data. I would HIGHLY recommend doing your charts and graphs in a file outside of one that you are using for your PowerApps data source.
You can quickly cause an issue in the Excel file that will lead to the "why doesn't my PowerApp work any more?" question.
If you have a separate Excel file to connect to external data (in this case the other Excel file), then you can muck with it and have issues without causing problems to your PowerApp.

Was this reply helpful? Yes No