Answered

Selecting some items from the gallery to generate JSON

(0) Share

Report

Posted on by EvaSantos

Hi, I'm creating a flow to generate an Excel file. Following a tutorial I was able to generate the JSON file of all the items in the gallery.

GenerateExcel.Run(
JSON(
Galeria_incidencias. AllItems;
JSONFormat.IgnoreUnsupportedTypes & JSONFormat.IgnoreBinaryData
)
)
But I need only a few of them to arrive. How can I select the ones I'm interested in?
Let's see if anyone can help me

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

Verified answer

v-xiaochen-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @EvaSantos ,

If you want to filter rows, please try this

GenerateExcel.Run( JSON( Filter( Galeria_incidencias. AllItems;<column>=Value ); JSONFormat.IgnoreUnsupportedTypes & JSONFormat.IgnoreBinaryData ) )

If you want to select columns, please try this

GenerateExcel.Run( JSON( ShowColumns( Galeria_incidencias. AllItems;"First Column";"Second Column"); JSONFormat.IgnoreUnsupportedTypes & JSONFormat.IgnoreBinaryData ) )

Best Regards,

Wearsky
EvaSantos 49 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks!
EvaSantos 49 on at

Like
a
(0)

Report
Copy link

Link copied!

Well, I already have the columns I need, but is there a way to sort them in the order they should be inserted into the csv file?