{"id":1167,"date":"2023-12-26T10:08:50","date_gmt":"2023-12-26T10:08:50","guid":{"rendered":"https:\/\/poiseddevelopers.com\/reality-tech\/?p=1167"},"modified":"2024-04-26T11:47:16","modified_gmt":"2024-04-26T11:47:16","slug":"power-apps-development-using-copilot","status":"publish","type":"post","link":"https:\/\/poiseddevelopers.com\/reality-tech\/power-apps-development-using-copilot\/","title":{"rendered":"Power Apps Development using Copilot"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_65 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title \" >Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 eztoc-toggle-hide-by-default' ><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/poiseddevelopers.com\/reality-tech\/power-apps-development-using-copilot\/#What_is_copilot_in_Microsoft_365\" title=\"What is copilot in Microsoft 365?\">What is copilot in Microsoft 365?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/poiseddevelopers.com\/reality-tech\/power-apps-development-using-copilot\/#Features_of_Microsoft_Copilot_for_Power_Apps\" title=\"Features of Microsoft Copilot for Power Apps\">Features of Microsoft Copilot for Power Apps<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/poiseddevelopers.com\/reality-tech\/power-apps-development-using-copilot\/#What_is_the_prerequisite_for_the_AI_features_enable_in_power_applications\" title=\"What is the prerequisite for the AI features enable in power applications.?\">What is the prerequisite for the AI features enable in power applications.?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/poiseddevelopers.com\/reality-tech\/power-apps-development-using-copilot\/#How_to_create_power_app_canvas_using_the_Copilot\" title=\"How to create power app canvas using the Copilot?\">How to create power app canvas using the Copilot?<\/a><\/li><\/ul><\/nav><\/div>\n<h3><span class=\"ez-toc-section\" id=\"What_is_copilot_in_Microsoft_365\"><\/span>What is copilot in Microsoft 365?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Copilot, an AI-powered development assistance tool, is integrated into Power Apps, enabling app makers and end-users to build apps with data by describing requirements through multiple conversation steps, providing copilot-powered experiences from the first screen.<\/p>\n<p>Microsoft has launched Copilot, designed to assist with day-to-day office tasks. Copilot is compatible with all Microsoft Office 365 applications, including other Microsoft applications such as Power Apps.<\/p>\n<p>Microsoft Copilot is a cutting-edge feature that offers intelligent recommendations and suggestions while you work in Office applications like Word, Excel, PowerPoint, Outlook, OneNote, and Power Apps. It is an AI-powered software tool aimed to improve the efficiency and functionality for Microsoft 365.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Features_of_Microsoft_Copilot_for_Power_Apps\"><\/span>Features of Microsoft Copilot for Power Apps<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<ol>\n<li>\n<h5 role=\"heading\" data-uw-rm-heading=\"level\" aria-level=\"4\">Generating Formulas in App Development<\/h5>\n<ul>\n<li>Microsoft Copilot offers invaluable assistance by creating formulas, ultimately saving you substantial time and energy. This tool not only suggests formulas and expressions while you construct your application but also considers prevalent patterns and optimal methodologies. It guarantees the efficiency and dependability of the generated formulas by incorporating established best practices.<\/li>\n<\/ul>\n<\/li>\n<li>\n<h5>Offering Intelligent Suggestions<\/h5>\n<ul>\n<li>When Copilot processes data in your application, it analyses the data structure. After that, it makes recommendations for appropriate fields, tables, and connections to be put into practice. This feature makes the data integration stage a lot easier, giving you more information to work with while designing the app.<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<h3><span class=\"ez-toc-section\" id=\"What_is_the_prerequisite_for_the_AI_features_enable_in_power_applications\"><\/span>What is the prerequisite for the AI features enable in power applications.?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<ul>\n<li>Your environment must be in the United States region.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-1179 size-full\" src=\"https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/Img-01-1024x124-1.webp\" alt=\"img-01\" width=\"1024\" height=\"124\" srcset=\"https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/Img-01-1024x124-1.webp 1024w, https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/Img-01-1024x124-1-300x36.webp 300w, https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/Img-01-1024x124-1-768x93.webp 768w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/p>\n<ul>\n<li>Your account must have English (United States) as the browser language.<\/li>\n<li>Have a Microsoft Dataverse database in your environment.<\/li>\n<li>If your environment doesn\u2019t show the preview the copilot features, you can follow the below steps to enable the copilot features.<\/li>\n<li>Sign into the\u00a0<a href=\"https:\/\/admin.powerplatform.microsoft.com\/\" target=\"_blank\" rel=\"noopener\" aria-label=\"Power Platform admin center - opens in new tab\" data-uw-rm-ext-link=\"na\">Power Platform admin center<\/a>.<\/li>\n<li>Inside the admin center, click on the Environments option in the left panel &gt; Select specific environment &gt; Click on settings &gt; then click on Product &gt; Click on Features &gt; Turn on Copilot and under AI Builder, enable AI Builder preview models. By default, these features are enabled.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-1180 size-full\" src=\"https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/Img-02-1024x162-1.webp\" alt=\"img-02\" width=\"1024\" height=\"162\" srcset=\"https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/Img-02-1024x162-1.webp 1024w, https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/Img-02-1024x162-1-300x47.webp 300w, https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/Img-02-1024x162-1-768x122.webp 768w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/p>\n<h3><span class=\"ez-toc-section\" id=\"How_to_create_power_app_canvas_using_the_Copilot\"><\/span>How to create power app canvas using the Copilot?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<ul>\n<li>Now you open the power app environment you can see the AI assistance on the power app home page as seen in the below screenshot:<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-1182 size-full\" src=\"https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/Img-03-1024x626-1.webp\" alt=\"img-03\" width=\"1024\" height=\"626\" srcset=\"https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/Img-03-1024x626-1.webp 1024w, https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/Img-03-1024x626-1-300x183.webp 300w, https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/Img-03-1024x626-1-768x470.webp 768w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-1183 size-full\" src=\"https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/Img-04-1024x276-1.webp\" alt=\"img-04\" width=\"1024\" height=\"276\" srcset=\"https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/Img-04-1024x276-1.webp 1024w, https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/Img-04-1024x276-1-300x81.webp 300w, https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/Img-04-1024x276-1-768x207.webp 768w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/p>\n<ul>\n<li>In the Description box you can enter your app description. Write: I want to develop an onboarding Employee Management System where user can add the new request and update the\u00a0existing request and remove the existing request as well.<\/li>\n<li>After providing the description, the AI builder creates a sample table for you with some sample data. You can modify this table according to your requirements, and it works like a conversation using natural language.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-1185 size-full\" src=\"https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/Img-05-1024x491-1.webp\" alt=\"img-05\" width=\"1024\" height=\"491\" srcset=\"https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/Img-05-1024x491-1.webp 1024w, https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/Img-05-1024x491-1-300x144.webp 300w, https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/Img-05-1024x491-1-768x368.webp 768w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/p>\n<p><strong>If you want to add the more columns, then here are the few examples as shown below<\/strong>:<\/p>\n<p>Add columns: write the prompt as show in the below. I am adding the columns based on my requirement you can add your columns same as your requirement.<\/p>\n<ul>\n<li>Add columns called Employment Type and its choice columns and Choice value is 1) Employee 2) Intern.<\/li>\n<li>Add columns called Start Date and its column Types date filed.<\/li>\n<li>Add columns called End Date and its column types of date filed.<\/li>\n<li>Add columns called Business Title and its column types of single line of text.<\/li>\n<li>Add columns called First Name and its column types of single line of text.<\/li>\n<li>Add columns called Last Name and its column types of single line of text.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-1187 size-full\" src=\"https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/Img-06-1024x464-1.webp\" alt=\"img-06\" width=\"1024\" height=\"464\" srcset=\"https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/Img-06-1024x464-1.webp 1024w, https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/Img-06-1024x464-1-300x136.webp 300w, https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/Img-06-1024x464-1-768x348.webp 768w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/p>\n<ul>\n<li>As shown in the image below, the mentioned columns have been added to our table. Once the columns are added in the Copilot section, you will find text like the following highlighted in a square box: \u2018The Employee management table has been updated.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-1190 size-full\" src=\"https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/Img-07-1024x461-1.webp\" alt=\"img-07\" width=\"1024\" height=\"461\" srcset=\"https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/Img-07-1024x461-1.webp 1024w, https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/Img-07-1024x461-1-300x135.webp 300w, https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/Img-07-1024x461-1-768x346.webp 768w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/p>\n<ul>\n<li>Change columns Datatype: if you want to change the columns datatype then you can also change the datatype based on your requirement. For the changing the data type here is the sample prompt text:<br role=\"presentation\" \/>\u201cChange the data type of the columns \u201ccolumns Name\u201d to and \u201cexpected datatype\u201d \u201c Let say I want to change my \u201cShipping Address\u201d columns Single line of Text to Multiline of text.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-1192 size-full\" src=\"https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/Img-08-1024x486-1.webp\" alt=\"img-08\" width=\"1024\" height=\"486\" srcset=\"https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/Img-08-1024x486-1.webp 1024w, https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/Img-08-1024x486-1-300x142.webp 300w, https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/Img-08-1024x486-1-768x365.webp 768w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/p>\n<ul>\n<li>Remove the columns: To remove unnecessary columns from the table, you can simply type:<br role=\"presentation\" \/>\u2018Remove the columns \u201cColumn Name\u201d from the \u201cYour Table Name\u201d table.\u2019 You can see in the image below that the \u2018Request Type\u2019 columns have been removed from the table.\u201d<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-1194 size-full\" src=\"https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/Img-09-1024x463-1.webp\" alt=\"img-09\" width=\"1024\" height=\"463\" srcset=\"https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/Img-09-1024x463-1.webp 1024w, https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/Img-09-1024x463-1-300x136.webp 300w, https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/Img-09-1024x463-1-768x347.webp 768w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/p>\n<ul>\n<li>Adding new rows: You can add rows and adjust specific column values for a single employee. This manner, you can continue to customize the table to your liking.<\/li>\n<li>As seen in the image below, our app is now complete with the gallery and form control with search functionality.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-1196 size-full\" src=\"https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/Img-10-1024x563-1.webp\" alt=\"img-10\" width=\"1024\" height=\"563\" srcset=\"https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/Img-10-1024x563-1.webp 1024w, https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/Img-10-1024x563-1-300x165.webp 300w, https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/Img-10-1024x563-1-768x422.webp 768w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/p>\n","protected":false},"excerpt":{"rendered":"<p>What is copilot in Microsoft 365? Copilot, an AI-powered development assistance tool, is integrated into Power Apps, enabling app makers and end-users to build apps with data by describing requirements through multiple conversation steps, providing copilot-powered experiences from the first screen. Microsoft has launched Copilot, designed to assist with day-to-day office tasks. Copilot is compatible [&hellip;]<\/p>\n","protected":false},"author":6,"featured_media":1174,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[24],"tags":[],"class_list":["post-1167","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-copilot"],"acf":[],"_links":{"self":[{"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/posts\/1167","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/comments?post=1167"}],"version-history":[{"count":1,"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/posts\/1167\/revisions"}],"predecessor-version":[{"id":1200,"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/posts\/1167\/revisions\/1200"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/media\/1174"}],"wp:attachment":[{"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/media?parent=1167"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/categories?post=1167"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/tags?post=1167"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}