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:
Getting this error but appears to be filling in data. Thoughts?
Hi @Armyrunner
I set up a Flow according to the information you provided, you can refer to the screenshot below to see if it helps.
This is my test excel and list.
Flow in details:
Note:'Planner Next Update (NU_x003a_)' and 'Planner Complete Date (CD_x003a_)' is 'Planner Next Update (NU:)' and DC 'Planner Complete Date (NU:)' column internal name.You can find it by add a compose action,then select the column,then hover the mouse on the column name, and its internal name will be displayed
Expression1:formatDateTime(addDays('1899-12-30',int(items('Apply_to_each')?['Planner Next Update (NU_x003a_)'])),'yyyy-MM-dd')
Expression2:formatDateTime(addDays('1899-12-30',int(items('Apply_to_each')?['Planner Complete Date (CD_x003a_)'])),'yyyy-MM-dd')
Save and test.
After flow runs, the list will be update like this:
Hope the content above may help you.
Best Regards
If my solution helps, then please consider Accept it as the solution to help the other members find it more quickly.