Data Value from Excel

[Mila]

Hi everyone!

We are trying to build a Flow where data cells from a table in an Excel database are pulled into an e-mail notification to users. 

While selecting the 'Enrolment Date' dynamic content value to build the automated message works ok,

when the user receives the e-mail, the date is not show properly an looks like this:

We tried changing the column type in Excel to both Long Date, Short Date, Custom, and General. Nothing has worked. 

We tried using a date/time Expression as suggested by someone, however, when adding it in and then looking for the dynamic content value to insert, this is not listed:

Can anyone help?

Many thanks!

Mila

[ScottShearer · Accepted solution]

@Mila 

In youe Excel action, click on Advanced options and set the DateTime format to ISO 8601.

[Mila]

Thanks so much Scott!!

[Mila]

@ScottShearer 

Having applied this successfully, the new issue is that the date and time string in the automated message comes up as 

We do not have in the original spreadsheet - or want - the time to display. Any ideas?

Thanks

[ScottShearer]

@Mila 

One way to address this is to use a formatDateTime() expression.  If you post a screen shot of your Flow I can be more specific.

[Mila]

Hi @ScottShearer , sure. Here they are:

Thank you!

Mila

[Mila]

Hi @ScottShearer , just wondering if you have any ideas? Thanks!

[ScottShearer]

@Mila 

Where you are referencing the Date column from excel, use the following expression:

formatDateTime(YourColumnFromDynamicProperties,'yyyy-MM-dd')

You can substitute another date time format string for yyyy-MM-dd if you would like.

[Mila]

Hi @ScottShearer this does not work as the Column from dynamic properties does not show up.