cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Mila
Helper II
Helper II

Data Value from Excel

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,

Capture1.PNG

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:

Capture3.PNG

 

Can anyone help?

 

Many thanks!

Mila

1 ACCEPTED SOLUTION

Accepted Solutions
ScottShearer
Super User
Super User

@Mila 

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

image.png

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott

View solution in original post

8 REPLIES 8
ScottShearer
Super User
Super User

@Mila 

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

image.png

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott

Thanks so much Scott!!

Mila
Helper II
Helper II

@ScottShearer 

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

MicrosoftTeams-image.png

 

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

 

Thanks

ScottShearer
Super User
Super User

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

 

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott
Mila
Helper II
Helper II

Hi @ScottShearer , sure. Here they are:

 

Mila_0-1642678637959.png

Mila_1-1642678798333.png

Mila_2-1642678903432.png

Mila_3-1642678966439.png

 

Thank you!

Mila

 

 

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

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

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott

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

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

May UG Leader Call Carousel 768x460.png

June User Group Leader Call

Join us on June 28 for our monthly User Group leader call!

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Power Automate Designer Feedback_carousel.jpg

Help make Flow Design easier

Are you new to designing flows? What is your biggest struggle with Power Automate Designer? Help us make it more user friendly!

Top Solution Authors
Top Kudoed Authors
Users online (2,945)