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)

Sort by

WiZey 3,023 Moderator on at

Like (0)

Report
Copy link

Link copied!

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
Copy link

Link copied!

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
Copy link

Link copied!

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
Copy link

Link copied!

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