{"id":5787,"date":"2024-06-12T07:29:28","date_gmt":"2024-06-12T07:29:28","guid":{"rendered":"https:\/\/powergi.net\/?p=5787"},"modified":"2025-09-09T21:48:35","modified_gmt":"2025-09-09T21:48:35","slug":"read-raw-excel-data-unformatted-xlsx-using-power-automate-excel-file-to-sharepoint-list","status":"publish","type":"post","link":"https:\/\/powergi.net\/es\/blog\/read-raw-excel-data-unformatted-xlsx-using-power-automate-excel-file-to-sharepoint-list\/","title":{"rendered":"Read Raw Excel Data (unformatted xlsx) using Power Automate | Excel File to SharePoint List"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"5787\" class=\"elementor elementor-5787\" data-elementor-post-type=\"post\">\n\t\t\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;\">Power Automate has some cool out-of-the-box features to read data from Excel files. But if you want to read this data using these actions, the data needs to be formatted as an actual table in the file and not a flat range \u2013 but don\u2019t you worry, Office Scripts got you covered!\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">With Office scripts you can run many automations on your Excel files and they function as if they were \u201c<\/span><a href=\"https:\/\/powergi.net\/blog\/how-to-split-one-excel-sheet-into-multiple-files-using-macro\/\" target=\"_blank\" rel=\"noopener\"><b>VBA macros<\/b><\/a><span style=\"font-weight: 400;\">\u201d but with the ability to run online! This means that many of the limitations that the regular Excel connector has in <a href=\"https:\/\/powergi.net\/blog\/power-automate-desktop-app-licensing-explained-updated-2024\/\"><strong>Power Automate<\/strong><\/a> can be worked around using Office scripts.\u00a0 This is especially beneficial when working with <a href=\"https:\/\/powergi.net\/microsoft-power-platform-consulting-services\/\"><strong>PowerApps consulting services<\/strong><\/a> to optimize workflows.<\/span><\/p><p><span style=\"font-weight: 400;\">For today\u2019s blog, we will show how to read unformatted (flat range) data from an Excel file and insert this data into a <\/span><a href=\"https:\/\/powergi.net\/blog\/power-automate-upload-file-to-sharepoint\/\" target=\"_blank\" rel=\"noopener\"><b>SharePoint<\/b><\/a> <span style=\"font-weight: 400;\">list.\u00a0<\/span><\/p><p>By integrating Microsoft Power Platform into your operations, you streamline data management effectively. Leveraging <a href=\"https:\/\/powergi.net\/microsoft-power-platform-consulting-services\/\"><strong>Power Platform Consulting Services<\/strong><\/a> can transform your workflows, ensuring seamless automation and data integration tailored to your needs.<\/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-793154f elementor-widget elementor-widget-table-of-contents\" data-id=\"793154f\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings='{\"exclude_headings_by_selector\":[],\"marker_view\":\"bullets\",\"no_headings_message\":\"No headings were found on this page.\",\"headings_by_tags\":[\"h2\",\"h3\",\"h4\",\"h5\",\"h6\"],\"icon\":{\"value\":\"fas fa-circle\",\"library\":\"fa-solid\"},\"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__793154f\" 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<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\">Use case description <\/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;\">The trigger for our automation is an Excel file that is received through email from an automated system that sends us the list of new subscribers to our newsletter. File format is xlsx.\u00a0<\/span><\/p><div id=\"seology-cta-1\">\t\t<div data-elementor-type=\"section\" data-elementor-id=\"7276\" class=\"elementor elementor-7276\" 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\">From vision to execution<\/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\">Whether you're just starting or scaling automation, we help turn your ideas into impactful solutions.<\/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\/es\/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><p><span style=\"font-weight: 400;\">Excel file looks like this:<\/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 fetchpriority=\"high\" decoding=\"async\" width=\"412\" height=\"194\" src=\"https:\/\/powergi.net\/wp-content\/uploads\/2024\/06\/unnamed-1.png\" class=\"attachment-large size-large wp-image-5792\" alt=\"Excel File\" srcset=\"https:\/\/powergi.net\/wp-content\/uploads\/2024\/06\/unnamed-1.png 412w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/06\/unnamed-1-300x141.png 300w\" sizes=\"(max-width: 412px) 100vw, 412px\">\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-3193b18 elementor-widget elementor-widget-text-editor\" data-id=\"3193b18\" 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 extract all these rows present in the file and push them into our list of subscribers in SharePoint:\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-b7ceedc elementor-widget elementor-widget-image\" data-id=\"b7ceedc\" 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=\"264\" src=\"https:\/\/powergi.net\/wp-content\/uploads\/2024\/06\/unnamed-2.png\" class=\"attachment-large size-large wp-image-5794\" alt=\"SharePoint View\" srcset=\"https:\/\/powergi.net\/wp-content\/uploads\/2024\/06\/unnamed-2.png 512w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/06\/unnamed-2-300x155.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-8aeb656 elementor-widget elementor-widget-heading\" data-id=\"8aeb656\" 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-907e025 elementor-widget elementor-widget-text-editor\" data-id=\"907e025\" 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;\">Open Excel online or your <\/span><a href=\"https:\/\/powergi.net\/link-your-office-365-apps\/\" target=\"_blank\" rel=\"noopener\"><b>desktop app<\/b><\/a><span style=\"font-weight: 400;\"> and find the \u201cAutomate\u201d tab. Then, just click on \u201cNew script\u201d <\/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-bf053a6 elementor-widget elementor-widget-image\" data-id=\"bf053a6\" 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\/06\/unnamed-3.png\" class=\"attachment-large size-large wp-image-5795\" alt=\"Create Office Script\" srcset=\"https:\/\/powergi.net\/wp-content\/uploads\/2024\/06\/unnamed-3.png 512w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/06\/unnamed-3-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): string { \r\nlet resultData: TableData[] = []; \r\nlet selectedSheet = workbook.getActiveWorksheet(); \r\n\/\/ Add a new table \r\nlet newTable = workbook.addTable(selectedSheet.getUsedRange(), true).setName(\"NewsletterContacts\"); \r\n\/\/get table \r\nconst contactsData = workbook.getTable(\"NewsletterContacts\"); \r\nconst contactsDataView = contactsData.getRange().getVisibleView().getText(); \r\nresultData = returnObjectFromValues(contactsDataView); \r\n\/\/console.log(resultData); \r\nreturn JSON.stringify(resultData); \r\n} \r\n \r\nfunction returnObjectFromValues(values: string[][]): TableData[] { \r\nlet objectArray: TableData[] = []; \r\nlet objectKeys: string[] = []; \r\nfor (let i = 0; i &lt; values.length; i++) { \r\nif (i === 0) { \r\nobjectKeys = values[i] \r\ncontinue; \r\n} \r\n \r\nlet object = {} \r\nfor (let j = 0; j &lt; values[i].length; j++) { \r\nobject[objectKeys[j]] = values[i][j] \r\n} \r\n \r\nobjectArray.push(object as TableData); \r\n} \r\n \r\nreturn objectArray; \r\n} \r\n \r\ninterface TableData { \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;\">And rename the Script.\u00a0\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">It should look like this:<\/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-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 loading=\"lazy\" decoding=\"async\" width=\"451\" height=\"512\" src=\"https:\/\/powergi.net\/wp-content\/uploads\/2024\/06\/unnamed-4.png\" class=\"attachment-large size-large wp-image-5796\" alt=\"Rename the Script\" srcset=\"https:\/\/powergi.net\/wp-content\/uploads\/2024\/06\/unnamed-4.png 451w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/06\/unnamed-4-264x300.png 264w\" sizes=\"(max-width: 451px) 100vw, 451px\">\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;\">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.<\/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 Power Automate flow<\/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 Set up trigger<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a251935 elementor-widget elementor-widget-text-editor\" data-id=\"a251935\" 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;\">For our use case, we will receive the Excel file from an automated email with the words \u201cSubscriber Report\u201d in the subject: <\/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-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 condition to check file extension<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-b1f553d elementor-widget elementor-widget-text-editor\" data-id=\"b1f553d\" 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 make sure the script will only run for .xlsx files, so let\u2019s add a condition on the attachment name. Once this is added to our flow, an \u201capply to each\u201d action will automatically show up. It should look like this: <\/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-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=\"124\" src=\"https:\/\/powergi.net\/wp-content\/uploads\/2024\/06\/unnamed-6.png\" class=\"attachment-large size-large wp-image-5798\" alt=\"Create the file in SharePoint\" srcset=\"https:\/\/powergi.net\/wp-content\/uploads\/2024\/06\/unnamed-6.png 512w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/06\/unnamed-6-300x73.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 Create the 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-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;\">Now we need to save a copy of the attached file into SharePoint, because Office Scripts can only run on files saved on OneDrive or SharePoint. <\/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=\"193\" src=\"https:\/\/powergi.net\/wp-content\/uploads\/2024\/06\/unnamed-8.png\" class=\"attachment-large size-large wp-image-5799\" alt=\"Create the file in SharePoint\" srcset=\"https:\/\/powergi.net\/wp-content\/uploads\/2024\/06\/unnamed-8.png 512w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/06\/unnamed-8-300x113.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 Delay for some seconds<\/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;\">It happens sometimes that the Excel connector gets a bit slow so it\u2019s good to add a delay between when file is created and when the script runs<\/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=\"123\" src=\"https:\/\/powergi.net\/wp-content\/uploads\/2024\/06\/unnamed-9.png\" class=\"attachment-large size-large wp-image-5800\" alt=\"Add a Delay\" srcset=\"https:\/\/powergi.net\/wp-content\/uploads\/2024\/06\/unnamed-9.png 512w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/06\/unnamed-9-300x72.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-32c53f6 elementor-widget elementor-widget-heading\" data-id=\"32c53f6\" 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-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;\">Now, let\u2019s add the \u201cRun script\u201d action, select SharePoint site and library.\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">In the \u201cFile\u201d field, pass the \u201cId\u201d that\u2019s coming from the \u201cCreate file\u201d action. Finally, select the script you just created. <\/span><\/p><div id=\"seology-cta-2\">\t\t<div data-elementor-type=\"section\" data-elementor-id=\"7280\" class=\"elementor elementor-7280\" 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\">Automate tasks that slow you down<\/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\">Free up your team\u2019s time and focus on strategic work with digital and robotic automation.<\/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\/es\/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-579c1b8 elementor-widget elementor-widget-image\" data-id=\"579c1b8\" 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=\"188\" src=\"https:\/\/powergi.net\/wp-content\/uploads\/2024\/06\/unnamed-10.png\" class=\"attachment-large size-large wp-image-5801\" alt=\"Add the \u201cRun script\u201d Action\" srcset=\"https:\/\/powergi.net\/wp-content\/uploads\/2024\/06\/unnamed-10.png 512w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/06\/unnamed-10-300x110.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-424d851 elementor-widget elementor-widget-text-editor\" data-id=\"424d851\" 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 also <a href=\"https:\/\/powergi.net\/blog\/power-automate-upload-file-to-sharepoint\/\"><strong>upload the script in a SharePoint site<\/strong><\/a> and use \u201cRun Script from SharePoint library\u201d action.<\/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-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.6 Parse output to JSON<\/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;\">The Excel script will return the table in the file in JSON format, so we just need to convert this into a format that can be easily consumed by Power Automate. <\/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=\"512\" height=\"290\" src=\"https:\/\/powergi.net\/wp-content\/uploads\/2024\/06\/unnamed-11.png\" class=\"attachment-large size-large wp-image-5802\" alt=\"Parse Output to JSON\" srcset=\"https:\/\/powergi.net\/wp-content\/uploads\/2024\/06\/unnamed-11.png 512w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/06\/unnamed-11-300x170.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-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;\">Below is the JSON schema for the table shown above. Notice how we just have column names in the properties and the data type. <\/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>{ \r\n\u202f \u202f \"type\": \"array\", \r\n\u202f \u202f \"items\": { \r\n\u202f \u202f \u202f \u202f \"type\": \"object\", \r\n\u202f \u202f \u202f \u202f \"properties\": { \r\n\u202f \u202f \u202f \u202f \u202f \u202f \"id\": { \r\n\u202f \u202f \u202f \u202f \u202f \u202f \u202f \u202f \"type\": \"string\" \r\n\u202f \u202f \u202f \u202f \u202f \u202f }, \r\n\u202f \u202f \u202f \u202f \u202f \u202f \"first_name\": { \r\n\u202f \u202f \u202f \u202f \u202f \u202f \u202f \u202f \"type\": \"string\" \r\n\u202f \u202f \u202f \u202f \u202f \u202f }, \r\n\u202f \u202f \u202f \u202f \u202f \u202f \"last_name\": { \r\n\u202f \u202f \u202f \u202f \u202f \u202f \u202f \u202f \"type\": \"string\" \r\n\u202f \u202f \u202f \u202f \u202f \u202f }, \r\n\u202f \u202f \u202f \u202f \u202f \u202f \"email\": { \r\n\u202f \u202f \u202f \u202f \u202f \u202f \u202f \u202f \"type\": \"string\" \r\n\u202f \u202f \u202f \u202f \u202f \u202f }, \r\n\u202f \u202f \u202f \u202f \u202f \u202f \"gender\": { \r\n\u202f \u202f \u202f \u202f \u202f \u202f \u202f \u202f \"type\": \"string\" \r\n\u202f \u202f \u202f \u202f \u202f \u202f }, \r\n\u202f \u202f \u202f \u202f \u202f \u202f \"ip_address\": { \r\n\u202f \u202f \u202f \u202f \u202f \u202f \u202f \u202f \"type\": \"string\" \r\n\u202f \u202f \u202f \u202f \u202f \u202f } \r\n\u202f \u202f \u202f \u202f }, \r\n\u202f \u202f \u202f \u202f \"required\": [ \r\n\u202f \u202f \u202f \u202f \u202f \u202f \"id\", \r\n\u202f \u202f \u202f \u202f \u202f \u202f \"first_name\", \r\n\u202f \u202f \u202f \u202f \u202f \u202f \"last_name\", \r\n\u202f \u202f \u202f \u202f \u202f \u202f \"email\", \r\n\u202f \u202f \u202f \u202f \u202f \u202f \"gender\", \r\n\u202f \u202f \u202f \u202f \u202f \u202f \"ip_address\" \r\n\u202f \u202f \u202f \u202f ] \r\n\u202f \u202f } \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-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.7 Create item 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-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;\">Find the \u201cCreate item\u201d action in Power Automate and fill out SharePoint site, list and fields from the JSON content, it should look like this:<\/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-56a43f6 elementor-widget elementor-widget-image\" data-id=\"56a43f6\" 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=\"484\" height=\"512\" src=\"https:\/\/powergi.net\/wp-content\/uploads\/2024\/06\/unnamed-12.png\" class=\"attachment-large size-large wp-image-5803\" alt=\"Create Item\" srcset=\"https:\/\/powergi.net\/wp-content\/uploads\/2024\/06\/unnamed-12.png 484w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/06\/unnamed-12-284x300.png 284w\" sizes=\"(max-width: 484px) 100vw, 484px\">\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-79d4beb elementor-widget elementor-widget-heading\" data-id=\"79d4beb\" 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<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-72a9a33 elementor-widget elementor-widget-text-editor\" data-id=\"72a9a33\" 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 we\u2019re ready to test the 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-67a31a4 elementor-widget elementor-widget-image\" data-id=\"67a31a4\" 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=\"355\" src=\"https:\/\/powergi.net\/wp-content\/uploads\/2024\/06\/unnamed-14.png\" class=\"attachment-large size-large wp-image-5804\" alt=\"Test the Automation\" srcset=\"https:\/\/powergi.net\/wp-content\/uploads\/2024\/06\/unnamed-14.png 512w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/06\/unnamed-14-300x208.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-9839b7e elementor-widget elementor-widget-heading\" data-id=\"9839b7e\" 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-by-step video tutorial<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-90bcf37 elementor-widget elementor-widget-video\" data-id=\"90bcf37\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings='{\"youtube_url\":\"https:\\\/\\\/www.youtube.com\\\/watch?v=A-ttKpNH5Vw\",\"video_type\":\"youtube\",\"controls\":\"yes\"}' data-widget_type=\"video.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-wrapper elementor-open-inline\">\n\t\t\t<div class=\"elementor-video\"><\/div>\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<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Power Automate has some cool out-of-the-box features to read data from Excel files. But if you want to read this data using these actions, the data needs to be formatted as an actual table in the file and not a flat range \u2013 but don\u2019t you worry, Office Scripts got you covered!\u00a0 With Office scripts [&hellip;]<\/p>\n","protected":false},"author":5,"featured_media":5789,"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,133,120],"class_list":["post-5787","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-power-automate-desktop-app-services","tag-sharepoint"],"glossary_letter":null,"rank_math_title":"Excel | Power Automate | SharePoint | Power GI","rank_math_description":"Discover how to efficiently read raw Excel data using Power Automate and smoothly transfer it to a SharePoint list. Simplify your workflows!","rank_math_focus_keyword":"Excel","_links":{"self":[{"href":"https:\/\/powergi.net\/es\/wp-json\/wp\/v2\/posts\/5787","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/powergi.net\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/powergi.net\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/powergi.net\/es\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/powergi.net\/es\/wp-json\/wp\/v2\/comments?post=5787"}],"version-history":[{"count":0,"href":"https:\/\/powergi.net\/es\/wp-json\/wp\/v2\/posts\/5787\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/powergi.net\/es\/wp-json\/wp\/v2\/media\/5789"}],"wp:attachment":[{"href":"https:\/\/powergi.net\/es\/wp-json\/wp\/v2\/media?parent=5787"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/powergi.net\/es\/wp-json\/wp\/v2\/categories?post=5787"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/powergi.net\/es\/wp-json\/wp\/v2\/tags?post=5787"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}