Answered

Data Value from Excel

(0) Share

Report

Posted on by Community Power Pla...

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:

Capture.2PNG.PNG

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

I have the same question (0)

All responses (8)

Answers (1)

Verified answer

ScottShearer 25,254 Most Valuable Professional on at

Like (1)

Report

Re: Data Value from Excel

@Anonymous

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

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Re: Data Value from Excel

Thanks so much Scott!!

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Re: Data Value from Excel

@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

Was this reply helpful? Yes No
ScottShearer 25,254 Most Valuable Professional on at

Like (0)

Report

Re: Data Value from Excel

@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.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Re: Data Value from Excel

Hi @ScottShearer , sure. Here they are:

Thank you!
Mila

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Re: Data Value from Excel

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

Was this reply helpful? Yes No
ScottShearer 25,254 Most Valuable Professional on at

Like (0)

Report

Re: Data Value from Excel

@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.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Re: Data Value from Excel

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

Was this reply helpful? Yes No