![PowerApps forms multipantalla](https://llogic.cat/wp-content/uploads/2021/07/caratula-1-300x125.png)
![PowerApps forms multipantalla](https://llogic.cat/wp-content/uploads/2021/07/caratula-1-300x125.png)
PowerApps. Formularios multipantalla
Código de la App Botón Nuevo- OnSelect() ResetForm(frm_general);;ResetForm(frm_descripción);;ResetForm(frm_técnico);;ResetForm(frm_adjuntos);;Set(varFormData;Defaults(Incidencias));;Set(editmode;false);;Navigate(Scr_general) Botón Editar registro – OnSelect() ResetForm(frm_general);;ResetForm(frm_descripción);;ResetForm(frm_técnico);;ResetForm(frm_adjuntos);;Set(varFormData;ThisItem);;Set(editmode;true);;Navigate(Scr_general) Icono Guardar OnSelect() Patch(Incidencias;varFormData;frm_general.Updates;frm_descripción.Updates;frm_técnico.Updates;frm_adjuntos.Updates);;If(IsEmpty(Errors(Incidencias));Notify(«Registro guardado correctamente»;NotificationType.Success);;Navigate(Scr_principal);Notify(First(Errors(Incidencias)).Message;NotificationType.Error))
![PowerApps. Massive import](https://llogic.cat/wp-content/uploads/2021/07/caratula-300x125.png)
![PowerApps. Massive import](https://llogic.cat/wp-content/uploads/2021/07/caratula-300x125.png)
PowerApps. Importación masiva de registros
Código de la App Funciones PowerApps Split(TextInput1.Text;Char(10)) Left(ThisItem.Result;Find(» «;ThisItem.Result)) Mid(ThisItem.Result;Find(» «;ThisItem.Result)+1) Set( waitvisible; true );; ForAll( Gallery1.AllItems As Items; If( Items.Label2.Text <> «»; Patch( Personal;
![](https://llogic.cat/wp-content/uploads/2021/07/portada-300x184.png)
![](https://llogic.cat/wp-content/uploads/2021/07/portada-300x184.png)
PowerApps. Acceso a Sql sin licencia premium
Código de la App Script para crear Tabla en Excel function main(workbook: ExcelScript.Workbook) { let selectedSheet = workbook.getActiveWorksheet(); // Create a table with format on range A1:EG2 on selectedSheet let tabla2 = workbook.addTable(selectedSheet.getRange(«A1:EG2»), true); tabla2.setPredefinedTableStyle(«TableStyleLight1»); // Rename table tabla2 to tb_txt tabla2.setName(«tb_txt»);} PowerApps llamada al flujo PowerAutomate Set (image_wait;true);; Set(respuesta;Excel_SQL.Run(TextInput1.Text));; Refresh(artículos_excel);; Set (image_wait;false);;
![powerapps drag&drop](https://llogic.cat/wp-content/uploads/2021/06/dnd2-300x125.png)
![powerapps drag&drop](https://llogic.cat/wp-content/uploads/2021/06/dnd2-300x125.png)
PowerApps Drag&Drop
Código de la App INSTALAR HERRAMIENTAS Instalar .NET Framework 4.6.2 Developer pack Instalar Vistual studio 2017 o superior Ejecutar Developer Command Prompt (CLI) CREAR COMPONENTE
![](https://llogic.cat/wp-content/uploads/2021/05/caratula-5-300x169.png)
![](https://llogic.cat/wp-content/uploads/2021/05/caratula-5-300x169.png)
PowerApps. Editar tablas
Código de la App Controles Botón Nuevo registro 0nSelect Patch(Artículos;Defaults(Artículos);{Title:»»}) Modificar datos Default ThisItem.Title OnChange Patch(Artículos;ThisItem;{Title:txt_title.Text}) Eliminar registro (icono papelera) OnSelect Set(popup_visible;true) Eliminar registro (botón
![Powerautomate agrupar](https://llogic.cat/wp-content/uploads/2021/05/caratula2-1-300x200.png)
![Powerautomate agrupar](https://llogic.cat/wp-content/uploads/2021/05/caratula2-1-300x200.png)
PowerAutomate. Agrupar y contar
Código de la App Union union(variables(‘Ventas’),variables(‘Ventas’)) Length length(variables(‘VentasVendedor’))
![sharepoint forms](https://llogic.cat/wp-content/uploads/2021/05/caratula-2-300x214.png)
![sharepoint forms](https://llogic.cat/wp-content/uploads/2021/05/caratula-2-300x214.png)
Formularios SharePoint con PowerApps
Código de la App Controles Icono Enviar email OnSelect [Office365Outlook.SendEmailV2(TextInput1.Text; «Verifica este artículo»;SharePointIntegration.Selected.’Vinculo al elemento’)