Power Apps Specialist for PepsiCo Peru

@Tanmoy236

Hi! I specialize in Microsoft Power Apps, Power BI, Excel, and SharePoint integrations. With 9+ years of experience in data automation and workflow optimization, I build solutions that synchronize complex Excel macros with apps while preserving existing functionality. Here's how I can help: * Create an XLSX copy of your XLSM file for Power Apps input without affecting macros * Implement robust two-way synchronization between XLSX and XLSM files on SharePoint * Build error-handling and update controls to prevent loops, data overwrites, or file-lock issues * Ensure Power Apps users can log operational data seamlessly while keeping Excel macros intact * Provide full technical documentation of architecture, logic, and synchronization mechanisms Can you confirm whether Power Automate is preferred for synchronization, or should I propose the most efficient method?

@anchalsingh0005

As a seasoned full-stack developer, my diverse skill set makes me an ideal candidate for this project. Excelling in Power Apps, Power BI, Excel, and SharePoint, I've built a strong foundation to precisely meet PepsiCo Peru's needs. For over 7 years, I've been committed to delivering projects above client expectations. Speaking on architecture design and integration challenges, I have robust expertise in designing solutions that integrate existing macros whilst keeping the functionalities intact. This includes maintaining synchronization between XLSX and XLSM files even during automatic updates via macros. Good knowledge of SharePoint will ensure data gets seamlessly updated despite any temporary file locks - giving you stability and reliability in the system. Lastly, your plan to migrate subsequent visualizations to Power BI is also within my area of expertise. My proficient understanding of the Microsoft ecosystem means smooth replication of your existing dashboards preserving true visualization equivalent for convenient data analysis and automation opportunities using Power Apps or other tools like Power Automate. Partner with me for a well-structured solution that ensures quality and process documentation

@GameOfWords

I’m a full-stack software engineer with expertise in React, Node.js, Python, and cloud architectures, delivering scalable web and mobile applications that are secure, performant, and visually refined. I also specialize in AI integrations, chatbots, and workflow automations using OpenAI, LangChain, Pinecone, n8n, and Zapier, helping businesses build intelligent, future-ready solutions. I focus on creating clean, maintainable code that bridges backend logic with elegant frontend experiences. I’d love to help bring your project to life with a solution that works beautifully and thinks smartly. To review my samples and achievements, please visit:https://www.freelancer.com/u/GameOfWords Let’s bring your vision to life—connect with me today, and I’ll deliver a solution that works flawlessly and exceeds expectations.

@nareshk44

As a freelancer with a deep-rooted expertise in the Microsoft Office Suite, particularly in Excel and Power BI, I am confident that I can deliver the high-quality, innovative solutions you are seeking for PepsiCo Peru's supply chain department. I have extensive experience in data management and automation, skills that align perfectly with your project's demands of integrating an XLSX file as a data source for your Power Apps application hosted on SharePoint while synchronizing it with your existing XLSM file. One of my strengths is my ability to identify and solve potential technical complexities before they arise. This, coupled with my meticulous attention to detail and focus on quality, ensures not only effective synchronization between files with minimal risk of data loss or inconsistency but also robust error handling mechanisms that guarantee system stability under any eventuality. Furthermore, I must emphasize my proficiency in technical documentation. As requested in your project description, I will provide comprehensive documentation of the entire implementation process from start to finish. My commitment to fast and accurate delivery will ensure you have detailed records of every process deployed. Let us collaborate to build an optimized digital ecosystem for your logistics and warehousing department by mitigating inefficient manual processes through reliable data integration tools!

@GraphicsHub2k24

Dedicated Freelancer Ready to Elevate Your Project for Power Apps Specialist for PepsiCo Peru. I have a solid background in Data Visualization, Technical Documentation, Excel, Data Analysis, Data Management, Excel Macros, Data Integration, Power BI, Automation and Logistics, I bring valuable expertise to your project. I have successfully completed many projects with 100% client satisfaction. Clear and timely communication is my priority. I believe in keeping you informed throughout the project lifecycle. I am available for a discussion at your earliest convenience. Please feel free to contact me to further discuss your project details. Thank you for considering my bid. I am excited about the opportunity to contribute to the success of your project. Please visit my portfolio to check my previous work samples, here - https://www.freelancer.com/u/GraphicsHub2k24?page=portfolio&w=f&ngsw-bypass= Best regards, Muhammad Asim Khan

@hireageek

Hi there, I'm a top California freelancer with extensive experience in Power Apps, Excel, and SharePoint, and I understand the critical need for robust data integration within your Logistics and Warehousing department at PepsiCo Peru. I’m confident in my ability to design a solution that maintains your existing operational macros while synchronizing data seamlessly between your XLSM and XLSX files housed on SharePoint. My approach will ensure that operational processes are efficiently tracked and recorded through Power Apps without disrupting your current workflows. I will implement a sustainable synchronization mechanism that guarantees data consistency and integrity, allowing updates from both the application and the macros to reflect accurately in both file formats. I’m ready to start immediately and aim to deliver a stable solution as quickly as possible. Please message me right away to discuss this further and clarify any details What specific macros or functionalities in the XLSM file are critical to maintain during the synchronization process?. Best regards,

@viviprabu22

With over a decade of experience in the Microsoft ecosystem, I'm well-positioned to be your Power Apps Specialist for PepsiCo Peru. My mastery of Power Apps, Power BI, Excel, SharePoint and my proven ability to create seamless data integration and synchronization solutions with a deep understanding of macros make me an exceptional fit for this project. Not only can I maintain the integrity of your current XLSM file while integrating it with Power Apps, but I can also ensure reliable synchronization between the XLSX and XLSM files, even amidst potentially challenging scenarios like temporary file locks within SharePoint. What sets me further apart is that I'm not just an expert in individual components—I possess a holistic understanding of this entire ecosystem which will be invaluable as we migrate your current visualizations to Power BI. I promise to not just replicate the look and feel but leverage the power of Power BI for better data analysis, visualization, and automation capabilities. Additionally, my skills extend beyond technical implementation; I have a passion for robust process documentation that ensures clarity and continuity.

@SkillCrafts

Having designed automated inventory and logistics tracking systems for complex, high-volume FMCG operations, I understand the specific challenges of optimizing Supply Chain workflows within a large-scale ecosystem like PepsiCo Peru. My background in developing bespoke Power Apps that bridge the gap between frontline data entry and executive-level reporting ensures that your department gains real-time operational visibility while maintaining strict data integrity. I specialize in transforming fragmented manual processes into cohesive, scalable digital solutions that leverage the full power of the Microsoft 365 suite to drive efficiency across the value chain. My technical approach centers on building a high-performance Canvas or Model-Driven App tailored to your specific data architecture, utilizing Power Automate to streamline complex multi-stage approvals and logistics notifications. I will implement a robust data layer—leveraging Dataverse for relational complexity or SharePoint for rapid deployment—to ensure seamless synchronization with your Power BI dashboards for advanced supply chain analytics and predictive reporting. I prioritize building custom connectors and implementing Row-Level Security (RLS) to ensure that sensitive supply chain data is both accessible and protected. Furthermore, I focus on a mobile-first UI/UX design to ensure high adoption rates among field staff and warehouse operators who require intuitive interfaces in fast-paced environments. To ensure we choose the most efficient architecture, are you currently looking to digitize a legacy Excel-based tracking system, or is this an entirely new initiative focused on a specific bottleneck in the Peru supply chain? Additionally, do you have existing Power BI templates that this new application must integrate with to maintain reporting consistency? I am available for a brief chat or a call to align on your immediate technical requirements and discuss how we can execute this project within your required timeframe. I look forward to the possibility of collaborating with the PepsiCo team to enhance your operational capabilities.

@erdikudu

Hi Sir/Madam, I have been working on Office 365 for 9 years. I have experience with SharePoint, Project, PowerApps, Teams, Flow, PowerBI, Planner and Office Plugin. I developed many mobile/tablet apps like inspection, handover protocol, trade management apps. I developed those forms as canvas and model driven apps. I can make the custom connector, form to pdf convert, putting the form into teams tab, etc. I used the Sharepoint, Local Sql server, azure sql server as a database for PowerApps app. I used the Microsoft Graph to integrate the app and other M365 applications. I developed a few powerapps portal with custom branding and custom screen functionalities. You can check my freelancer profile to see my previous experience. Please let me know if you have any questions

@usamae

Solid experience with Power Apps and Power BI integrations - I've built data sync solutions between Excel files and canvas apps before, which is exactly what you're describing. For PepsiCo's logistics tracking: I'd set up the XLSM data flow into Power Apps via SharePoint as the common data layer, automate the sync with Power Automate flows, and surface the dashboards in Power BI for the KPI visibility you need. The tricky part is keeping the Excel macros working while bridging to the app - I've dealt with that before. Can start immediately. Quick question: is the Excel file currently shared on SharePoint or a local network drive? That affects the sync architecture. - Usama

@Hemantt841

PepsiCo Peru team, I understand you need a Power Apps specialist to integrate your XLSM Excel macros with a Power Apps solution while keeping your SharePoint files synchronized. Your goal to improve operational time tracking in Logistics and Warehousing through a seamless digital tool integration is clear and critical. You require maintaining the original XLSM file with macros intact, creating an identical XLSX copy as a data source for Power Apps, and ensuring real-time, bidirectional synchronization between these two files hosted on SharePoint. Additionally, robust error handling, prevention of update loops, and preserving macro functionality are essential for system stability. I have built similar solutions where I integrated Excel files with Power Apps and SharePoint, implementing synchronization mechanisms that ensure data consistency without disrupting macros. For instance, I developed a synchronization layer that managed updates between XLSX and XLSM files while maintaining macro integrity and handling SharePoint file locks efficiently, which directly aligns with your needs. I can complete this integration and synchronization setup within 10 days, allowing time for thorough testing and documentation. Let’s discuss how I can start immediately and deliver a stable, well-documented solution tailored to your Supply Chain workflow.

@zeldac1

Hi PepsiCo Peru team, I saw you're wiring Power Apps to talk to an on-SharePoint XLSM with macros while exposing a synchronized XLSX as the data source. A common pitfall here is macro-driven data integrity conflicts between XLSM and the data layer used by Power Apps. One quick insight: ensure you separate the write path from macro logic and guard against update loops with a controlled sync queue. Plan: • map data fields and establish a two-way sync between XLSX and XLSM without triggering macros on every write • implement a safe write API in Power Apps and a SharePoint-based trigger to propagate changes • add robust error handling and lock management; test with periodic XLSM updates • document the architecture and decisions I recently resolved a similar Excel-Power Apps integration for a logistics team, delivering reliable two-way sync and zero macro interference. Can you share the SharePoint URLs and the exact macro triggers to plan the data flow?

@billybryan98

Hello PepsiCo Peru Team, I’m a data and automation specialist focused on Power Apps, Power BI, Excel (including macros), and SharePoint. I design robust data integrations that keep macro-driven Excel workbooks intact while exposing a clean Power Apps data surface. I’ve built architectures where XLSX serves as the Power Apps data source and syncs with the original XLSM on SharePoint, with safe update paths, error handling, and loop prevention. This enables logging operational times and events without disrupting macros, and sets the stage for a Power BI mirror of existing visuals. I can implement the two-way synchronization, maintain macro integrity, and document the architecture and workflows for easy handover. Ready to start immediately. Best regards, Billy Bryan

@Alesha1018

As an experienced software engineer, specializing in Automation and proficient in Excel and other Microsoft technologies such as Power BI, SharePoint combines perfectly with the unique needs of your project. Over the years, I have developed a solid understanding of working with Power Apps & Power Automate that can be vital in integrating data sync between your XLSM and XLSX files stored within the SharePoint platform. My technical abilities coupled with an analytical mindset would enable me to not just create a solution but provide you with alternatives to ensure you get the most reliable and robust solution. Debugging, maintaining, and improving existing applications are my key strengths which will prove particularly useful here. It would not only help me maintain your XLSM file-including macros-as it is but also allow me to update it consistently using Power Automate for every new record added through Power Apps ensuring that no discrepancies or loops occur. Additionally, my proficiency in Microsoft's ecosystem can be central to effectively transferring the existing visualizations from XLSM to Power BI while retaining the logic and structures from one system to another successfully.