Hey Guys,
I’m trying to create an XLSX File out of a SharePoint List. My Problem here is im trying to get the choice fields in one cell like its displayed in SharePoint.
This is an Example Array Item:
{
"Product title": "Junior Sagaland",
"Article Number": "21372 6 ",
"Format": "Landscape format",
"Box size": "SG 40",
"Priority": "Prio Packaging + Content",
"Technology": [
{
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
"Id": 0,
"Value": "no power needed"
}
],
"Display unit": null,
"Animation": [],
"VKK": null,
"Marketing support": [],
"New": null,
"Availability": null,
"Segment": "Children games",
"Responsible IPM": "Sugg, Franziska",
"Subsidiary": "RSV",
"Availability-Status Packaging": "–",
"Availability-Status Decoration": [],
"Dimensions Content": null,
"Licence note": null,
"Silent Seller": null,
"Product focus": null,
"Status List": "in process",
"Quarter": null,
"Delete": false
}
I want the technology field displayed for each item in one cell. There could be multiple values or none.
Can anyone help me how to achieve this?