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",
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
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
26 | |
24 | |
23 | |
14 | |
10 |
User | Count |
---|---|
57 | |
55 | |
29 | |
27 | |
24 |