{"id":7221,"date":"2024-10-29T12:40:55","date_gmt":"2024-10-29T12:40:55","guid":{"rendered":"https:\/\/softreetechnology.com\/blog\/?p=7221"},"modified":"2024-10-29T12:41:44","modified_gmt":"2024-10-29T12:41:44","slug":"auto-populate-sharepoint-list-columns","status":"publish","type":"post","link":"https:\/\/softreetechnology.com\/blog\/sharepoint\/auto-populate-sharepoint-list-columns\/","title":{"rendered":"Auto Populate SharePoint List Columns Based on Value in One Column using Power Automate"},"content":{"rendered":"\n<p>Do you want to auto populate SharePoint list columns based on the value in one column using Power Automate? In this case study, we will see how to auto populate SharePoint list columns based on value in one column using Power Automate.<\/p>\n\n\n\n<p>For example, I have a SharePoint list called Employee Directory, which contains the following columns:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>First Name<\/li><li>Last Name<\/li><li>Joining Date<\/li><li>Department<\/li><li>Organization Email<\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXeqRPrtR558RRdi7_HWyBW_eraMqnr0d_-DkkIlt0Wjc2Y_AOIrfy2u0OZUTn--MmXtV7mOvF6NZL7F-2innogoey8i_mHEF4riaOyAu-Fb-B0o_mLhzwhUnt6ygiLyPScINrVzoihv3lPX8NlxnhqOqSpfya7M_jIirHg_F0T7281SPQBzIac?key=Eb8aYkzsVayS3x0YJ1SeU1Iv\" alt=\"\"\/><\/figure>\n\n\n\n<p>When a new employee is added to the list, we will automatically generate an email address by using First name and Last name. For example, first name =Bibhuti and Last name = dakua, then the email ID will be <a href=\"mailto:bibhuti.dakua@domain.com\">bibhuti.dakua@domain.com<\/a>.<\/p>\n\n\n\n<p>Let\u2019s say another employee joins the organization with the same name, in that case, the email id will be generated as <a href=\"mailto:Bibhuti.Dakua1@domain.com\">Bibhuti.Dakua1@domain.com<\/a>.<\/p>\n\n\n\n<p>Let\u2019s see how we can auto-populate the email ID based on the first name and last name column using Power Automate.<\/p>\n\n\n\n<p><strong>Auto Populate SharePoint list columns based on the value in one column using Power Automate<\/strong><\/p>\n\n\n\n<p>Here we will see how we can auto-populate SharePoint list columns based on the value in one column using Power Automate.<\/p>\n\n\n\n<p>Follow the below steps to auto-populate SharePoint list columns based on the value in one column using Power Automate.<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Open Power Automate Cloud, click on \u201c<strong>+Create<\/strong>\u201d, and select <strong>Automated Cloud flow<\/strong>.<\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXd9ks-YSzLqsCgF2BVC26om_GTlXf2JJWnaM3dGxp0o5u4uSLxTZ2lK3IFwgyMPUMiA4OdjVwWFCI0tQ5rQ7rfe5cdOAxWT6-Nxr79JVGzOfUiAbQ6el30MVRMDyTr8cgcYpK6a_GzvlucsRPAMmDZZffOHjNF1SqJbJ73vxJliyhBCMPPV9Q?key=Eb8aYkzsVayS3x0YJ1SeU1Iv\" alt=\"\"\/><\/figure>\n\n\n\n<ul class=\"wp-block-list\"><li>Then provide the flow name and select the When an item is created action. Then click on <strong>Create<\/strong>.<\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXfnMUA19VbA1Tyaer1ZVSmker9GBxG78JrE87SZU5MHGUSNivkpTrFcgVdn4Z3lCdmivIwZi7sfVscYIISmk8HTeE_cHliJqs4D6La1Fhuc63Xmfk9vMfFjLeZVNy9-8MRcH0gahLDLGO6XZGunuOhpjd0_R-QZ5n-U7uS4tqWZfcDbJbk9Ig?key=Eb8aYkzsVayS3x0YJ1SeU1Iv\" alt=\"\"\/><\/figure>\n\n\n\n<ul class=\"wp-block-list\"><li>Now, you can <strong>When an item is created action<\/strong> is added to the flow. Provide the below information:<br><br><strong>Site address<\/strong>: Provide the SharePoint site address.<br><strong>List name<\/strong>: Provide the list name.<\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXd_WxA8QvdtWRqfHPJqL-xfDogWn860Vu1038bzUoL3V4EazGqfoTBwrmdxODPMyu45MHjownnATV0N5H5SWe48Li1318_ezmevcK7PFuvdltya9aWpwnSZSaDQVaqYOGiwUXNy8HWG3j18yaxA-v40wZsd85M6zMenX_96yN-rwj8dg1r0uA?key=Eb8aYkzsVayS3x0YJ1SeU1Iv\" alt=\"\"\/><\/figure>\n\n\n\n<ul class=\"wp-block-list\"><li>Next, we will create the first part of the email. for this, click on <strong>+New step <\/strong>-&gt; select Compose action. Then provide the below information:<br>Inputs: Provide like below<br><strong>@{triggerOutputs()?[&#8216;body\/Title&#8217;]}.@{triggerOutputs()?[&#8216;body\/Lastname&#8217;]}<\/strong><\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXfgZHvBVxL7kK158O-i_WuThWmTIAa5c3NCEa2xZ9jfRDNaU2XcKEzJd1TNRYeGMd8U9xxJlQ7m38aBZZtxHeem0t_Cdt_XfCRrzvXIbOVa_xMOXoguStDJ70qrxi9PPJuE4HUCUSWi8VystHtItralW1DRVEZYxNabO5_bI95hx7mEfF3PvoI?key=Eb8aYkzsVayS3x0YJ1SeU1Iv\" alt=\"\"\/><\/figure>\n\n\n\n<ul class=\"wp-block-list\"><li>Now we initialize a variable, where we will store their email address, for this click on the <strong>+New step<\/strong> -&gt; select <strong>Initialize variable<\/strong> action. Then provide the below information:<br><strong>Name<\/strong>: Provide the variable name<br><strong>Type<\/strong>: Select the type as string<\/li><\/ul>\n\n\n\n<p><strong>Value<\/strong>: Provide the value like below:<br><strong>@{outputs(&#8216;Compose&#8217;)}@szgql.onmicrosoft.com<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXeeeQ2SfeEEPJhUqSrxts7kKuCeNgCTTIXsls6RDmB76hBLWWhiKEiEmaIAo8E33Y3xfSBF8C-ULcWah6Nks1gCDysmqfcsgYfGcSlC1heZjeMBgVW04IUmlGuCCJhMgtoce7k_cCOdhpKQqWeq50OIvjzSkVXpDi95kcSZUh01WeWGzfjPLQ?key=Eb8aYkzsVayS3x0YJ1SeU1Iv\" alt=\"\"\/><\/figure>\n\n\n\n<ul class=\"wp-block-list\"><li>We will get the items from the SharePoint list, whose email address contains the firstname. lastname, of the current employee.<\/li><\/ul>\n\n\n\n<p>For this, click on +New step -&gt; select \u2018Get items action. Then provide the below information:<\/p>\n\n\n\n<p>Site address: Provide the SharePoint site address<br>List name: Provide the list name<br>Filter query: Provide the query like below:<\/p>\n\n\n\n<p><strong>substringof(&#8216;@{Outputs(&#8216;Compose&#8217;)}&#8217;,Organization Email)<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXehW6DHsWB4XyEykvR2ldtRwksWRkx1dQLJdvca6K4OzEFQhxbUqB2WySIGlArgqMumZnYOG3PaFmnH88dawjHvgfdAVo82eU-m5HPwAw9ltP26u8pxsV-wz7iOzLctkIbJoPgk8o8MgV-z1QJTIWcn_25KMGtPiIKTl4pXfvqAzlwY5R9x540?key=Eb8aYkzsVayS3x0YJ1SeU1Iv\" alt=\"\"\/><\/figure>\n\n\n\n<ul class=\"wp-block-list\"><li>Next, we will <strong>initialize another variable<\/strong> which we will use as a counter, for this, click on <strong>+New step<\/strong> -&gt; <strong>select Initialize variable action<\/strong>. Then provide the below information:<br><strong>Name<\/strong>: Provide the variable name<br><strong>Type<\/strong>: Select the type as Integer<br><strong>Value<\/strong>: Provide the value as 0<\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXerGclrkKzNjciHbOB51Y204n31Dz1r3vs24N6fDs2biycA_uJajXAWtWZEuPrQFdQ7MTwr9dWB9Ig_8fFofcSGdTQ35r_LRTdSa_cNNb-XlBOnkuhsuyZ0AIb4_3MJDOZ0cDEoZFJjW0OW-pkAnxNb4Cko372mwADzsFE4L2UGyOIkIM9pA0s?key=Eb8aYkzsVayS3x0YJ1SeU1Iv\" alt=\"\"\/><\/figure>\n\n\n\n<ul class=\"wp-block-list\"><li>Now we will check the organization\u2019s email, for this click on +New step -&gt; select Condition action. Then provide the below information:<br>Choose a value: Select the <strong>OrgEmail<\/strong> variable from <strong>dynamic content<\/strong>.<br>Operator: Select the operator as <strong>is equal to<\/strong><br>Choose a value: Select the <strong>Organizational Email -Get items<\/strong>, from dynamic content. This will automatically apply to each action.<\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXf-Evt3HueLfqnofU1W0mHKYmO6XMK9_YnayVCiov3w1NrcqnWaXuIGb6Rms73-dO-OTyPcQVEIM0mpjDBFaiEJnhUt8M9N6OMlFpqMj3V7gdehQoUUkwLZBe8Lqg9r6zmCM5EXjzrITj4uoduAq0txoNHVCGxZ1rgAfdTrRdXgJCr3ttoLiQ?key=Eb8aYkzsVayS3x0YJ1SeU1Iv\" alt=\"\"\/><\/figure>\n\n\n\n<ul class=\"wp-block-list\"><li>Now if the condition becomes true, that means the email exists in the list. So, in the If yes part we will increment the counter by 1 and set the email with the counter.<br><br>First, in the If Yes part of the condition, click on <strong>Add an action<\/strong> -&gt; select <strong>Increment variable action<\/strong>. Then, provide the information below.<br><br><strong>Name:<\/strong> Select the name as Counter.<\/li><\/ul>\n\n\n\n<p><strong>Value:<\/strong> Provide the value as 1.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXceuFopcFxbOvHg0LYAUbsVjVQ9JVOZinY6ngP56T0SQvJYQzl2UvrDiv_GLVOmeyIbdDeGDA0gUFSnkawGBHXBxIrW0OUr_k8notwYilde3B5-t18PlTJ9eJGUmEX12DPwYLW1Uz2HmTdIHqR8M1uW_LjQotBhVttGTLzF358wncEQWjC63w?key=Eb8aYkzsVayS3x0YJ1SeU1Iv\" alt=\"\"\/><\/figure>\n\n\n\n<ul class=\"wp-block-list\"><li>Next, we will set the organization email; for this, click on <strong>Add an action<\/strong> -&gt; select <strong>Set variable<\/strong> <strong>action<\/strong>. Then provide the below information:<br><strong>Name<\/strong>: Select the variable name.<\/li><\/ul>\n\n\n\n<p><strong>Value<\/strong>: provide the value like below.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXeNrEhRDRWS1NudtmSxAvsXecE05gy9FENsKVRxINqruRB1vtyR2E-lNEwel4y8lXozXePMYbq7hqEn0S0Y02nn8d0Gi07Tu6k1rkOam0NTfQJ0eR2AEIlV7f_ZYBjt9pKF6u_zXKofrMLMqeLTjZ9IVxHBjkJsqIjGKktn5NTeSzTueHQJVQ?key=Eb8aYkzsVayS3x0YJ1SeU1Iv\" alt=\"\"\/><\/figure>\n\n\n\n<ul class=\"wp-block-list\"><li>Now, if the condition is false then the email does not exist in the list, so we can use the email. So we can directly update the email in the SharePoint list. For this, click on +New step -&gt; select Update site action.<\/li><\/ul>\n\n\n\n<p><br>Then provide the below information:<br><strong>Site address<\/strong>: Provide the SharePoint site address.<br><strong>List name<\/strong>: Provide the list name<br><strong>Id<\/strong>: Select the id from dynamic content<\/p>\n\n\n\n<p><strong>Organization email<\/strong>: Select OrgEmail from dynamic content.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXe1xJgz3zOKDXPi2MDoliEKupl73vVQaB5l5qZeIlnmuvrT8yKlX_re9WfO6msyR3u1xGPLI74yeQ0GSXK0WBcRbkU14eTlUahgkjIvKizKOwt2sKwXfda_JUNnAXEIkEyybZ4wfZUpG14rvkGVSC0t6ZWQp9y3Ssu0eZPEOOLm20H846PbQA?key=Eb8aYkzsVayS3x0YJ1SeU1Iv\" alt=\"\"\/><\/figure>\n\n\n\n<ul class=\"wp-block-list\"><li>Now run the flow manually and create an item in the SharePoint list to make the flow trigger.<\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXeJAEt5YHtmgwim0STgZ_mWdO_HXmXsCpHkzCsOGlXNqIOi_VMR1Vaoecj5SX7haN53LM5rJm0F-t22f9DJ4lOmxxT7ASICZWSZbP5dZBFZ9or1BGN6RqPypK_wNQfA4XXVEad6gOYZvKJQtFLwhLcj1ajV3e7utoj1Dc12kYMpfI4WvFKW3Q0?key=Eb8aYkzsVayS3x0YJ1SeU1Iv\" alt=\"\"\/><\/figure>\n\n\n\n<ul class=\"wp-block-list\"><li>The Organization email is autogenerated with the Organization email field in SharePoint<\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXe-VnTwEwUZnp_o7cRy6tP1Lt9pJZvu4dsT6K5k0Z1jI_SwE1q11PEeIkVW_pZanKx1TFJwmRZCaDGumHPcUwSKvd4bXTCqmfJaZyLe4B0i87metQXjyK7DNR_OJPQUOAebgBKqEdY6Dv68JhzEmjL18Uz9iBZaq5uHzJ6WO-aVfVDBzyXdWgI?key=Eb8aYkzsVayS3x0YJ1SeU1Iv\" alt=\"\"\/><\/figure>\n\n\n\n<p>This is how to auto populate SharePoint list columns based on the value in one column using Power Automate.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Do you want to auto populate SharePoint list columns based on the value in one column using Power Automate? In this case study, we will see how to auto populate SharePoint list columns based on value in one column using Power Automate. For example, I have a SharePoint list called Employee Directory, which contains the following columns: First Name Last [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":7222,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[43],"tags":[376,341,56,377],"class_list":["post-7221","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sharepoint","tag-auto-populate-sharepoint-list-columns","tag-power-automate","tag-sharepoint","tag-sharepoint-list-automation"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.6 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Auto Populate SharePoint List Columns Based on Value in One Column using Power Automate - Softree Technology<\/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:\/\/softreetechnology.com\/blog\/sharepoint\/auto-populate-sharepoint-list-columns\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Auto Populate SharePoint List Columns Based on Value in One Column using Power Automate - Softree Technology\" \/>\n<meta property=\"og:description\" content=\"Do you want to auto populate SharePoint list columns based on the value in one column using Power Automate? In this case study, we will see how to auto populate SharePoint list columns based on value in one column using Power Automate. For example, I have a SharePoint list called Employee Directory, which contains the following columns: First Name Last [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/softreetechnology.com\/blog\/sharepoint\/auto-populate-sharepoint-list-columns\/\" \/>\n<meta property=\"og:site_name\" content=\"Softree Technology\" \/>\n<meta property=\"article:published_time\" content=\"2024-10-29T12:40:55+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-10-29T12:41:44+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/softreetechnology.com\/blog\/wp-content\/uploads\/2024\/10\/Auto-Populate-SharePoint-List-Columns-Based-on-Value-in-One-Column-using-Power-Automate.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1080\" \/>\n\t<meta property=\"og:image:height\" content=\"1080\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Auto Populate SharePoint List Columns Based on Value in One Column using Power Automate - Softree Technology","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:\/\/softreetechnology.com\/blog\/sharepoint\/auto-populate-sharepoint-list-columns\/","og_locale":"en_US","og_type":"article","og_title":"Auto Populate SharePoint List Columns Based on Value in One Column using Power Automate - Softree Technology","og_description":"Do you want to auto populate SharePoint list columns based on the value in one column using Power Automate? In this case study, we will see how to auto populate SharePoint list columns based on value in one column using Power Automate. For example, I have a SharePoint list called Employee Directory, which contains the following columns: First Name Last [&hellip;]","og_url":"https:\/\/softreetechnology.com\/blog\/sharepoint\/auto-populate-sharepoint-list-columns\/","og_site_name":"Softree Technology","article_published_time":"2024-10-29T12:40:55+00:00","article_modified_time":"2024-10-29T12:41:44+00:00","og_image":[{"width":1080,"height":1080,"url":"https:\/\/softreetechnology.com\/blog\/wp-content\/uploads\/2024\/10\/Auto-Populate-SharePoint-List-Columns-Based-on-Value-in-One-Column-using-Power-Automate.png","type":"image\/png"}],"author":"admin","twitter_card":"summary_large_image","twitter_misc":{"Written by":"admin","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/softreetechnology.com\/blog\/sharepoint\/auto-populate-sharepoint-list-columns\/#article","isPartOf":{"@id":"https:\/\/softreetechnology.com\/blog\/sharepoint\/auto-populate-sharepoint-list-columns\/"},"author":{"name":"admin","@id":"https:\/\/softreetechnology.com\/blog\/#\/schema\/person\/98740297642f06debccdcee2de84086b"},"headline":"Auto Populate SharePoint List Columns Based on Value in One Column using Power Automate","datePublished":"2024-10-29T12:40:55+00:00","dateModified":"2024-10-29T12:41:44+00:00","mainEntityOfPage":{"@id":"https:\/\/softreetechnology.com\/blog\/sharepoint\/auto-populate-sharepoint-list-columns\/"},"wordCount":773,"commentCount":0,"publisher":{"@id":"https:\/\/softreetechnology.com\/blog\/#organization"},"image":{"@id":"https:\/\/softreetechnology.com\/blog\/sharepoint\/auto-populate-sharepoint-list-columns\/#primaryimage"},"thumbnailUrl":"https:\/\/softreetechnology.com\/blog\/wp-content\/uploads\/2024\/10\/Auto-Populate-SharePoint-List-Columns-Based-on-Value-in-One-Column-using-Power-Automate.png","keywords":["Auto Populate SharePoint List Columns","Power Automate","SharePoint","SharePoint List Automation"],"articleSection":["SharePoint"],"inLanguage":"en","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/softreetechnology.com\/blog\/sharepoint\/auto-populate-sharepoint-list-columns\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/softreetechnology.com\/blog\/sharepoint\/auto-populate-sharepoint-list-columns\/","url":"https:\/\/softreetechnology.com\/blog\/sharepoint\/auto-populate-sharepoint-list-columns\/","name":"Auto Populate SharePoint List Columns Based on Value in One Column using Power Automate - Softree Technology","isPartOf":{"@id":"https:\/\/softreetechnology.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/softreetechnology.com\/blog\/sharepoint\/auto-populate-sharepoint-list-columns\/#primaryimage"},"image":{"@id":"https:\/\/softreetechnology.com\/blog\/sharepoint\/auto-populate-sharepoint-list-columns\/#primaryimage"},"thumbnailUrl":"https:\/\/softreetechnology.com\/blog\/wp-content\/uploads\/2024\/10\/Auto-Populate-SharePoint-List-Columns-Based-on-Value-in-One-Column-using-Power-Automate.png","datePublished":"2024-10-29T12:40:55+00:00","dateModified":"2024-10-29T12:41:44+00:00","breadcrumb":{"@id":"https:\/\/softreetechnology.com\/blog\/sharepoint\/auto-populate-sharepoint-list-columns\/#breadcrumb"},"inLanguage":"en","potentialAction":[{"@type":"ReadAction","target":["https:\/\/softreetechnology.com\/blog\/sharepoint\/auto-populate-sharepoint-list-columns\/"]}]},{"@type":"ImageObject","inLanguage":"en","@id":"https:\/\/softreetechnology.com\/blog\/sharepoint\/auto-populate-sharepoint-list-columns\/#primaryimage","url":"https:\/\/softreetechnology.com\/blog\/wp-content\/uploads\/2024\/10\/Auto-Populate-SharePoint-List-Columns-Based-on-Value-in-One-Column-using-Power-Automate.png","contentUrl":"https:\/\/softreetechnology.com\/blog\/wp-content\/uploads\/2024\/10\/Auto-Populate-SharePoint-List-Columns-Based-on-Value-in-One-Column-using-Power-Automate.png","width":1080,"height":1080},{"@type":"BreadcrumbList","@id":"https:\/\/softreetechnology.com\/blog\/sharepoint\/auto-populate-sharepoint-list-columns\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/softreetechnology.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Auto Populate SharePoint List Columns Based on Value in One Column using Power Automate"}]},{"@type":"WebSite","@id":"https:\/\/softreetechnology.com\/blog\/#website","url":"https:\/\/softreetechnology.com\/blog\/","name":"Softree Technology","description":"Celebrating 10+ Years in SharePoint Consulting !","publisher":{"@id":"https:\/\/softreetechnology.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/softreetechnology.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en"},{"@type":"Organization","@id":"https:\/\/softreetechnology.com\/blog\/#organization","name":"Softree Technology","url":"https:\/\/softreetechnology.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en","@id":"https:\/\/softreetechnology.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/softreetechnology.com\/blog\/wp-content\/uploads\/2023\/03\/cropped-white-logo-soft.png","contentUrl":"https:\/\/softreetechnology.com\/blog\/wp-content\/uploads\/2023\/03\/cropped-white-logo-soft.png","width":844,"height":230,"caption":"Softree Technology"},"image":{"@id":"https:\/\/softreetechnology.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/softreetechnology.com\/blog\/#\/schema\/person\/98740297642f06debccdcee2de84086b","name":"admin","image":{"@type":"ImageObject","inLanguage":"en","@id":"https:\/\/softreetechnology.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/6fc78c8a7aa3fb0bf43c3b9a2e3962d7?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/6fc78c8a7aa3fb0bf43c3b9a2e3962d7?s=96&d=mm&r=g","caption":"admin"},"sameAs":["https:\/\/softreeconsulting.com"],"url":"https:\/\/softreetechnology.com\/blog\/author\/admin\/"}]}},"_links":{"self":[{"href":"https:\/\/softreetechnology.com\/blog\/wp-json\/wp\/v2\/posts\/7221","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/softreetechnology.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/softreetechnology.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/softreetechnology.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/softreetechnology.com\/blog\/wp-json\/wp\/v2\/comments?post=7221"}],"version-history":[{"count":1,"href":"https:\/\/softreetechnology.com\/blog\/wp-json\/wp\/v2\/posts\/7221\/revisions"}],"predecessor-version":[{"id":7223,"href":"https:\/\/softreetechnology.com\/blog\/wp-json\/wp\/v2\/posts\/7221\/revisions\/7223"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/softreetechnology.com\/blog\/wp-json\/wp\/v2\/media\/7222"}],"wp:attachment":[{"href":"https:\/\/softreetechnology.com\/blog\/wp-json\/wp\/v2\/media?parent=7221"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/softreetechnology.com\/blog\/wp-json\/wp\/v2\/categories?post=7221"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/softreetechnology.com\/blog\/wp-json\/wp\/v2\/tags?post=7221"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}