You’re offline. This is a read only version of the page.
Announcements
Hello,
I have a Power Automate Flow where I would like to take the details from a SharePoint list and have some of them populate into an Excel file that is copied into a folder on the same SharePoint. I have seen videos of people doing this and have followed along. However, I keep getting a Bad Gateway error and cannot figure out why. Some of the code has a "null" next to it which I assumed might be the problem. However, every data field has an entry so nothing should be empty. Below is my Excel Script Code, flow, and error. Is there a way to fix this? Again, I have seen many others accomplish this task so I know it is possible. Just need some expertise. Thanks!
Hi @bmorley2010 ,
Please try:
Share
Report
All responses (
Answers (
function main(workbook: ExcelScript.Workbook, Name: string | undefined, Manage: string | undefined ) {
let sheet1=workbook.getWorksheet("Sheet1");
sheet1.getRange("B3").setValue(Name);
sheet1.getRange("B4").setValue(Manage);
}
Best Regards,
Bof
503
