Same Exact Parallel Flow, one doesn't work.

[AfonsoTanida]

Hello, I have a flow that runs an excel script, then converts the that excel file into a csv table. Here is what it looks like:

The reason for the parallel flows is because the Excel file has more than 5000 rows I need to list. The parallel allows me to create 2 csv files, one with the first 5000 rows, the other with the rest (I don't have more than 10,000) by using an excel script to delete the first 5000 rows for the second csv file...

At least that's how it SHOULD work

For whatever reason, literally just adding this code to the Excel Script completely stops the flow from working:

// Delete range 2:5000 on selectedSheet
	selectedSheet.getRange("2:5000").delete(ExcelScript.DeleteShiftDirection.up);

"Why?" well, I have a "Select" step to format the dates from ISO 8601 to just MM/dd/yyyy. Which works PERFECTLY for the first csv file that doesn't have the first 5000 rows deleted. Here is the code for that "Select" step and the picture for a visual.

formatDateTime(Item()?['Planned Start Date'], 'MM/dd/yyyy')

Here is the error I get when I try to run the flow. And the picture again, for visuals.

The execution of template action 'Select_2' failed: The evaluation of 'query' action 'where' expression '{
  "Name": "@item()?['Name']",
  "ID": "@item()?['ID']",
  "Description": "@item()?['Description']",
  "Status": "@item()?['Status']",
  "Planned Start Date": "@formatDateTime(Item()?['Planned Start Date'], 'MM/dd/yyyy')",
  "Planned Finish Date": "@formatDateTime(Item()?['Planned Finish Date'], 'MM/dd/yyyy')",
  "Planned Work": "@item()?['Planned Work']",
  "Actual Start Date": "@item()?['Actual Start Date']",
  "Actual Finish Date": "@item()?['Actual Finish Date']",
  "Actual Work": "@item()?['Actual Work']",
  "Bill Rate": "@item()?['Bill Rate']",
  "Customer": "@item()?['Customer']",
  "Permissions": "@item()?['Permissions']",
  "Notes": "@item()?['Notes']",
  "Project Manager": "@item()?['Project Manager']",
  "CSR": "@item()?['CSR']",
  "Billing Type": "@item()?['Billing type']",
  "Job Type": "@item()?['Job Type']",
  "Department Name": "@item()?['Department Name']",
  "Department ID": "@item()?['Department ID']",
  "Budgeted duration (hours)": "@item()?['Budgeted duration (hours)']",
  "Budgeted Billing": "@item()?['Budgeted billing']",
  "Budgeted Cost Employee Cost": "@item()?['Budgeted Cost Employee Cost']",
  "Sage Status": "@item()?['Sage Status']",
  "Task": "@item()?['Task']",
  "Sage Customer": "@item()?['Sage Customer']",
  "Customer Number": "@item()?['Customer Number']"
}' failed: 'In function 'formatDateTime', the value provided for date time string '' was not valid. The datetime string must match ISO 8601 format.'.

If someone could help me out I would really, really appreciate it. I've been trying to fix this simple issue for HOURS.

Thank you.

[creativeopinion]

Instead of adding the additional code to the script to remove the rows from the existing table, have you tried to set

the Skip Count field in the List rows present in a table action in your parallel branch?

If I helped you solve your problem—please mark my post as a solution ✅.
Consider giving me a 👍 if you liked my response!

👉 Watch my tutorials on YouTube
👉 Tips and Tricks on TikTok

[AfonsoTanida]

Hello, I just tried that and I get the same error message.