DATE FROM EXCEL ONLINE TO POWER AUTOMATE HTML TABLE

[AdminofMk]

Hello Experts, 

I am very much rookie to Power automate. 

I am in the middle of building an approval flow. 

I tried to create a HTML table in email  from the excel data. 

but the date available in the column comes as integer rather proper date format. 

i gone through many solutions here  but cant get it right. because of the table column contains multiple variables. 

kindly Help on this issue. 

DATA TABLE. 

flow 

Output. 

[v-bofeng-msft]

Hi @AdminofMk ,

Please try:

addDays('1899-12-30',int('44896'))

Best Regards,

Bof

[AdminofMk]

Thanks @v-bofeng-msft , 

But cell value is dynamic, every time it changes based on the response through Forms.

secondly, where should we insert the compose output. 

[v-bofeng-msft]

Hi @AdminofMk ,

I suggest you store date values in text format instead of date format.

Best Regards,

Bof

[grantjenkins]

What method did you use to create your HTML table?

[AdminofMk]

@v-bofeng-msft 

[AdminofMk]

Hi @grantjenkins ,

I import the excel table using list rows present in the table. 

[v-bofeng-msft]

Hi @AdminofMk ,

Dates are saved as numbers in Excel, which represent the number of days (days difference from '1899-12-30'). If you format the date value to text, then it will be displayed as a number, and you just need to re-enter the date.

I think this link will help you a lot:

https://support.microsoft.com/en-us/office/datevalue-function-df8b07d4-7761-4a93-bc33-b7471bbff252#:....

Best Regards,

Bof

[AdminofMk]

HI @v-bofeng-msft ,

 the source of the date is from the Forms and it will update the . not entering anything in excel. 

Ms Forms Fields.

update a row with data from the forms input. 

[v-bofeng-msft]

Hi @AdminofMk ,

I've made a test for your reference:

My table:

My flow:

Result:

Best Regards,

Bof

[AdminofMk · Accepted solution]

Dear @v-bofeng-msft ,

I appreciate your effort on help me out on this issue. 

i have add the expression on the source data(microsoft forms) while mapping it to the excel, it will save as text with the desired date format.  and it is working fine.  

my 2 weeks of struggle finaly comes to an end. 

outputs('Get_response_details')?['body/raf6219c6f0b541168773e09b5deaaca7'] << i got this from peek code.

formatDateTime(outputs('Get_response_details')?
'body/raf6219c6f0b541168773e09b5deaaca7'],'dd/MM/yyyy')

[grantjenkins]

@AdminofMk Just wondering, if you are getting people to fill in a Microsoft Form then why don't you just have a trigger on When a new response is submitted, then get the response details and create your HTML Table? This will give you the dates in the correct format.

[AdminofMk]

Hi @grantjenkins 

  My Flow trigger is same as your said only. 

If i create HTML table directly from the Forms, then the table will be align horizontaly and will consume more space in email since the forms have more than 10 columns.

Moreover, before creating the table i need to add some dynamic value to the table so i needed to deal with excel.