Power Platform Community Forum Thread Details

I have an issue where, after I added a few more lines of cell grabs to this script, it now is pulling the same value for all cells (being the last value) and errors saying they are all integers not string. I cannot figure out why all of a sudden this is failing as it was working fine until I added code as SD12Construction start:

function main(workbook: ExcelScript.Workbook): SOWDATA {
 let sheet = workbook.getWorksheet("SOW SMR");
 return {
 SiteID: sheet.getRange("C3").getValue(),
 SiteName: sheet.getRange("C4").getValue(),
 NONFIM: sheet.getRange("C10").getValue(),
 SD19S: sheet.getRange("C11").getValue(),
 SD19: sheet.getRange("C12").getValue(),
 SD20: sheet.getRange("C13").getValue(),
 PT: sheet.getRange("C14").getValue(),
 TotalRevenue: sheet.getRange("C15").getValue(),
 SD12ConstructionStart: sheet.getRange("D28").getValue(),
 SD12ConstructionComplete: sheet.getRange("E28").getValue(),
 SD19HopSubmission: sheet.getRange("F28").getValue(),
 SD19HopApproval: sheet.getRange("G28").getValue(),
 SD22DeliveryDate: sheet.getRange("H28").getValue(),
 } as SOWDATA;
}

interface SOWDATA {
 SiteID: string;
 SiteName: string;
 NONFIM: string;
 SD19S: string;
 SD19: string;
 SD20: string;
 PT: string;
 TotalRevenue: string;
 SD12ConstructionStart: string;
 SD12ConstructionComplete: string;
 SD19HopSubmission: string;
 SD19HopApproval: string;
 SD22DeliveryDate: string;
 }