cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Takoua
Level: Powered On

Output of PowerApps is charts in excel file

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

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User
Super User

Re: Output of PowerApps is charts in excel file

@Takouaunfortunately 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.

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.

View solution in original post

5 REPLIES 5
Highlighted
Super User
Super User

Re: Output of PowerApps is charts in excel file

@Takouaunfortunately 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.

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.

View solution in original post

iamlee
Level 8

Re: Output of PowerApps is charts in excel file

@Takoua , 

 

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. 

Takoua
Level: Powered On

Re: Output of PowerApps is charts in excel file

Thanks very much  RandyHayes

Takoua
Level: Powered On

Re: Output of PowerApps is charts in excel file

Thanks very much iamlee

Super User
Super User

Re: Output of PowerApps is charts in excel file

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.

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.

Helpful resources

Announcements
thirdimage

Power Platform 24

Check it out!

thirdimage

New Badges

Check it out!

thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

Top Solution Authors
Top Kudoed Authors
Users online (5,751)