Step-1: Let's use the PowerApps (V2) trigger and Parse JSON like below:
- Use the JSON string from PowerApps as input.
- Provide a schema matching your filtered data structure (see below).
Please use the following json in the Parse JSON field:
{
"type": "array",
"items": {
"type": "object",
"properties": {
"ID": { "type": "integer" },
"Name": { "type": "string" },
"Status": { "type": "string" },
"Amount": { "type": "integer" },
"Margin": { "type": "string" }
},
"required": ["ID", "Name", "Status", "Amount", "Margin"]
}
}
Step-2: Wherever you want (either in SP or OD), use Create File action. Can be a blank file or a template file with a table. (For simplicity I avaoided screenshot.)
Step-3: Now we can loop ParseJSON result (let's use Apply to each) to inser rows into table and then use Add a row into table action like below:
Step-4: TO generate the sharing link, please use Create sharing link action - download link actually.
Step-5: Finally, you can use Respond to PowerApps action to return the sharing link URL
Please note that, I have skipped screenshot where I felt things are easy to catchup.
I am sure some clues I tried to give. If these clues help to resolve the issue brought you by here, please don't forget to check the box Does this answer your question? At the same time, I am pretty sure you have liked the response!
