{"id":110945,"date":"2018-06-13T07:31:15","date_gmt":"2018-06-13T14:31:15","guid":{"rendered":"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/power-automate\/advanced-flow-of-the-week-when-a-new-item-is-created-automatically-populate-a-sharepoint-lookup-column-calculated-field\/"},"modified":"2025-06-11T08:08:15","modified_gmt":"2025-06-11T15:08:15","slug":"advanced-flow-of-the-week-when-a-new-item-is-created-automatically-populate-a-sharepoint-lookup-column-calculated-field","status":"publish","type":"post","link":"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/power-automate\/advanced-flow-of-the-week-when-a-new-item-is-created-automatically-populate-a-sharepoint-lookup-column-calculated-field\/","title":{"rendered":"Advanced | Flow of the Week: When a new item is created, automatically populate a SharePoint lookup column calculated field"},"content":{"rendered":"<p>This post will show how to automatically calculate and update a column in a SharePoint list when an item is created or modified.<\/p>\n<p>It&#8217;s common practice in SharePoint to use lookup columns to manage relationships between lists. Sometimes the list also needs to maintain a calculated field based on lookup column values selected, it could be as simple as sum of another column values in lookup column list or a complex formula. In this post we look at a simple sum of values from lookup column. Consider following two SharePoint lists that are used to manage the turbine energy distribution at Cronus energy.<\/p>\n<p>\u00a0<\/p>\n<h2>SharePoint Lists<\/h2>\n<p>\u00a0<\/p>\n<p><strong>Turbines List<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" height=\"326\" src=\"https:\/\/swatga.dm.files.1drv.com\/y4mg4IZIpYNE2ZwTnSys2SpqLGoD1BF2edyCB-HbsTwUuZ4oZqJs9fYMu7sR5XA2eUL0F3yxGApPFCdJ-Udzma8jsjj2AXELEhWqJ6M8yom5lFEwhR5e8UnljkfYUrSiQiwLNrtVtRnJSbMDKqNkj8Ji43grR8ROLU4uc8Qj_zwj1SLEB7Clskv5xgDtqnuMcTOGJSJ_nb2CW8LRJ0bTa1TCA?width=1028&amp;height=326&amp;cropmode=none\" width=\"1028\"\/><\/p>\n<p>This list contains different turbines available and corresponding maximum output capacity.<\/p>\n<p>\u00a0<\/p>\n<p><strong>Turbine Energy Distribution List<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" height=\"273\" src=\"https:\/\/rvefdg.dm.files.1drv.com\/y4mCC06QJQiLcPmF8_WwjT4WiGyuag_SGAlLtUEbkvs1PUNd1alXJ0X9OTXTufjRgffmlDO4qy0KaDBqM665ip4Od1zFNUOeCYD8Mt23f_dI4fHwQT-TNGF_6xBHEshDOGZajKD5Bc6kU2ygbp7UqZcmi7Iv_ZwvtYLYVfMjEBJtp5Lo10OSl5AwveGLlV75FomEZLxs4hqHa5hQQ22JyuTJg?width=1028&amp;height=273&amp;cropmode=none\" width=\"1028\"\/><\/p>\n<p>This list contains entries for weekly energy distribution by selecting a number of turbines from the Turbines list. One of the list column &#8216;Turbines&#8217; is a lookup column into Turbines list which allow multi-selection of turbines.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" height=\"467\" src=\"https:\/\/zwwfmw.dm.files.1drv.com\/y4mNgYSldCVo_xNlL1nv1VOai8gDfZS9kcstFYuuwlYXIiV5dwt-P8TRzAzpCMrbtXW3cVSByNjtQomwJk4m0ko3LS2mYQ0xFaswvG-VAEBfhqKJbHoIxeN_j6AqzSOj7rslMCKZatqaq9EKYNzNzX84LszRS5yGDY6jWzFTzl4P0lQkTXCxhEUL_-KIDTLkUwAyCBSFK3q-pP6Qxn_XE3ikA?width=1028&amp;height=467&amp;cropmode=none\" style='font-family: Tahoma, \"Helvetica Neue\", Arial, Helvetica, sans-serif; font-size: 13.008px; font-style: normal; font-weight: 400;' width=\"1028\"\/><\/p>\n<p>Details of lookup column configuration is shown below. The \u2018Turbines\u2019 column in \u2018Total Energy Distribution\u2019 list points\u00a0 to column \u2018Turbines Name\u2019 from \u2018Turbines\u2019 list. Also notice that \u2018Allow multiple values\u2019 checkbox is checked to allow selection of multiple turbines and ID\u00a0 field is checked in additional fields. The ID field allows us to look up the associated list item in the \u2018Turbines\u2019 list.<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"https:\/\/ddyfpg.dm.files.1drv.com\/y4mJtzRiLQgKyj-YOd-SwqQNLkReaUx-DkkRCS-LV-lGYFpumlDh0gwYS85pjiIy1qMiMq9kcJCLG8XRIOVAyfN_RVCkjMpSSIT2LLtanzbzR8_TwFfrcgIt49escH0iGVGDpQjkR0rtv3grxh6U4zlZQeMFtfQhu1MAJZjGPzPypAsdMBQSiQfqRpYUUQSHJwbVsdQk4w9FBYGLTlkg6r-og?width=453&amp;height=654&amp;cropmode=none\" style=\"width: 453px; height: 654px;\"\/><\/p>\n<p>Given above lists the goal is to automatically calculate the &#8216;Total energy&#8217; column value in &#8220;Turbine Energy Distribution&#8221; list for the all of the turbines selected whenever a new item is added or existing item is updated.<\/p>\n<p>\u00a0<\/p>\n<h2>Creating the Flow<\/h2>\n<p>The flow algorithm on a high level : Flow runs when an item is created or modified and then loops through the turbines selected in the lookup column to calculate the sum of the output energy capacity and finally updates the list to populate the \u2018Total energy\u2019 column with the calculated value.<\/p>\n<p>\u00a0<\/p>\n<p>Below are steps to implement the flow to achieve above goal.<\/p>\n<ul>\n<li>First add &#8220;When a new item is created or updated&#8221; trigger. This trigger fires whenever an item is modified or updated so that flow can handle the calculation in both cases and keep the Total energy value for any changes to selected Turbines.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" height=\"283\" src=\"https:\/\/njhdka.dm.files.1drv.com\/y4mf53gtxkLzId1yxJqqJGvpk_mGWpoK5w8LV2ytLzpKNsJzqXvDmaeoqMkrhhRmD-VoEChy3LuOPmMyG7Ebc0AIL907IlMyYbUav2bSYBuN0lHNoQHSwpy10EBpF8LMOsryYLM-k6PD3zLVPTkE-8rVlhIDycKNT3bAH5-F55L0R582sDDP4TXXEPe_zYCUrUC4aGllKkufVrzua7yGrmYPQ?width=1028&amp;height=283&amp;cropmode=none\" width=\"1028\"\/><\/p>\n<ul>\n<li>We need an integer variable to store the total energy value as we loop through all of the turbines list. Create &#8220;Initialize Variable&#8221; action&#8221; and Name the variable as &#8220;Total Energy Sum&#8221;. Select the &#8220;Type&#8221; to be an integer to store the energy capacity and set the initial value to 0.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" height=\"308\" src=\"https:\/\/ddyypg.dm.files.1drv.com\/y4m_4v9vmopbt_NkD-t7tZHOTSwaA_yleGzJLIfb2o7e1iscnKdbZla0EbHqAmduaZrAsRVzpgTnPD9tvlGEkTyxNIl8bGaEa_PgkAT8FplsSsX5x4bagUeaGG6F3mrpafupfJPkoHucHu7uaZHM_5E0mqoCZVwI23lBh6PtGHLz6GomBd1DNY0pyG0WeoZdsm0ZFySZxfAyLqxisgeapqeXA?width=1028&amp;height=308&amp;cropmode=none\" width=\"1028\"\/><\/p>\n<ul>\n<li>Next step we need to loop through all turbines to calculate the sum of the energy capacity for the selected turbines. Click on &#8220;New Step&#8221; and select &#8220;Add an apply to each&#8221; under &#8220;\u2026 More&#8221;.<\/li>\n<li>Click into\u00a0 \u2018Select an output from the previous steps\u2019 textbox and select &#8220;Turbines.ID&#8221; token from the Dynamics content. This is an array field that contains the Turbine Id&#8217;s from the &#8220;Turbines&#8221; list through lookup column relationship.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" height=\"413\" src=\"https:\/\/p6qqsa.dm.files.1drv.com\/y4meqp42iDB6OoPTBMVXijlyDMPhH948ElYQzS2rVAI3L9B40IPUvaqtEIakXLbxP_PIOJhXwz7HrjlAbxSviFzPgwspRnHusem-PY5BPNR1XqtACvhvjr38ohpRXZMnTuEOPaXYceRC5D5QzqPynVYbXXmjIMOfY-oMoPy8TvJsrL_N5tVCNOPDPBAQx83TI9MrN51GToFDpk9wo6w3NsORw?width=1028&amp;height=413&amp;cropmode=none\" width=\"1028\"\/> <img loading=\"lazy\" decoding=\"async\" height=\"458\" src=\"https:\/\/3zmojg.dm.files.1drv.com\/y4mROV08HMIXkS6USb1IeqwggUcqI8ZZisrqFBjDV0OdCG69hMb36TbF7OmROCo1hGCb9qrZrfgfbCKsz_Jr-gHnDssHsNHHTAqxMxBDqoU7tze9_J2fBTNsIUnp5ED3knyRlFEoDPGCVeA2lZYs_x13Ig01XdsmXVQwvKUxeN1eq5xi1OWF3elkHxarcfl7GHdy68Ugq6CRtXp6tLLfziCEQ?width=1028&amp;height=458&amp;cropmode=none\" width=\"1028\"\/><\/p>\n<ul>\n<li>Next step add &#8220;Get Item&#8221; to find the energy capacity for each turbine from the &#8220;Turbines&#8221; list. Configure the &#8220;Get Item&#8221; action with &#8220;Turbines&#8221; list and &#8220;Turbines:ID id&#8221; token which points to a specific turbine in the list.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" height=\"769\" src=\"https:\/\/e31d0w.dm.files.1drv.com\/y4mMTXfaBJOcZ6hYKBMyjUOE9DMaVAIEkKlHdaD3uEdvBS-SLUnu8HzIzwclw_OR2UfF8uBY6AFUvkUDUEaBYgO-KU4H78zlHR8KD96jyLAY1CJyF7ShBstOrIq_q0bg90b8cPcQM46DuEGWdGB6NubHtEuUyGlJzhs3SVW24NAv0JKV8tF2bAnxJdszgRC3gKMutU5vQrFupEdBpuAAbtVUQ?width=1028&amp;height=769&amp;cropmode=none\" width=\"1028\"\/><\/p>\n<ul>\n<li>Next step is to convert the turbine output capacity into an integer value and add it to the &#8220;Total Energy Sum&#8221; variable. Add &#8220;Increment variable&#8221; action, select variable name to be &#8220;Total Energy Sum&#8221; and use expression builder to convert &#8220;Max output Capacity&#8221; to an integer value. Select &#8220;Value&#8221; textbox and then click on &#8220;Expression&#8221; tab in the token picker. Enter function name int() and switch tab to &#8220;Dynamic content&#8221; and select token &#8220;Max Output Capacity&#8221; to set it as a parameter to int() function. Raw function expression should look like\u00a0 <em>&#8220;int(body(&#8216;Get_item&#8217;)?[&#8216;Max_x0020_Output_x0020_Capacity&#8217;])&#8221;. <\/em>Click on &#8220;OK&#8221; button on the token picker to update the value field with the expression.<\/li>\n<\/ul>\n<p><img decoding=\"async\" alt=\"\" src=\"https:\/\/qh9n6w.dm.files.1drv.com\/y4myPVyaANJ2lbRag0Z4YbSixKVHK_h8l_kaWZFhV5nx4USb89o8z-jipSo0U66EVuN1443mhElRRMuPusU5ebvVZlpd3gHJchTbZpdvXyqcsg5hdha2Ea6osMoQ2WAz68TZ1z99WRpR38PFWjYJ5Kvc_ZiKo9hVL0BIq_Sy4SeNk4yEfc75XVNfqJbQ6gpcv1uSqe30Kg5O6TfvD8lmxVpYA?width=1062&amp;height=464&amp;cropmode=none\" style=\"width: 1062px; height: 464px;\"\/><\/p>\n<p>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 We are done with logic to calculate the total energy inside the loop. Apply-each loop goes through each turbine and increments the &#8220;Total Energy Sum&#8221; variable with &#8220;Max output capacity&#8221; for each turbine.<\/p>\n<ul>\n<li>Next task is to update the &#8220;Turbine Energy Distribution&#8221; list with &#8220;Total Energy Sum&#8221; calculated in the above &#8216;apply-each&#8221; loop. Let&#8217;s add a condition and update the list item only when the total energy calculated doesn\u2019t match with existing item value. This is important since the update item will trigger the same flow and could lead to infinite loop without the condition. Add following condition action, select &#8220;Total Energy Sum&#8221; from variables, select &#8220;is not equal to&#8221; from the\u00a0drop-down and select integer value for the &#8220;Total Energy&#8221; from trigger outputs using int() function from expression builder.<\/li>\n<\/ul>\n<p>\u200b\u200b<img decoding=\"async\" alt=\"\" src=\"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/Condition_TotalEnergy.png\" style=\"width: 1138px; height: 377px;\"\/><\/p>\n<ul>\n<li>Select &#8216;Add an action&#8221; in &#8220;If yes&#8221; from the condition block and add &#8220;Update Item&#8221; action. Select the value for &#8216;Site Address&#8217; and select &#8216;Total Energy Distribution&#8217; for &#8216;List Name&#8217;. Configure the required fields with tokens &lt;ID&gt; and &lt;Week&gt;.\u00a0 Select Total Energy column and pick &#8220;Total Energy Sum&#8221; token from the &#8220;Variables&#8221; section in the token picker (If the variables section is empty, please select &#8216;see more&#8217; on the top right to see all of the tokens).<\/li>\n<\/ul>\n<p>\u200b\u200b<img decoding=\"async\" alt=\"\" src=\"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/UpdateItem_With_ConditionV2.png\"\/><\/p>\n<p>\u00a0\u00a0<\/p>\n<p>After adding all of the steps overall Flow looks like below.<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/OverallFlow.png\" style=\"width: 1200px; height: 953px;\"\/><\/p>\n<h2>\u00a0<\/h2>\n<h2>Testing the Flow<\/h2>\n<p>Go to SharePoint and add a new item to &#8220;Turbine Energy Distribution&#8221; list and select 4 turbines. Please note that &#8220;Total Energy&#8221; column would empty after creating the item, this column gets populated with the sum of the capacity of the turbines selected after Flow run.<\/p>\n<p>\u00a0<\/p>\n<p>Wait for few minutes and refresh the list item. As expected &#8220;Total Energy&#8221; field Is updated with sum of the capacity of the selected turbines in the list.<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"https:\/\/rveedg.dm.files.1drv.com\/y4mii6ryVWEiu8sC_WSGuGVanOlSQOcxxZtW6_xsGHdfGFgL1m4Tio4tHImyshb478QkMHryG3NMM11X3zY2cTulWPjtSkfv8JuFTKZjv0kjk3gP5BQVFgE3ilhF7Mpfxiqb6JRgznY6naCIlJKvkiNZrWCH-ogRhONeNP9CPcXfPfdi7Xb_ZJdxbr0CCkAMHr09XyTRDJq05npMEATp_f-pw?width=588&amp;height=559&amp;cropmode=none\" style=\"width: 588px; height: 559px;\"\/><\/p>\n<p>You can also verify that Flow run succeeded and &#8220;Update Item&#8221; in the run history would show &#8220;Total energy&#8221; column is updated with value 90 which is sum of output capacity for the selected turbines.<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"https:\/\/zwwemw.dm.files.1drv.com\/y4mnOOAvlaCcuJnKZQQHQcn2WxGt5ieJkFIgWtiZPQe6YwLoZHjBamhi8_YFeKHKHeQ-oNHfNH2xa4FxNg5jKMQJKYNYN1WEoVRSygx4LNXHFJdeQ0ZHu-ObRjkjeKh7uQm97H8B5m-eLHJDm3KIMow7xDHVkinj_1DsegzhEBWCz6FljmnKLysjFxUgkKUVCXKp-iAb31VTc2eCgbj8obQPA?width=992&amp;height=237&amp;cropmode=none\" style=\"width: 992px; height: 237px;\"\/><\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"https:\/\/njhcka.dm.files.1drv.com\/y4m6TP7UtJT1IaNIzPfDzr9OY2JwV3pqn5C5nghrHOlw2tBX_fwAHPTe4pst3gtRxnwHwzoFtH0TciBlRYB1Bo62GBRsJTJHcfKRmIBWBHmVFLj75lzQCpgBvcBztv_WerxGo6OiiaXP91TT1lbETcHUtVp25aR4V9LfeKkSf-PX2KKKAVAZqCMYqGpCgsSaLlkXN85tG0UOpqJ2a3xiv_trQ?width=573&amp;height=758&amp;cropmode=none\" style=\"width: 573px; height: 758px;\"\/><\/p>\n<p>This time update the list item and add one more turbine &#8220;Peace River &#8211; 004&#8221; and wait for the flow to run. Total Energy is automatically updated to 110 reflecting the sum of all the of turbines selected.<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"https:\/\/p6rgsa.dm.files.1drv.com\/y4miMcKSBGSflhD4WQ7eEQRpv7LjPMd1Ps20-je1dcLHhgdfQcNsQVXqDW8ZHPj9sCkYJqu4tChmgztAK8VkxrxAmeo6eUNurv5leZsrYKeu09aYx9Y-uSH7FfDfpQoayxNVcaonCMA1RGJ6PzwJR0pibo2Iy9sF_ub7lf9vEHjRpDyIaLGDjwCp_RM0mYx2Pmy3Q-BfPpVYYKr_pEq7ItqRg?width=1082&amp;height=290&amp;cropmode=none\" style=\"width: 1082px; height: 290px;\"\/><\/p>\n<p>\u00a0<\/p>\n<h2>Conclusion<\/h2>\n<p>In this blog post we learned how to use a loop to iterate through the list of items in a lookup column list, using &#8220;initialize variable&#8221; and &#8220;increment variable&#8221; actions to maintain the calculated value in a loop,<\/p>\n<p>using lookup columns to automatically update the calculated fields using the flow. You can download the flow created from <a href=\"https:\/\/procsi.blob.core.windows.net\/blog-images\/FOTWLookupColumnCalulatedField\/Auto-updatetotalenergydistribution.zip\">here<\/a>. If you have any questions please leave us comments below<\/p>\n","protected":false},"excerpt":{"rendered":"<p>This post will show how to automatically calculate and update a column in a SharePoint list when an item is created or modified.<\/p>\n","protected":false},"author":357,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"ms_queue_id":[],"ep_exclude_from_search":false,"_classifai_error":"","_classifai_text_to_speech_error":"","_alt_title":"","ms-ems-related-posts":[],"footnotes":""},"audience":[3378],"content-type":[3423],"job-role":[],"product":[3474],"property":[],"topic":[],"coauthors":[2933],"class_list":["post-110945","post","type-post","status-publish","format-standard","hentry","audience-it-professional","content-type-tips-and-guides","product-power-automate"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Advanced | Flow of the Week: When a new item is created, automatically populate a SharePoint lookup column calculated field - Microsoft Power Platform Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/2018\/06\/13\/advanced-flow-of-the-week-when-a-new-item-is-created-automatically-populate-a-sharepoint-lookup-column-calculated-field\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Advanced | Flow of the Week: When a new item is created, automatically populate a SharePoint lookup column calculated field - Microsoft Power Platform Blog\" \/>\n<meta property=\"og:description\" content=\"This post will show how to automatically calculate and update a column in a SharePoint list when an item is created or modified.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/power-automate\/advanced-flow-of-the-week-when-a-new-item-is-created-automatically-populate-a-sharepoint-lookup-column-calculated-field\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft Power Platform Blog\" \/>\n<meta property=\"article:published_time\" content=\"2018-06-13T14:31:15+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-06-11T15:08:15+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/swatga.dm.files.1drv.com\/y4mg4IZIpYNE2ZwTnSys2SpqLGoD1BF2edyCB-HbsTwUuZ4oZqJs9fYMu7sR5XA2eUL0F3yxGApPFCdJ-Udzma8jsjj2AXELEhWqJ6M8yom5lFEwhR5e8UnljkfYUrSiQiwLNrtVtRnJSbMDKqNkj8Ji43grR8ROLU4uc8Qj_zwj1SLEB7Clskv5xgDtqnuMcTOGJSJ_nb2CW8LRJ0bTa1TCA?width=1028&amp;height=326&amp;cropmode=none\" \/>\n<meta name=\"author\" content=\"Chandrakumar Bhumireddy\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Chandrakumar Bhumireddy\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/2018\/06\/13\/advanced-flow-of-the-week-when-a-new-item-is-created-automatically-populate-a-sharepoint-lookup-column-calculated-field\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/2018\/06\/13\/advanced-flow-of-the-week-when-a-new-item-is-created-automatically-populate-a-sharepoint-lookup-column-calculated-field\/\"},\"author\":[{\"@id\":\"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/author\/chandrakumar-bhumireddy\/\",\"@type\":\"Person\",\"@name\":\"Chandrakumar Bhumireddy\"}],\"headline\":\"Advanced | Flow of the Week: When a new item is created, automatically populate a SharePoint lookup column calculated field\",\"datePublished\":\"2018-06-13T14:31:15+00:00\",\"dateModified\":\"2025-06-11T15:08:15+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/2018\/06\/13\/advanced-flow-of-the-week-when-a-new-item-is-created-automatically-populate-a-sharepoint-lookup-column-calculated-field\/\"},\"wordCount\":1102,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/2018\/06\/13\/advanced-flow-of-the-week-when-a-new-item-is-created-automatically-populate-a-sharepoint-lookup-column-calculated-field\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/swatga.dm.files.1drv.com\/y4mg4IZIpYNE2ZwTnSys2SpqLGoD1BF2edyCB-HbsTwUuZ4oZqJs9fYMu7sR5XA2eUL0F3yxGApPFCdJ-Udzma8jsjj2AXELEhWqJ6M8yom5lFEwhR5e8UnljkfYUrSiQiwLNrtVtRnJSbMDKqNkj8Ji43grR8ROLU4uc8Qj_zwj1SLEB7Clskv5xgDtqnuMcTOGJSJ_nb2CW8LRJ0bTa1TCA?width=1028&amp;height=326&amp;cropmode=none\",\"keywords\":[\"Flow of the Week\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/2018\/06\/13\/advanced-flow-of-the-week-when-a-new-item-is-created-automatically-populate-a-sharepoint-lookup-column-calculated-field\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/2018\/06\/13\/advanced-flow-of-the-week-when-a-new-item-is-created-automatically-populate-a-sharepoint-lookup-column-calculated-field\/\",\"url\":\"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/2018\/06\/13\/advanced-flow-of-the-week-when-a-new-item-is-created-automatically-populate-a-sharepoint-lookup-column-calculated-field\/\",\"name\":\"Advanced | Flow of the Week: When a new item is created, automatically populate a SharePoint lookup column calculated field - Microsoft Power Platform Blog\",\"isPartOf\":{\"@id\":\"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/2018\/06\/13\/advanced-flow-of-the-week-when-a-new-item-is-created-automatically-populate-a-sharepoint-lookup-column-calculated-field\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/2018\/06\/13\/advanced-flow-of-the-week-when-a-new-item-is-created-automatically-populate-a-sharepoint-lookup-column-calculated-field\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/swatga.dm.files.1drv.com\/y4mg4IZIpYNE2ZwTnSys2SpqLGoD1BF2edyCB-HbsTwUuZ4oZqJs9fYMu7sR5XA2eUL0F3yxGApPFCdJ-Udzma8jsjj2AXELEhWqJ6M8yom5lFEwhR5e8UnljkfYUrSiQiwLNrtVtRnJSbMDKqNkj8Ji43grR8ROLU4uc8Qj_zwj1SLEB7Clskv5xgDtqnuMcTOGJSJ_nb2CW8LRJ0bTa1TCA?width=1028&amp;height=326&amp;cropmode=none\",\"datePublished\":\"2018-06-13T14:31:15+00:00\",\"dateModified\":\"2025-06-11T15:08:15+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/2018\/06\/13\/advanced-flow-of-the-week-when-a-new-item-is-created-automatically-populate-a-sharepoint-lookup-column-calculated-field\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/2018\/06\/13\/advanced-flow-of-the-week-when-a-new-item-is-created-automatically-populate-a-sharepoint-lookup-column-calculated-field\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/2018\/06\/13\/advanced-flow-of-the-week-when-a-new-item-is-created-automatically-populate-a-sharepoint-lookup-column-calculated-field\/#primaryimage\",\"url\":\"https:\/\/swatga.dm.files.1drv.com\/y4mg4IZIpYNE2ZwTnSys2SpqLGoD1BF2edyCB-HbsTwUuZ4oZqJs9fYMu7sR5XA2eUL0F3yxGApPFCdJ-Udzma8jsjj2AXELEhWqJ6M8yom5lFEwhR5e8UnljkfYUrSiQiwLNrtVtRnJSbMDKqNkj8Ji43grR8ROLU4uc8Qj_zwj1SLEB7Clskv5xgDtqnuMcTOGJSJ_nb2CW8LRJ0bTa1TCA?width=1028&amp;height=326&amp;cropmode=none\",\"contentUrl\":\"https:\/\/swatga.dm.files.1drv.com\/y4mg4IZIpYNE2ZwTnSys2SpqLGoD1BF2edyCB-HbsTwUuZ4oZqJs9fYMu7sR5XA2eUL0F3yxGApPFCdJ-Udzma8jsjj2AXELEhWqJ6M8yom5lFEwhR5e8UnljkfYUrSiQiwLNrtVtRnJSbMDKqNkj8Ji43grR8ROLU4uc8Qj_zwj1SLEB7Clskv5xgDtqnuMcTOGJSJ_nb2CW8LRJ0bTa1TCA?width=1028&amp;height=326&amp;cropmode=none\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/2018\/06\/13\/advanced-flow-of-the-week-when-a-new-item-is-created-automatically-populate-a-sharepoint-lookup-column-calculated-field\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Advanced | Flow of the Week: When a new item is created, automatically populate a SharePoint lookup column calculated field\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/#website\",\"url\":\"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/\",\"name\":\"Microsoft Power Platform Blog\",\"description\":\"Innovate with Business Apps\",\"publisher\":{\"@id\":\"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/#organization\",\"name\":\"Microsoft Power Platform Blog\",\"url\":\"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2020\/03\/Microsoft-Logo-e1685482038800.png\",\"contentUrl\":\"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2020\/03\/Microsoft-Logo-e1685482038800.png\",\"width\":194,\"height\":145,\"caption\":\"Microsoft Power Platform Blog\"},\"image\":{\"@id\":\"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/#\/schema\/person\/1b5e77384cdaf883e9971200527186e6\",\"name\":\"chandrakumar Bhumireddy\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/ba6c33e136209422ccacae4b14dc62ba906e49908e79472cb197a33bddefdabf?s=96&d=mm&r=g6ac45ca65b0698897d16d06b2b8f147d\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/ba6c33e136209422ccacae4b14dc62ba906e49908e79472cb197a33bddefdabf?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/ba6c33e136209422ccacae4b14dc62ba906e49908e79472cb197a33bddefdabf?s=96&d=mm&r=g\",\"caption\":\"chandrakumar Bhumireddy\"},\"url\":\"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/author\/chandbhu\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Advanced | Flow of the Week: When a new item is created, automatically populate a SharePoint lookup column calculated field - Microsoft Power Platform Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/2018\/06\/13\/advanced-flow-of-the-week-when-a-new-item-is-created-automatically-populate-a-sharepoint-lookup-column-calculated-field\/","og_locale":"en_US","og_type":"article","og_title":"Advanced | Flow of the Week: When a new item is created, automatically populate a SharePoint lookup column calculated field - Microsoft Power Platform Blog","og_description":"This post will show how to automatically calculate and update a column in a SharePoint list when an item is created or modified.","og_url":"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/power-automate\/advanced-flow-of-the-week-when-a-new-item-is-created-automatically-populate-a-sharepoint-lookup-column-calculated-field\/","og_site_name":"Microsoft Power Platform Blog","article_published_time":"2018-06-13T14:31:15+00:00","article_modified_time":"2025-06-11T15:08:15+00:00","og_image":[{"url":"https:\/\/swatga.dm.files.1drv.com\/y4mg4IZIpYNE2ZwTnSys2SpqLGoD1BF2edyCB-HbsTwUuZ4oZqJs9fYMu7sR5XA2eUL0F3yxGApPFCdJ-Udzma8jsjj2AXELEhWqJ6M8yom5lFEwhR5e8UnljkfYUrSiQiwLNrtVtRnJSbMDKqNkj8Ji43grR8ROLU4uc8Qj_zwj1SLEB7Clskv5xgDtqnuMcTOGJSJ_nb2CW8LRJ0bTa1TCA?width=1028&amp;height=326&amp;cropmode=none","type":"","width":"","height":""}],"author":"Chandrakumar Bhumireddy","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Chandrakumar Bhumireddy","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/2018\/06\/13\/advanced-flow-of-the-week-when-a-new-item-is-created-automatically-populate-a-sharepoint-lookup-column-calculated-field\/#article","isPartOf":{"@id":"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/2018\/06\/13\/advanced-flow-of-the-week-when-a-new-item-is-created-automatically-populate-a-sharepoint-lookup-column-calculated-field\/"},"author":[{"@id":"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/author\/chandrakumar-bhumireddy\/","@type":"Person","@name":"Chandrakumar Bhumireddy"}],"headline":"Advanced | Flow of the Week: When a new item is created, automatically populate a SharePoint lookup column calculated field","datePublished":"2018-06-13T14:31:15+00:00","dateModified":"2025-06-11T15:08:15+00:00","mainEntityOfPage":{"@id":"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/2018\/06\/13\/advanced-flow-of-the-week-when-a-new-item-is-created-automatically-populate-a-sharepoint-lookup-column-calculated-field\/"},"wordCount":1102,"commentCount":0,"publisher":{"@id":"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/#organization"},"image":{"@id":"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/2018\/06\/13\/advanced-flow-of-the-week-when-a-new-item-is-created-automatically-populate-a-sharepoint-lookup-column-calculated-field\/#primaryimage"},"thumbnailUrl":"https:\/\/swatga.dm.files.1drv.com\/y4mg4IZIpYNE2ZwTnSys2SpqLGoD1BF2edyCB-HbsTwUuZ4oZqJs9fYMu7sR5XA2eUL0F3yxGApPFCdJ-Udzma8jsjj2AXELEhWqJ6M8yom5lFEwhR5e8UnljkfYUrSiQiwLNrtVtRnJSbMDKqNkj8Ji43grR8ROLU4uc8Qj_zwj1SLEB7Clskv5xgDtqnuMcTOGJSJ_nb2CW8LRJ0bTa1TCA?width=1028&amp;height=326&amp;cropmode=none","keywords":["Flow of the Week"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/2018\/06\/13\/advanced-flow-of-the-week-when-a-new-item-is-created-automatically-populate-a-sharepoint-lookup-column-calculated-field\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/2018\/06\/13\/advanced-flow-of-the-week-when-a-new-item-is-created-automatically-populate-a-sharepoint-lookup-column-calculated-field\/","url":"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/2018\/06\/13\/advanced-flow-of-the-week-when-a-new-item-is-created-automatically-populate-a-sharepoint-lookup-column-calculated-field\/","name":"Advanced | Flow of the Week: When a new item is created, automatically populate a SharePoint lookup column calculated field - Microsoft Power Platform Blog","isPartOf":{"@id":"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/2018\/06\/13\/advanced-flow-of-the-week-when-a-new-item-is-created-automatically-populate-a-sharepoint-lookup-column-calculated-field\/#primaryimage"},"image":{"@id":"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/2018\/06\/13\/advanced-flow-of-the-week-when-a-new-item-is-created-automatically-populate-a-sharepoint-lookup-column-calculated-field\/#primaryimage"},"thumbnailUrl":"https:\/\/swatga.dm.files.1drv.com\/y4mg4IZIpYNE2ZwTnSys2SpqLGoD1BF2edyCB-HbsTwUuZ4oZqJs9fYMu7sR5XA2eUL0F3yxGApPFCdJ-Udzma8jsjj2AXELEhWqJ6M8yom5lFEwhR5e8UnljkfYUrSiQiwLNrtVtRnJSbMDKqNkj8Ji43grR8ROLU4uc8Qj_zwj1SLEB7Clskv5xgDtqnuMcTOGJSJ_nb2CW8LRJ0bTa1TCA?width=1028&amp;height=326&amp;cropmode=none","datePublished":"2018-06-13T14:31:15+00:00","dateModified":"2025-06-11T15:08:15+00:00","breadcrumb":{"@id":"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/2018\/06\/13\/advanced-flow-of-the-week-when-a-new-item-is-created-automatically-populate-a-sharepoint-lookup-column-calculated-field\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/2018\/06\/13\/advanced-flow-of-the-week-when-a-new-item-is-created-automatically-populate-a-sharepoint-lookup-column-calculated-field\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/2018\/06\/13\/advanced-flow-of-the-week-when-a-new-item-is-created-automatically-populate-a-sharepoint-lookup-column-calculated-field\/#primaryimage","url":"https:\/\/swatga.dm.files.1drv.com\/y4mg4IZIpYNE2ZwTnSys2SpqLGoD1BF2edyCB-HbsTwUuZ4oZqJs9fYMu7sR5XA2eUL0F3yxGApPFCdJ-Udzma8jsjj2AXELEhWqJ6M8yom5lFEwhR5e8UnljkfYUrSiQiwLNrtVtRnJSbMDKqNkj8Ji43grR8ROLU4uc8Qj_zwj1SLEB7Clskv5xgDtqnuMcTOGJSJ_nb2CW8LRJ0bTa1TCA?width=1028&amp;height=326&amp;cropmode=none","contentUrl":"https:\/\/swatga.dm.files.1drv.com\/y4mg4IZIpYNE2ZwTnSys2SpqLGoD1BF2edyCB-HbsTwUuZ4oZqJs9fYMu7sR5XA2eUL0F3yxGApPFCdJ-Udzma8jsjj2AXELEhWqJ6M8yom5lFEwhR5e8UnljkfYUrSiQiwLNrtVtRnJSbMDKqNkj8Ji43grR8ROLU4uc8Qj_zwj1SLEB7Clskv5xgDtqnuMcTOGJSJ_nb2CW8LRJ0bTa1TCA?width=1028&amp;height=326&amp;cropmode=none"},{"@type":"BreadcrumbList","@id":"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/2018\/06\/13\/advanced-flow-of-the-week-when-a-new-item-is-created-automatically-populate-a-sharepoint-lookup-column-calculated-field\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/"},{"@type":"ListItem","position":2,"name":"Advanced | Flow of the Week: When a new item is created, automatically populate a SharePoint lookup column calculated field"}]},{"@type":"WebSite","@id":"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/#website","url":"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/","name":"Microsoft Power Platform Blog","description":"Innovate with Business Apps","publisher":{"@id":"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/#organization","name":"Microsoft Power Platform Blog","url":"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2020\/03\/Microsoft-Logo-e1685482038800.png","contentUrl":"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2020\/03\/Microsoft-Logo-e1685482038800.png","width":194,"height":145,"caption":"Microsoft Power Platform Blog"},"image":{"@id":"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/#\/schema\/person\/1b5e77384cdaf883e9971200527186e6","name":"chandrakumar Bhumireddy","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/ba6c33e136209422ccacae4b14dc62ba906e49908e79472cb197a33bddefdabf?s=96&d=mm&r=g6ac45ca65b0698897d16d06b2b8f147d","url":"https:\/\/secure.gravatar.com\/avatar\/ba6c33e136209422ccacae4b14dc62ba906e49908e79472cb197a33bddefdabf?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ba6c33e136209422ccacae4b14dc62ba906e49908e79472cb197a33bddefdabf?s=96&d=mm&r=g","caption":"chandrakumar Bhumireddy"},"url":"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/author\/chandbhu\/"}]}},"bloginabox_animated_featured_image":null,"bloginabox_display_generated_audio":false,"distributor_meta":false,"distributor_terms":false,"distributor_media":false,"distributor_original_site_name":"Microsoft Power Platform Blog","distributor_original_site_url":"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog","push-errors":false,"_links":{"self":[{"href":"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/posts\/110945","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/users\/357"}],"replies":[{"embeddable":true,"href":"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/comments?post=110945"}],"version-history":[{"count":1,"href":"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/posts\/110945\/revisions"}],"predecessor-version":[{"id":131064,"href":"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/posts\/110945\/revisions\/131064"}],"wp:attachment":[{"href":"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/media?parent=110945"}],"wp:term":[{"taxonomy":"audience","embeddable":true,"href":"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/audience?post=110945"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/content-type?post=110945"},{"taxonomy":"job-role","embeddable":true,"href":"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/job-role?post=110945"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/product?post=110945"},{"taxonomy":"property","embeddable":true,"href":"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/property?post=110945"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/topic?post=110945"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/coauthors?post=110945"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}