"Skip Count" in "list rows present in a table" messing up "formatDateTime" function.

[AfonsoTanida]

Hello, I have a flow that converts an excel file to a .csv file.

One problem I originally had is that it was converting the dates from MM/dd/yyyy to xxxxx, the number of days between the date and 1/1/1900. I fixed this issue by using the following function in a "Select" step before creating the csv table. 

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

This worked, and I thought I was done with this particular flow.

Turns out, there is a 5000 row limit when using the step "List rows present in a table". So I thought okay, I'll just repeat with a "Do until" step and create 2 separate csv tables, one that has the first 5000 rows, the other that has the rest (I don't expect there to be more than 6k-7k rows for a while) because I can upload them individually for what I am doing.

The problem is that when I use the "Skip Count" field in "List rows present in a table", I get this error. 

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.'.

Does anyone know how I can fix this? Thanks. (If it could be fixed by somehow getting past the 5000 row limit, that would be great. So I wouldn't have to submit 2 csv files, I can just submit one.

[creativeopinion]

Have you tried to toggle on Pagination in the List Rows Present in a table action and set a threshold? 

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]

Yes, I can't go any higher than 5,000 items.