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
Solved! Go to Solution.
In youe Excel action, click on Advanced options and set the DateTime format to ISO 8601.
In youe Excel action, click on Advanced options and set the DateTime format to ISO 8601.
Thanks so much Scott!!
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
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.
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.
Hi @ScottShearer this does not work as the Column from dynamic properties does not show up.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
30 | |
29 | |
27 | |
20 | |
11 |