When I have used the variable
ForAll(
Gallery1_4.AllItems As aExport,
Collect(
ColViewALL,
{
Name: aExport.Name,
'No. of hours spent on above task': aExport.'No. of hours spent on above task',
BU: aExport.BU,
QualityTask: aExport.QualityTask,
Activity: aExport.Activity,
'Core Function': aExport.'Core Function',
Status: aExport.Status.Value,
'Approver Name': aExport.'Approver Name',
'Employee ID': aExport.'Employee ID',
Location: aExport.Location,
Designation: aExport.Designation,
Department: aExport.Department,
'Created By': aExport.'Created By'.DisplayName,
Date: aExport.Date
}
)
);
Set(
varExportFile,
Concat(
ColViewALL,
Name & "," & 'No. of hours spent on above task' & "," & BU & "," & QualityTask & "," & Activity & "," & 'Core Function' & "," & Status & "," & 'Approver Name' & "," & 'Employee ID' & "," & Location & "," & Designation & "," & Department & "," & 'Created By' & "," & Date & Char(10)
)
);
KRCExportExcel.Run(varExportFile)
I'm greeting error
Powerautomate also running failed
