Unanswered

Send gallery to JSON issues

(0) Share

Report

Posted on by jed76

I’m trying to send a filtered gallery via JSON to us in a word template using flow. I’ve managed to get the basics working but for some reason I can only see three of my columns in the JSON output? I am taking these outputs and mapping them to a repeating table in Word using the SELECT operation to map them but I can’t see all columns from the filtered gallery?

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (0)

Sort by

LaurensM 12,516 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hi @jed76, could you check if the following parameters resolve the error and do not remove any fields you require:

JSON( Gallery, IgnoreUnsupportedTypes & IgnoreBinaryData )

I hope this helps!

Was this reply helpful? Yes No
jed76 on at

Like (0)

Report
Copy link

Link copied!

Thanks. This is kind of what I am already doing but the gallery has some filtering applied. Would it be better to add the gallery to a collection first and perhaps use show columns before using JSON?

Do you also know if it is possible to send the data to an excel file instead of a repeating word table? I need to apply conditional formatting to the data as well based on certain criteria and can’t think of a way to do this in a repeating word table?

Was this reply helpful? Yes No
LaurensM 12,516 Moderator on at

Like (1)

Report
Copy link

Link copied!
@jed76 , Ok the JSON() might be leaving out these fields due to the given parameters.
In my test case, the dropdown / choice fields were not in the JSON body.

The method you proposed would be the preferred way in my opinion. I tested this with the code below and my choice fields were in the JSON this time:

ClearCollect( colGallery, ShowColumns( Gallery1.AllItems, "ChoiceFieldName", "TitleFieldName" ) ); ClearCollect( colJSON, JSON(colGallery) )

(The ClearCollect of the colJSON was solely for testing and seeing the results)

Was this reply helpful? Yes No
jed76 on at

Like (1)

Report
Copy link

Link copied!

Great - I’ll give this a try. So after the collection you’d just use JSON(colGallery)? Or do you need to add ignorebinary data etc?

Was this reply helpful? Yes No
LaurensM 12,516 Moderator on at

Like (1)

Report
Copy link

Link copied!

@jed76 in my test case the JSON(colGallery) worked fine without the additional parameters.
However, this might differ in your specific case.

For your information:
IgnoreUnsupportedTypes is used to ignore (and leave out) unsupported types such as controls and record references. (controls will have been the issue when referencing the gallery without ShowColumns())
IgnoreBinaryData is used to ignore audio/video clip and image columns.
IncludeBinaryData is used to add image or media references to the JSON.

Was this reply helpful? Yes No
jed76 on at

Like (0)

Report
Copy link

Link copied!

Many thanks - I’ll give it a try in a bit and let you know!

Was this reply helpful? Yes No
jed76 on at

Like (0)

Report
Copy link

Link copied!

Getting there - the collection seemed to work much better although I still had to use ignoreunsupportedformats.

Many thanks!

Was this reply helpful? Yes No