Canvas Powerapps with Excel Download

[rampprakash]

Dear All,

I got a requirement to implement Powerapps report

Details:

Report Screen with : From Date and To Date with Download Button

If user selected from Date and To Date and click on Download Button i need to fetch Data from Sharepoint List based on Date Created and Need to Download the file as EXCEL.

Can any one guide me how to achieve this.

[VijayTailor]

Hi @rampprakash ,

Please use the below url for Gr8 tutorials about your requirement,

I also use the Same and ImplementedHope it will help you to achieve your requirement.
https://www.youtube.com/watch?v=imhxy3REgXc

Thanks,
Vijay Tailor

Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."-Vijay

[rampprakash]

Hello @VijayTailor ,

I need to export directly from Sharepoint, is there a way to achieve that kind of scinario?

[VijayTailor]

Hi @rampprakash ,

Yes t, thanks for the Information.

that is also possible and Essay to Implement.

For this Requirement, you can Just pass the Date and Create a Power app flow and Filter your data inflow with the selected date that you passed inflow.

See the Demo.

After this when you adding flow into the button and that flow expects 2 variables.
Like below -
reference - Demo for adding flow in power app. (Now you can implement your logic inflow as per your requirement)

Thanks,

Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."-Vijay

[rampprakash]

Dear @VijayTailor ,

I need to add data to excel, and I need to send that data as an excel, 

As per your comment if it is 50 records it will work fine else it will take lot of time to insert data to excel and send an email.

[VijayTailor]

Hi @rampprakash ,

In this scenario, My Suggestion is better to collect all the updated record into the collection and send that collection to flow in JSON formate.

and Parse the received data into flow and use apply each to update record in async mode. hope this approach helps you to resolve your issue.
 Thanks,