Power Platform Community Forum Thread Details

Hi All,
here i have one requirment, i need to export gallery item as csv formate, but in this gallery we have one person and group column which is we need to seperate them into seperate columns and export
these are my list columns
1, Title - single line of text,
2, Host organization- single line of text,

3, Date and Time - Date and Time Column,
4, MultiSelectPeopleColumn - Person and Group Column.
the Below code is used for preparing collection and send to power automate for exporting
/****Code****/

Clear(ColForRestricted);

ForAll(
gal_Presentation_records.AllItems As currentItem
With({
NewObj:{ Title:currentItem.Title,
HostOrganizations:currentItem.'Host organization',
Year:Year(currentItem.'Date and Time')
},
AllNewObj:{}
},
//Define NewObj1

ForAll(currentItem.MultiSelectPeopleColumn As EachPerson,
With({ DisplayName:EachPerson.DisplayName,
//NewObj:Patch(NewObj,{Name:EachPerson.DisplayName})
AllNewObj:Patch(AllNewObj,{}, {Name:EachPerson.DisplayName})

},

Patch(NewObj,AllNewObj);

))
;
Collect(ColForRestricted,NewObj);
)

Thank you.

Categories:

Building Power Apps