//Create a collection for the data export
ClearCollect(colExport, {});
ForAll(GalleryAllRequests.AllItems, Collect(colExport, {ChangeNo: ThisRecord.ChangeNo.Text, Title: ThisRecord.Title4.Text, Origator: ThisRecord.Originator.Text, ChangeOwner: ThisRecord.ChangeOwner.Text, DateRaised: DateValue(ThisRecord.DateRaised.Text), Status: ThisRecord.StatusBtn.Text}));
RemoveIf(colExport, IsBlank(Title));
Set(varFileLink, 'ExportChangesToExcel'.Run({file:{contentBytes: JSON(colExport,JSONFormat.IgnoreUnsupportedTypes), name:Concatenate(varEV.projectname, "-", Now())}}).filelink);
Launch(varFileLink);
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.