Announcements
Hello, I have a gallery listing records from a SharePoint list. I need a button to export the gallery to a CSV file. Using JSON, complex column types aren't allowed. I have quite a few complex columns (of type choice) that I need to output to the CSV file. Is there anyway around this? Thanks.
@Anonymous
I'd try creating a collection of your data first and in this action, convert all complex types to simple types. Just an idea.
How would I go about that? I can't seem to find anything online
There's probably a few ways to do this but I'd just create a collection from scratch ie
// Clear collection first Clear( myCollection); // Create collection from gallery ForAll( yourGalleryName.AllItems As colCSV, Collect( myCollection, {TextColumn1: colCSV.TextColumn1Name, TextColumn2: colCSV.TextColumn2Name, ChoiceColumn1: colCSV.ChoiceColumn1Name.Value // .... add extra columns required as needed ... } ) )
Note: This assumes that your Choice columns are all single choice only, not Multi choice options.
Thank you so much!
Hi!
Thank you @Anonymous, this was exactly what I was looking for!
I have multiple choice columns (choices columns) as well and I found this workaround to get it as a string:
ChoicesColumn1: Concat(colCSV.ChoicesColumn; Value; ", ")
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 402 Super User 2026 Season 2
Mohsin Ali 328
WarrenBelz 296 Most Valuable Professional
