cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

List rows present in a table connector issue

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",

1 REPLY 1
v-yuazh-msft
Community Support
Community Support

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:

Capture.PNG

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:

Capture.PNG

 

 

Best regards,

Alice

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (3,629)