You're right, let me focus specifically on implementing this solution in Power Apps. Here's a detailed guide for building your Marketing Events Manager in Power Apps:

Power Apps Implementation Guide

Setting Up Your Canvas App

1. Create a new Canvas app:

   • Open make.powerapps.com
   • Click "Create" → "Canvas app from blank"
   • Choose "Tablet layout" (for more screen space)
   • Name it "Marketing Events Manager"

2. Connect to SharePoint data sources:

   • In the Power Apps editor, go to the Data panel (database icon)
   • Click "Add data" → "SharePoint"
   • Connect to your SharePoint site
   • Add all four lists: Eventos, Actividades, Proveedores, Clientes

Building the App Structure

1. Create your navigation:

   // On App.OnStart property, add: Set( AppVars, { CurrentScreen: "Dashboard", CurrentUser: User(), SelectedEvent: Blank(), SelectedActivity: Blank() } );

2. Add a navigation bar:

   • Insert a rectangle at the top of each screen
   • Add buttons for each section:
   // For each navigation button, set OnSelect: Set(AppVars.CurrentScreen, "Dashboard"); Navigate(DashboardScreen);

Dashboard Screen

1. Create KPI cards:

   // Total Events card label Text: "Total Events: " & CountRows(Eventos) // Pending Activities card label Text: "Pending Activities: " & CountRows(Filter(Actividades, Estado = "Pendiente"))

2. Upcoming Activities gallery:

   // Gallery Items property SortByColumns( Filter( Actividades, Fecha_de_ejecución >= Today() ), "Fecha_de_ejecución", Ascending )

3. Add status indicators:

   // In the gallery template, add a label with: Text: ThisItem.Estado Color: If(ThisItem.Estado = "Completado", Green, If(ThisItem.Estado = "En Progreso", Blue, Orange))

Events Screen

1. Events gallery:

   // Gallery Items property SortByColumns(Eventos, "Fecha_inicio", Ascending) // OnSelect property Set(AppVars.SelectedEvent, ThisItem); Navigate(EventDetailScreen);

2. New Event button:

   // OnSelect property ResetForm(EventForm); NewForm(EventForm); Navigate(NewEventScreen);

3. Event form fields:

   • Add form controls for:

     • Nombre (Text input)
     • Tipo_de_evento (Dropdown)
     • Fecha_inicio (Date picker)
     • Fecha_fin (Date picker)
     • Ubicacion (Text input)
     • Responsable (People picker)
     • Estado (Dropdown)
     • Presupuesto (Number input)
     • Descripcion (Multi-line text)

Activities Screen

1. Activities gallery with filtering:

   // Gallery Items property - when coming from an event If( !IsBlank(AppVars.SelectedEvent), Filter(Actividades, Evento_relacionado.ID = AppVars.SelectedEvent.ID), Actividades ) // OnSelect property Set(AppVars.SelectedActivity, ThisItem); Navigate(ActivityDetailScreen);

2. Activity form with lookups:

   // For the Event dropdown DataSource property Eventos // For the Provider dropdown DataSource property Proveedores // For the Assigned To people picker DataSource Office365Users.SearchUser()

3. Status tracking:

   // Status change OnChange property If( DataCardValue_Status.Selected.Value = "Completado" && AppVars.SelectedActivity.Estado <> "Completado", Patch( Actividades, AppVars.SelectedActivity, { Estado: "Completado", Fecha_completado: Now() } ) )

Providers and Clients Screens

1. Providers gallery:

   // Gallery Items property SortByColumns(Proveedores, "Nombre", Ascending)

2. Provider form fields:

   • Add form controls for:

     • Nombre (Text input)
     • Tipo (Dropdown)
     • Contacto (Text input)
     • Email (Text input)
     • Telefono (Text input)
3. Similar setup for Clients screen

Advanced Features

1. Search functionality:

   // Add a search box with OnChange property UpdateContext({searchText: TextInput1.Text}); // Then in your gallery Items property If( IsBlank(searchText), Eventos, Filter( Eventos, StartsWith(Nombre, searchText) || StartsWith(Ubicacion, searchText) || StartsWith(Responsable.DisplayName, searchText) ) )

2. Activity filtering by status:

   // Add a dropdown for status filtering UpdateContext({statusFilter: Dropdown1.Selected.Value}); // Then in your gallery Items property Filter( Actividades, IsBlank(statusFilter) || Estado = statusFilter )

3. Event detail view with related activities:

   // In the event detail screen, add a gallery with: Items: Filter(Actividades, Evento_relacionado.ID = AppVars.SelectedEvent.ID)

4. Dashboard charts:

   • Add a chart control
   // For activities by status chart Items: GroupBy( Actividades, "Estado", "Count", CountRows(ThisRecord.AllItems) )

Power Automate Integration

1. Trigger flows from Power Apps:

   // Button to send notification OnSelect PowerAppsbutton.Run( AppVars.SelectedEvent.ID, AppVars.SelectedEvent.Nombre, AppVars.CurrentUser.Email )

2. Flow for activity status changes:

   • Create a flow triggered by "When an item is modified" in SharePoint
   • Add a condition to check if Status field changed
   • Send notification to the assigned person

3. Flow for new provider assignments:

   • Create a flow triggered by "When an item is created or modified" in Activities list
   • Add a condition to check if Provider field is not empty
   • Send notification to the provider's contact email

Formulas for Common Tasks

1. Calculate days until event:

   DateDiff(Today(), ThisItem.Fecha_inicio)

2. Format currency:

   Text(ThisItem.Presupuesto, "$#,##0.00")

3. Calculate budget usage:

   // Assuming you track expenses in a related list Sum( Filter( Gastos, Evento_relacionado.ID = AppVars.SelectedEvent.ID ), Monto )

4. Progress indicator:

   // For activities completion CountRows( Filter( Actividades, Evento_relacionado.ID = AppVars.SelectedEvent.ID && Estado = "Completado" ) ) / CountRows( Filter( Actividades, Evento_relacionado.ID = AppVars.SelectedEvent.ID ) ) * 100

Publishing Your App

1. Save and publish:

   • Click "File" → "Save"
   • Click "Publish" → "Publish this version"

2. Share with your team:

   • Click "Share"
   • Add users or groups from your organization
   • Set appropriate permissions (edit or view)

3. Add to Teams:

   • In Teams, go to the desired channel
   • Click "+" to add a tab
   • Select "Power Apps"
   • Choose your Marketing Events Manager app

This Power Apps implementation gives you a fully functional event management system that connects directly to your SharePoint lists. The formulas and functions are specific to Power Apps and will help you create a dynamic, interactive experience for your marketing team.