cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Takoua
Frequent Visitor

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
RandyHayes
Super User III
Super User III

@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.
Check out my PowerApps Videos too!

View solution in original post

5 REPLIES 5
RandyHayes
Super User III
Super User III

@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.
Check out my PowerApps Videos too!

View solution in original post

iamlee
Resolver I
Resolver I

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

Thanks very much  RandyHayes

Takoua
Frequent Visitor

Thanks very much iamlee

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.
Check out my PowerApps Videos too!

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

Top Solution Authors
Top Kudoed Authors
Users online (75,072)