[URL] Worldwide Content Releastionship

<div><div data-sp-canvascontrol="" data-sp-canvasdataversion="1.0" data-sp-controldata="&#123;&quot;position&quot;&#58;&#123;&quot;layoutIndex&quot;&#58;1,&quot;zoneIndex&quot;&#58;1,&quot;sectionIndex&quot;&#58;1,&quot;sectionFactor&quot;&#58;12,&quot;controlIndex&quot;&#58;0&#125;,&quot;controlType&quot;&#58;3,&quot;id&quot;&#58;&quot;478d4eca-6a17-43af-a285-dbfc2f16972b&quot;,&quot;webPartId&quot;&#58;&quot;d1d91016-032f-456d-98a4-721247c305e8&quot;,&quot;rteInstanceId&quot;&#58;&quot;818cd1a5-2233-4c14-be7e-fac6e887a1bf&quot;,&quot;addedFromPersistedData&quot;&#58;true,&quot;reservedHeight&quot;&#58;780,&quot;reservedWidth&quot;&#58;1178&#125;"><div data-sp-webpart="" data-sp-webpartdataversion="1.11" data-sp-webpartdata="&#123;&quot;id&quot;&#58;&quot;d1d91016-032f-456d-98a4-721247c305e8&quot;,&quot;instanceId&quot;&#58;&quot;478d4eca-6a17-43af-a285-dbfc2f16972b&quot;,&quot;title&quot;&#58;&quot;Image&quot;,&quot;description&quot;&#58;&quot;Add an image, picture or photo to your page including text overlays and ability to crop and resize images.&quot;,&quot;audiences&quot;&#58;[],&quot;serverProcessedContent&quot;&#58;&#123;&quot;htmlStrings&quot;&#58;&#123;&#125;,&quot;searchablePlainTexts&quot;&#58;&#123;&#125;,&quot;imageSources&quot;&#58;&#123;&quot;imageSource&quot;&#58;&quot;/sites/M365-CDN/SiteAssets/SitePages/Content-20206/1549119297-image-9.jpg&quot;&#125;,&quot;links&quot;&#58;&#123;&#125;,&quot;customMetadata&quot;&#58;&#123;&quot;imageSource&quot;&#58;&#123;&quot;siteId&quot;&#58;&quot;40ef054e-5ec7-4552-ac92-09bbd4faa5e1&quot;,&quot;webId&quot;&#58;&quot;35f81bac-1b1d-4f8c-a038-0302a1a6ae55&quot;,&quot;listId&quot;&#58;&quot;870ffa3e-eb32-4905-82ab-9e57adb99968&quot;,&quot;uniqueId&quot;&#58;&quot;f9e140be-8f51-4949-928a-f0d4b6ce7fae&quot;,&quot;width&quot;&#58;2048,&quot;height&quot;&#58;1311&#125;&#125;&#125;,&quot;dataVersion&quot;&#58;&quot;1.11&quot;,&quot;properties&quot;&#58;&#123;&quot;id&quot;&#58;&quot;76ea3e29-517e-48ff-a6ed-6050487ceb00&quot;,&quot;linkUrl&quot;&#58;&quot;&quot;,&quot;isInlineImage&quot;&#58;true,&quot;siteId&quot;&#58;&quot;40ef054e-5ec7-4552-ac92-09bbd4faa5e1&quot;,&quot;webId&quot;&#58;&quot;35f81bac-1b1d-4f8c-a038-0302a1a6ae55&quot;,&quot;listId&quot;&#58;&quot;870ffa3e-eb32-4905-82ab-9e57adb99968&quot;,&quot;uniqueId&quot;&#58;&quot;f9e140be-8f51-4949-928a-f0d4b6ce7fae&quot;,&quot;imgHeight&quot;&#58;1311,&quot;imgWidth&quot;&#58;2048,&quot;imageSourceType&quot;&#58;2,&quot;alignment&quot;&#58;&quot;Center&quot;,&quot;fileName&quot;&#58;&quot;image-9.jpg&quot;,&quot;fixAspectRatio&quot;&#58;false,&quot;overlayText&quot;&#58;&quot;&quot;,&quot;altText&quot;&#58;&quot;&quot;&#125;,&quot;containsDynamicDataSource&quot;&#58;false&#125;"><div data-sp-componentid="d1d91016-032f-456d-98a4-721247c305e8"></div><div data-sp-htmlproperties=""><img data-sp-prop-name="imageSource" src="/sites/M365-CDN/SiteAssets/SitePages/Content-20206/1549119297-image-9.jpg" data-sp-cust-siteId="40ef054e-5ec7-4552-ac92-09bbd4faa5e1" data-sp-cust-webId="35f81bac-1b1d-4f8c-a038-0302a1a6ae55" data-sp-cust-listId="870ffa3e-eb32-4905-82ab-9e57adb99968" data-sp-cust-uniqueId="f9e140be-8f51-4949-928a-f0d4b6ce7fae" data-sp-cust-width="2048" data-sp-cust-height="1311" /></div></div></div><div data-sp-canvascontrol="" data-sp-canvasdataversion="1.0" data-sp-controldata="&#123;&quot;controlType&quot;&#58;4,&quot;id&quot;&#58;&quot;818cd1a5-2233-4c14-be7e-fac6e887a1bf&quot;,&quot;position&quot;&#58;&#123;&quot;layoutIndex&quot;&#58;1,&quot;zoneIndex&quot;&#58;1,&quot;sectionIndex&quot;&#58;1,&quot;sectionFactor&quot;&#58;12,&quot;controlIndex&quot;&#58;1&#125;,&quot;addedFromPersistedData&quot;&#58;true&#125;"><div data-sp-rte=""><p>As you know, working with&#160; <a data-cke-saved-href="https&#58;//learn.microsoft.com/en-us/dotnet/api/system.datetime?view=net-8.0&amp;WT.mc_id=DX-MVP-5004571" href="https&#58;//learn.microsoft.com/en-us/dotnet/api/system.datetime?view=net-8.0&amp;WT.mc_id=DX-MVP-5004571">DateTime&#160;</a> is never an easy task. Especially if you also combine your Power Automate flow with Dataverse (which by default support showing DateTime based on the System User &gt; Time Zone setting). So, today I will show a little bit of knowledge that I got while creating the Flow that I’ll show you.</p><p>I created a flow where I will call an API to get data that contains the DateTime (but in the Unix time format)&#58;</p><div tabindex="-1" data-cke-widget-wrapper="1" data-cke-filter="off" class="cke_widget_wrapper cke_widget_block cke_widget_inlineimage cke_widget_wrapper_webPartInRteInlineImage cke_widget_wrapper_webPartInRteClear cke_widget_wrapper_webPartInRteAlignCenter cke_widget_wrapper_webPartInRte" data-cke-display-name="div" data-cke-widget-id="0" role="region" aria-label="Inline image in RTE. Use Alt + F11 to go to toolbar. Use Alt + P to open the property pane."><div data-webpart-id="image" class="webPartInRte webPartInRteAlignCenter webPartInRteClear webPartInRteInlineImage cke_widget_element" data-cke-widget-data="%7B%22classes%22%3A%7B%22webPartInRteInlineImage%22%3A1%2C%22webPartInRteClear%22%3A1%2C%22webPartInRteAlignCenter%22%3A1%2C%22webPartInRte%22%3A1%7D%7D" data-cke-widget-upcasted="1" data-cke-widget-keep-attr="0" data-widget="inlineimage" data-instance-id="478d4eca-6a17-43af-a285-dbfc2f16972b" title=""></div></div><p><br></p><p><span class="fontSizeXLarge"><a data-cke-saved-href="https&#58;//temmyraharjo.wordpress.com/2023/05/06/power-automate-working-with-datetime-to-dataverse/" href="https&#58;//temmyraharjo.wordpress.com/2023/05/06/power-automate-working-with-datetime-to-dataverse/">Power Automate&#58; Working with DateTime to Dataverse – Temmy Wahyu Raharjo</a></span></p><p><a data-cke-saved-href="https&#58;//learn.microsoft.com/en-us/dotnet/api/system.datetime?view=net-8.0&amp;WT.mc_id=DX-MVP-5004571" href="https&#58;//learn.microsoft.com/en-us/dotnet/api/system.datetime?view=net-8.0&amp;WT.mc_id=DX-MVP-5004571">DateTime Struct (System) | Microsoft Learn</a></p><p>​​​​​​​<b>DateTime to Microsoft Dataverse</b></p><p>Microsoft Dataverse is a cloud-based platform that provides a secure and scalable data store for your applications. You can use it to store and manage data used by business applications. One of the common data types you might encounter while working with Dataverse is DateTime.<br></p><p><b>Create a new DateTime field&#58;</b></p><p>In the Microsoft Dataverse, you can create a new DateTime field by following these steps&#58;</p><ul><li>Go to the Power Apps portal&#58; <a data-cke-saved-href="https&#58;//make.powerapps.com/" href="https&#58;//make.powerapps.com/">https&#58;//make.powerapps.com/</a></li><li>Select your environment and click on &quot;Data&quot; in the left-hand navigation pane.</li><li>Click on &quot;Tables&quot; and then select the table where you want to add the DateTime field.</li><li>Click on &quot;Add Column&quot; and choose &quot;Date and Time&quot; as the data type.</li><li>Enter a name for the new DateTime field and configure its properties as needed (behavior, format, etc.).</li></ul><p><b>Formatting DateTime in Power Apps&#58;</b></p><ul><li>In Power Apps, you can format a DateTime field using the Text function. For example, to display a DateTime field in the format &quot;yyyy-MM-dd&quot;&#58;</li></ul><p><br></p><p><b>More links on about Power Automate and Date</b></p><p><br></p><ul><li>[Power Automate formatdatetime [with real examples]](<a data-cke-saved-href="https&#58;//www.spguides.com/power-automate-formatdatetime/" href="https&#58;//www.spguides.com/power-automate-formatdatetime/">https&#58;//www.spguides.com/power-automate-formatdatetime/</a>)</li></ul><p>Sep 15, 2022 — To get a decent or convenient date &amp; time format, we use formatDateTime() function in Power Automate Flow. This is done by passing the&#160;...</p><ul><li><a data-cke-saved-href="https&#58;//www.bythedevs.com/post/working-with-date-time-data-of-excel-in-power-automate" href="https&#58;//www.bythedevs.com/post/working-with-date-time-data-of-excel-in-power-automate">Working with Date &amp; Time data of Excel in Power Automate</a></li></ul><p>Dec 24, 2019 — Let's get Started! · Column formatting in Excel · Using expressions in Power Automate · Expression&#58; formatDateTime(addMinutes(concat(formatDateTime&#160;...</p><ul><li><a data-cke-saved-href="https&#58;//softchief.com/2021/09/13/use-of-date-time-expressions-guide-for-power-automate-complete-tutorial/" href="https&#58;//softchief.com/2021/09/13/use-of-date-time-expressions-guide-for-power-automate-complete-tutorial/">Use of Date &amp; Time Expressions Guide for Power Automate</a></li></ul><p>Sep 13, 2021 — formatDateTime, This expression returns the date format from a timestamp. Example to display in “yyyy-MM-dd” format then you have to pass like&#160;...</p><ul><li><a data-cke-saved-href="https&#58;//devoworx.net/format-date-in-power-automate/" href="https&#58;//devoworx.net/format-date-in-power-automate/">How To Format Date In Power Automate?</a></li></ul><p>Mar 25, 2022 — Use the FormatDateTime() function in Power Automate. 1) Ensure Date Field Fomat. Regardless of your current data source, you have first to make&#160;...</p></div></div><div data-sp-canvascontrol="" data-sp-canvasdataversion="1.0" data-sp-controldata="&#123;&quot;controlType&quot;&#58;0,&quot;pageSettingsSlice&quot;&#58;&#123;&quot;isDefaultDescription&quot;&#58;true,&quot;isDefaultThumbnail&quot;&#58;true,&quot;globalRichTextStylingVersion&quot;&#58;0,&quot;rtePageSettings&quot;&#58;&#123;&quot;contentVersion&quot;&#58;4&#125;,&quot;isEmailReady&quot;&#58;false&#125;&#125;"></div></div>

Power Automate: Working with DateTime to Dataverse

EN Main Home

Constantly the latest news, events and article about Microsoft 365 and Azure.

HubSite 365 - The network about Microsoft 365 and Azure.

EN Main Events

EN Main Dashboard

EN Main Role Pro Office 365

EN Main Role Citizen Developer

EN Main Role Data Analytics

EN Main Role Azure Datacenter

EN Main My365

EN Main Content

EN Main Search

EN Main News

EN Main Know-How

#More-News

Exploring PowerApps with AI Copilot

Mobile Mastery with Power BI

Dataverse for Teams – Formula Columns

Microsoft Teams vs Microsoft Team Premium and how to create and manage a Teams Webinar

SharePoint Search updates Juni 2023

Trigger Power Automate flows from Power Pages

Generate a PDF from a Modern Template in SharePoint with Microsoft Syntex

Dataverse integration for Microsoft Fabric

Supercharge Your Word Document using Microsoft Loop with Quizzes, Polls, Tasks and more!

#Top-News

Power Platform + AI (GPT-3 & ChatGPT)

Azure Infrastructure Weekly Update - 9th June 2023

Microsoft Word Tutorial - The Power of the @ symbol

OneNote - The Secret to Note-taking for Busy People

365 EduCon DC

EPPC European Power Platform Conference

Commsverse

Dynamics 365 Bootcamp CX Summit

Scottish Summit

365 EduCon and PWR EduCon Seattle

CollabCon

Events Slider Top 01

Breaking News 01

Footer01

Media of the Month 01

Lakehouse VS  Warehouse VS  Datamart   The Difference Between The Three Fabric Objects

Power Automate: Working with DateTime to Dataverse

As you know, working with DateTime is never an easy task. Especially if you also combine your Power Automate flow with Dataverse