List rows present in a table connector issue

[Anonymous]

Hi,

I'm using the List rows present in a table connector to retrieve data from my excel, the output is working fine, except the date in my excel is getting formated as number in the output, how can i fix this.

Date in my excel:10/18/2018, in the body i can see the ouput is read as below

Mid Project Assessment": "43391",

[v-yuazh-msft]

Hi @Anonymous,

The date time in Excel Online (Business) connector would be formated with string value, and the value have a relationship with the date time as below:

date time = (1900-01-01) +(Value-2)days

So you could refer to screenshot below to create the flow:

The expression in the Compose 2 as below:

formatDateTime(addDays('1900-01-01',add(int(outputs('Compose')),-2)),'yyyy-MM-dd')

The flow would run successfully as below:

Best regards,

Alice