{"id":232,"date":"2024-01-20T16:39:26","date_gmt":"2024-01-20T16:39:26","guid":{"rendered":"https:\/\/kb.ctse.nl\/?page_id=232"},"modified":"2024-05-05T11:20:23","modified_gmt":"2024-05-05T11:20:23","slug":"powerdoc-flow-template-tips-trics","status":"publish","type":"page","link":"https:\/\/kb.ctse.nl\/?page_id=232","title":{"rendered":"Flow Template: Tips &#038; Trics"},"content":{"rendered":"\n<p><strong>If you retrieve Dataverse data<\/strong><\/p>\n\n\n\n<p>Getting the formatted value of a picklist, lookup, date or number field, use an expression and add <em>@OData.Community.Display.V1.FormattedValue<\/em> after the field name like this:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>outputs('Get_opportunity')?&#91;'body\/my_somepicklist@OData.Community.Display.V1.FormattedValue']\nor\noutputs('Get_opportunity')?&#91;'body\/_parentcustomerid_value@OData.Community.Display.V1.FormattedValue']<\/code><\/pre>\n\n\n\n<p>For gettting current date, use an expression like this:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>utcNow()<\/code><\/pre>\n\n\n\n<p>For formatting values, use an expression like this:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>\/\/ formatting number with 2 decimals in Dutch notation:\nformatNumber(outputs('Get_opportunity')?&#91;'body\/my_somenumber']), 'N2', 'nl-NL')<\/code><\/pre>\n\n\n<pre class=\"wp-block-code\"><code>\/\/ or formatting number with 2 decimals in Dutch notation with Euro currency:\nformatNumber(outputs('Get_opportunity')?&#91;'body\/my_somenumber']), 'C2', 'nl-NL')<\/code><\/pre>\n\n\n<pre class=\"wp-block-code\"><code>\/\/ or extracting the year from a utc date in West European timezone\n\/\/ (almost all dates in Dataverse are utc):\nformatDateTime(convertFromUtc(outputs('Get_opportunity')?&#91;'body\/my_somedate'], 'W. Europe Standard Time'), 'yyyy')<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>If you retrieve Dataverse data Getting the formatted value of a picklist, lookup, date or number field, use an expression and add @OData.Community.Display.V1.FormattedValue after the field name like this: For gettting current date, use an expression like this: For formatting values, use an expression like this:<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":274,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-232","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/kb.ctse.nl\/index.php?rest_route=\/wp\/v2\/pages\/232","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kb.ctse.nl\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/kb.ctse.nl\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/kb.ctse.nl\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kb.ctse.nl\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=232"}],"version-history":[{"count":7,"href":"https:\/\/kb.ctse.nl\/index.php?rest_route=\/wp\/v2\/pages\/232\/revisions"}],"predecessor-version":[{"id":426,"href":"https:\/\/kb.ctse.nl\/index.php?rest_route=\/wp\/v2\/pages\/232\/revisions\/426"}],"up":[{"embeddable":true,"href":"https:\/\/kb.ctse.nl\/index.php?rest_route=\/wp\/v2\/pages\/274"}],"wp:attachment":[{"href":"https:\/\/kb.ctse.nl\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=232"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}