Hello,
I'm struggling to add dates from Excel to sharepoint list without success.
Here is the issue i have.
On excel file i have colums A with string values.
On column B i have date values (in french format: DD/MM/YYYY
When i upload this file my flow detects this workbook, then creates table and then i need to create elements on my sharepoint list for each string and date values.
for the string i use this expression to retrieve these values: item()?['COLA']
and for the dates i use this expression : formatDateTime(
addDays('1899-12-30', int(item()?['DATE'])),
'dd/MM/yyyy'
)
The issue is that it only creates the first element for the first string and first date. but i have a total of 47 values to be added in my sharepoint list.
Please also note that i can have the same date for multiple cells and sometimes the same string multiple times in my workbook . it must import them all on my sharepoint list.
Could you help me please?
