"error": {
"code": "TriggerInputSchemaMismatch",
"message": "The input body for trigger 'manual' of type 'Request' did not match its schema definition. Error details: 'Invalid type. Expected String but got Null.'."
}
}
//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);


Report
All responses (
Answers (