Set(ExportLink, ExportToExcel.Run(JSONData).link)
My flow was built from this:
- Create a New Flow:
- Go to Power Automate (flow.microsoft.com).
- Click on Create and select Instant cloud flow.
- Choose PowerApps as the trigger and name your flow (e.g., “ExportToExcel”).
- Add Actions to the Flow:
- Initialize Variable: Add an action to initialize a variable to store the JSON data from PowerApps.
o
Initialize variable
o
- Name: JSONData
o
- Type: String
o
- Value: Ask in PowerApps
- Create CSV Table: Add an action to create a CSV table from the JSON data.
o
Create CSV table
o
- From: JSONData
o
- Columns: Automatic
- Create File: Add an action to create a file in OneDrive or SharePoint.
o
Create file
o
- Folder Path: /YourFolderPath
o
- File Name: ExportedData.csv
o
- File Content: Output from Create CSV table
- Create Share Link: Add an action to create a shareable link for the file.
o
Create share link
o
- File: ID from Create file
o
- Link type: View
o
- Scope: Organization
- Respond to PowerApps: Add an action to respond to PowerApps with the shareable link.
o
Respond to PowerApps
o
- Add an output of type Text
o
- Value: Web URL from Create share link
Any help is appreciated. I am new at all this, so when it comes to these I spend much time looking for a fix but always come back to this forum for help.