7/12/2023 0 Comments Power automate excel to planner![]() ![]() This is just the first step of the new import from Excel experience.Microsoft Planner lets you easily bring together teams, tasks, documents, and conversations for better results. You can learn more about the experience here. Table generated with Copilot Table generated without Copilot What’s next? You can also give us feedback on how Copilot is doing so we can further improve our modeling in the future. When a table is generated leveraging Copilot, a card will show up to the left, indicating AI has assisted with the creation of this table. Copilot is also able to detect repetitive values in a column and infer that as a choice column, in the meantime generating choice options automatically to save the manual effort. When Copilot is enabled, it will assist with your table creation by generating table name, table description, column data type and format, as well as column header based on the data you upload. Import your data more easily with Copilot The remaining data will be uploaded in the background, and you can always proceed to table hub or table designer to review the progress. This is because we want to unblock the creation of your app by uploading the top 20 rows of data first. Depending on the size of your data, you might not see all of your data in the canvas app right away. Once you select Create app, we will create a Dataverse table based on your table configuration from the previous step, and then generate a responsive canvas app using that table. After uploading your Excel file, you will see a preview of your table, where you can review and edit your table schema before selecting Create app to create a Dataverse table and responsive canvas app. Once you are on the new home page, simply select Start with data, then Upload an Excel file. To use the new import data from Excel experience, you’ll need to enable the new maker portal home page. ![]() With the new import data from Excel experience, there’s no need to go through the manual creation of table and column prior to data import, nor the need to learn about Power Query - all you need is upload your Excel file, review and edit the table schema, then see your table and app created for you in real time. This might increase frictions as you set up your business logic and apps down the road. Furthermore, importing with Dataflow only allows the configuration of a subset of the complete data types supported by Dataverse. However, to be able to use Dataflow, you need to be familiar with Power Query, which requires a different skillset from Dataverse.
0 Comments
Leave a Reply. |