{"id":6030,"date":"2024-08-22T11:55:40","date_gmt":"2024-08-22T11:55:40","guid":{"rendered":"https:\/\/powergi.net\/?p=6030"},"modified":"2025-09-09T19:38:43","modified_gmt":"2025-09-09T19:38:43","slug":"convert-excel-file-to-csv-format-with-power-automate-xlsx-to-csv","status":"publish","type":"post","link":"https:\/\/powergi.net\/de\/blog\/convert-excel-file-to-csv-format-with-power-automate-xlsx-to-csv\/","title":{"rendered":"Convert Excel file to CSV format with Power Automate (xlsx to csv)"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"6030\" class=\"elementor elementor-6030\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-d50cb0c elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"d50cb0c\" data-element_type=\"section\" data-e-type=\"section\" data-settings='{\"jet_parallax_layout_list\":[]}'>\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-306ba1c\" data-id=\"306ba1c\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-dc8d6a7 elementor-widget elementor-widget-table-of-contents\" data-id=\"dc8d6a7\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings='{\"exclude_headings_by_selector\":[],\"no_headings_message\":\"No headings were found on this page.\",\"headings_by_tags\":[\"h2\",\"h3\",\"h4\",\"h5\",\"h6\"],\"marker_view\":\"numbers\",\"hierarchical_view\":\"yes\",\"min_height\":{\"unit\":\"px\",\"size\":\"\",\"sizes\":[]},\"min_height_tablet\":{\"unit\":\"px\",\"size\":\"\",\"sizes\":[]},\"min_height_mobile\":{\"unit\":\"px\",\"size\":\"\",\"sizes\":[]}}' data-widget_type=\"table-of-contents.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-toc__header\">\n\t\t\t\t\t\t<h4 class=\"elementor-toc__header-title\">\n\t\t\t\tTable of Contents\t\t\t<\/h4>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div id=\"elementor-toc__dc8d6a7\" class=\"elementor-toc__body\">\n\t\t\t<div class=\"elementor-toc__spinner-container\">\n\t\t\t\t<i class=\"elementor-toc__spinner eicon-animation-spin eicon-loading\" aria-hidden=\"true\"><\/i>\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-63b83ae elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"63b83ae\" data-element_type=\"section\" data-e-type=\"section\" data-settings='{\"jet_parallax_layout_list\":[]}'>\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-f35648f\" data-id=\"f35648f\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-9ee57d0 elementor-widget elementor-widget-text-editor\" data-id=\"9ee57d0\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">Let\u2019s suppose we receive inventory files from our provider, and we need to upload these stock counts in our ERP system every time we get these files. The file format our ERP system requires is a CSV document but the file from the provider is in XLSX format.\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">In this blog we will show how to use <\/span><a href=\"https:\/\/powergi.net\/\" target=\"_blank\" rel=\"noopener\"><b>Power Automate<\/b><\/a> <span style=\"font-weight: 400;\">in combination with Office Scripts to take the XLSX format file and convert it into the CSV format that is friendly with our ERP system.\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">The provider email can have one or more Excel files that can look like this:\u00a0<\/span><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3dbf817 elementor-widget elementor-widget-image\" data-id=\"3dbf817\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img fetchpriority=\"high\" decoding=\"async\" width=\"324\" height=\"512\" src=\"https:\/\/powergi.net\/wp-content\/uploads\/2024\/08\/unnamed-40.png\" class=\"attachment-large size-large wp-image-6033\" alt=\"Excel Files\" srcset=\"https:\/\/powergi.net\/wp-content\/uploads\/2024\/08\/unnamed-40.png 324w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/08\/unnamed-40-190x300.png 190w\" sizes=\"(max-width: 324px) 100vw, 324px\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-6208fe0 elementor-widget elementor-widget-heading\" data-id=\"6208fe0\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Step 1. Create Office Script<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a38b45b elementor-widget elementor-widget-text-editor\" data-id=\"a38b45b\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">We need to create an small automation in the cloud that will take the content of the file and make it a table instead of a flat range, we will use the amazing Office Scripts for that. <\/span><span style=\"font-weight: 400;\">If you need help implementing this kind of automation, our <a href=\"https:\/\/powergi.net\/microsoft-power-platform-consulting-services\/\"><strong>consulting on Power Platform solutions<\/strong><\/a> can guide you through best practices.\u00a0<\/span><\/p><p>Many organizations also benefit from <a href=\"https:\/\/powergi.net\/power-apps-consulting-services\/\"><strong>business applications consulting services<\/strong><\/a> to design scalable automation strategies that align with their data workflows.<\/p><p><span style=\"font-weight: 400;\">Open Excel online or <\/span>Excel desktop\u00a0<span style=\"font-weight: 400;\">and find the \u201cAutomate\u201d tab. Then, just click on \u201cNew script\u201d\u00a0<\/span><span style=\"font-weight: 400;\">\u00a0<\/span><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7b379e8 elementor-widget elementor-widget-image\" data-id=\"7b379e8\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"512\" height=\"104\" src=\"https:\/\/powergi.net\/wp-content\/uploads\/2024\/08\/unnamed-41.png\" class=\"attachment-large size-large wp-image-6035\" alt=\"Create Office Script\" srcset=\"https:\/\/powergi.net\/wp-content\/uploads\/2024\/08\/unnamed-41.png 512w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/08\/unnamed-41-300x61.png 300w\" sizes=\"(max-width: 512px) 100vw, 512px\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f481d3f elementor-widget elementor-widget-code-highlight\" data-id=\"f481d3f\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"prismjs-default copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-javascript line-numbers\">\n\t\t\t\t<code readonly class=\"language-javascript\">\n\t\t\t\t\t<xmp>function main(workbook: ExcelScript.Workbook) { \r\n \r\n\u202f \u202f let selectedSheet = workbook.getActiveWorksheet(); \r\n\u202f \u202f \/\/ set headers name \r\n\u202f \u202f selectedSheet.getRange(\"A1:D1\").setValues([[\"product_name\", \"category_name\", \"qty\", \"from\"]]); \r\n\u202f \u202f \/\/ Add a new table at range on selectedSheet \r\n\u202f \u202f let newTable = workbook.addTable(selectedSheet.getRange(\"A1\").getSurroundingRegion(), true); \r\n\u202f \u202f \/\/ Add a new table at range A1:D769 on selectedSheet \r\n\u202f \u202f newTable.setName(\"Inventario\"); \r\n \r\n} \r\n<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-1e4b634 elementor-widget elementor-widget-text-editor\" data-id=\"1e4b634\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">Use code above and rename the Script.\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">It should look like this: <\/span><\/p><div id=\"seology-cta-1\">\t\t<div data-elementor-type=\"section\" data-elementor-id=\"7267\" class=\"elementor elementor-7267\" data-elementor-post-type=\"elementor_library\">\n\t\t\t<div class=\"elementor-element elementor-element-7e3f164 e-con-full e-flex e-con e-parent\" data-id=\"7e3f164\" data-element_type=\"container\" data-e-type=\"container\" data-settings='{\"background_background\":\"classic\",\"jet_parallax_layout_list\":[]}'>\n\t\t<div class=\"elementor-element elementor-element-9078c9f e-con-full e-flex e-con e-child\" data-id=\"9078c9f\" data-element_type=\"container\" data-e-type=\"container\" data-settings='{\"jet_parallax_layout_list\":[]}'>\n\t\t\t\t<div class=\"elementor-element elementor-element-7b99949 elementor-widget elementor-widget-heading\" data-id=\"7b99949\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<p class=\"elementor-heading-title elementor-size-default\">Turn your ideas into digital solutions<\/p>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-8e61db5 elementor-widget elementor-widget-heading\" data-id=\"8e61db5\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<p class=\"elementor-heading-title elementor-size-default\">Our team guides you step by step to build custom apps in Power Platform.<\/p>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-a578907 e-flex e-con-boxed e-con e-child\" data-id=\"a578907\" data-element_type=\"container\" data-e-type=\"container\" data-settings='{\"jet_parallax_layout_list\":[]}'>\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-e8c827b elementor-view-stacked elementor-shape-circle elementor-widget elementor-widget-icon\" data-id=\"e8c827b\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"icon.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-icon-wrapper\">\n\t\t\t<a class=\"elementor-icon\" href=\"#ctc_chat\">\n\t\t\t<i aria-hidden=\"true\" class=\"fab fa-whatsapp\"><\/i>\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d834237 elementor-view-stacked elementor-shape-circle elementor-widget elementor-widget-icon\" data-id=\"d834237\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"icon.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-icon-wrapper\">\n\t\t\t<a class=\"elementor-icon\" href=\"https:\/\/powergi.net\/de\/contact\/\">\n\t\t\t<i aria-hidden=\"true\" class=\"far fa-envelope\"><\/i>\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<\/div>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-1380def elementor-widget elementor-widget-image\" data-id=\"1380def\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"512\" height=\"159\" src=\"https:\/\/powergi.net\/wp-content\/uploads\/2024\/08\/unnamed-43.png\" class=\"attachment-large size-large wp-image-6036\" alt=\"Office Scripts\" srcset=\"https:\/\/powergi.net\/wp-content\/uploads\/2024\/08\/unnamed-43.png 512w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/08\/unnamed-43-300x93.png 300w\" sizes=\"(max-width: 512px) 100vw, 512px\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-383f4f7 elementor-widget elementor-widget-text-editor\" data-id=\"383f4f7\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">What this code is doing is just renaming the columns in our <\/span><a href=\"https:\/\/powergi.net\/blog\/read-raw-excel-data-unformatted-xlsx-using-power-automate-excel-file-to-sharepoint-list\/\" target=\"_blank\" rel=\"noopener\"><b>excel file<\/b><\/a> <span style=\"font-weight: 400;\">and then converting the content of the excel document into a table called \u201cInventario\u201d.\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">What\u2019s really cool about Office Scripts is that you can do much more \u2013 add calculations, columns, remove rows, create pivot tables. If there are any additional step you need to apply to your CSV file you can just add it here by recording the transformations steps using the actions recorder.<\/span><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d7de7d6 elementor-widget elementor-widget-image\" data-id=\"d7de7d6\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"512\" height=\"86\" src=\"https:\/\/powergi.net\/wp-content\/uploads\/2024\/08\/unnamed-44.png\" class=\"attachment-large size-large wp-image-6037\" alt=\"Office Scripts\" srcset=\"https:\/\/powergi.net\/wp-content\/uploads\/2024\/08\/unnamed-44.png 512w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/08\/unnamed-44-300x50.png 300w\" sizes=\"(max-width: 512px) 100vw, 512px\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-004e2e7 elementor-widget elementor-widget-text-editor\" data-id=\"004e2e7\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">You can always go back to edit the script if needed.\u00a0\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">This office script will be saved in our OneDrive account (the OneDrive user that created the script), under the \u201cDocuments\u201d folder. We can leave it there or download the script and save it to SharePoint, we can run the script from any of these services.\u00a0\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">Important: Office Scripts can\u2019t process high volumes of data, if your file has more than 1000 rows make sure to find a way <a href=\"https:\/\/powergi.net\/blog\/how-to-split-one-excel-sheet-into-multiple-files-using-macro\/\"><strong>to split your file in batches<\/strong><\/a> for the Office Script to not time out. <\/span><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-33acbe4 elementor-widget elementor-widget-heading\" data-id=\"33acbe4\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Step 2. Create a Power Automate Workflow <\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-db32925 elementor-widget elementor-widget-heading\" data-id=\"db32925\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">2.1 Add email trigger <\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-fb1b4b8 elementor-widget elementor-widget-image\" data-id=\"fb1b4b8\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"512\" height=\"390\" src=\"https:\/\/powergi.net\/wp-content\/uploads\/2024\/06\/unnamed-5.png\" class=\"attachment-large size-large wp-image-5797\" alt=\"Add Email Trigger\" srcset=\"https:\/\/powergi.net\/wp-content\/uploads\/2024\/06\/unnamed-5.png 512w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/06\/unnamed-5-300x229.png 300w\" sizes=\"(max-width: 512px) 100vw, 512px\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-78dade9 elementor-widget elementor-widget-heading\" data-id=\"78dade9\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">2.2 Add a convert time zone action <\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-94e2b32 elementor-widget elementor-widget-image\" data-id=\"94e2b32\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"512\" height=\"191\" src=\"https:\/\/powergi.net\/wp-content\/uploads\/2024\/08\/unnamed-46.png\" class=\"attachment-large size-large wp-image-6038\" alt=\"Convert Time Zone\" srcset=\"https:\/\/powergi.net\/wp-content\/uploads\/2024\/08\/unnamed-46.png 512w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/08\/unnamed-46-300x112.png 300w\" sizes=\"(max-width: 512px) 100vw, 512px\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-27fb55f elementor-widget elementor-widget-heading\" data-id=\"27fb55f\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">2.3 Add a create new SharePoint folder action <\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f737760 elementor-widget elementor-widget-text-editor\" data-id=\"f737760\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">The email can contain one or more document attached and we want to group all files in a single folder, so we need to create a folder to locate the files related to each email.\u00a0<\/span><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-8d3cd5b elementor-widget elementor-widget-image\" data-id=\"8d3cd5b\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"512\" height=\"208\" src=\"https:\/\/powergi.net\/wp-content\/uploads\/2024\/08\/unnamed-47.png\" class=\"attachment-large size-large wp-image-6039\" alt=\"Create New Sharepoint Folder\" srcset=\"https:\/\/powergi.net\/wp-content\/uploads\/2024\/08\/unnamed-47.png 512w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/08\/unnamed-47-300x122.png 300w\" sizes=\"(max-width: 512px) 100vw, 512px\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ff55e27 elementor-widget elementor-widget-heading\" data-id=\"ff55e27\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">2.4 Add a Create file action <\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7111a42 elementor-widget elementor-widget-text-editor\" data-id=\"7111a42\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">Now it\u2019s time to get the file content from attachments and save it in the folder we just created.\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">Find the create file action from SharePoint connection and set up like this:\u00a0<\/span><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-fcaeae3 elementor-widget elementor-widget-image\" data-id=\"fcaeae3\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"512\" height=\"211\" src=\"https:\/\/powergi.net\/wp-content\/uploads\/2024\/08\/unnamed-48.png\" class=\"attachment-large size-large wp-image-6042\" alt=\"Add a Create file\" srcset=\"https:\/\/powergi.net\/wp-content\/uploads\/2024\/08\/unnamed-48.png 512w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/08\/unnamed-48-300x124.png 300w\" sizes=\"(max-width: 512px) 100vw, 512px\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-459af33 elementor-widget elementor-widget-text-editor\" data-id=\"459af33\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>\u00a0<\/p><p dir=\"ltr\" style=\"line-height: 1.38; background-color: #ffffff; margin-top: 0pt; margin-bottom: 8pt;\"><span style=\"font-size: 11pt; font-family: Arial,sans-serif; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Folder path (select full path from the Create folder action):\u00a0<\/span><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-68f9fad elementor-widget elementor-widget-code-highlight\" data-id=\"68f9fad\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"prismjs-default copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-javascript line-numbers\">\n\t\t\t\t<code readonly class=\"language-javascript\">\n\t\t\t\t\t<xmp>@{outputs('Create_new_folder')?['body\/{FullPath}']} \r\n<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-4a2e302 elementor-widget elementor-widget-text-editor\" data-id=\"4a2e302\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p dir=\"ltr\" style=\"line-height: 1.38; background-color: #ffffff; margin-top: 0pt; margin-bottom: 8pt;\"><span style=\"font-weight: 400;\">File name (select file name from the attachments list in your trigger): <\/span><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-996f538 elementor-widget elementor-widget-code-highlight\" data-id=\"996f538\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"prismjs-default copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-javascript line-numbers\">\n\t\t\t\t<code readonly class=\"language-javascript\">\n\t\t\t\t\t<xmp>@{items('Apply_to_each')?['name']}_@{guid()}.xlsx <\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-2ff0fa3 elementor-widget elementor-widget-text-editor\" data-id=\"2ff0fa3\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">File content (select file content from the attachments list in your trigger, and use the base64ToBinary formula): <\/span><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-5dada27 elementor-widget elementor-widget-code-highlight\" data-id=\"5dada27\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"prismjs-default copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-javascript line-numbers\">\n\t\t\t\t<code readonly class=\"language-javascript\">\n\t\t\t\t\t<xmp>@{base64ToBinary(items('Apply_to_each')?['contentBytes'])} <\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-59253f6 elementor-widget elementor-widget-text-editor\" data-id=\"59253f6\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">Once you select either file name or content, you will notice Power Automate will add an apply to each action, this means everything you add inside this action will execute for each of the files contained in your email.\u00a0<\/span><\/p><p>If you\u2019re struggling to integrate Power Automate with SharePoint, our <a href=\"https:\/\/powergi.net\/microsoft-power-platform-consulting-services\/\"><strong>Power Platform consulting services<\/strong><\/a> can provide tailored guidance<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-5eabcbf elementor-widget elementor-widget-image\" data-id=\"5eabcbf\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"983\" height=\"578\" src=\"https:\/\/powergi.net\/wp-content\/uploads\/2024\/08\/unnamed-49.png\" class=\"attachment-large size-large wp-image-6043\" alt=\"Apply to Each Action\" srcset=\"https:\/\/powergi.net\/wp-content\/uploads\/2024\/08\/unnamed-49.png 983w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/08\/unnamed-49-300x176.png 300w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/08\/unnamed-49-768x452.png 768w\" sizes=\"(max-width: 983px) 100vw, 983px\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-000f7c4 elementor-widget elementor-widget-text-editor\" data-id=\"000f7c4\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>If you\u2019re finding it difficult to seamlessly integrate Power Automate with SharePoint, our <a href=\"https:\/\/powergi.net\/microsoft-power-platform-consulting-services\/\"><strong>power platform consulting services<\/strong><\/a>\u00a0can offer tailored solutions to enhance your workflow automation.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-0c3db80 elementor-widget elementor-widget-heading\" data-id=\"0c3db80\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">2.5 Run Script <\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-428f7d6 elementor-widget elementor-widget-text-editor\" data-id=\"428f7d6\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">Now that we have our file saved in <\/span><a href=\"https:\/\/powergi.net\/blog\/ultimate-guide-to-odata-query-filters-in-sharepoint\/\" target=\"_blank\" rel=\"noopener\"><b>SharePoint<\/b><\/a><span style=\"font-weight: 400;\">, we can execute the automation we just created with Office Scripts, where we take the values from the Excel file and convert them into a table.\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">Find the \u201crun script\u201d action from the Excel connector, select the office script we just selected and pass the file Id from the Create file action from above\u00a0<\/span><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7f649d6 elementor-widget elementor-widget-image\" data-id=\"7f649d6\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"973\" height=\"359\" src=\"https:\/\/powergi.net\/wp-content\/uploads\/2024\/08\/unnamed-50.png\" class=\"attachment-large size-large wp-image-6044\" alt=\"Run Script\" srcset=\"https:\/\/powergi.net\/wp-content\/uploads\/2024\/08\/unnamed-50.png 973w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/08\/unnamed-50-300x111.png 300w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/08\/unnamed-50-768x283.png 768w\" sizes=\"(max-width: 973px) 100vw, 973px\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-6f6253e elementor-widget elementor-widget-text-editor\" data-id=\"6f6253e\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">File:\u00a0<\/span><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-248c408 elementor-widget elementor-widget-code-highlight\" data-id=\"248c408\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"prismjs-default copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-javascript line-numbers\">\n\t\t\t\t<code readonly class=\"language-javascript\">\n\t\t\t\t\t<xmp>@{outputs('Create_file_3')?['body\/Id']} \r\n<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-31bd574 elementor-widget elementor-widget-heading\" data-id=\"31bd574\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">2.6 Get table content <\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-0dd1332 elementor-widget elementor-widget-text-editor\" data-id=\"0dd1332\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">Now that the script has ran, the table name \u201cInventario\u201d will exist in the file we just created, so we can use the \u201cList rows present in a table\u201d action from the Excel connector.\u00a0<\/span><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-331458d elementor-widget elementor-widget-text-editor\" data-id=\"331458d\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">File:\u00a0<\/span><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-33a4483 elementor-widget elementor-widget-code-highlight\" data-id=\"33a4483\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"prismjs-default copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-javascript line-numbers\">\n\t\t\t\t<code readonly class=\"language-javascript\">\n\t\t\t\t\t<xmp>@{outputs('Create_file_3')?['body\/Id']} <\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-bc58946 elementor-widget elementor-widget-text-editor\" data-id=\"bc58946\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">Table:<\/span><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-82fc172 elementor-widget elementor-widget-code-highlight\" data-id=\"82fc172\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"prismjs-default copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-javascript line-numbers\">\n\t\t\t\t<code readonly class=\"language-javascript\">\n\t\t\t\t\t<xmp>@{string('Inventario')} \r\n<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-9e83ccc elementor-widget elementor-widget-heading\" data-id=\"9e83ccc\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">2.7 Select the columns you need in your file \n<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-720abf4 elementor-widget elementor-widget-text-editor\" data-id=\"720abf4\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">Find the \u201cSelect\u201d action from the \u201cData operation\u201d connector.\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">In the From field, select the \u201cvalue\u201d result from previous action.\u00a0<\/span><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-5254602 elementor-widget elementor-widget-code-highlight\" data-id=\"5254602\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"prismjs-default copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-javascript line-numbers\">\n\t\t\t\t<code readonly class=\"language-javascript\">\n\t\t\t\t\t<xmp>@{outputs('List_rows_present_in_a_table')?['body\/value']} \r\n<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-becb403 elementor-widget elementor-widget-text-editor\" data-id=\"becb403\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">In the \u201cMap\u201d section, add the columns you need the final CSV document to have and on the right, indicate the corresponding column from the Excel file\u00a0 <\/span><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-49ccec2 elementor-widget elementor-widget-code-highlight\" data-id=\"49ccec2\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"prismjs-default copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-javascript line-numbers\">\n\t\t\t\t<code readonly class=\"language-javascript\">\n\t\t\t\t\t<xmp>@{item()?['column-name-in-excel-file']} \r\n@{item()?['product_name']} \r\n<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-16f45c8 elementor-widget elementor-widget-image\" data-id=\"16f45c8\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"923\" height=\"460\" src=\"https:\/\/powergi.net\/wp-content\/uploads\/2024\/08\/unnamed-51.png\" class=\"attachment-large size-large wp-image-6045\" alt=\"Select the Columns\" srcset=\"https:\/\/powergi.net\/wp-content\/uploads\/2024\/08\/unnamed-51.png 923w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/08\/unnamed-51-300x150.png 300w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/08\/unnamed-51-768x383.png 768w\" sizes=\"(max-width: 923px) 100vw, 923px\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-fc05208 elementor-widget elementor-widget-heading\" data-id=\"fc05208\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">2.8 Create CSV <\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-eda7bb4 elementor-widget elementor-widget-text-editor\" data-id=\"eda7bb4\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">Find the \u201cCreate CSV Table\u201d action from the \u201cData operation\u201d connector. In the From field, just select the result from the \u201cSelect\u201d operation.\u00a0<\/span><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-2dc60f8 elementor-widget elementor-widget-image\" data-id=\"2dc60f8\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"921\" height=\"233\" src=\"https:\/\/powergi.net\/wp-content\/uploads\/2024\/08\/unnamed-52.png\" class=\"attachment-large size-large wp-image-6046\" alt=\"Create CSV\" srcset=\"https:\/\/powergi.net\/wp-content\/uploads\/2024\/08\/unnamed-52.png 921w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/08\/unnamed-52-300x76.png 300w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/08\/unnamed-52-768x194.png 768w\" sizes=\"(max-width: 921px) 100vw, 921px\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c4558f1 elementor-widget elementor-widget-text-editor\" data-id=\"c4558f1\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">From:\u00a0<\/span><span style=\"font-weight: 400;\"><br><\/span><\/p><div id=\"seology-cta-2\">\t\t<div data-elementor-type=\"section\" data-elementor-id=\"7283\" class=\"elementor elementor-7283\" data-elementor-post-type=\"elementor_library\">\n\t\t\t<div class=\"elementor-element elementor-element-7e3f164 e-con-full e-flex e-con e-parent\" data-id=\"7e3f164\" data-element_type=\"container\" data-e-type=\"container\" data-settings='{\"background_background\":\"classic\",\"jet_parallax_layout_list\":[]}'>\n\t\t<div class=\"elementor-element elementor-element-9078c9f e-con-full e-flex e-con e-child\" data-id=\"9078c9f\" data-element_type=\"container\" data-e-type=\"container\" data-settings='{\"jet_parallax_layout_list\":[]}'>\n\t\t\t\t<div class=\"elementor-element elementor-element-7b99949 elementor-widget elementor-widget-heading\" data-id=\"7b99949\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<p class=\"elementor-heading-title elementor-size-default\">Is your business ready for automation?<\/p>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-8e61db5 elementor-widget elementor-widget-heading\" data-id=\"8e61db5\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<p class=\"elementor-heading-title elementor-size-default\">Automate processes with Microsoft Power Platform.<\/p>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-a578907 e-flex e-con-boxed e-con e-child\" data-id=\"a578907\" data-element_type=\"container\" data-e-type=\"container\" data-settings='{\"jet_parallax_layout_list\":[]}'>\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-e8c827b elementor-view-stacked elementor-shape-circle elementor-widget elementor-widget-icon\" data-id=\"e8c827b\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"icon.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-icon-wrapper\">\n\t\t\t<a class=\"elementor-icon\" href=\"#ctc_chat\">\n\t\t\t<i aria-hidden=\"true\" class=\"fab fa-whatsapp\"><\/i>\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d834237 elementor-view-stacked elementor-shape-circle elementor-widget elementor-widget-icon\" data-id=\"d834237\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"icon.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-icon-wrapper\">\n\t\t\t<a class=\"elementor-icon\" href=\"https:\/\/powergi.net\/de\/contact\/\">\n\t\t\t<i aria-hidden=\"true\" class=\"far fa-envelope\"><\/i>\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<\/div>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f4c8edd elementor-widget elementor-widget-code-highlight\" data-id=\"f4c8edd\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"prismjs-default copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-javascript line-numbers\">\n\t\t\t\t<code readonly class=\"language-javascript\">\n\t\t\t\t\t<xmp>@{body('Select')} \r\n<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e1e611e elementor-widget elementor-widget-heading\" data-id=\"e1e611e\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">2.9 Save file in SharePoint <\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e6f005c elementor-widget elementor-widget-text-editor\" data-id=\"e6f005c\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">Find the create file action from SharePoint connection and set up like this:\u00a0 <\/span><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f40bbbe elementor-widget elementor-widget-image\" data-id=\"f40bbbe\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"915\" height=\"374\" src=\"https:\/\/powergi.net\/wp-content\/uploads\/2024\/08\/unnamed-53.png\" class=\"attachment-large size-large wp-image-6047\" alt=\"Create File Action from SharePoint\" srcset=\"https:\/\/powergi.net\/wp-content\/uploads\/2024\/08\/unnamed-53.png 915w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/08\/unnamed-53-300x123.png 300w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/08\/unnamed-53-768x314.png 768w\" sizes=\"(max-width: 915px) 100vw, 915px\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-29e91e2 elementor-widget elementor-widget-text-editor\" data-id=\"29e91e2\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">Folder path (select full path from the Create folder action):\u00a0<\/span><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-af7851c elementor-widget elementor-widget-code-highlight\" data-id=\"af7851c\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"prismjs-default copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-javascript line-numbers\">\n\t\t\t\t<code readonly class=\"language-javascript\">\n\t\t\t\t\t<xmp>@{outputs('Create_new_folder')?['body\/{FullPath}']} <\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-06f9505 elementor-widget elementor-widget-text-editor\" data-id=\"06f9505\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">File name (select file name from the attachments list in your trigger and add CSV extension at the end):\u00a0<\/span><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-522334e elementor-widget elementor-widget-code-highlight\" data-id=\"522334e\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"prismjs-default copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-javascript line-numbers\">\n\t\t\t\t<code readonly class=\"language-javascript\">\n\t\t\t\t\t<xmp>@{items('Apply_to_each')?['name']}_@{guid()}.csv \r\n<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c94236b elementor-widget elementor-widget-text-editor\" data-id=\"c94236b\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">File content (select the result from the \u201cCreate CSV table\u201d operation.): <\/span><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-eecd455 elementor-widget elementor-widget-code-highlight\" data-id=\"eecd455\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"prismjs-default copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-javascript line-numbers\">\n\t\t\t\t<code readonly class=\"language-javascript\">\n\t\t\t\t\t<xmp>@{body('Create_CSV_table')} \r\n<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7e18072 elementor-widget elementor-widget-heading\" data-id=\"7e18072\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Step 3. Test Automation <\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-28afd62 elementor-widget elementor-widget-text-editor\" data-id=\"28afd62\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">We\u2019re ready to test what we just built! This is how the final workflow should look: <\/span><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-6843e62 elementor-widget elementor-widget-image\" data-id=\"6843e62\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"733\" height=\"1024\" src=\"https:\/\/powergi.net\/wp-content\/uploads\/2024\/08\/unnamed-54-733x1024.png\" class=\"attachment-large size-large wp-image-6049\" alt=\"Test Automation\" srcset=\"https:\/\/powergi.net\/wp-content\/uploads\/2024\/08\/unnamed-54-733x1024.png 733w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/08\/unnamed-54-215x300.png 215w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/08\/unnamed-54-768x1073.png 768w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/08\/unnamed-54.png 918w\" sizes=\"(max-width: 733px) 100vw, 733px\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ae657d1 elementor-widget elementor-widget-text-editor\" data-id=\"ae657d1\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">Send an email with the file(s) sample(s) and wait for execution to happen: <\/span><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-4d1232f elementor-widget elementor-widget-image\" data-id=\"4d1232f\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"357\" src=\"https:\/\/powergi.net\/wp-content\/uploads\/2024\/08\/unnamed-55-1024x357.png\" class=\"attachment-large size-large wp-image-6050\" alt=\"Send an Email with the File\" srcset=\"https:\/\/powergi.net\/wp-content\/uploads\/2024\/08\/unnamed-55-1024x357.png 1024w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/08\/unnamed-55-300x104.png 300w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/08\/unnamed-55-768x268.png 768w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/08\/unnamed-55.png 1490w\" sizes=\"(max-width: 1024px) 100vw, 1024px\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-367ab2c elementor-widget elementor-widget-text-editor\" data-id=\"367ab2c\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">When you go to SharePoint you will notice files will be created! <\/span><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-be34278 elementor-widget elementor-widget-image\" data-id=\"be34278\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"305\" src=\"https:\/\/powergi.net\/wp-content\/uploads\/2024\/08\/unnamed-56-1024x305.png\" class=\"attachment-large size-large wp-image-6051\" alt=\"Excel files\" srcset=\"https:\/\/powergi.net\/wp-content\/uploads\/2024\/08\/unnamed-56-1024x305.png 1024w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/08\/unnamed-56-300x89.png 300w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/08\/unnamed-56-768x229.png 768w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/08\/unnamed-56.png 1257w\" sizes=\"(max-width: 1024px) 100vw, 1024px\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-54d4746 elementor-widget elementor-widget-text-editor\" data-id=\"54d4746\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">The email we used as example had 2 Excel files, so two CSV documents were created by our automation. <\/span><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e2ce0eb elementor-widget elementor-widget-image\" data-id=\"e2ce0eb\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"781\" height=\"668\" src=\"https:\/\/powergi.net\/wp-content\/uploads\/2024\/08\/unnamed-57.png\" class=\"attachment-large size-large wp-image-6052\" alt=\"Excel Files\" srcset=\"https:\/\/powergi.net\/wp-content\/uploads\/2024\/08\/unnamed-57.png 781w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/08\/unnamed-57-300x257.png 300w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/08\/unnamed-57-768x657.png 768w\" sizes=\"(max-width: 781px) 100vw, 781px\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Table of Contents Let\u2019s suppose we receive inventory files from our provider, and we need to upload these stock counts in our ERP system every time we get these files. The file format our ERP system requires is a CSV document but the file from the provider is in XLSX format.\u00a0 In this blog we [&hellip;]<\/p>\n","protected":false},"author":5,"featured_media":6031,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"default","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"default","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"glossary_letter":"","footnotes":""},"categories":[35,118],"tags":[13,16,17,117,120],"class_list":["post-6030","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-microsoft-excel","category-sharepoint-cat","tag-automation","tag-excel","tag-power-automate","tag-power-automate-desktop","tag-sharepoint"],"glossary_letter":null,"rank_math_title":"Power Automate | Excel file | SharePoint | Power GI","rank_math_description":"Increase efficiency by converting Excel files to CSV format using Power Automate. Streamline your workflow smoothly. Call us!","rank_math_focus_keyword":"Power Automate","_links":{"self":[{"href":"https:\/\/powergi.net\/de\/wp-json\/wp\/v2\/posts\/6030","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/powergi.net\/de\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/powergi.net\/de\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/powergi.net\/de\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/powergi.net\/de\/wp-json\/wp\/v2\/comments?post=6030"}],"version-history":[{"count":0,"href":"https:\/\/powergi.net\/de\/wp-json\/wp\/v2\/posts\/6030\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/powergi.net\/de\/wp-json\/wp\/v2\/media\/6031"}],"wp:attachment":[{"href":"https:\/\/powergi.net\/de\/wp-json\/wp\/v2\/media?parent=6030"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/powergi.net\/de\/wp-json\/wp\/v2\/categories?post=6030"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/powergi.net\/de\/wp-json\/wp\/v2\/tags?post=6030"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}