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
Ignite 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Power Apps Africa Challenge 2022

Power Apps Africa Challenge

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

Top Kudoed Authors
Users online (2,320)