I have been trying to figure this one out for weeks and can not find a solution. I hope someone can help. The goal is to add the missing dates (if they exist) for that record already in the SharePoint list from the Excel file. I have done this many times for other flows but this one is not working.
My Excel Spreadsheet:
Here is my data from the Excel spreadsheet . As you can see columns DB 'Planner Next Update (NU:)' and DC 'Planner Complete Date (NU:)' is what I am trying to import into my SharePoint list. Both columns have both dates and blanks.
Column B of the Excel file has the matching column values in 'CIR' to the list that I want the dates added to. The list column with the matching value is 'ProjCIR'.
My SharePoint List:
The SharePoint list fields 'NU' and 'CD' are formatted as Date/Time (Date only). The matching field to the Excel file is also 'ProjCIR' formatted as Single line of Text.
My Flow:
Second Step Detail:
Third step detail
with condition length(outputs('Get_items')?['body/value']):
***In my 1st fail I used the Excel values in Apply to each 2:
Flow error:
Update item error:
***My 2nd fail I used addDays('1899-12-30',int(),'yyyy-MM-dd') in Apply to each 2:
Flow error:
Update item error:
