cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mrstian89
Helper IV
Helper IV

Create Excel files from PowerApps

Hi! We are using a Power App for listing acccess in a specific area at our work facility.

Some users will have a much smoother workflow if they are able to create a Excel-file from the Power Apps with their own selection of data. Is this possible?

 

We will need the following functions:

  • The user use checkboxes to decide which columns from the Dataverse table to show in the new Excel-file
  • Multiple inputs to filter rows. For instance: Location = Computer room.
  • Either download the Excel file directly or send it by e-mail.

 

Cheers!

1 ACCEPTED SOLUTION

Accepted Solutions

Hi @mrstian89

That's possible.

You could use the Power Apps trigger, and then add the Create file action so that you could name the file based on input from power apps.

Here is a blog for your reference:

https://powerautomate.microsoft.com/fr-fr/blog/howto-upload-return-file/

Best Regards,
Qi

View solution in original post

3 REPLIES 3
v-qiaqi-msft
Community Support
Community Support

Hi @mrstian89,

Do you want to create an excel table in Power Apps?

 

If you want to generate an excel file in Power Apps, I am afraid that there is no way to achieve this currently.

 

Power Apps is a platform that we process data based on a data source from the data base like OneDrive, Dataverser, SharePoint or SQL.

Power Apps does not support to create a table as the data source, it is a place where connects data source to.

Best Regards,
Qi

Not even possible to start a flow which will generate an Excel-file or similar filtered by inputs in Power Apps? 

Hi @mrstian89

That's possible.

You could use the Power Apps trigger, and then add the Create file action so that you could name the file based on input from power apps.

Here is a blog for your reference:

https://powerautomate.microsoft.com/fr-fr/blog/howto-upload-return-file/

Best Regards,
Qi

Helpful resources

Announcements
Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Super User 2 - 2022 Congratulations

Welcome Super Users

The Super User program for 2022 - Season 2 has kicked off!

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Government Carousel

New forum: GCC, GCCH, DoD - Federal App Makers (FAM)

In response to the unique and evolving requirements of the United States public sector, Microsoft has created Power Apps US Government.

Users online (2,316)