Exporting a Gallery into Excel

(0) Share

Report

Posted on by Micaiah

198

Hey All,

Previously I was trying to export the items in a data table into Excel and kept running into trouble so I'm trying to do the same thing but with a Gallery this time. However, I'm not sure what I'm overlooking.

This code is on the "On Select" icon I'm using

And the rest below is what's happening in my flow:

Any help would be greatly appreciated.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

WiZey 3,023 Moderator on at

Like (0)

Report

Hello @Micaiah ,

How do you read your JSON data in Power Automate? Do you use this action?

Was this reply helpful? Yes No
Micaiah 198 on at

Like (0)

Report

Hi @WiZey ,
I saw an example and suggestion that using json(triggerBody()[‘text’]) could work since it makes the JSON being parsed dynamic, so I was trying to do it that way.

Was this reply helpful? Yes No
Micaiah 198 on at

Like (0)

Report

Hello, @WiZey @iAm_ManCat

I'm trying to generate a JSON sample to use in the Parse JSON step in my flow since I can't get the dynamic way to work. I tried using the example in this link as a reference: https://www.matthewdevaney.com/power-apps-export-to-excel-as-a-csv-file/
but my sample keeps showing up blank. Also double quotes no longer work for column names in the ShowColumns function and I've changed the code to reflect that but I still don't know what the issue is.

Any suggestions?

Was this reply helpful? Yes No
Verified answer

Micaiah 198 on at

Like (0)

Report

I figured out what the problem was and it was linked to my collection(it was empty because I forgot to run the code in preview mode after writing it). The initial suggestion I made about json(dynamic content-name of text input from powerapps trigger) worked once my collection was populated.

Was this reply helpful? Yes No