1.

How to export to excel in PowerApps?

Answer»

Because there is no direct function in PowerApps, we must use a flow to do this.

  • Create a button in PowerApps and link it to a flow when the button is pressed.
  • As a parameter, PASS JSON data to the flow. To save the JSON data to excel in a SharePoint site, use the create CSV and create file ACTIONS in the flow. To communicate back the URL of our Excel file to POWER App, use the react to power app action.
  • When the power app RECEIVES the Excel link, it uses the DOWNLOAD function to save the file.


Discussion

No Comment Found

Related InterviewSolutions