{"id":32438,"date":"2022-12-08T15:06:33","date_gmt":"2022-12-08T14:06:33","guid":{"rendered":"https:\/\/www.hakoit.com\/?p=32438"},"modified":"2026-02-04T17:40:30","modified_gmt":"2026-02-04T16:40:30","slug":"crear-una-app-con-excel-en-5-pasos-powerapps-tutorial","status":"publish","type":"post","link":"https:\/\/www.hakoit.com\/crear-una-app-con-excel-en-5-pasos-powerapps-tutorial\/","title":{"rendered":"Crear una app con EXCEL en 5 pasos | PowerApps Tutorial [2026]"},"content":{"rendered":"

[et_pb_section fb_built=\u00bb1″ admin_label=\u00bbsection\u00bb _builder_version=\u00bb4.16″ da_disable_devices=\u00bboff|off|off\u00bb global_colors_info=\u00bb{}\u00bb da_is_popup=\u00bboff\u00bb da_exit_intent=\u00bboff\u00bb da_has_close=\u00bbon\u00bb da_alt_close=\u00bboff\u00bb da_dark_close=\u00bboff\u00bb da_not_modal=\u00bbon\u00bb da_is_singular=\u00bboff\u00bb da_with_loader=\u00bboff\u00bb da_has_shadow=\u00bbon\u00bb][et_pb_row admin_label=\u00bbrow\u00bb _builder_version=\u00bb4.16″ background_size=\u00bbinitial\u00bb background_position=\u00bbtop_left\u00bb background_repeat=\u00bbrepeat\u00bb global_colors_info=\u00bb{}\u00bb][et_pb_column type=\u00bb4_4″ _builder_version=\u00bb4.16″ custom_padding=\u00bb|||\u00bb global_colors_info=\u00bb{}\u00bb custom_padding__hover=\u00bb|||\u00bb][et_pb_text _builder_version=\u00bb4.22.1″ _module_preset=\u00bbdefault\u00bb global_colors_info=\u00bb{}\u00bb]<\/p>\n

En esta publicaci\u00f3n, explicaremos c\u00f3mo crear una app con Excel en 5 pasos<\/strong>, utilizando OneDrive para empresas y Microsoft Excel<\/strong>.<\/p>\n

Si ten\u00e9s dudas sobre c\u00f3mo crear una aplicaci\u00f3n en Excel pero no est\u00e1 seguro de por d\u00f3nde empezar, esta es la gu\u00eda excelente para vos!.<\/p>\n

\u00bfQu\u00e9 es Power Apps?<\/h2>\n

Power Apps<\/a> es una soluci\u00f3n revolucionaria de Microsoft que permite a cualquier persona, incluso sin experiencia en programaci\u00f3n, crear aplicaciones personalizadas. Esta herramienta est\u00e1 dise\u00f1ada para ser accesible y f\u00e1cil de usar, lo que la convierte en una opci\u00f3n perfecta para quienes desean simplificar procesos y aumentar la productividad.<\/p>\n

C\u00f3mo hacer una App con EXCEL – 5 Pasos<\/h2>\n

PASO 1-<\/strong> Primero, Entrar en <\/span>Power Apps<\/span><\/strong>. https:\/\/make.powerapps.com\/<\/span><\/p>\n

PASO 2-<\/strong> segundo, Seleccionar <\/span>Excel<\/span><\/strong>\u00a0(Start from)<\/span><\/p>\n

[\/et_pb_text][et_pb_image src=\u00bbhttps:\/\/www.hakoit.com\/wp-content\/uploads\/2022\/12\/create-an-app-with-excel-hakoit-1.jpg\u00bb alt=\u00bbcreate an app with excel\u00bb title_text=\u00bbcreate an app with excel\u00bb _builder_version=\u00bb4.19.1″ _module_preset=\u00bbdefault\u00bb global_colors_info=\u00bb{}\u00bb][\/et_pb_image][et_pb_text _builder_version=\u00bb4.19.1″ _module_preset=\u00bbdefault\u00bb global_colors_info=\u00bb{}\u00bb]<\/p>\n

PASO 3-<\/strong> Buscar & Seleccionar \u00ab<\/span>OneDrive for Business<\/b>\u00bb para crear una nueva conexi\u00f3n.<\/span><\/p>\n

[\/et_pb_text][et_pb_image src=\u00bbhttps:\/\/www.hakoit.com\/wp-content\/uploads\/2022\/12\/create-an-app-with-excel-hakoit-2.jpg\u00bb alt=\u00bbcan excel be used to create a database\u00bb title_text=\u00bbcan excel be used to create a database\u00bb _builder_version=\u00bb4.19.1″ _module_preset=\u00bbdefault\u00bb global_colors_info=\u00bb{}\u00bb][\/et_pb_image][et_pb_text admin_label=\u00bb4- Find the location\u00bb _builder_version=\u00bb4.19.1″ _module_preset=\u00bbdefault\u00bb global_colors_info=\u00bb{}\u00bb]<\/p>\n

PASO 4- <\/strong><\/span>Buscar la ubicaci\u00f3n<\/strong> donde ten\u00e9s guardado el archivo de Excel y seleccionar el archivo Excel.<\/strong> Luego seleccionar la Tabla para realizar la conexi\u00f3n. Y, crear\u00e1s una aplicaci\u00f3n con excel.<\/p>\n

En este ejemplo, \u00abPowerApps-Data-Places-to-go.xlsx<\/strong>\u00ab<\/p>\n

[\/et_pb_text][et_pb_image src=\u00bbhttps:\/\/www.hakoit.com\/wp-content\/uploads\/2022\/12\/create-an-app-with-excel-hakoit-3.jpg\u00bb alt=\u00bbhow to make an app from an excel\u00bb title_text=\u00bbhow to make an app from an excel\u00bb _builder_version=\u00bb4.19.1″ _module_preset=\u00bbdefault\u00bb global_colors_info=\u00bb{}\u00bb][\/et_pb_image][et_pb_image src=\u00bbhttps:\/\/www.hakoit.com\/wp-content\/uploads\/2022\/12\/create-an-app-with-excel-hakoit-4.jpg\u00bb alt=\u00bbmake an app with excel\u00bb title_text=\u00bbmake an app with excel\u00bb admin_label=\u00bbImagen\u00bb _builder_version=\u00bb4.19.1″ _module_preset=\u00bbdefault\u00bb global_colors_info=\u00bb{}\u00bb][\/et_pb_image][et_pb_text admin_label=\u00bbWait some seconds\u00bb _builder_version=\u00bb4.19.1″ _module_preset=\u00bbdefault\u00bb global_colors_info=\u00bb{}\u00bb]<\/p>\n

\n

Esperar unos segundos (La M\u00e1gia esta en proceso!<\/strong>)<\/span><\/p>\n<\/blockquote>\n

[\/et_pb_text][et_pb_image src=\u00bbhttps:\/\/www.hakoit.com\/wp-content\/uploads\/2022\/12\/create-an-app-with-excel-hakoit-5.jpg\u00bb alt=\u00bbCrear una app con EXCEL Power Apps\u00bb title_text=\u00bbCrear una app con EXCEL Power Apps\u00bb _builder_version=\u00bb4.19.1″ _module_preset=\u00bbdefault\u00bb global_colors_info=\u00bb{}\u00bb][\/et_pb_image][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=\u00bb4.17.4″ _module_preset=\u00bbdefault\u00bb locked=\u00bboff\u00bb global_colors_info=\u00bb{}\u00bb][et_pb_column type=\u00bb4_4″ _builder_version=\u00bb4.17.4″ _module_preset=\u00bbdefault\u00bb global_colors_info=\u00bb{}\u00bb][et_pb_code admin_label=\u00bbadsHakoITpowerApps\u00bb _builder_version=\u00bb4.19.1″ _module_preset=\u00bbdefault\u00bb locked=\u00bboff\u00bb global_colors_info=\u00bb{}\u00bb]<\/p>\n

\"CREATE<\/a><\/div>\n

[\/et_pb_code][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=\u00bb4.19.1″ _module_preset=\u00bbdefault\u00bb global_colors_info=\u00bb{}\u00bb][et_pb_column type=\u00bb4_4″ _builder_version=\u00bb4.19.1″ _module_preset=\u00bbdefault\u00bb global_colors_info=\u00bb{}\u00bb][et_pb_text admin_label=\u00bbtext done\u00bb _builder_version=\u00bb4.19.1″ _module_preset=\u00bbdefault\u00bb global_colors_info=\u00bb{}\u00bb]<\/p>\n

\n

Crear una APP con Excel \u2714\ufe0e Listo!!!<\/strong><\/p>\n<\/blockquote>\n

[\/et_pb_text][et_pb_image src=\u00bbhttps:\/\/www.hakoit.com\/wp-content\/uploads\/2022\/12\/create-an-app-with-excel-hakoit-6.jpg\u00bb alt=\u00bbCrear una app con EXCEL\u00bb title_text=\u00bbCrear una app con EXCEL\u00bb _builder_version=\u00bb4.19.1″ _module_preset=\u00bbdefault\u00bb global_colors_info=\u00bb{}\u00bb][\/et_pb_image][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=\u00bb3_5,2_5″ _builder_version=\u00bb4.19.1″ _module_preset=\u00bbdefault\u00bb global_colors_info=\u00bb{}\u00bb][et_pb_column type=\u00bb3_5″ _builder_version=\u00bb4.19.1″ _module_preset=\u00bbdefault\u00bb global_colors_info=\u00bb{}\u00bb][et_pb_text admin_label=\u00bb05- Finally\u00bb _builder_version=\u00bb4.19.1″ _module_preset=\u00bbdefault\u00bb global_colors_info=\u00bb{}\u00bb]<\/p>\n

PASO 5-<\/strong> Finalmente, y lo m\u00e1s importante, Ejecute la aplicaci\u00f3n<\/strong>, el bot\u00f3n Play<\/strong> (arriba a la derecha) o F5<\/strong>.<\/span><\/p>\n

Felicitaciones!, \u00a1Ya pod\u00e9s utilizar y disfrutar la App! Creaste tu propia aplicaci\u00f3n m\u00f3vil con Excel y Power Apps<\/a>! Felicitaciones!!!<\/b><\/p>\n

 <\/p>\n

[\/et_pb_text][\/et_pb_column][et_pb_column type=\u00bb2_5″ _builder_version=\u00bb4.19.1″ _module_preset=\u00bbdefault\u00bb global_colors_info=\u00bb{}\u00bb][et_pb_image src=\u00bbhttps:\/\/www.hakoit.com\/wp-content\/uploads\/2022\/12\/create-an-app-with-excel-hakoit-7.jpg\u00bb alt=\u00bbcreate an app with excel HakoIT\u00bb title_text=\u00bbcreate an app with excel HakoIT\u00bb _builder_version=\u00bb4.19.1″ _module_preset=\u00bbdefault\u00bb global_colors_info=\u00bb{}\u00bb][\/et_pb_image][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=\u00bb1_5,3_5,1_5″ disabled_on=\u00bbon|on|on\u00bb _builder_version=\u00bb4.19.1″ _module_preset=\u00bbdefault\u00bb disabled=\u00bbon\u00bb global_colors_info=\u00bb{}\u00bb][et_pb_column type=\u00bb1_5″ _builder_version=\u00bb4.19.1″ _module_preset=\u00bbdefault\u00bb global_colors_info=\u00bb{}\u00bb][\/et_pb_column][et_pb_column type=\u00bb3_5″ _builder_version=\u00bb4.19.1″ _module_preset=\u00bbdefault\u00bb global_colors_info=\u00bb{}\u00bb][et_pb_text _builder_version=\u00bb4.22.1″ _module_preset=\u00bbdefault\u00bb global_colors_info=\u00bb{}\u00bb]<\/p>\n

Video tutorial Example<\/h2>\n

[\/et_pb_text][\/et_pb_column][et_pb_column type=\u00bb1_5″ _builder_version=\u00bb4.19.1″ _module_preset=\u00bbdefault\u00bb global_colors_info=\u00bb{}\u00bb][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=\u00bb1″ _builder_version=\u00bb4.19.1″ _module_preset=\u00bbdefault\u00bb da_disable_devices=\u00bboff|off|off\u00bb global_colors_info=\u00bb{}\u00bb da_is_popup=\u00bboff\u00bb da_exit_intent=\u00bboff\u00bb da_has_close=\u00bbon\u00bb da_alt_close=\u00bboff\u00bb da_dark_close=\u00bboff\u00bb da_not_modal=\u00bbon\u00bb da_is_singular=\u00bboff\u00bb da_with_loader=\u00bboff\u00bb da_has_shadow=\u00bbon\u00bb][et_pb_row _builder_version=\u00bb4.19.1″ _module_preset=\u00bbdefault\u00bb global_colors_info=\u00bb{}\u00bb][et_pb_column type=\u00bb4_4″ _builder_version=\u00bb4.19.1″ _module_preset=\u00bbdefault\u00bb global_colors_info=\u00bb{}\u00bb][et_pb_text _builder_version=\u00bb4.22.1″ _module_preset=\u00bbdefault\u00bb global_colors_info=\u00bb{}\u00bb]<\/p>\n

Personalicemos un poco nuestra Power App desde Excel<\/h2>\n

Luego de\u00a0 Crear una app con EXCEL, pod\u00e9s personalizar lsa pantallas utilizando los controles disponibles en la barra de herramientas, y las propiedades avanzadas en el panel del lado derecho.
As\u00ed que queremos personalizar nuestro t\u00edtulo, galer\u00eda y ver algunas otras cosas de dise\u00f1o.<\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=\u00bb1_3,1_3,1_3″ _builder_version=\u00bb4.19.1″ _module_preset=\u00bbdefault\u00bb global_colors_info=\u00bb{}\u00bb][et_pb_column type=\u00bb1_3″ _builder_version=\u00bb4.19.1″ _module_preset=\u00bbdefault\u00bb global_colors_info=\u00bb{}\u00bb][et_pb_text _builder_version=\u00bb4.19.1″ _module_preset=\u00bbdefault\u00bb global_colors_info=\u00bb{}\u00bb]<\/p>\n

Vista de la Galer\u00eda<\/strong><\/em><\/p>\n

[\/et_pb_text][et_pb_image src=\u00bbhttps:\/\/www.hakoit.com\/wp-content\/uploads\/2022\/12\/make-an-app-with-excel-01.jpg\u00bb alt=\u00bbcrear app basada en excel\u00bb title_text=\u00bbcrear app basada en excel\u00bb show_in_lightbox=\u00bbon\u00bb _builder_version=\u00bb4.19.1″ _module_preset=\u00bbdefault\u00bb global_colors_info=\u00bb{}\u00bb][\/et_pb_image][\/et_pb_column][et_pb_column type=\u00bb1_3″ _builder_version=\u00bb4.19.1″ _module_preset=\u00bbdefault\u00bb global_colors_info=\u00bb{}\u00bb][et_pb_text _builder_version=\u00bb4.19.1″ _module_preset=\u00bbdefault\u00bb global_colors_info=\u00bb{}\u00bb]<\/p>\n

Ver detalles<\/strong><\/em><\/p>\n

[\/et_pb_text][et_pb_image src=\u00bbhttps:\/\/www.hakoit.com\/wp-content\/uploads\/2022\/12\/make-an-app-with-excel-02-View.jpg\u00bb alt=\u00bbcrear app desde excel\u00bb title_text=\u00bbcrear app desde excel\u00bb _builder_version=\u00bb4.19.1″ _module_preset=\u00bbdefault\u00bb global_colors_info=\u00bb{}\u00bb][\/et_pb_image][\/et_pb_column][et_pb_column type=\u00bb1_3″ _builder_version=\u00bb4.19.1″ _module_preset=\u00bbdefault\u00bb global_colors_info=\u00bb{}\u00bb][et_pb_text _builder_version=\u00bb4.19.1″ _module_preset=\u00bbdefault\u00bb global_colors_info=\u00bb{}\u00bb]<\/p>\n

Editar<\/strong><\/em><\/p>\n

[\/et_pb_text][et_pb_image src=\u00bbhttps:\/\/www.hakoit.com\/wp-content\/uploads\/2022\/12\/make-an-app-with-excel-03-Edit.jpg\u00bb alt=\u00bbmake an app with excel – edit item\u00bb title_text=\u00bbmake an app with excel – edit item\u00bb _builder_version=\u00bb4.19.1″ _module_preset=\u00bbdefault\u00bb global_colors_info=\u00bb{}\u00bb][\/et_pb_image][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=\u00bb1_3,1_3,1_3″ _builder_version=\u00bb4.19.1″ _module_preset=\u00bbdefault\u00bb global_colors_info=\u00bb{}\u00bb][et_pb_column type=\u00bb1_3″ _builder_version=\u00bb4.19.1″ _module_preset=\u00bbdefault\u00bb global_colors_info=\u00bb{}\u00bb][et_pb_text _builder_version=\u00bb4.19.1″ _module_preset=\u00bbdefault\u00bb global_colors_info=\u00bb{}\u00bb]<\/p>\n

Agregar nuevo<\/strong><\/em><\/p>\n

[\/et_pb_text][et_pb_image src=\u00bbhttps:\/\/www.hakoit.com\/wp-content\/uploads\/2022\/12\/make-an-app-with-excel-04-New.jpg\u00bb alt=\u00bbmake an app with excel – add new item\u00bb title_text=\u00bbmake an app with excel – add new item\u00bb _builder_version=\u00bb4.19.1″ _module_preset=\u00bbdefault\u00bb global_colors_info=\u00bb{}\u00bb][\/et_pb_image][\/et_pb_column][et_pb_column type=\u00bb1_3″ _builder_version=\u00bb4.19.1″ _module_preset=\u00bbdefault\u00bb global_colors_info=\u00bb{}\u00bb][et_pb_text _builder_version=\u00bb4.19.1″ _module_preset=\u00bbdefault\u00bb global_colors_info=\u00bb{}\u00bb]<\/p>\n

Ingresar informaci\u00f3n<\/strong><\/em><\/p>\n

[\/et_pb_text][et_pb_image src=\u00bbhttps:\/\/www.hakoit.com\/wp-content\/uploads\/2022\/12\/make-an-app-with-excel-05-New.jpg\u00bb alt=\u00bbadd new item powerapps excel\u00bb title_text=\u00bbadd new item powerapps excel\u00bb _builder_version=\u00bb4.19.1″ _module_preset=\u00bbdefault\u00bb global_colors_info=\u00bb{}\u00bb][\/et_pb_image][\/et_pb_column][et_pb_column type=\u00bb1_3″ _builder_version=\u00bb4.19.1″ _module_preset=\u00bbdefault\u00bb global_colors_info=\u00bb{}\u00bb][et_pb_text _builder_version=\u00bb4.19.1″ _module_preset=\u00bbdefault\u00bb global_colors_info=\u00bb{}\u00bb]<\/p>\n

Vista del nuevo lugar<\/strong><\/em><\/p>\n

[\/et_pb_text][et_pb_image src=\u00bbhttps:\/\/www.hakoit.com\/wp-content\/uploads\/2022\/12\/make-an-app-with-excel-06.jpg\u00bb alt=\u00bbcrear app a partir de excel\u00bb title_text=\u00bbcrear app a partir de excel\u00bb _builder_version=\u00bb4.19.1″ _module_preset=\u00bbdefault\u00bb global_colors_info=\u00bb{}\u00bb][\/et_pb_image][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=\u00bb1″ admin_label=\u00bbExcel\u00bb _builder_version=\u00bb4.19.1″ _module_preset=\u00bbdefault\u00bb da_disable_devices=\u00bboff|off|off\u00bb global_colors_info=\u00bb{}\u00bb da_is_popup=\u00bboff\u00bb da_exit_intent=\u00bboff\u00bb da_has_close=\u00bbon\u00bb da_alt_close=\u00bboff\u00bb da_dark_close=\u00bboff\u00bb da_not_modal=\u00bbon\u00bb da_is_singular=\u00bboff\u00bb da_with_loader=\u00bboff\u00bb da_has_shadow=\u00bbon\u00bb][et_pb_row _builder_version=\u00bb4.19.1″ _module_preset=\u00bbdefault\u00bb global_colors_info=\u00bb{}\u00bb][et_pb_column type=\u00bb4_4″ _builder_version=\u00bb4.19.1″ _module_preset=\u00bbdefault\u00bb global_colors_info=\u00bb{}\u00bb][et_pb_text admin_label=\u00bbPower Apps Excel table – Excel Tips\u00bb _builder_version=\u00bb4.22.1″ _module_preset=\u00bbdefault\u00bb global_colors_info=\u00bb{}\u00bb]<\/p>\n

Power Apps tabla Excel – Excel Tips \/ Convertir Excel a App:<\/span><\/h2>\n

En este ejemplo, utilizamos un Microsoft Excel<\/a> <\/strong>almacenado en OneDrive for Business<\/strong>.<\/p>\n

TIP:<\/strong> En Power Apps, solo podes crear una aplicaci\u00f3n basada en datos de Excel, si tiene formato de tabla<\/strong>.<\/span><\/p>\n

A continuaci\u00f3n, aprender\u00e1s algunos consejos para crear una app con Excel y c\u00f3mo dar formato a una tabla en Excel.<\/p>\n

-Guarde su archivo de Excel en una ubicaci\u00f3n en la nube<\/strong> , como Dropbox, Google Drive, OneDrive y OneDrive for Business.<\/p>\n

En el ejemplo, usamos \u00abOneDrive for Business\u00bb.<\/p>\n

[\/et_pb_text][et_pb_image src=\u00bbhttps:\/\/www.hakoit.com\/wp-content\/uploads\/2022\/12\/powerapps-excel-hakoIT-1.jpg\u00bb alt=\u00bbexcel spreadsheet OneDrive for Business\u00bb title_text=\u00bbexcel spreadsheet OneDrive for Business\u00bb _builder_version=\u00bb4.19.1″ _module_preset=\u00bbdefault\u00bb global_colors_info=\u00bb{}\u00bb][\/et_pb_image][et_pb_text _builder_version=\u00bb4.19.1″ _module_preset=\u00bbdefault\u00bb global_colors_info=\u00bb{}\u00bb]<\/p>\n

-El archivo original Microsoft Excel (se ve asi):<\/span><\/p>\n

[\/et_pb_text][et_pb_image src=\u00bbhttps:\/\/www.hakoit.com\/wp-content\/uploads\/2022\/12\/powerapps-excel-hakoIT-2.jpg\u00bb alt=\u00bbcreate an excel application\u00bb title_text=\u00bbcreate an excel application\u00bb _builder_version=\u00bb4.19.1″ _module_preset=\u00bbdefault\u00bb global_colors_info=\u00bb{}\u00bb][\/et_pb_image][et_pb_text admin_label=\u00bb1 The Name of Image\u00bb _builder_version=\u00bb4.19.1″ _module_preset=\u00bbdefault\u00bb global_colors_info=\u00bb{}\u00bb]<\/p>\n

TIP 1- El nombre del encabezado<\/strong> de la columna que contine imagenes<\/strong>: Image [image]<\/span><\/h3>\n

Si su tabla contiene im\u00e1genes,<\/strong> use el nombre de la columna de encabezado<\/strong> \u00abImage [image]\u00bb<\/strong>.
<\/span>Entonces, con esta palabra clave, vincular\u00e1 autom\u00e1ticamente esa columna a un control de imagen en una galer\u00eda.<\/span><\/span><\/p>\n

[\/et_pb_text][et_pb_image src=\u00bbhttps:\/\/www.hakoit.com\/wp-content\/uploads\/2022\/12\/powerapps-excel-hakoIT-3.jpg\u00bb alt=\u00bbhow to create an app from excel spreadsheet\u00bb title_text=\u00bbhow to create an app from excel spreadsheet\u00bb _builder_version=\u00bb4.19.1″ _module_preset=\u00bbdefault\u00bb global_colors_info=\u00bb{}\u00bb][\/et_pb_image][et_pb_text admin_label=\u00bb2- Excel Table\u00bb _builder_version=\u00bb4.19.1″ _module_preset=\u00bbdefault\u00bb global_colors_info=\u00bb{}\u00bb]<\/p>\n

TIP 2- Tabla Excel: (Important\u00edsimo<\/strong>)<\/span><\/h3>\n

Recuerde:<\/strong> En Power Apps<\/a>, <\/span>pod\u00e9s crear una aplicaci\u00f3n m\u00f3bil<\/strong> basada en datos de Excel<\/strong> solo si tiene el formato<\/strong> de una tabla<\/strong>.<\/p>\n

P\u00f3des convertir tus datos en una tabla<\/strong> siguiendo los siguientes pasos:<\/p>\n

1-Selecciona toda la informaci\u00f3n del Excel.<\/p>\n

2-Haga clic en Format as Table <\/strong>(<\/span>Formato como tabla) en la pesta\u00f1a Home<\/strong><\/span> (Inicio) de Excel.<\/p>\n

[\/et_pb_text][et_pb_image src=\u00bbhttps:\/\/www.hakoit.com\/wp-content\/uploads\/2022\/12\/powerapps-excel-hakoIT-4.jpg\u00bb alt=\u00bbPower Apps Excel Tutorial HakoIT\u00bb title_text=\u00bbPower Apps Excel Tutorial HakoIT\u00bb _builder_version=\u00bb4.19.1″ _module_preset=\u00bbdefault\u00bb global_colors_info=\u00bb{}\u00bb][\/et_pb_image][et_pb_text admin_label=\u00bb3-On the ribbon\u00bb _builder_version=\u00bb4.19.1″ _module_preset=\u00bbdefault\u00bb global_colors_info=\u00bb{}\u00bb]<\/p>\n

3- En el desplegable, seleccione un dise\u00f1o de tabla<\/span>.<\/p>\n

[\/et_pb_text][et_pb_image src=\u00bbhttps:\/\/www.hakoit.com\/wp-content\/uploads\/2022\/12\/powerapps-excel-hakoIT-5.jpg\u00bb alt=\u00bbhow to create an app from excel spreadsheet\u00bb title_text=\u00bbhow to create an app from excel spreadsheet\u00bb _builder_version=\u00bb4.19.1″ _module_preset=\u00bbdefault\u00bb global_colors_info=\u00bb{}\u00bb][\/et_pb_image][et_pb_text admin_label=\u00bb4- In the dialog box,\u00bb _builder_version=\u00bb4.19.1″ _module_preset=\u00bbdefault\u00bb global_colors_info=\u00bb{}\u00bb]<\/p>\n

4- En el cuadro de di\u00e1logo, seleccione My table has headers<\/strong> (Mi tabla tiene encabezados) y luego seleccione OK<\/strong>.<\/span><\/p>\n

[\/et_pb_text][et_pb_image src=\u00bbhttps:\/\/www.hakoit.com\/wp-content\/uploads\/2022\/12\/powerapps-excel-hakoIT-6.jpg\u00bb alt=\u00bbPower Apps Excel Tutorial\u00bb title_text=\u00bbPower Apps Excel Tutorial\u00bb _builder_version=\u00bb4.19.1″ _module_preset=\u00bbdefault\u00bb global_colors_info=\u00bb{}\u00bb][\/et_pb_image][et_pb_text admin_label=\u00bb5- (Optional) Rename your table name:\u00bb _builder_version=\u00bb4.19.1″ _module_preset=\u00bbdefault\u00bb global_colors_info=\u00bb{}\u00bb]<\/p>\n

TIP 3-\u00a0 (Opcional) Renombre el nombre de. la tabla<\/strong>:<\/span><\/h3>\n

Despu\u00e9s del \u00faltimo TIP, especialmente cuando el archivo de Excel contiene m\u00e1s de una tabla, puede cambiar el nombre de su tabla<\/strong> en la pesta\u00f1a Table Design (<\/strong>Dise\u00f1o de tabla). Y as\u00ed, luego en el Power Apps, podr\u00e1 elegir su tabla f\u00e1cilmente.<\/span><\/p>\n

[\/et_pb_text][et_pb_image src=\u00bbhttps:\/\/www.hakoit.com\/wp-content\/uploads\/2022\/12\/powerapps-excel-hakoIT-7.jpg\u00bb alt=\u00bbPowerApps Tutorial 2022″ title_text=\u00bbPowerApps Tutorial 2022″ _builder_version=\u00bb4.19.1″ _module_preset=\u00bbdefault\u00bb global_colors_info=\u00bb{}\u00bb][\/et_pb_image][et_pb_text admin_label=\u00bb6- Save the changes\u00bb _builder_version=\u00bb4.19.1″ _module_preset=\u00bbdefault\u00bb global_colors_info=\u00bb{}\u00bb]<\/p>\n

6- <\/span>Guardar los cambios <\/b>en\u00a0OneDrive for Business.<\/span><\/p>\n

\n

El archivo FINAL<\/strong> Microsoft Excel, con una tabla y<\/strong> el encabezado de la columna de im\u00e1genes<\/strong> con el texto\u00a0\u00abImage [image]<\/strong>\u00ab.<\/span><\/p>\n<\/blockquote>\n

Pod\u00e9s descargar<\/strong> el archivo final de Microsoft Excel en el siguiente link: places-to-go-data.xlsx<\/strong><\/a><\/p>\n

[\/et_pb_text][et_pb_image src=\u00bbhttps:\/\/www.hakoit.com\/wp-content\/uploads\/2022\/12\/powerapps-excel-hakoIT-8.jpg\u00bb alt=\u00bbhacer una aplicaci\u00f3n con Excel\u00bb title_text=\u00bbhacer una aplicaci\u00f3n con Excel\u00bb _builder_version=\u00bb4.19.1″ _module_preset=\u00bbdefault\u00bb global_colors_info=\u00bb{}\u00bb][\/et_pb_image][et_pb_text _builder_version=\u00bb4.19.1″ _module_preset=\u00bbdefault\u00bb global_colors_info=\u00bb{}\u00bb][\/et_pb_text][et_pb_text _builder_version=\u00bb4.19.1″ _module_preset=\u00bbdefault\u00bb global_colors_info=\u00bb{}\u00bb]<\/p>\n

Notas\/Recomendaciones para hacer una aplicaci\u00f3n con excel:<\/h3>\n