Answered

How to export Gallery items to a JSON file?

(0) Share

Report

Posted on by taiping8

I have a Gallery that displays Outlook Calender events. Each row shows the subject, start date, end date and venue of the event.

How can all these Gallery items be exported into a single JSON file?

For another use case, I was able to read values from individual controls into a dataCollection and save them to a JSONData variable as JSON formatted data.

ClearCollect( dataCollection,
{ Type: Dropdown1.Selected.Value,
DateFrom: DatePicker1.SelectedDate,
DateTo: DatePicker2.SelectedDate,
Duration: Radio1.Selected.Value
});

Set(JSONData,JSON(dataCollection, IndentFour));

As for the Gallery, it has a Selected property for individual items. It does have an AllItems property but there was an error when I tried to save it to a variable or collection.

How can I extract the Gallery items into one JSON file?

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Akser 1,546 Moderator on at

Like (1)

Report

Hi @taiping8,

I'm sharing a video with a timestamp, any chance you get the error shown there? If yes, continue watching for a possible solution (JSONFormat.IgnoreUnsupportedTypes)

https://youtu.be/tQCBWMR7T64?t=1145

Was this reply helpful? Yes No
Verified answer

taiping8 26 on at

Like (0)

Report

I would like to share on the solution. The gallery contains a title, sub-title, label and body.

First is to loop through the gallery items and save them to a collection:
ClearCollect(
colEventData, //Collection
ForAll(
Gallery1.AllItems As Items, //the Gallery
{
Type: "CalendarEvent",
Subject: Items.Title2.Text,
Start: Items.Subtitle3.Text,
End: Items.Label11.Text,
Venue: Items.Body1.Text
}
)
);

Then save the collection to a variable.
Set(jsonEventData,JSON(colEventData, JSONFormat.IndentFour));

Finally run the Power Automate flow to write the contents to a file:
CalFlow.Run(jsonEventData);

Was this reply helpful? Yes No