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

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

v-xiaochen-msft on at

Like (1)

Report
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

Was this reply helpful? Yes No
EvaSantos 49 on at

Like (0)

Report

Thanks!

Was this reply helpful? Yes No
EvaSantos 49 on at

Like (0)

Report

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?

Was this reply helpful? Yes No